...
| Source | Destination | Comment |
|---|---|---|
| household_id | household_id__c | The TCS Household ID |
| household_status | caseService_statusStatus__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 |
...