Versions Compared

Version Old Version 18 New Version 19
Changes made by

Vincent Li (Unlicensed)

Vincent Li (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

sams reference id


Children_Services_Household_Id__chousehold id (HouseholdFileRefNumber)
chl_reference_child_idChildren_Services_Id__c
012W000000016sEIAQ

RecordTypeId

 This is the ID for the Child Account Record Type

csis_action_by__cEMP_NAME

JSON example:

JSON example:

{
     "method" : "POST",
      "url" : "/services/data/v45.0/sobjects/Legacy_System_Record__e",
      "referenceId" : "

A9594843

C9677210",
       "body" : {
              "JSON_Message__c" : "{


                      "ReferenceId


                        "Name":"*",
                        "RecordTypeId":"0123s000000aJkPAAU",
                        "AccountSource":"CSIS2",
                        "EmpUserId":"

1068320

*",

                     

                        "

household

first_

id

name__c":"

1068320

*",

                     

                        "

Service

last_

Status

name__c":"

INACTIVE

*",

                     

                        "

Start

Ontario_Works_

Date

Id__c":"

2018-

305366401",

                     

                        "

End

date_of_

Date

birth__c":"

2021-",
                      "Household_income

2018-",
                        "Is_Aboriginal__c":false,
                        "Children_Services_Household_Id__c":"

0

1180236",

                     

                        "

Funding

Children_Services_

Stream

Id__c":"

REG

C9677210"


            

,
                        "csis_action_by__c":"*"                }",

            

              "Object_Name__c" : "

Household

Account"
       }
}

CCFS Household Mapping

The source is a number of tables identifying the status of the Child Care Fee Subsidy case. See this sample SQL.

SourceDestinationComment
household_idhousehold_id__cThe TCS Household ID
household_statusService_Status__c

The code is one of:

  • Waiting
  • Allocated
  • Enrolled
  • Inactive


start_datecase_start__cThe case start date
inactive_datecase_inactive_date__cIf the household status is inactive, this is the start of the inactive status, after 6 months this case expires
last_update_date_timeNot uploaded to SalesforceUsed 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_incomeHousehold_income__chousehold income from table: financial_assessment
funding_streamFunding_Stream__cfunding stream from table: family_funding

JSON example:


{
     "method" : "POST",
      "url" : "/services/data/v45.0/sobjects/Legacy_System_Record__e",
      "referenceId" : "

A9594843

1068320",
       "body" : {
              "JSON_Message__c" : "{

                        

                      "

Name

ReferenceId":"

*

1068320",

                        "RecordTypeId":"0123s000000aJkPAAU",
                        "AccountSource":"CSIS2",
                        "EmpUserId":"*",
                        "first_name

                      "household_id__c":"

*

1068320",

                       

                      "

last

Service_

name

Status__c":"

*

INACTIVE",

                       

                      "

Ontario

Start_

Works

Date_

Id

_

_

c":"

305366401

2018-",

                       

                      "

date

End_

of

Date_

birth

_

_

c":"

2018

2021-",

                        "Is_Aboriginal__c":false,
                        "Children_Services_Household_Id

                      "Household_income__c":"

1180236

0",

                       

                      "

Children

Funding_

Services_Id

Stream__c":"

C9677210

REG"

,
                        "csis_action_by__c":"*"               


             }",

             

             "Object_Name__c" : "

Account

Household"
       }
}

Update the Process Log

Once the information is successfully loaded update the log with the most recent version using an update similar to this.