Page Comparison

...

Source	Destination	Comment
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
cast (rad_reference_applicant_id,varchar2(20))	Children_Services_Id__c
pad_street_nbr \|\| ' ' \|\| pad_street_name	street
pad_city	city
pad_province_code	state_code
pad_postal_code	postal_code
pad_country_code	country_code
'Address'	geocodeAccuracy
012W000000016s9IAA	RecordTypeId	This is the ID for the Adult Account Record Type

...

Source	Destination	Comment
trim(chl_given_name)	FirstName
trim (chl_surname)	LastName
trim(chl_middle_name)	MiddleName
trim(chl_suffix_name)	Suffix
to_char(chl_birthdate,'yyyy-mm-dd')	personBirthDate
chl_social_insurance_number	Social_Insurance_Number__c
chl_ow_member_id	Ontario_Works_Id__c
chl_reference_child_id	Children_Services_Id__c
012W000000016sEIAQ	RecordTypeId	This is the ID for the Child Account Record Type

...

Versions Compared