Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Travel And Expense Composite View Reports

Banner Operational Data Store
Composite View Target: AE_ITINERARY

Description Itineraries which define the various segments of a trip with the travel plan.
Key & Frequency One row per travel itinerary.

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: