Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The source is the RESPONSIBLE_ADULT table. The destination is the JSON representation of the Salesforce Account sobject.

SourceDestinationComment

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|| ' ' || streetNamestreet
citycity
provincestate_code
postalCodepostal_code
'CA'country_code
'Address'geocodeAccuracy
businessUnitIdhousehold_id__c
StatusCodecase_status__c

Process Log

The process log table is used to manage the date ranges when calling the service.

Code Block
languagesql
titleProcess Log for OW Client
collapsetrue
-- 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';      

...