Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Neu Schedule Data Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: AUTHORIZATION_ITINERARY

Description Contains information about where a person or group plans to travel with their start and end dates of travel as well as each start and ending locations.
Key & Frequency One row per authorization per itinerary segment.
Recommended Search Columns AUTHORIZATION_KEY
PORTFOLIO_KEY
AUTHORIZATION, AUTHORIZATION_STATUS
ITINERARY_KEY
TRAVEL_START_DATE
OWNER_UID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

AUTHORIZATION Authorization System generated code identifying the authorization. The prefix is defined by the client for system ID TRAVAUTH in the table fobfseq. VARCHAR2(63)  

FTRBAUTH

DOC_CODE

AUTHORIZATION_DESC Authorization Description Authorization request description. VARCHAR2(255)  

FTRBAUTH

DESCRIPTION

AUTHORIZATION_KEY Authorization KEY Unique internal identification number of the authorization record. NUMBER  

FTPRITIN

FTRBAUTH_ID

AUTHORIZATION_STATUS Authorization Status Authorization request status. VARCHAR2(63)  

FTRBAUTH

REQUEST_STATUS

AUTHORIZATION_STATUS_DESC Authorization Status Description Authorization request status description. VARCHAR2(255)  

FUNCTION

SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'REQUEST_STATUS' AND VALUE = REIMBURSEMENT_STATUS

DATA_ORIGIN Data Origin Source system that created or updated the row. VARCHAR2(63)  

FTPRITIN

DATA_ORIGIN

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(63)  

FTPRITIN

CREATE_SOURCE

ITINERARY_CREATE_USER Itinerary Create User Banner ID of the person who created this new record. VARCHAR2(63)  

FTPRITIN

CREATE_USER

ITINERARY_KEY Itinerary KEY Unique internal identification number of the itinerary record. NUMBER  

FTPRITIN

ID

ITINERARY_USER_ID Itinerary User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)  

FTPRITIN

USER_ID

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)  

NA

NA

OWNER_ENTITY_IND Owner Entity Indicator Indicates whether the expense owner is a person or an organization. VARCHAR2(1)  

FUNCTION

MAKFUNC.F_GET_ENTITY_IND

OWNER_ID Owner ID User-defined or system generated one-up number of the expense owner. VARCHAR2(63)  

FUNCTION

MAKFUNC.F_GET_PERSON_INFO

OWNER_NAME Owner Name Combination of the person's last, first, and middle initial into one value. VARCHAR2(255)  

FUNCTION

MAKFUNC.F_GET_PERSON_INFO

OWNER_UID Owner UID Unique identification of the person who owns this portfolio and the expenses within it. NUMBER  

FTPBPORT

OWNER_PIDM

PORTFOLIO Portfolio System generated code identifying the portfolio. The prefix is defined by the client for system ID TRAVPORT in the table fobfseq. VARCHAR2(63)  

FTPBPORT

PORTFOLIO_NUMBER

PORTFOLIO_KEY Portfolio KEY Unique internal identification number of the portfolio record. NUMBER  

FTPRITIN

FTPBPORT_ID

PORTFOLIO_NAME Portfolio Name Name assigned to the Portfolio. As an example, Office expenses for year 2008 or Recruiting Trip in Southern California. VARCHAR2(63)  

FTPBPORT

NAME

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

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(63)  

FTPRITIN

FROM_CITY

TRAVEL_FROM_NATION Travel From Nation Nation/country code in which the travel segment begins. VARCHAR2(63)  

FTPRITIN

FROM_NATN_CODE

TRAVEL_FROM_NATION_DESC Travel From Nation Description Nation/country code description. VARCHAR2(255)  

STVNATN

STVNATN_NATION

TRAVEL_FROM_STATE_PROVINCE Travel From State Province State or province code in which the travel segment begins. VARCHAR2(63)  

FTPRITIN

FROM_STAT_CODE

TRAVEL_FROM_STATE_PROV_DESC Travel From State Province Description State or province name. VARCHAR2(255)  

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(63)  

FTPRITIN

TO_CITY

TRAVEL_TO_NATION Travel To Nation Nation/country code in which the travel segment ends. VARCHAR2(63)  

FTPRITIN

TO_NATN_CODE

TRAVEL_TO_NATION_DESC Travel To Nation Description Nation/country code description. VARCHAR2(255)  

STVNATN

STVNATN_NATION

TRAVEL_TO_STATE_PROVINCE Travel To State Province State or province code in which the travel segment ends. VARCHAR2(63)  

FTPRITIN

TO_STAT_CODE

TRAVEL_TO_STATE_PROVINCE_DESC Travel To State Province Description State or province name. VARCHAR2(255)  

STVSTAT

STVSTAT_DESC



Ver: 9.0