...
Source | Destination | Comment |
|---|---|---|
trim(chchl_given_name) | FirstName |
|
trim (chchl_surname) | LastName |
|
trim(chchl_middle_name) | MiddleName |
|
trim(chchl_suffix_name) | Suffix | rad |
to_char(chl_birthdate,'yyyy-mm-dd') | personBirthDate |
|
chl_social_insurance_number | Social_Insurance_Number__c |
|
radchl_ow_member_id | Ontario_Works_Id__c |
|
| 012W000000016sEIAQ | RecordTypeId | This is the ID for the Child Account Record Type |