Versions Compared

Version Old Version 4 New Version Current
Changes made by

Vincent Li (Unlicensed)

Vincent Li (Unlicensed)

Saved on

Key

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

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.

...

SourceDestinationComment

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|| ' ' || streetNamestreet
citycity
provincestate_code
postalCodepostal_code
'CA'country_code
'Address'geocodeAccuracy
businessUnitIdhousehold_id__c
StatusCodecase_status__c
DomesticViolenceIndicator

Salesforce Sync JSON Data Mapping

...

:

...

JSON FieldsArribute

Salesforce

Fields

TCS Example

OW API FieldsOW API ExampleComment
JSON_Message__c
FirstNameString



first_name__c
pettest101
GivenNameBibiana
last_name__c

LastName

MKMOPPJXK

MiddleName
(


case_status__c
)
StatusCodeCS10001
SAMS_Status__cStatusCompleted

Active1
Name
String(Add (value is firstname + '

firstname + '  ' +MiddleName +  '  '+ lastname

))demowithinsert




GenderCodeF
gender__cGenderFemale
(suffix)String

salutation__c
date_of_birth__c

Title

Mrs.
date_of_birth__c
1966
(yyyy-
09
mm-
17
dd)

DoB

19820428
Title

email__c
Stringemail__cctpNwJMdPJtpjTF@toronto.caPhoneStringphone4164041943String
(null)

phoneTelephone555-5555555
Secondary_Phone__c(null)

Other_phone__c

(null)



Mobile_phone__c

(null)



Is_Aboriginal__c
BillingStreet

(null)



BillingStreet(Primary)
200 WELLESLEY ST EUnitNumber||' '||streetNumber|| ' ' || streetName1254 StreetBillingCityStringBillingCityTORONTO
UnitNumber + '-'  +streetNumber + ' ' + streetName12-1254 Street
BillingCitycitySCARBOROUGH
BillingState
StringBillingStateON
provinceSCARBOROUGH
BillingPostalCodeString

BillingPostalCode
M4X 1G3
postalCodeM5N 5E3
BillingCountry
StringBillingCountryCABillingGeocodeAccuracyPostalAddress1254 Street , SCARBOROUGH, Ontario, M5N 5E3
"CA"

ShippingStreet(Secondary)(null)

ShippingCity(null)

ShippingState(null)

ShippingPostalcode(null)

ShippingCountry(null)

RecordTypeId
String(RecordTypeId)0121h0000004kgaAAAChildren_Services_Id__cString

0121h0000004kgaAAA  (Parent) (age >=18 based on birthday)

012W000000016sEIAQ  (Child) (age <18 based on birthday)



Ontario_Works_Id__c
StringOntario_Works_Id__c3304892315ReferenceNum15146436109
ReferenceNum

15146436109
SAMS client reference number
Purpose:
Call client search
Call client ID verification


Children_Services_Id__c
441234781String
(null)

CSIS_household_Id__c
AccountSource Children_Services_Household_Id__c
(null)

AccountSource "Ontario Works"

Children_Services_Household_Id__c
112311221
(null)

RGI_Houshold_Id__c(null)

OW_Household_id__cICCaseID

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



IndigenousInd0

IndigenousGroup
(


Is_sensitive_client__c(Boolean/Integer)DomesticViolenceIndicator0

DomesticViolenceStart


DomesticViolenceEnd
(


OW_start_date__c
(format:YYYY-MM-DD)
StatusChangeDate20190826

RecordChangeDate20191002
WP_Ind__cWPInd

1 or null

Welcome Policy Indicator / Consent
WP_Start_Date__c
(format:YYYY-MM-DD)		WPStartDate

20210608Welcome Start Date
format:YYYYMMDD
WP_End_Date__c
(format:YYYY-MM-DD)		WPEndDate20220609Welcome 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

StringAccount

":"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.

...