| ODS Column |
ODS Business Definition |
ODS Calculation Formula |
ODS Data Type |
Banner Source Name |
Banner Source Column |
Banner Form Name |
|
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)
|
|
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
|
|
NA
|
SYSDATE
|
|
|
DOCUMENT_REFERENCE_NUMBER
|
User-defined identification number further identifying this document and linking it to an external reference number.
|
|
|
FGBENCH
|
FGBENCH_DOC_REF_NUM
|
|
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
|
|
NA
|
NA
|
|
|
ENCUMBRANCE_DESC
|
Encumbrance description or title.
|
|
|
FGBENCH
|
FGBENCH_DESC
|
|
|
ENCUMBRANCE_NUMBER
|
Unique encumbrance code of a document.
|
|
|
FGBENCH
|
FGBENCH_NUM
|
|
|
ENCUMBRANCE_SOURCE
|
Indicates the actual document type source for the encumbrance.
|
|
|
CALCULATION
|
DECODE(FGBENCH_SOURCE_IND)
|
|
|
ENCUMBRANCE_STATUS
|
Indicates the status of the encumbrance; Whether it is closed or open.
|
|
|
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
|
|
|
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
|
|
|
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_UID
|
System generated unique internal identification number used to access the vendor.
|
|
|
FGBENCH
|
FGBENCH_VENDOR_PIDM
|
|
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
|
|
NA
|
NA
|
|