Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

Banner Operational Data Store
Composite View Target: AF_ENCUMBRANCE

Description Source composite view contains general information on encumbrance item.

Target Column Business Definition Database Data Type Source Name Source Column
AMOUNT Total value of the encumbrance being recorded. NUMBER

FGBENCH

FGBENCH_DOC_AMT

APPROVAL_IND Indicates the document has met final approval. VARCHAR2(1)

FGBENCH

FGBENCH_APPR_IND

CHANGE_DESC Title or a brief description of any change made to an existing encumbrance. VARCHAR2(35)

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. VARCHAR2(8)

FGBENCH

FGBENCH_DOC_CHANGE_NUM

COMPLETE_IND Indicates if the encumbrance document is complete. VARCHAR2(1)

CALCULATION

DECODE(FGBENCH_STATUS)

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DEFERRED_EDIT_IND   VARCHAR2(1)    
DOCUMENT_REFERENCE_NUMBER User-defined identification number further identifying this document and linking it to an external reference number. VARCHAR2(8)

FGBENCH

FGBENCH_DOC_REF_NUM

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

ENCUMBRANCE_ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE

FGBENCH

FGBENCH_ACTIVITY_DATE

ENCUMBRANCE_CREATE_DATE Date that information for this record in the table was entered. DATE

FGBENCH

FGBENCH_CREATE_DATE

ENCUMBRANCE_CREATE_SOURCE Source system that created the new record. VARCHAR2(30)

FGBENCH

FGBENCH_CREATE_SOURCE

ENCUMBRANCE_CREATE_USER Unique identification code of the user who created the encumbrance. VARCHAR2(30)

FGBENCH

FGBENCH_CREATE_USER

ENCUMBRANCE_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(30)

FGBENCH

FGBENCH_DATA_ORIGIN

ENCUMBRANCE_DESC Encumbrance description or title. VARCHAR2(35)

FGBENCH

FGBENCH_DESC

ENCUMBRANCE_NUMBER Unique encumbrance code of a document. VARCHAR2(8)

FGBENCH

FGBENCH_NUM

ENCUMBRANCE_SOURCE Indicates the actual document type source for the encumbrance. VARCHAR2(35)

CALCULATION

DECODE(FGBENCH_SOURCE_IND)

ENCUMBRANCE_STATUS Indicates the status of the encumbrance; Whether it is closed or open. VARCHAR2(30)

CALCULATION

DECODE(FGBENCH_STATUS_IND)

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

FGBENCH

FGBENCH_TYPE

ENCUMBRANCE_USER_ID Unique identification code of the user who entered or last updated the encumbrance. VARCHAR2(30)

FGBENCH

FGBENCH_USER_ID

ESTABLISHED_DATE Date the encumbrance was originally established. DATE

FGBENCH

FGBENCH_ESTAB_DATE

HR_ENCUMBRANCE_IND Indicates whether the encumbrance is from Human Resources. CHAR(1)

CALCULATION

CASE WHEN ENCUMBRANCE_NUMBER

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

NSF_ON_OFF_IND   VARCHAR2(1)    
TEXT_IND Indicates if the document has associated text. VARCHAR2(1)

FGBENCH

FGBENCH_TEXT_IND

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

FGBENCH

FGBENCH_TRANS_DATE

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

FGBENCH

FGBENCH_VENDOR_PIDM

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: