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

Ver: 8.3