...
The source is a number of tables identifying the status of the Child Care Fee Subsidy case. See this sample SQL.
| Source | Destination | Comment | |
|---|---|---|---|
| household_id | household_id__c | The TCS Household ID | |
| household_status | case_status__c | The code is one of:
| |
| start_date | case_start__c | The case start date | |
| inactive_date | case_inactive_date__c | The If the household status is inactive, this is the start of the inactive status, after 60 days this case expires | |
| last_update_date_time | -- | The 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 |
...
Update the Process Log
Once the information is successfully loaded update the log with the most recent version using an update similar to this.