Page Comparison

trim(rad_given_name)

FirstName

trim (rad_surname)

LastName

trim(rad_middle_name)

MiddleName

trim(rad_suffix_name)

Suffix

rad_social_insurance_number

Social_Insurance_Number__c

There's some magic that needs to be done to create the encrypted user ID

Salesforce "triggers" will encrypt the SIN.

rad_ow_member_id

Ontario_Works_Id__c

to_char(rad_birthdate,'yyyy-mm-dd')

personBirthDate

rad_email_address

personEmail

(select rpc_area_code || rpc_local_number
from resp_adult_phone_cntct
where rpc_responsible_adult_id = rad_responsible_adult_id
and rpc_phone_type_code = 'HOME')

Phone

(select rpc_area_code || rpc_local_number
from resp_adult_phone_cntct
where rpc_responsible_adult_id = rad_responsible_adult_id
and rpc_phone_type_code = 'WORK')

Secondary_Phone__c

This is the work phone number

(select rpc_area_code || rpc_local_number
from resp_adult_phone_cntct
where rpc_responsible_adult_id = rad_responsible_adult_id
and rpc_phone_type_code = 'MOBILE')

PersonMobilePhone

012W000000016s9IAA

RecordTypeId

This is the ID for the Adult Account Record Type