...
{ |
|---|
JSON field mapping with tables:
| Json Fields | Parent record (Table.column) | Child record (Table.column) | Household record (Table.column) |
| Children_Services_Id__c | RESPONSIBLE_ADULT.RAD_REFERENCE_APPLICANT_ID | CHILD.CHL_REFERENCE_CHILD_ID | |
| Ontario_Works_Id__c | RESPONSIBLE_ADULT.RAD_OW_MEMBER_ID | CHILD.CHL_OW_MEMBER_ID | |
| Children_Services_Household_Id__c | HOUSEHOLD.HHO_FILE_REFERENCE_NUMBER | HOUSEHOLD.HHO_FILE_REFERENCE_NUMBER | |
| household_id__c | Appointment.APP_FAMILY_ID |
Parent-Child-Household relationship (not for active Household):
| RESPONSIBLE_ADULT | HOUSEHOLD_RESP_ADULT_MEMBER | HOUSEHOLD | HOUSEHOLD_CHILD_MEMBER | CHILD |
| RAD_RESPONSIBLE_ADULT_ID | HHR_RESPONSIBLE_ADULT_ID | |||
| HHC_CHILD_ID | CHL_CHILD_ID | |||
| HHR_HOUSEHOLD_ID | HHO_HOUSEHOLD_ID | HHC_HOUSEHOLD_ID |
Update the Process Log
Once the information is successfully loaded update the log with the most recent version using an update similar to this.