Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
AMOUNT	Total value of the encumbrance being recorded.	NUMBER	FGBENCH	FGBENCH_DOC_AMT	NO	NO
APPROVAL_IND	Indicates the document has met final approval.	VARCHAR2(1)	FGBENCH	FGBENCH_APPR_IND	NO	NO
CHANGE_DESC	Title or a brief description of any change made to an existing encumbrance.	VARCHAR2(35)	FGBENCH	FGBENCH_CHANGE_DESC	NO	NO
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	NO	NO
COMPLETE_IND	Indicates if the encumbrance document is complete.	VARCHAR2(1)	CALCULATION	DECODE(FGBENCH_STATUS)	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DEFERRED_EDIT_IND		VARCHAR2(1)				NO
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	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
ENCUMBRANCE_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	FGBENCH	FGBENCH_ACTIVITY_DATE	NO	NO
ENCUMBRANCE_CREATE_DATE	Date that information for this record in the table was entered.	DATE	FGBENCH	FGBENCH_CREATE_DATE	NO	NO
ENCUMBRANCE_CREATE_SOURCE	Source system that created the new record.	VARCHAR2(30)	FGBENCH	FGBENCH_CREATE_SOURCE	NO	NO
ENCUMBRANCE_CREATE_USER	Unique identification code of the user who created the encumbrance.	VARCHAR2(30)	FGBENCH	FGBENCH_CREATE_USER	NO	NO
ENCUMBRANCE_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(30)	FGBENCH	FGBENCH_DATA_ORIGIN	NO	NO
ENCUMBRANCE_DESC	Encumbrance description or title.	VARCHAR2(35)	FGBENCH	FGBENCH_DESC	NO	NO
ENCUMBRANCE_NUMBER	Unique encumbrance code of a document.	VARCHAR2(8)	FGBENCH	FGBENCH_NUM	NO	NO
ENCUMBRANCE_SOURCE	Indicates the actual document type source for the encumbrance.	VARCHAR2(35)	CALCULATION	DECODE(FGBENCH_SOURCE_IND)	NO	NO
ENCUMBRANCE_STATUS	Indicates the status of the encumbrance; Whether it is closed or open.	VARCHAR2(30)	CALCULATION	DECODE(FGBENCH_STATUS_IND)	NO	NO
ENCUMBRANCE_TYPE	Indicates the type of encumbrance as either general encumbrance, labor, purchase order or requisition.	VARCHAR2(1)	FGBENCH	FGBENCH_TYPE	NO	NO
ENCUMBRANCE_USER_ID	Unique identification code of the user who entered or last updated the encumbrance.	VARCHAR2(30)	FGBENCH	FGBENCH_USER_ID	NO	NO
ESTABLISHED_DATE	Date the encumbrance was originally established.	DATE	FGBENCH	FGBENCH_ESTAB_DATE	NO	NO
HR_ENCUMBRANCE_IND	Indicates whether the encumbrance is from Human Resources.	CHAR(1)	CALCULATION	CASE WHEN ENCUMBRANCE_NUMBER	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
NSF_ON_OFF_IND		VARCHAR2(1)				NO
TEXT_IND	Indicates if the document has associated text.	VARCHAR2(1)	FGBENCH	FGBENCH_TEXT_IND	NO	NO
TRANSACTION_DATE	Date used by the finance system to control posting to the ledgers.	DATE	FGBENCH	FGBENCH_TRANS_DATE	NO	NO
VENDOR_UID	System generated unique internal identification number used to access the vendor.	NUMBER	FGBENCH	FGBENCH_VENDOR_PIDM	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: