Target Column	Business Definition	Database Data Type	Source Name	Source Column
AMOUNT	Total value of the encumbrance being recorded.	NUMBER(17,2)	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
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_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
ESTABLISHED_DATE	Date the encumbrance was originally established.	DATE	FGBENCH	FGBENCH_ESTAB_DATE
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
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(8)	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: 8.1