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

SGHE Banner Operational Data Store
Reporting View Target: AUTHORIZATION_STATUS_HISTORY

Description Contains status and status date history as the authorization request migrates through various stages of completion.
Key & Frequency One row per authorization per change in status.
Recommended Search Columns PORTFOLIO_KEY
AUTHORIZATION_KEY
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

FTRRSTHS

FTRBAUTH_ID

AUTHORIZATION_STATUS Authorization request status. VARCHAR2(63)

FTRRSTHS

STATUS

AUTHORIZATION_STATUS_DATE Date and time the status was updated. DATE

FTRRSTHS

STATUS_DATE

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

MESSAGE Indicates an action taken on the document for any of the status indicators. As an example, the invoice API for a reimbursement or the encumbrance API for an authorization may fail. That message needs to be recorded so that some form of action may be taken. VARCHAR2(4000)

FTRRSTHS

MESSAGE

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

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

FTRBAUTH

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

STATUS_CHANGE_HOURS Amount of time in hours between the prior status date and this status date. NUMBER

FUNCTION

MEKFUNC.F_STATUS_CHANGE_HOURS(AUTHORIZATION_KEY, STATUS_DATE, 'A', 'L')

STATUS_CHANGE_HOURS_TOTAL Amount of time in hours between the first established status date and this status date. NUMBER

FUNCTION

MEKFUNC.F_STATUS_CHANGE_HOURS(AUTHORIZATION_KEY, STATUS_DATE, 'A', 'T')

STATUS_HISTORY_ACTIVITY_DATE Date information for this record in the table was entered or last updated. DATE

FTRRSTHS

ACTIVITY_DATE

STATUS_HISTORY_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(63)

FTRRSTHS

DATA_ORIGIN

STATUS_HISTORY_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

FTRRSTHS

USER_ID



Ver: 8.5