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

Ver: 9.2