RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE Operational Data Store
Composite View Target: AF_BUDGET_DETAIL

Description Source composite view contains detailed budget information, including change history.

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: 3.1