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

Banner Operational Data Store
Composite View Target: AE_APPROVAL_HISTORY

Description History of requests for authorization or reimbursement approvals.
Key & Frequency One row per authorization or reimbursement request.

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE The date when the information for the record in this table was entered or last updated. DATE

FTRRACIR

FTRRRCIR

ACTIVITY_DATE

ACTIVITY_DATE

APPROVAL_HISTORY_KEY Unique internal identification number of the approval history record. NUMBER

FTRRACIR

FTRRRCIR

ID

ID

CIRCULATION_KEY Unique internal identification number of the circulation header record. NUMBER

FTRRACIR

FTRRRCIR

FOBCIRH_ID

FOBCIRH_ID

CURRENT_DATE This is a the system current date (sysdate). DATE

NA

SYSDATE

DOC_TYPE Document type. NUMBER

CONSTANT

CONSTANT

85

86

DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

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

REQUEST_KEY Unique interanal identification number of the request record. NUMBER

FTRRACIR

FTRRRCIR

FTRBAUTH_ID

FTRBREMB_ID

USER_ID The unique identification code of the user who last touched this record. VARCHAR2(30)

FTRRACIR

FTRRRCIR

USER_ID

USER_ID

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: