Page Comparison

Toronto Employment and Social Services (TESS) is providing a web service that returns client profiles. This approach eliminates the need for HSIO to temporarily save any client information.

...

Source	Destination	Comment
GivenName	FirstName
LastName	LastName
MiddleName	MiddleName
	Suffix	Not needed
ReferenceNum	Ontario_Works_Id__c
DoB	personBirthDate	there may be the need to transform the date: the input format is yyyymmdd
	personEmail	No email address
telephoneNumber	Phone
	Secondary_Phone__c	Not provided by OW
	PersonMobilePhone	Not provided by OW
streetNumber\|\| ' ' \|\| streetName	street
city	city
province	state_code
postalCode	postal_code
'CA'	country_code
'Address'	geocodeAccuracy
businessUnitId	household_id__c
StatusCode	case_status__c
DomesticViolenceIndicator

Salesforce Sync JSON Data Mapping

...

:

...

FirstName(Add (value is lastname))19660917TORONTO
JSON Fields Arribute
Salesforce
Fields
TCS Example OW API Fields OW API Example Comment
JSON_Message__c

String first_name__c pettest101 GivenName Bibiana
last_name__c
LastName
MKMOPPJXK

MiddleName

(case_status__c) StatusCode CS10001
SAMS_Statusc Status Completed

Active 1
Name String
firstname + ' ' +
demowithinsert
MiddleName + ' '+ lastname

GenderCode F
genderc Gender Female
(suffix) salutation__c date_of_birth__c String
Title
Mrs.
date_of_birthc (yyyy- mm- dd)
DoB
19820428Title
emailc String email__c ctpNwJMdPJtpjTF@toronto.ca Phone String phone 4164041943 (null)

phone Telephone 555-5555555
Secondary_Phone__c (null)

Other_phone__c
(null)

Mobile_phone__c
(null)

Is_Aboriginal__c BillingStreet String
(null)

BillingStreet(Primary) 200 WELLESLEY ST E UnitNumber||' '||streetNumber|| ' ' || streetName 1254 Street BillingCity String BillingCity UnitNumber + '-' +streetNumber + ' ' + streetName 12-1254 Street
BillingCity city SCARBOROUGH
BillingStateString BillingState ON province SCARBOROUGH BillingPostalCode String
BillingPostalCodeM4X 1G3 postalCode M5N 5E3
BillingCountry String BillingCountry CA BillingGeocodeAccuracy PostalAddress 1254 Street , SCARBOROUGH, Ontario, M5N 5E3"CA"

ShippingStreet(Secondary) (null)

ShippingCity (null)

ShippingState (null)

ShippingPostalcode (null)

ShippingCountry (null)

RecordTypeId String (RecordTypeId) 0121h0000004kgaAAA
0121h0000004kgaAAA (Parent) (age >=18 based on birthday)
012W000000016sEIAQ (Child) (age <18 based on birthday)

Ontario_Works_Id__c String Ontario_Works_Id__c 3304892315 ReferenceNum 15146436109 Children_Services_Id__c StringReferenceNum
15146436109
SAMS client reference number
Purpose:
Call client search
Call client ID verification

Children_Services_Id__c 441234781(null)

CSIS_household_Id__c AccountSource Children_Services_Household_Id__c String(null)

AccountSource "Ontario Works"

Children_Services_Household_Id__c 112311221(null)

RGI_Houshold_Id__c (null)

OW_Household_id__c ICCaseID
1212724857222
BU ID
Purpose:
To link together members of an OW household

IndigenousInd 0

IndigenousGroupBoolean/Integer

