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_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)	FUNCTION	F_GET_FINANCE_DESC
ACTIVITY_STATUS	Extracted 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
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	Extracted current status of the associated chart of accounts.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
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)
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	Extracted current status of the associated fund.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
ITEM	System-generated line item number that identifies each commodity line item for procurement documents.	NUMBER	FGBENCD	FGBENCD_ITEM
LOCATION	Identification accounting code of the physical location of the financial manager.	VARCHAR2(63)	FGBENCD	FGBENCD_LOCN_CODE
LOCATION_DESC	Extracted description or title of the associated location.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
LOCATION_STATUS	Extracted 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
ORGANIZATION_CODE	Identification accounting code used for the department.	VARCHAR2(63)	FGBENCD	FGBENCD_ORGN_CODE
ORGANIZATION_DESC	Extracted description or title associated with the organization code.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ORGANIZATION_STATUS	Extracted 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	Extracted description or title of the associated program.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
PROGRAM_STATUS	Extracted 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
SEQUENCE_NUMBER	System-generated one-up number to support split accounting within a document.	NUMBER	FGBENCD	FGBENCD_SEQ_NUM

Ver: 8.1