Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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_LINE_ITEM_ID	Budget Line Item ID	System assigned budget line item identification code.	VARCHAR2(15)		FBBBLIN	FBBBLIN_TEXT_SEQ_NUM
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: