Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Travel And Expense Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AE_STATUS_HISTORY

Description Contains status and status date history as the authorization / reimbursement request migrates through various stages of completion.
Key & Frequency One row per authorization or reimbursement per change in status.

Target Column Business Definition Database Data Type Source Name Source Column
AUTHORIZATION_KEY Unique internal identification number of the authorization record. NUMBER

FTRRSTHS

FTRBAUTH_ID

CURRENT_DATE SYSDATE. DATE

FUNCTION

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

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

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

REIMBURSEMENT_KEY Unique internal identification number of the reimbursement record. NUMBER

FTRRSTHS

FTRBREMB_ID

STATUS Request status. VARCHAR2(1)

FTRRSTHS

STATUS

STATUS_DATE Date and time the status was updated. DATE

FTRRSTHS

STATUS_DATE

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

FTRRSTHS

DATA_ORIGIN

STATUS_HISTORY_KEY Unique internal identification number of the status history record. NUMBER

FTRBAUTH

ID

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

FTRRSTHS

USER_ID

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: