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

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

RecordTypeId

This is the ID for the Adult Account Record Type

trim(ch_given_name)

FirstName

trim (ch_surname)

LastName

trim(ch_middle_name)

MiddleName

trim(ch_suffix_name)

Suffix

rad_social_insurance_number

Social_Insurance_Number__c

rad_ow_member_id

Ontario_Works_Id__c

RecordTypeId

 This is the ID for the Child Account Record Type