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_APPROVAL_HISTORY

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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVITY_DATE The date when the information for the record in this table was entered or last updated.    

FTRRACIR

FTRRRCIR

ACTIVITY_DATE

ACTIVITY_DATE

 
APPROVAL_HISTORY_KEY Unique internal identification number of the approval history record.    

FTRRACIR

FTRRRCIR

ID

ID

 
CIRCULATION_KEY Unique internal identification number of the circulation header record.    

FTRRACIR

FTRRRCIR

FOBCIRH_ID

FOBCIRH_ID

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

NA

SYSDATE

 
DOC_TYPE Document type    

CONSTANT

CONSTANT

85

86

 
DOMAIN_VALUE Domain column for future use, not currently populated.    

NA

NA

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

NA

NA

 
REQUEST_KEY Unique interanal identification number of the request record.    

FTRRACIR

FTRRRCIR

FTRBAUTH_ID

FTRBREMB_ID

 
USER_ID The unique identification code of the user who last touched this record.    

FTRRACIR

FTRRRCIR

USER_ID

USER_ID

 
ZONE_VALUE Zone column for future use, not currently populated.    

NA

NA

 


Ver: 8.3