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

Description Contains status and status date history as the reimbursement request migrates through various stages of completion.
Key & Frequency One row per reimbursement per status change.
Recommended Search Columns PORTFOLIO_KEY
REIMBURSEMENT, REIMBURSEMENT_STATUS
REIMBURSEMENT_KEY
PORTFOLIO_KEY, REIMBURSEMENT_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

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

FTRBREMB

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

REIMBURSEMENT System generated code identifying the reimbursement. The prefix is defined by the client for system ID TRAVREIM in the table fobfseq. VARCHAR2(63)

FTRBREMB

DOC_CODE

REIMBURSEMENT_DESC Reimbursement request description. VARCHAR2(255)

FTRBREMB

DESCRIPTION

REIMBURSEMENT_KEY Unique internal identification number of the reimbursement record. NUMBER

FTRRSTHS

FTRBREMB_ID

REIMBURSEMENT_STATUS Reimbursement request status. VARCHAR2(63)

FTRRSTHS

STATUS

REIMBURSEMENT_STATUS_DATE Date and time the status was updated. DATE

FTRRSTHS

STATUS_DATE

REIMBURSEMENT_STATUS_DESC Reimbursement request status description. VARCHAR2(255)

FUNCTION

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

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

FUNCTION

MEKFUNC.F_STATUS_CHANGE_HOURS(REIMBURSEMENT_KEY, STATUS_DATE, 'R', '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(REIMBURSEMENT_KEY, STATUS_DATE, 'R', '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