...
Adult Mapping
The source is the RESPONSIBLE_ADULT tableJSON from the GetClientProfile method in the TESS-HSI service. The destination is the JSON representation of the Salesforce Account sobject.
| 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 |
Process Log
The process log table is used to manage the date ranges when calling the service.
...