| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
AMOUNT
|
Amount
|
Total value of the encumbrance being recorded.
|
NUMBER
|
FGBENCH
|
FGBENCH_DOC_AMT
|
|
APPROVAL_IND
|
Approval Indicator
|
Indicates the document has met final approval.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_APPR_IND
|
|
CHANGE_DESC
|
Change Description
|
Title or a brief description of any change made to an existing encumbrance.
|
VARCHAR2(255)
|
FGBENCH
|
FGBENCH_CHANGE_DESC
|
|
CHANGE_NUMBER
|
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(63)
|
FGBENCH
|
FGBENCH_DOC_CHANGE_NUM
|
|
COMPLETE_IND
|
Complete Indicator
|
Indicates if the encumbrance document is complete.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(FGBENCH_STATUS)
|
|
DEFERRED_EDIT_IND
|
Deferred Edit Indicator
|
Indicates activation of the deferred edit feature allowing batch editing of the accounting strings.
|
VARCHAR2(63)
|
CALCULATION
|
NVL(FGBENCH_EDIT_DEFERRAL,'N')
|
|
DOCUMENT_REFERENCE_NUMBER
|
Document Reference Number
|
User-defined identification number further identifying this document and linking it to an external reference number.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_DOC_REF_NUM
|
|
ENCUMBRANCE_ACTIVITY_DATE
|
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
|
Encumbrance Create Date
|
Date that information for this record in the table was entered.
|
DATE
|
FGBENCH
|
FGBENCH_CREATE_DATE
|
|
ENCUMBRANCE_CREATE_SOURCE
|
Encumbrance Create Source
|
Source system that created the new record.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_CREATE_SOURCE
|
|
ENCUMBRANCE_CREATE_USER
|
Encumbrance Create User
|
Unique identification code of the user who created the encumbrance.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_CREATE_USER
|
|
ENCUMBRANCE_DATA_ORIGIN
|
Encumbrance Data Origin
|
Source system that created or updated the data.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_DATA_ORIGIN
|
|
ENCUMBRANCE_DESC
|
Encumbrance Description
|
Encumbrance description or title.
|
VARCHAR2(255)
|
FGBENCH
|
FGBENCH_DESC
|
|
ENCUMBRANCE_NUMBER
|
Encumbrance Number
|
Unique encumbrance code of a document.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_NUM
|
|
ENCUMBRANCE_SOURCE
|
Encumbrance Source
|
Deciphers document type source for the encumbrance as requisition, purchase order, or neither.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(FGBENCH_SOURCE_IND)
|
|
ENCUMBRANCE_STATUS
|
Encumbrance Status
|
Deciphers encumbrance document as open or closed.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(FGBENCH_STATUS_IND)
|
|
ENCUMBRANCE_TYPE
|
Encumbrance Type
|
Indicates the type of encumbrance as either general encumbrance, labor, purchase order or requisition.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_TYPE
|
|
ENCUMBRANCE_TYPE_DESC
|
Encumbrance Type Description
|
Encumbrance type description.
|
VARCHAR2(255)
|
FUNCTION
|
SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'ENCUMBRANCE_TYPE' AND VALUE = ENCUMBRANCE_TYPE
|
|
ENCUMBRANCE_USER_ID
|
Encumbrance User ID
|
Unique identification code of the user who entered or last updated the encumbrance.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_USER_ID
|
|
ESTABLISHED_DATE
|
Established Date
|
Date the encumbrance was originally established.
|
DATE
|
FGBENCH
|
FGBENCH_ESTAB_DATE
|
|
HR_ENCUMBRANCE_IND
|
HR Encumbrance Indicator
|
Indicates whether the encumbrance is from Banner Human Resources.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN ENCUMBRANCE_NUMBER
|
|
LEDGER_ENCUMBERED_AMOUNT
|
Ledger Encumbered Amount
|
Sum of original encumbrance amounts plus encumbrance adjustments of all accounting lines for the maximum fiscal year.
|
NUMBER
|
FUNCTION
|
MFKFUNC.F_GET_LEDGER_ENCUMBERED_AMOUNT
|
|
LEDGER_REMAINING_BALANCE
|
Ledger Remaining Balance
|
Document encumbrance remaining balance.
|
NUMBER
|
FUNCTION
|
MFKFUNC.F_GET_LEDGER_REMAINING_BALANCE
|
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
|
NSF_ON_OFF_IND
|
Non_Sufficient Funds On Off Indicator
|
Indicates when non-sufficient funds checking will be performed. If (Y)es, checking is performed at time of data entry.
|
VARCHAR2(63)
|
CALCULATION
|
NVL(FGBENCH_NSF_ON_OFF_IND,'N')
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
TEXT_IND
|
Text Indicator
|
Indicates if the document has associated text.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_TEXT_IND
|
|
TRANSACTION_DATE
|
Transaction Date
|
Date used by the finance system to control posting to the ledgers.
|
DATE
|
FGBENCH
|
FGBENCH_TRANS_DATE
|
|
VENDOR_ID
|
Vendor ID
|
User-defined or system generated one-up number of the vendor.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
VENDOR_NAME
|
Vendor Name
|
Vendor Name.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
VENDOR_UID
|
Vendor UID
|
System generated unique internal identification number used to access the vendor.
|
NUMBER
|
FGBENCH
|
FGBENCH_VENDOR_PIDM
|