...
The source is the RESPONSIBLE_ADULT table. 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 |
Process Log
The process log table is used to manage the date ranges when calling the service.
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
-- CRM Synch OW Client Update PROCESS_LOG set PRL_LAST_SUCCESS_RUN_START_TS = to_timestamp('2018-01-01','YYYY-MM-DD') where prl_process_log_type_code = 'SFSOWC'; |
...