Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT	Code representing an account, such as revenue, labor, expenditure or transfer.	VARCHAR2(63)	FGBENCD	FGBENCD_ACCT_CODE
ACCOUNT_DESC	Account code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ACCOUNT_INDEX	Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.	VARCHAR2(63)	FGBENCD	FGBENCD_ACCI_CODE
ACCOUNT_INDEX_DESC	Account index description.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ACCOUNT_INDEX_STATUS	Account index status.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS
ACCOUNT_STATUS	Current status of the associated account.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
ACTIVITY	Code used to identify accounting data by activity.	VARCHAR2(63)	FGBENCD	FGBENCD_ACTV_CODE
ACTIVITY_DESC	Activity code title or description.	VARCHAR2(255)	FTVACTV	FTVACTV_TITLE
ACTIVITY_STATUS	Current status of the associated activity.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AVAILABLE_BALANCE_OVERRIDE_IND	Determines whether the available balance of funds was overriden.	VARCHAR2(1)	CALCULATION	NVL(FGBENCD_ABAL_OVERRIDE)
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FGBENCD	FGBENCD_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_STATUS	Current status of the associated chart of accounts.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
COMMITMENT_PERCENT	Percent of budget carried forward on a rolled encumbrance.	NUMBER	FGBENCD	FGBENCD_CMT_PCT
COMMITMENT_TYPE	Encumbrance commitment type description.	VARCHAR2(63)	FGBENCD	FGBENCD_CMT_TYPE
COMMITMENT_TYPE_DESC	Encumbrance commitment type description.	VARCHAR2(255)	CALCULATION	CASE WHEN FGBENCD_CMT_TYPE
DISTRIBUTION_PERCENT	Percentage of the of the transaction total amount assigned to this accounting distribution.	NUMBER	FGBENCD	FGBENCD_DIST_PCT
DOCUMENT_ENCUMBRANCE_STATUS	Deciphers encumbrance document as open or closed.	VARCHAR2(63)	CALCULATION	DECODE(FGBENCH_STATUS_IND)
ENCUMBRANCE_NUMBER	Unique encumbrance code of a document.	VARCHAR2(63)	FGBENCD	FGBENCD_NUM
ENCUMBRANCE_STATUS	Deciphers encumbrance accounting line as open or closed.	VARCHAR2(63)	CALCULATION	DECODE(FGBENCD_STATUS)
ENC_ACCOUNTING_ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	FGBENCD	FGBENCD_ACTIVITY_DATE
ENC_ACCOUNTING_CREATE_DATE	Date that information for this record in the table was entered.	DATE	FGBENCD	FGBENCD_CREATE_DATE
ENC_ACCOUNTING_CREATE_SOURCE	Source system that created the new record.	VARCHAR2(63)	FGBENCD	FGBENCD_CREATE_SOURCE
ENC_ACCOUNTING_CREATE_USER	Unique identification code of the user who created the encumbrance encumbrance.	VARCHAR2(63)	FGBENCD	FGBENCD_CREATE_USER
ENC_ACCOUNTING_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(63)	FGBENCD	FGBENCD_DATA_ORIGIN
ENC_ACCOUNTING_USER_ID	Unique identification code of the user who entered or last updated the encumbrance accounting.	VARCHAR2(63)	FGBENCD	FGBENCD_USER_ID
FIELD_CODE	Two-digit code that represents the specific operating ledger bucket amount updated.	VARCHAR2(63)	FGBENCD	FGBENCD_OPAL_FIELD_CODE
FIELD_CODE_DESC	Two-digit code that represents the specific operating ledger bucket amount updated.	VARCHAR2(255)	CALCULATION	CASE WHEN FGBENCD_FIELD_CODE
FISCAL_PERIOD	Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.	VARCHAR2(63)	FGBENCD	FGBENCD_POSTING_PERIOD
FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(63)	FUNCTION	FOFYCNV
FUND	Unique fiscal entity code.	VARCHAR2(63)	FGBENCD	FGBENCD_FUND_CODE
FUND_DESC	Description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
FUND_STATUS	Current status of the associated fund.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
HR_ENCUMBRANCE_IND	Indicates whether the encumbrance is from Human Resources.	VARCHAR2(1)	CALCULATION	CASE WHEN ENCUMBRANCE_NUMBER
HR_ENCUMBRANCE_PERIOD	Determines whether Human Resources labor encumbrance item is current year or future year.	VARCHAR2(63)	CALCULATION	CASE WHEN HR_ENCUMBRANCE_IND
HR_ENCUMBRANCE_PERIOD_DESC	Humance Resources encumbrance period description.	VARCHAR2(255)	CALCULATION	CASE WHEN HR_ENCUMBRANCE_IND
ITEM	System-generated line item number that identifies each commodity line item for procurement documents.	NUMBER	FGBENCD	FGBENCD_ITEM
LABOR_ITEM_TYPE	Human Resources labor item description.	VARCHAR2(255)	CALCULATION	CASE WHEN HR_ENCUMBRANCE_IND
LEDGER_ENCUMBERED_AMOUNT		NUMBER	FUNCTION	MFKFUNC.F_GET_LEDGER_ENCUMBERED_AMOUNT
LEDGER_REMAINING_BALANCE		NUMBER	FUNCTION	MFKFUNC.F_GET_LEDGER_REMAINING_BALANCE
LOCATION	Identification accounting code of the physical location of the financial manager.	VARCHAR2(63)	FGBENCD	FGBENCD_LOCN_CODE
LOCATION_DESC	Description or title of the associated location.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
LOCATION_STATUS	Current status of the associated location.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
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
MULTI_YEAR_ENCUMBRANCE_IND	Indicates whether multi-year labor encumbering is utilized with a fund/grant combination.	VARCHAR2(1)	FRVFUND	FRVFUND_ENC_MULT_YEAR_IND
ORGANIZATION_CODE	Identification accounting code used for the department.	VARCHAR2(63)	FGBENCD	FGBENCD_ORGN_CODE
ORGANIZATION_DESC	Description or title associated with the organization code.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ORGANIZATION_STATUS	Current status of the associated organization.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
PENDING_AMOUNT	Amount of the encumbrance being charged to this accounting distribution.	NUMBER	FGBENCD	FGBENCD_PEND_AMT
POSTABLE_IND	Deciphers encumbrance accounting line as postable, error or not checked.	VARCHAR2(63)	CALCULATION	DECODE(FGBENCD_STATUS_IND)
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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(63)	FGBENCD	FGBENCD_PROG_CODE
PROGRAM_DESC	Description or title of the associated program.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
PROGRAM_STATUS	Current status of the associated program.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
PROJECT	Work order code used within cost accounting module.	VARCHAR2(63)	FGBENCD	FGBENCD_PRJD_CODE
RULE_CLASS	User defined rule class used to post the transaction.	VARCHAR2(63)	FGBENCD	FGBENCD_RUCL_CODE
RULE_CLASS_DESC	Rule class description.	VARCHAR2(255)	FTVRUCL	FTVRUCL_CLASS_TITLE
SEQUENCE_NUMBER	System-generated one-up number to support split accounting within a document.	NUMBER	FGBENCD	FGBENCD_SEQ_NUM

Ver: 8.4.1