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.
...
Salesforce Fields | OW API Fields | OW API Example | Comment |
|---|---|---|---|
| JSON_Message__c | |||
| first_name__c | GivenName | Bibiana | |
| last_name__c | LastName | MKMOPPJXK | |
| case_status__c | CS10001 | ||
| SAMS_Status__c | Status | Completed | |
| 1 | |||
| Name | firstname + ' ' +MiddleName + ' '+ lastname | ||
| F | |||
| gender__c | Gender | Female | |
| salutation__c |
| Mrs. | |
| date_of_birth__c (yyyy-mm-dd) | DoB | 19820428 | |
| email__c | (null) | ||
| phone | Telephone | 555-5555555 | |
| Secondary_Phone__c | (null) | ||
| Other_phone__c | (null) | ||
| Mobile_phone__c | (null) | ||
| Is_Aboriginal__c | (null) | ||
| BillingStreet(Primary) | UnitNumber + '-' +streetNumber + ' ' + streetName | 12-1254 Street | |
| BillingCity | city | SCARBOROUGH | |
| BillingState | province | SCARBOROUGH | |
| BillingPostalCode | postalCode | M5N 5E3 | |
| BillingCountry | "CA" | ||
| ShippingStreet(Secondary) | (null) | ||
| ShippingCity | (null) | ||
| ShippingState | (null) | ||
| ShippingPostalcode | (null) | ||
| ShippingCountry | (null) | ||
| RecordTypeId | 0121h0000004kgaAAA (Parent) (age >=18 based on birthday) 012W000000016sEIAQ (Child) (age <18 based on birthday) | ||
| Ontario_Works_Id__c | ReferenceNum | 15146436109 | |
| Children_Services_Id__c | (null) | ||
| CSIS_household_Id__c | (null) | ||
| AccountSource | "Ontario Works" | ||
| Children_Services_Household_Id__c | (null) | ||
| RGI_Houshold_Id__c | (null) | ||
| OW_Household_id__c | ICCaseID | 1212724857222 | |
| 0 | |||
| Is_sensitive_client__c(Boolean/Integer) | DomesticViolenceIndicator | 0 | |
| OW_start_date__c (format:YYYY-MM-DD) | StatusChangeDate | 20190826 | |
| 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" |
...