...
| Source | Destination | Comment |
|---|---|---|
| household_id | household_id__c | The TCS Household ID |
| household_status | Service_Status__c | The code is one of:
|
| start_date | case_start__c | The case start date |
| inactive_date | case_inactive_date__c | If the household status is inactive, this is the start of the inactive status, after 6 months this case expires |
| last_update_date_time | Not uploaded to Salesforce | Used to determine the maximum date time is used for this run is used as the start of the next run Must be saved in the Process Log |
| household_income | Household_income__c | household income from table: financial_assessment |
| funding_stream | Funding_Stream__c | funding stream from table: family_funding |
For household income and funding stream logic, please refer the confluence page provided by Ramzi: /wiki/spaces/CSI/pages/2860844000
JSON example:
{ |
|---|
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.