Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AMOUNT	Total value of the encumbrance being recorded.	NUMBER	FGBENCH	FGBENCH_DOC_AMT
APPROVAL_IND	Indicates the document has met final approval.	VARCHAR2(63)	FGBENCH	FGBENCH_APPR_IND
CHANGE_DESC	Title or a brief description of any change made to an existing encumbrance.	VARCHAR2(255)	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(63)	FGBENCH	FGBENCH_DOC_CHANGE_NUM
COMPLETE_IND	Indicates if the encumbrance document is complete.	VARCHAR2(63)	CALCULATION	DECODE(FGBENCH_STATUS)
DEFERRED_EDIT_IND	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	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	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(63)	FGBENCH	FGBENCH_CREATE_SOURCE
ENCUMBRANCE_CREATE_USER	Unique identification code of the user who created the encumbrance.	VARCHAR2(63)	FGBENCH	FGBENCH_CREATE_USER
ENCUMBRANCE_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(63)	FGBENCH	FGBENCH_DATA_ORIGIN
ENCUMBRANCE_DESC	Encumbrance description or title.	VARCHAR2(255)	FGBENCH	FGBENCH_DESC
ENCUMBRANCE_NUMBER	Unique encumbrance code of a document.	VARCHAR2(63)	FGBENCH	FGBENCH_NUM
ENCUMBRANCE_SOURCE	Deciphers document type source for the encumbrance as requisition, purchase order, or neither.	VARCHAR2(63)	CALCULATION	DECODE(FGBENCH_SOURCE_IND)
ENCUMBRANCE_STATUS	Deciphers encumbrance document as open or closed.	VARCHAR2(63)	CALCULATION	DECODE(FGBENCH_STATUS_IND)
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.	VARCHAR2(255)	FUNCTION	SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'ENCUMBRANCE_TYPE' AND VALUE = ENCUMBRANCE_TYPE
ENCUMBRANCE_USER_ID	Unique identification code of the user who entered or last updated the encumbrance.	VARCHAR2(63)	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 Banner Human Resources.	VARCHAR2(1)	CALCULATION	CASE WHEN ENCUMBRANCE_NUMBER
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	Document encumbrance remaining balance.	NUMBER	FUNCTION	MFKFUNC.F_GET_LEDGER_REMAINING_BALANCE
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NSF_ON_OFF_IND	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-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
TEXT_IND	Indicates if the document has associated text.	VARCHAR2(63)	FGBENCH	FGBENCH_TEXT_IND
TRANSACTION_DATE	Date used by the finance system to control posting to the ledgers.	DATE	FGBENCH	FGBENCH_TRANS_DATE
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.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
VENDOR_UID	System generated unique internal identification number used to access the vendor.	NUMBER	FGBENCH	FGBENCH_VENDOR_PIDM

Ver: 8.5