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

Ver: