...
Source | Destination | Comment |
|---|---|---|
trim(chl_given_name) | FirstName |
|
trim (chl_surname) | LastName |
|
trim(chl_middle_name) | MiddleName |
|
trim(chl_suffix_name) | Suffix |
|
to_char(chl_birthdate,'yyyy-mm-dd') | personBirthDate |
|
chl_social_insurance_number | Social_Insurance_Number__c |
|
chl_ow_member_id | Ontario_Works_Id__c |
|
| chl_reference_child_id | Children_Services_Id__c | |
| 012W000000016sEIAQ | RecordTypeId | This is the ID for the Child Account Record Type |
CCFS Household Mapping
The source is a number of tables identifying the status of the Child Care Fee Subsidy case.
| 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 start of the inactive status, after 60 days this case expires |
| last_update_date_time | -- | 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.