Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACCOUNT		Code representing an account, such as revenue, labor, expenditure or transfer.	VARCHAR2(6)		FGBENCD	FGBENCD_ACCT_CODE
ACCOUNT_DESC		Account code description or title.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
ACCOUNT_INDEX	Account INDEX		VARCHAR2(6)
ACCOUNT_INDEX_DESC	Account INDEX Description		VARCHAR2(35)
ACCOUNT_INDEX_STATUS	Account INDEX Status		VARCHAR2(1)
ACCOUNT_STATUS		Current status of the associated account.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
ACTIVITY		Code used to identify accounting data by activity.	VARCHAR2(6)		FGBENCD	FGBENCD_ACTV_CODE
ACTIVITY_DESC		Activity code title or description.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
ACTIVITY_STATUS		Extracted current status of the associated activity.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
AVAILABLE_BALANCE_OVERRIDE_IND	Available Balance Override Indicator		VARCHAR2(1)
CHART_OF_ACCOUNTS		Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)		FGBENCD	FGBENCD_COAS_CODE
CHART_OF_ACCOUNTS_DESC		Chart of accounts code description or title.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_STATUS		Extracted current status of the associated chart of accounts.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
COMMITMENT_PERCENT	Commitment Percent		NUMBER
COMMITMENT_TYPE	Commitment Type		VARCHAR2(1)
COMMITMENT_TYPE_DESC	Commitment Type Description		VARCHAR2(11)
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DISTRIBUTION_PERCENT		Percentage of the of the transaction total amount assigned to this accounting distribution.	NUMBER(6, 3)		FGBENCD	FGBENCD_DIST_PCT
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
ENCUMBRANCE_NUMBER		Unique encumbrance code of a document.	VARCHAR2(8)		FGBENCD	FGBENCD_NUM
ENCUMBRANCE_STATUS		Indicates the status of the encumbrance; Whether it is closed or open.	VARCHAR2(30)		CALCULATION	DECODE(FGBENCD_STATUS)
ENC_ACCOUNTING_ACTIVITY_DATE	Enc Accounting Activity Date		DATE
ENC_ACCOUNTING_CREATE_DATE	Enc Accounting Create Date		DATE
ENC_ACCOUNTING_CREATE_SOURCE	Enc Accounting Create Source		VARCHAR2(30)
ENC_ACCOUNTING_CREATE_USER	Enc Accounting Create User		VARCHAR2(30)
ENC_ACCOUNTING_DATA_ORIGIN	Enc Accounting Data Origin		VARCHAR2(30)
ENC_ACCOUNTING_USER_ID	Enc Accounting User ID		VARCHAR2(30)
FIELD_CODE	Field Code		VARCHAR2(2)
FIELD_CODE_DESC	Field Code Description		VARCHAR2(18)
FISCAL_PERIOD		Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.	VARCHAR2(2)		FGBENCD	FGBENCD_POSTING_PERIOD
FISCAL_YEAR		Unique identifier or code for the fiscal year.	VARCHAR2(4)		FUNCTION	FOFYCNV
FUND		Unique fiscal entity code.	VARCHAR2(6)		FGBENCD	FGBENCD_FUND_CODE
FUND_DESC		Description or title of the associated fund.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
FUND_STATUS		Extracted current status of the associated fund.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
ITEM		System-generated line item number that identifies each commodity line item for procurement documents.	NUMBER(4)		FGBENCD	FGBENCD_ITEM
LOCATION		Identification accounting code of the physical location of the financial manager.	VARCHAR2(6)		FGBENCD	FGBENCD_LOCN_CODE
LOCATION_DESC		Extracted description or title of the associated location.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
LOCATION_STATUS		Extracted current status of the associated location.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
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
ORGANIZATION_CODE		Identification accounting code used for the department.	VARCHAR2(6)		FGBENCD	FGBENCD_ORGN_CODE
ORGANIZATION_DESC		Extracted description or title associated with the organization code.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
ORGANIZATION_STATUS		Extracted current status of the associated organization.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
PENDING_AMOUNT	Pending Amount	Amount of the encumbrance being charged to this accounting distribution.	NUMBER(17,2)		FGBENCD	FGBENCD_PEND_AMT
POSTABLE_IND		Deciphers encumbrance accounting line as postable, error checked.	VARCHAR2(1)		CALCULATION	DECODE(FGBENCD_STATUS_IND)
PROGRAM		Identification accounting code use to identify the program classification structure or a subset or that structure as defined by the national council of higher education management systems.	VARCHAR2(6)		FGBENCD	FGBENCD_PROG_CODE
PROGRAM_DESC		Extracted description or title of the associated program.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
PROGRAM_STATUS		Extracted current status of the associated program.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
PROJECT		Work order code used within cost accounting module.	VARCHAR2(8)		FGBENCD	FGBENCD_PRJD_CODE
RULE_CLASS	Rule Class		VARCHAR2(4)
RULE_CLASS_DESC	Rule Class Description		VARCHAR2(35)
SEQUENCE_NUMBER		System-generated one-up number to support split accounting within a document.	NUMBER(4)		FGBENCD	FGBENCD_SEQ_NUM
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: