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

...

:

...

TCS ExampleFirstNamedemowithinsert19660917BillingStreetAccount
Salesforce
Fields
OW API Fields OW API Example Comment
JSON_Message__c

String first_name__c pettest101 GivenName Bibianalastname
last_name__c
LastName
MKMOPPJXK

MiddleName

case_status__c StatusCode CS10001
SAMS_Statusc Status Completed

Active 1 Name String
Name
(Add (value is firstname + ' ' +MiddleName + ' '+ lastname))

GenderCode F
genderc Gender Female
(suffix) salutation__c
Title
date_of_birth__c StringMrs.
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
(null)

String BillingStreet(Primary) 200 WELLESLEY ST E UnitNumber||' '||streetNumber|| ' ' || streetName 1254 Street BillingCity String BillingCity TORONTO UnitNumber + '-' +streetNumber + ' ' + streetName 12-1254 Street
BillingCity city SCARBOROUGH
BillingStateString BillingState ON province SCARBOROUGH
BillingPostalCode String BillingPostalCode M4X 1G3 postalCode M5N 5E3
BillingCountry String BillingCountry CA 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 (null)

AccountSource "Ontario Works"

Children_Services_Household_Id__c String 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 String "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":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 6	New Version Current
Changes made by	Snehal Surti (Unlicensed)	Vincent Li (Unlicensed)
Saved on	Oct 21, 2019	Jun 09, 2021

Versions Compared

Key

Salesforce Sync JSON Data Mapping

:

JSON example:

Process Log

Salesforce Fields		OW API Fields	OW API Example	Comment
JSON_Message__c
String	first_name__c	pettest101	GivenName	Bibianalastname
last_name__c	LastName	MKMOPPJXK
	~~MiddleName~~
case_status__c	~~StatusCode~~	CS10001
SAMS_Status__c	Status	Completed
	~~Active~~	1	Name	String
Name		(Add (value is firstname + ' ' +MiddleName + ' '+ lastname))
	~~GenderCode~~	F
gender__c	Gender	Female
(suffix)	salutation__c	~~Title~~	date_of_birth__c	StringMrs.
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	(null)
String	BillingStreet(Primary)	200 WELLESLEY ST E	UnitNumber\|\|' '\|\|streetNumber\|\| ' ' \|\| streetName	1254 Street	BillingCity	String	BillingCity	TORONTO	UnitNumber + '-' +streetNumber + ' ' + streetName	12-1254 Street
BillingCity	city	SCARBOROUGH
BillingStateString	BillingState	ON	province	SCARBOROUGH
BillingPostalCode	String	BillingPostalCode	M4X 1G3	postalCode	M5N 5E3
BillingCountry	String	BillingCountry	CA	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	(null)
AccountSource	"Ontario Works"
Children_Services_Household_Id__c	String	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	String		"Account"