(Is_sensitive_client__c(Boolean/Integer) DomesticViolenceIndicator 0

DomesticViolenceStart

DomesticViolenceEnd

(OW_start_date__c
(format:YYYY-MM-DD)
StatusChangeDate 20190826

RecordChangeDate 20191002
WP_Ind__c WPInd
1 or null
Welcome Policy Indicator / Consent
WP_Start_Date__c
(format:YYYY-MM-DD) WPStartDate

20210608 Welcome Start Date
format:YYYYMMDD
WP_End_Date__c
(format:YYYY-MM-DD) WPEndDate 20220609 Welcome End Date
format:YYYYMMDD
Object_Name__c "Account"

JSON example:

{
"allOrNone" : false,
"compositeRequest" : [
{
     "method" : "POST",
      "url" : "/services/data/v45.0/sobjects/Legacy_System_Record__e",
      "referenceId" : "101025047",
       "body" : {
              "JSON_Message__c" : "{
                           "Type":"Account",
                           "ReferenceId":"101025047",
                           "_type":"ClientProfile",
                          "Ontario_Works_Id__c":"101025047",
                          "case_status__c":"CS1",
                            "SAMS_Status__c":"Active",
                            "first_name__c":"",
                            "last_name__c":"",
                            "Name":"",
                            "gender__c":"Female",
                            "date_of_birth__c":"1980-",
                            "Phone":"6476785523",
                             "BillingStreet":"-",
                             "BillingCity":"SCARBOROUGH",
                             "BillingState":"Ontario",
                             "BillingPostalCode":"M1E ",
                             "OW_start_date__c":"2021-",
                             "BillingCountry":"CA",
                             "AccountSource":"Ontario Works",
                             "RecordTypeId":"0126A000000yrPjQAI",
                             "OW_Household_id__c":"103474441214",
                             "Is_sensitive_client__c

StringAccount

":0" }", "Object_Name__c" : "Account" } }... ] }

Process Log

The process log table is used to manage the date ranges when calling the service.

...

Version	Old Version 5	New Version Current
Changes made by	Vincent Li (Unlicensed)	Vincent Li (Unlicensed)
Saved on	Oct 18, 2019	Jun 09, 2021

Versions Compared

Key

Salesforce Sync JSON Data Mapping

:

JSON example:

Process Log

JSON Fields	Arribute	Salesforce Fields	TCS Example	OW API Fields	OW API Example	Comment
JSON_Message__c
String	first_name__c	pettest101	GivenName	Bibiana
last_name__c	LastName	MKMOPPJXK
	~~MiddleName~~
(case_status__c)	~~StatusCode~~	CS10001
SAMS_Status__c	Status	Completed
	~~Active~~	1
Name	String	firstname + ' ' +	demowithinsert MiddleName + ' '+ lastname
	~~GenderCode~~	F
gender__c	Gender	Female
(suffix)	salutation__c	date_of_birth__c	String ~~Title~~	Mrs.
date_of_birth__c	(yyyy-	mm-	dd)	DoB	19820428Title
email__c	String	email__c	ctpNwJMdPJtpjTF@toronto.ca	Phone	String	phone	4164041943	(null)
phone	Telephone	555-5555555
Secondary_Phone__c	(null)
Other_phone__c	(null)
Mobile_phone__c	(null)
Is_Aboriginal__c	BillingStreet	String (null)
BillingStreet(Primary)	200 WELLESLEY ST E	UnitNumber\|\|' '\|\|streetNumber\|\| ' ' \|\| streetName	1254 Street	BillingCity	String	BillingCity	UnitNumber + '-' +streetNumber + ' ' + streetName	12-1254 Street
BillingCity	city	SCARBOROUGH
BillingStateString	BillingState	ON	province	SCARBOROUGH	BillingPostalCode	String
BillingPostalCodeM4X 1G3	postalCode	M5N 5E3
BillingCountry	String	BillingCountry	CA	BillingGeocodeAccuracy	PostalAddress	1254 Street , SCARBOROUGH, Ontario, M5N 5E3"CA"
ShippingStreet(Secondary)	(null)
ShippingCity	(null)
ShippingState	(null)
ShippingPostalcode	(null)
ShippingCountry	(null)
RecordTypeId	String	(RecordTypeId)	0121h0000004kgaAAA 0121h0000004kgaAAA (Parent) (age >=18 based on birthday) 012W000000016sEIAQ (Child) (age <18 based on birthday)
Ontario_Works_Id__c	String	Ontario_Works_Id__c	3304892315	ReferenceNum	15146436109	Children_Services_Id__c	StringReferenceNum	15146436109 SAMS client reference number Purpose: Call client search Call client ID verification
Children_Services_Id__c	441234781(null)
CSIS_household_Id__c	AccountSource	Children_Services_Household_Id__c	String(null)
AccountSource	"Ontario Works"
Children_Services_Household_Id__c	112311221(null)
RGI_Houshold_Id__c	(null)
OW_Household_id__c	ICCaseID	1212724857222 BU ID Purpose: To link together members of an OW household
	~~IndigenousInd~~	0
	~~IndigenousGroup~~Boolean/Integer
(Is_sensitive_client__c(Boolean/Integer)	DomesticViolenceIndicator	0
	~~DomesticViolenceStart~~
	~~DomesticViolenceEnd~~
(OW_start_date__c (format:YYYY-MM-DD)	StatusChangeDate	20190826
	~~RecordChangeDate~~	20191002
WP_Ind__c	WPInd	1 or null	Welcome Policy Indicator / Consent
WP_Start_Date__c (format:YYYY-MM-DD)	WPStartDate	20210608	Welcome Start Date format:YYYYMMDD
WP_End_Date__c (format:YYYY-MM-DD)	WPEndDate	20220609	Welcome End Date format:YYYYMMDD
Object_Name__c	"Account"