| Task | Source | Target | JSON Format |
|---|---|---|---|
| Online Channel | online Channel endpoint (OData API) | CRM | Fairpass Profile record json |
| Fairpass Migration Data | TESS - NAS - CSV file | CRM | Fairpass Profile record json |
| TTC FairPass monthly Files (3) download | TTC SFTP | Corp NAS | |
| TTC FairPass Card Replacement File (1 of 3 in TTC files) | Corp NAS - xml file | CRM | FairPass Card Replace json |
...
| OData field | TESS CSV field | JSON field | Example |
|---|---|---|---|
| firstname | GivenName | First_Name__c | "Julius", |
| lastname | LastName | Last_Name__c | "Cicconettii", |
| dob | BirthDate | Date_of_Birth__c | "1967-04-09", |
| ADDRESS_FULL | StreetName | Street__c | "1815-12 12", |
| EmailAddress | Email__c | "d@email.com", | |
| CITY | City | City__c | "ETOBICOKE", |
| WARD | ProvinceCode | Province__c | "Ontario", |
| POSTAL_CODE | PostalCode | postal_code__c | "M5N 5E3", |
| phone | Alternate contact numbe | Phone__c | "333-333-3336", |
| phoneMobile | TelephoneNumber | Phone_Mobile__c | "333-333-3336", |
| sams_member_id | SAMS Reference# | sams_member_id__c | "372180668841", |
| presto_number | PrestoCardNum | presto_card__c | "41234567890", |
| tcs_household_id | TCS ID # (Children) | TCS_member_id__c | "372180668841", |
| "Fairpass Online" | "Fairpass Migration" | Process_type__c | "Fairpass Online", |
| Web_reference_number | Web_Reference_Number__c | "11604077789" | |
| Created_On | "Created_On__c" | "2020-10-22T18:44:19.000+0000" | |
| StartDate | Start_Date__c | 1980-09-03 | |
| ExpiryDate | End_Date__c | 1980-09-03 | |
| IssueDate | Issue_Date__c | 1980-09-03 |
Reference Jira:
| Jira Legacy | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| Jira Legacy | ||||||||
|---|---|---|---|---|---|---|---|---|
|
...