Mapping

trim(rad_given_name)

FirstName

trim (rad_surname)

LastName

rad_middle_name

MiddleName

rad_suffix_name

Suffix

rad_social_insurance_number

Social_Insurance_Number__c

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

(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