Toronto Employment and Social Services (TESS) is providing a web service that returns client profiles. This approach eliminates the need for HSIO to temporarily save any client information.
...
| Source | Destination | Comment |
|---|---|---|
GivenName | FirstName | |
LastName | LastName | |
MiddleName | MiddleName | |
Suffix | Not needed | |
| ReferenceNum | Ontario_Works_Id__c | |
DoB | personBirthDate | there may be the need to transform the date: the input format is yyyymmdd |
personEmail | No email address | |
telephoneNumber | Phone | |
Secondary_Phone__c | Not provided by OW | |
PersonMobilePhone | Not provided by OW | |
| streetNumber|| ' ' || streetName | street | |
| city | city | |
| province | state_code | |
| postalCode | postal_code | |
| 'CA' | country_code | |
| 'Address' | geocodeAccuracy | |
| businessUnitId | household_id__c | |
| StatusCode | case_status__c | |
| DomesticViolenceIndicator |
Salesforce Sync JSON Data Mapping
...
:
...
| Arribute | Salesforce Fields | TCS Example | OW API Fields | OW API Example | ||||
|---|---|---|---|---|---|---|---|---|
| JSON_Message__c | FirstName | String | ||||||
| first_name__c | pettest101 | GivenName | Bibiana | |||||
| lastname | last_name__c | LastName | MKMOPPJXK | |||||
| case_status__c | CS10001 | |||||||
| SAMS_Status__c | Status | Completed | ||||||
| 1 | ||||||||
| Name | String | Name | demowithinsert | (Add (value is firstname + ' firstname + ' ' +MiddleName + ' '+ lastname)) | ||||
| F | ||||||||
| gender__c | Gender | Female | ||||||
| (suffix) | salutation__c | Title | ||||||
| date_of_birth__c | String | date_of_birth__c | 1966-09-17(yyyy-mm-dd) | DoB | 19820428Title | |||
| email__c | String | email__c | ctpNwJMdPJtpjTF@toronto.ca | Phone | String | phone | 4164041943(null) | |
| phone | Telephone | 555-5555555 | ||||||
| Secondary_Phone__c | (null) | |||||||
| Other_phone__c | (null) | |||||||
| Mobile_phone__c | (null) | |||||||
| Is_Aboriginal__c | BillingStreet | String (null) | ||||||
| BillingStreet(Primary) | 200 WELLESLEY ST EUnitNumber ||+ '-'||streetNumber|| +streetNumber + ' ' || + streetName | 12-1254 Street | ||||||
| BillingCity | String | BillingCity | TORONTO | city | SCARBOROUGH | |||
| BillingState | String | BillingState | ON | province | SCARBOROUGHBillingPostalCode | |||
| String | BillingPostalCodeM4X 1G3 | postalCode | M5N 5E3 | |||||
| BillingCountry | String | BillingCountry | "CA | 1254 Street , SCARBOROUGH, Ontario, M5N 5E3 | " | |||
| ShippingStreet(Secondary) | (null) | |||||||
| ShippingCity | (null) | |||||||
| ShippingState | (null) | |||||||
| ShippingPostalcode | (null) | |||||||
| ShippingCountry | RecordTypeId | String | (RecordTypeIdnull) | 0121h0000004kgaAAA | ||||
| Ontario_Works_Id__c | String | RecordTypeId | ? | |||||
| Ontario_Works_Id__c | 3304892315 | ReferenceNum | 15146436109 | |||||
| Children_Services_Id__c | String | Children_Services_Id__c | 441234781 | (null) | ||||
| CSIS_household_Id__c | (null) | |||||||
| AccountSource | "Ontario Works" | |||||||
| Children_Services_Household_Id__c | String | Children_Services_Household_Id__c | 112311221(null) | |||||
| RGI_Houshold_Id__c | (null) | |||||||
| OW_Household_id__c | ICCaseID | 1212724857222 | ||||||
| 0 | ||||||||
| (Is_sensitive_client__c(Boolean/Integer) | DomesticViolenceIndicator | 0 | ||||||
| (OW_start_date__c) | StatusChangeDate | 20190826 | ||||||
| 20191002 | ||||||||
| Object_Name__c | String | "Account" |
Process Log
The process log table is used to manage the date ranges when calling the service.
...