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

Ver: