Mapping

The source is from the attached SQL queries one for Adult and one for Child. The destination Java Object classes are in the attached compress file.

Adult Mapping

The source is the RESPONSIBLE_ADULT table. The destination is the JSON representation of the Salesforce Account sobject.

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
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
012W000000016s9IAA	RecordTypeId	This is the ID for the Adult Account Record Type

The source is the CHILD table. The destination is the JSON representation of the Salesforce Account sobject.

Source	Destination	Comment
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
012W000000016sEIAQ	RecordTypeId	This is the ID for the Child Account Record Type