Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
AUTHORIZATION_KEY	Unique internal identification number of the authorization record.	NUMBER	FTPRITIN	FTRBAUTH_ID	NO	NO
CURRENT_DATE	This is a the system current date (sysdate).	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
ITINERARY_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	FTPRITIN	ACTIVITY_DATE	NO	NO
ITINERARY_CREATE_DATE	Date and time when a new itinerary record was created.	DATE	FTPRITIN	CREATE_DATE	NO	NO
ITINERARY_CREATE_SOURCE	Source system that created the data.	VARCHAR2(30)	FTPRITIN	CREATE_SOURCE	NO	NO
ITINERARY_CREATE_USER	ID of the person who created this new record.	VARCHAR2(30)	FTPRITIN	CREATE_USER	NO	NO
ITINERARY_DATA_ORIGIN	Source system that created or updated the row.	VARCHAR2(30)	FTPRITIN	DATA_ORIGIN	NO	NO
ITINERARY_KEY	Unique internal identification number of the itinerary record.	NUMBER	FTPRITIN	ID	NO	NO
ITINERARY_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FTPRITIN	USER_ID	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
PORTFOLIO_KEY	Unique internal identification number of the portfolio record.	NUMBER	FTPRITIN	FTPBPORT_ID	NO	NO
REIMBURSEMENT_KEY	Unique internal identification number of the reimbursement record.	NUMBER	FTPRITIN	FTRBREMB_ID	NO	NO
TRAVEL_END_DATE	Ending date and time for the travel segment.	DATE	FTPRITIN	END_DATE	NO	NO
TRAVEL_FROM_CITY	City name in which the travel segment begins.	VARCHAR2(50)	FTPRITIN	FROM_CITY	NO	NO
TRAVEL_FROM_NATION	Nation/country code in which the travel segment begins.	VARCHAR2(5)	FTPRITIN	FROM_NATN_CODE	NO	NO
TRAVEL_FROM_NATION_DESC	Nation/country code description.	VARCHAR2(30)	STVNATN	STVNATN_NATION	NO	NO
TRAVEL_FROM_STATE_PROVINCE	State or province code in which the travel segment begins.	VARCHAR2(3)	FTPRITIN	FROM_STAT_CODE	NO	NO
TRAVEL_FROM_STATE_PROV_DESC	State or province name.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
TRAVEL_START_DATE	Start date and time for the travel segment.	DATE	FTPRITIN	START_DATE	NO	NO
TRAVEL_TO_CITY	City name in which the travel segment ends.	VARCHAR2(50)	FTPRITIN	TO_CITY	NO	NO
TRAVEL_TO_NATION	Nation/country code in which the travel segment ends.	VARCHAR2(5)	FTPRITIN	TO_NATN_CODE	NO	NO
TRAVEL_TO_NATION_DESC	Nation/country code description.	VARCHAR2(30)	STVNATN	STVNATN_NATION	NO	NO
TRAVEL_TO_STATE_PROVINCE	State or province code in which the travel segment ends.	VARCHAR2(3)	FTPRITIN	TO_STAT_CODE	NO	NO
TRAVEL_TO_STATE_PROVINCE_DESC	State or province name.	VARCHAR2(30)	STVSTAT	STVSTAT_DESC	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: