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 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: