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 Local Source Local Target
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

NO

NO

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

FTRRACIR

FTRRRCIR

ID

ID

NO

NO

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

FTRRACIR

FTRRRCIR

FOBCIRH_ID

FOBCIRH_ID

NO

NO

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

NA

SYSDATE

NO

NO
DOC_TYPE Document type. NUMBER

CONSTANT

CONSTANT

85

86

NO

NO

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

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

NO
REQUEST_KEY Unique interanal identification number of the request record. NUMBER

FTRRACIR

FTRRRCIR

FTRBAUTH_ID

FTRBREMB_ID

NO

NO

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

FTRRACIR

FTRRRCIR

USER_ID

USER_ID

NO

NO

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

NA

NA

NO

NO


Ver: