Reporting View Target: AUTHORIZATION

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Travel And Expense Reporting View Reports

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 PORTFOLIO_KEY
AUTHORIZATION_KEY
TRAVEL_START_DATE
ITINERARY_KEY
OWNER_UID
AUTHORIZATION, AUTHORIZATION_STATUS

Target Column Business Definition Database Data Type Source Name Source Column

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

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 request description. VARCHAR2(255)
FTRBAUTH

DESCRIPTION

AUTHORIZATION_KEY Unique internal identification number of the authorization record. NUMBER
FTPRITIN

FTRBAUTH_ID

AUTHORIZATION_STATUS Authorization request status. VARCHAR2(63)
FTRBAUTH

REQUEST_STATUS

AUTHORIZATION_STATUS_DESC 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 Source system that created or updated the row. VARCHAR2(63)
FTPRITIN

DATA_ORIGIN

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

CREATE_SOURCE

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

CREATE_USER

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

USER_ID

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

NA

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

NA

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

MAKFUNC.F_GET_ENTITY_IND

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

MAKFUNC.F_GET_PERSON_INFO

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 Unique identification of the person who owns this portfolio and the expenses within it. NUMBER
FTPBPORT

OWNER_PIDM

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 Unique internal identification number of the portfolio record. NUMBER
FTPRITIN

FTPBPORT_ID

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-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

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

FROM_CITY

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

FROM_NATN_CODE

TRAVEL_FROM_NATION_DESC Nation/country code description. VARCHAR2(255)
STVNATN

STVNATN_NATION

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 State or province name. VARCHAR2(255)
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(63)
FTPRITIN

TO_CITY

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

TO_NATN_CODE

TRAVEL_TO_NATION_DESC Nation/country code description. VARCHAR2(255)
STVNATN

STVNATN_NATION

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 State or province name. VARCHAR2(255)
STVSTAT

STVSTAT_DESC

Ver: 9.1

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	PORTFOLIO_KEY AUTHORIZATION_KEY TRAVEL_START_DATE ITINERARY_KEY OWNER_UID AUTHORIZATION, AUTHORIZATION_STATUS

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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 request description.	VARCHAR2(255)	FTRBAUTH	DESCRIPTION
AUTHORIZATION_KEY	Unique internal identification number of the authorization record.	NUMBER	FTPRITIN	FTRBAUTH_ID
AUTHORIZATION_STATUS	Authorization request status.	VARCHAR2(63)	FTRBAUTH	REQUEST_STATUS
AUTHORIZATION_STATUS_DESC	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	Source system that created or updated the row.	VARCHAR2(63)	FTPRITIN	DATA_ORIGIN
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(63)	FTPRITIN	CREATE_SOURCE
ITINERARY_CREATE_USER	Banner ID of the person who created this new record.	VARCHAR2(63)	FTPRITIN	CREATE_USER
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(63)	FTPRITIN	USER_ID
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
OWNER_ENTITY_IND	Indicates whether the expense owner is a person or an organization.	VARCHAR2(1)	FUNCTION	MAKFUNC.F_GET_ENTITY_IND
OWNER_ID	User-defined or system generated one-up number of the expense owner.	VARCHAR2(63)	FUNCTION	MAKFUNC.F_GET_PERSON_INFO
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	Unique identification of the person who owns this portfolio and the expenses within it.	NUMBER	FTPBPORT	OWNER_PIDM
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	Unique internal identification number of the portfolio record.	NUMBER	FTPRITIN	FTPBPORT_ID
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-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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(63)	FTPRITIN	FROM_CITY
TRAVEL_FROM_NATION	Nation/country code in which the travel segment begins.	VARCHAR2(63)	FTPRITIN	FROM_NATN_CODE
TRAVEL_FROM_NATION_DESC	Nation/country code description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
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	State or province name.	VARCHAR2(255)	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(63)	FTPRITIN	TO_CITY
TRAVEL_TO_NATION	Nation/country code in which the travel segment ends.	VARCHAR2(63)	FTPRITIN	TO_NATN_CODE
TRAVEL_TO_NATION_DESC	Nation/country code description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
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	State or province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC