Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: ENCUMBRANCE

Description Contains encumbrance document number, type of encumbrance, encumbrance status, encumbrance posted date, encumbrance last change document, completion indicator, and approval indicator for the financial commitment.
Key & Frequency One row per encumbrance document number.
Recommended Search Columns ENCUMBRANCE_NUMBER
ENCUMBRANCE_TYPE

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
AMOUNT Total value of the encumbrance being recorded.    

FGBENCH

FGBENCH_DOC_AMT

 
APPROVAL_IND Indicates the document has met final approval.    

FGBENCH

FGBENCH_APPR_IND

 
CHANGE_DESC Title or a brief description of any change made to an existing encumbrance.    

FGBENCH

FGBENCH_CHANGE_DESC

 
CHANGE_NUMBER User-defined code identifies and provides an audit trail of any changes made to the original document. This code is actually used as the document code to post the encumbrance change to the ledgers.    

FGBENCH

FGBENCH_DOC_CHANGE_NUM

 
COMPLETE_IND Indicates if the encumbrance document is complete.    

CALCULATION

DECODE(FGBENCH_STATUS)

 
DOCUMENT_REFERENCE_NUMBER User-defined identification number further identifying this document and linking it to an external reference number.    

FGBENCH

FGBENCH_DOC_REF_NUM

 
ENCUMBRANCE_DESC Encumbrance description or title.    

FGBENCH

FGBENCH_DESC

 
ENCUMBRANCE_NUMBER Unique encumbrance code of a document.    

FGBENCH

FGBENCH_NUM

 
ENCUMBRANCE_SOURCE Deciphers document type source for the encumbrance as requisition, purchase order, or neither.    

CALCULATION

DECODE(FGBENCH_SOURCE_IND)

 
ENCUMBRANCE_STATUS Deciphers encumbrance document as open or closed.    

CALCULATION

DECODE(FGBENCH_STATUS_IND)

 
ENCUMBRANCE_TYPE Indicates the type of encumbrance as either general encumbrance, labor, purchase order or requisition.    

FGBENCH

FGBENCH_TYPE

 
ESTABLISHED_DATE Date the encumbrance was originally established.    

FGBENCH

FGBENCH_ESTAB_DATE

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

NA

NA

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

NA

NA

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
TEXT_IND Indicates if the document has associated text.    

FGBENCH

FGBENCH_TEXT_IND

 
TRANSACTION_DATE Date used by the finance system to control posting to the ledgers.    

FGBENCH

FGBENCH_TRANS_DATE

 
VENDOR_ID User-defined or system generated one-up number of the vendor.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
VENDOR_NAME Vendor Name    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
VENDOR_UID System generated unique internal identification number used to access the vendor.    

FGBENCH

FGBENCH_VENDOR_PIDM

 


Ver: 8.3