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)	FBBBLIN	FBBBLIN_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)	FBBBLIN	FBBBLIN_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
AUDIT_EXISTS_IND	Indicates whether a row has any records in the audit table. Valid values are Y and N.	VARCHAR2(1)	FBBBLIN	FBBBLIN_AUDIT_EXISTS_IND
BASE_ADOPTED_BUDGET	Adopted budget (original budget) amount from operating ledger at the time of budget build.	NUMBER	FBBBLIN	FBBBLIN_ADOPT_BUD_AMT
BASE_BUDGETED_AMOUNT	Base budget amount at the time of budget build.	NUMBER	FBBBLIN	FBBBLIN_BASE_BUDG_AMT
BASE_BUDGET_ADJUSTMENTS	Adjustments to budget from operating ledger at the time of budget build.	NUMBER	FBBBLIN	FBBBLIN_ADJT_BUD_AMT
BASE_CHART_OF_ACCOUNTS	Source chart of accounts from which the budget was rolled.	VARCHAR2(1)	FBBBLIN	FBBBLIN_BASE_COAS_CODE
BASE_CHART_OF_ACCOUNTS_DESC	Hierarchy description or title appropriate for this level.	VARCHAR2(35)	FTVCOAS	FTVCOAS_TITLE
BASE_CHART_OF_ACCOUNTS_STATUS	Obtains current status of the associated chart of accounts.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS
BASE_FISCAL_YEAR	The source fiscal year from which the budget was rolled.	VARCHAR2(4)	FBBBLIN	FBBBLIN_BASE_FSYR_CODE
BASE_TEMP_ADOPTED_BUDGET	Temporary changes to adopted budget from operating ledger at the time of budget build.	NUMBER	FBBBLIN	FBBBLIN_TEMP_ADOPT_AMT
BASE_TEMP_BUDGET_ADJUSTMENTS	Temporary budget adjustments from operating ledger at the time of budget build.	NUMBER	FBBBLIN	FBBBLIN_TEMP_ADJT_AMT
BUDGET_ADJUSTMENT	Adjusted budget that is the accumulation of all budget adjustments to this line item.	NUMBER	FBBBLIN	FBBBLIN_ADJT_AMT
BUDGET_AMOUNT	Calculated amount that includes the cumulative budget + budget adjustments.	NUMBER	CALCULATION	(NVL(FBVBLDL_BUDG_AMT,0)+NVL(FBVBLDL_ADJT_AMT,0))
BUDGET_IDENTIFIER	User-defined unique identification of the budget. Generally Fiscal year for which the budget is being prepared.	VARCHAR2(6)	FBBBLIN	FBBBLIN_OBUD_CODE
BUDGET_IDENTIFIER_DESC	Budget description.	VARCHAR2(35)	FTVOBUD	FTVOBUD_BUDG_TITLE
BUDGET_PHASE	User-defined unique identifier of a budget phase identifier.	VARCHAR2(6)	FBBBLIN	FBBBLIN_OBPH_CODE
BUDGET_PHASE_DESC	Budget phase description.	VARCHAR2(35)	FTVOBPH	FTVOBPH_BUDG_PHASE_TITLE
BUDGET_YEAR	Budget year defined for a budget identifier.	VARCHAR2(4)	FUNCTION	FOFYCNV
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FBBBLIN	FBBBLIN_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_ADOPTED_BUDGET	Extracted current cumulative adopted budget.	NUMBER	FUNCTION	FOKODSF.F_CONCAT_OP_AMTS
CURRENT_BUDGET	Extracted current cumulative budget as adopted budget plus current budget adjustments.	NUMBER	FUNCTION	FOKODSF.F_CONCAT_OP_AMTS
CURRENT_BUDGET_ADJUSTMENTS	Extracted current cumulative budget adjustments.	NUMBER	FUNCTION	FOKODSF.F_CONCAT_OP_AMTS
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
CURRENT_YTD_ACTIVITY	Extracts cumulative year-to-date activity-using amounts calculated up through and including the current period.	NUMBER	FUNCTION	FOKODSF.F_CONCAT_OP_AMTS
DELETED_IND	Indicates that the record is in the audit table.	VARCHAR2(1)	FBRAUDT	FBRAUDT_DELETED_IND
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
DURATION	Identifies the duration of the budget as either permanent temporary.	VARCHAR2(1)	FBBBLIN	FBBBLIN_BUDG_DUR_CODE
FUND	Unique fiscal entity code.	VARCHAR2(6)	FBBBLIN	FBBBLIN_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
LOCATION	Identification accounting code of the physical location of the financial manager.	VARCHAR2(6)	FBBBLIN	FBBBLIN_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)	FBBBLIN	FBBBLIN_ORGN_CODE
ORGANIZATION_DESC	Extracted description or title associated with the organization code.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
ORGANIZATION_LOCK_STATUS	Extracts organization lock status. Possible values are for implicitly unlocked, physically/explicitly unlocked, implicitly locked and physically/explicitly locked. Default value is implicitly unlocked.	VARCHAR2(1)	FUNCTION	FBKBUDG.F_GETLOCKSTATUS
ORGANIZATION_STATUS	Extracted current status of the associated organization.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS
ORIGINAL_BUDGET	This budget amount is the original amount entered for a given line item.	NUMBER	FBBBLIN	FBBBLIN_BUDG_AMT
ORIGIN_POINT	Origin point from which the budget was originally copied. OPAL for rolled from operating ledger, NEW for newly created, or position for rolled from position control.	VARCHAR2(4)	FBBBLIN	FBBBLIN_ORIGIN_POINT
PRIOR_YTD_ACTIVITY	Calculated prior year to date activity.	NUMBER	FUNCTION	FOKODSF.F_CONCAT_OP_AMTS
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)	FBBBLIN	FBBBLIN_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
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