Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

Banner 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 Local Source Local Target
ACCOUNT Code representing an account, such as revenue, labor, expenditure or transfer. VARCHAR2(6)

FBBBLIN

FBBBLIN_ACCT_CODE

NO

NO
ACCOUNT_DESC Account code description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
ACCOUNT_STATUS Current status of the associated account. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
ACTIVITY Code used to identify accounting data by activity. VARCHAR2(6)

FBBBLIN

FBBBLIN_ACTV_CODE

NO

NO
ACTIVITY_DESC Activity code title or description. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
ACTIVITY_STATUS Extracted current status of the associated activity. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
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

NO

NO
BASE_ADOPTED_BUDGET Adopted budget (original budget) amount from operating ledger at the time of budget build. NUMBER

FBBBLIN

FBBBLIN_ADOPT_BUD_AMT

NO

NO
BASE_BUDGETED_AMOUNT Base budget amount at the time of budget build. NUMBER

FBBBLIN

FBBBLIN_BASE_BUDG_AMT

NO

NO
BASE_BUDGET_ADJUSTMENTS Adjustments to budget from operating ledger at the time of budget build. NUMBER

FBBBLIN

FBBBLIN_ADJT_BUD_AMT

NO

NO
BASE_CHART_OF_ACCOUNTS Source chart of accounts from which the budget was rolled. VARCHAR2(1)

FBBBLIN

FBBBLIN_BASE_COAS_CODE

NO

NO
BASE_CHART_OF_ACCOUNTS_DESC Hierarchy description or title appropriate for this level. VARCHAR2(35)

FTVCOAS

FTVCOAS_TITLE

NO

NO
BASE_CHART_OF_ACCOUNTS_STATUS Obtains current status of the associated chart of accounts. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
BASE_FISCAL_YEAR The source fiscal year from which the budget was rolled. VARCHAR2(4)

FBBBLIN

FBBBLIN_BASE_FSYR_CODE

NO

NO
BASE_TEMP_ADOPTED_BUDGET Temporary changes to adopted budget from operating ledger at the time of budget build. NUMBER

FBBBLIN

FBBBLIN_TEMP_ADOPT_AMT

NO

NO
BASE_TEMP_BUDGET_ADJUSTMENTS Temporary budget adjustments from operating ledger at the time of budget build. NUMBER

FBBBLIN

FBBBLIN_TEMP_ADJT_AMT

NO

NO
BUDGET_ADJUSTMENT Adjusted budget that is the accumulation of all budget adjustments to this line item. NUMBER

FBBBLIN

FBBBLIN_ADJT_AMT

NO

NO
BUDGET_AMOUNT Calculated amount that includes the cumulative budget + budget adjustments. NUMBER

CALCULATION

(NVL(FBVBLDL_BUDG_AMT,0)+NVL(FBVBLDL_ADJT_AMT,0))

NO

NO
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

NO

NO
BUDGET_IDENTIFIER_DESC Budget description. VARCHAR2(35)

FTVOBUD

FTVOBUD_BUDG_TITLE

NO

NO
BUDGET_LINE_ITEM_ID System assigned budget line item identification code. VARCHAR2(15)

FBBBLIN

FBBBLIN_TEXT_SEQ_NUM

NO

NO
BUDGET_PHASE User-defined unique identifier of a budget phase identifier. VARCHAR2(6)

FBBBLIN

FBBBLIN_OBPH_CODE

NO

NO
BUDGET_PHASE_DESC Budget phase description. VARCHAR2(35)

FTVOBPH

FTVOBPH_BUDG_PHASE_TITLE

NO

NO
BUDGET_YEAR Budget year defined for a budget identifier. VARCHAR2(4)

FUNCTION

FOFYCNV

NO

NO
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment. VARCHAR2(1)

FBBBLIN

FBBBLIN_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_STATUS Extracted current status of the associated chart of accounts. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
CURRENT_ADOPTED_BUDGET Extracted current cumulative adopted budget. NUMBER

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

NO

NO
CURRENT_BUDGET Extracted current cumulative budget as adopted budget plus current budget adjustments. NUMBER

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

NO

NO
CURRENT_BUDGET_ADJUSTMENTS Extracted current cumulative budget adjustments. NUMBER

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
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

NO

NO
DELETED_IND Indicates that the record is in the audit table. VARCHAR2(1)

FBRAUDT

FBRAUDT_DELETED_IND

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

NO
DURATION Identifies the duration of the budget as either permanent temporary. VARCHAR2(1)

FBBBLIN

FBBBLIN_BUDG_DUR_CODE

NO

NO
FUND Financial Aid Fund code to be associated with information in this record. VARCHAR2(6)

FBBBLIN

FBBBLIN_FUND_CODE

NO

NO
FUND_DESC Description or title of the associated fund. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
FUND_STATUS Extracted current status of the associated fund. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
LOCATION Identification accounting code of the physical location of the financial manager. VARCHAR2(6)

FBBBLIN

FBBBLIN_LOCN_CODE

NO

NO
LOCATION_DESC Extracted description or title of the associated location. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
LOCATION_STATUS Extracted current status of the associated location. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
ORGANIZATION_CODE Identification accounting code used for the department. VARCHAR2(6)

FBBBLIN

FBBBLIN_ORGN_CODE

NO

NO
ORGANIZATION_DESC Extracted description or title associated with the organization code. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
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

NO

NO
ORGANIZATION_STATUS Extracted current status of the associated organization. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
ORIGINAL_BUDGET This budget amount is the original amount entered for a given line item. NUMBER

FBBBLIN

FBBBLIN_BUDG_AMT

NO

NO
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

NO

NO
PRIOR_YTD_ACTIVITY Calculated prior year to date activity. NUMBER

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

NO

NO
PROGRAM Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes. VARCHAR2(6)

FBBBLIN

FBBBLIN_PROG_CODE

NO

NO
PROGRAM_DESC Extracted description or title of the associated program. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
PROGRAM_STATUS Extracted current status of the associated program. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: