Page Comparison

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

FairPass Profile Data Mapping

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",
email	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"	Process_type__c	"Fairpass",
Web_reference_number		Web_Reference_Number__c	"1"

Reference Jira:

Jira Legacy

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	171541f2-d15a-30f9-88a2-170d76c90864
key	HSIF-2717

Jira Legacy

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	171541f2-d15a-30f9-88a2-170d76c90864
key	HSIF-2718

Jira Legacy

server	JIRA
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	171541f2-d15a-30f9-88a2-170d76c90864
key	HSIF-2719

Reference TESS CSV format mapping.MigrationMapping.xlsx

FairPass Card replacement Mapping:

Versions Compared