Target Column	Business Definition	Database Data Type	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_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
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
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)
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	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
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: 8.1