Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
AMOUNT	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
DEFERRED_EDIT_IND	Deferred Edit Indicator		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	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(30)		FGBENCH	FGBENCH_CREATE_SOURCE
ENCUMBRANCE_CREATE_USER	Encumbrance Create User	Unique identification code of the user who created the encumbrance.	VARCHAR2(30)		FGBENCH	FGBENCH_CREATE_USER
ENCUMBRANCE_DATA_ORIGIN	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	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	HR Encumbrance Indicator	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	Non_Sufficient Funds On Off Indicator		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(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: