Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Human Resources Reporting View Reports

Banner Operational Data Store
Reporting View Target: POSITION_BUDGET

Description Contains information pertaining to the funding of the position.
Key & Frequency One row per position per fiscal year per budgeted organization per budget per budget phase per effective date.
Recommended Search Columns FISCAL_YEAR, CHART_OF_ACCOUNTS
POSITION, FISCAL_YEAR, BUDGET, BUDGET_PHASE
POSITION, FISCAL_YEAR, BUDGETED_ORGANIZATION, BUDGET, BUDGET_PHASE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AMOUNT_BUDGETED Amount Budgeted Amount of money budgeted for this position for a fiscal year. NUMBER

NBRPTOT

NBRPTOT_BUDGET

AMOUNT_ENCUMBERED Amount Encumbered Total encumbrance amount. Contains the sum of contract values of employees assigned to Employee_Positions that report to this organization. NUMBER

NBRPTOT

NBRPTOT_ENCUMB

AMOUNT_EXPENDED Amount Expended Total amount of money expended against this organization. NUMBER

NBRPTOT

NBRPTOT_EXPEND

AMOUNT_REMAINING Amount Remaining Amount of budgeted money remaining for this position for a fiscal year (Original budget amount minus encumbrance amount minus amount expended). NUMBER

CALCULATION

NBRPTOT_BUDGET - NBRPTOT_ENCUMB - NBRPTOT_EXPEND

BASE_UNITS Base Units Number of pay periods for the position. If zero is entered into this field, the Position Budget Basis, Position Annual Basis, and Budget Appointment % must all be zero. NUMBER

NBRPTOT

NBRPTOT_BASE_UNITS

BUDGET Budget System defined code for the position's budget identification number. VARCHAR2(63)

NBRPTOT

NBRPTOT_OBUD_CODE

BUDGETED_ORGANIZATION Budgeted Organization Institution organization which has primary responsibility for this Position. VARCHAR2(63)

NBRPTOT

NBRPTOT_ORGN_CODE

BUDGET_APPOINTMENT_PCT Budget Appointment Percent Budgeted percentage of full time effort for this position appointment when calculating Budgeted FTE. If this field is zero, the Base Units, Position Budget Basis, and Position Annual Basis must also be zero. NUMBER

NBRPTOT

NBRPTOT_APPT_PCT

BUDGET_PHASE Budget Phase User-defined unique identifier of a budget phase identifier. VARCHAR2(63)

NBRPTOT

NBRPTOT_OBPH_CODE

BUDGET_ROLL_IND Budget Roll Indicator Budget roll indicator. VARCHAR2(1)

NBBPOSN

NBBPOSN_ROLL_IND

BUDGET_ROLL_IND_DESC Budget Roll Indicator Description Description that explains the values in budget roll indicator. VARCHAR2(255)

FUNCTION

MPKFUNC.F_POSITION_DEF_DATA

BUDGET_STATUS Budget Status Identifies the current status of the Position Total record. Valid values are active, working, transferred or closed. VARCHAR2(63)

NBRPTOT

NBRPTOT_STATUS

BUDGET_STATUS_DESC Budget Status Description Position status description. VARCHAR2(255)

CALCULATION

DECODE(NBRPTOT_STATUS,'A',APPROVED,'C',CLOSED,'T',TRANSFERRED,'W',WORKING)

CHART_OF_ACCOUNTS Chart Of Accounts Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

NBBFISC

NBBFISC_COAS_CODE

CREATE_FTE_RECORDS_IND Create FTE - Full Time Equated Records Indicator Indicator whether Job FTE/Salary Calculations and Tracking records are created for this position. VARCHAR2(1)

NBRPTOT

NBRPTOT_CREATE_JFTE_IND

EFFECTIVE_DATE Effective Date Identifies the date that the budget record became effective, or the date of an organization transfer. DATE

NBRPTOT

NBRPTOT_EFFECTIVE_DATE

EFFECTIVE_END_DATE Effective End Date End effective date. DATE

FUNCTION

NOKODSF.F_GET_END_NBRPTOT_DATE

EFFECTIVE_START_DATE Effective Start Date Start effective date. DATE

NBRPTOT

NBRPTOT_EFFECTIVE_DATE

FISCAL_YEAR Fiscal Year Unique identifier or code for the fiscal year. VARCHAR2(4)

NBRPTOT

NBRPTOT_FISC_CODE

FISCAL_YEAR_END_DATE Fiscal Year End Date End date of the fiscal year. DATE

NBBFISC

NBBFISC_END_DATE

FISCAL_YEAR_START_DATE Fiscal Year Start Date Start date of the fiscal year. DATE

NBBFISC

NBBFISC_BEGIN_DATE

LABOR_DISTRIBUTION_COUNT Labor Distribution Count Count of the number of the different labor distributions associated with this position. NUMBER

FUNCTION

MPKFUNC.F_COUNT_LABOR_DIST

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NUMBER_INCUMB_BEGIN_YEAR Number Incumb Begin Year Retrieves the sum of incumbents before the beginning of the fiscal year based on position and date. NUMBER

FUNCTION

MPKFUNC.F_NUMBER_INCUMB

NUMBER_INCUMB_END_YEAR Number Incumb End Year Retrieves the sum of incumbents after the end of the fiscal year based on position and date. NUMBER

FUNCTION

MPKFUNC.F_NUMBER_INCUMB

POSITION Position Position number. VARCHAR2(6)

NBBPOSN

NBBPOSN_POSN

POSITION_ANNUAL_BASIS Position Annual Basis Period of time for which a position is budgeted. Represents the planned period of effort for this position when calculating Budget FTE and Annualized FTE. This field may be expressed in any one of the following values: months, pay periods, terms, hours, or zero. If expressed as zero, the Base Units, Position Budget Basis, and Budget Appointment % must also be expressed as zero. If expressed as months, then the Position Budget Basis must also be expressed as months, etc. NUMBER

NBRPTOT

NBRPTOT_ANN_BASIS

POSITION_BUDGET_BASIS Position Budget Basis Period of time upon which a position is based or budgeted. Represents the budgeted number of periods for this position when calculating Budget FTE and Annualized FTE. This field may be expressed in any one of the following values: months, pay periods, terms, hours, or zero. If expressed as zero, the Base Units, Position Annual Basis, and Budget Appointment % must also be expressed as zero. If expressed in months, then the Position Annual Basis must also be expressed in months, etc. NUMBER

NBRPTOT

NBRPTOT_BUDG_BASIS

POSITION_FTE Position FTE - Full Time Equated Full time equivalency budgeted for this position. FTE that this budget amount is to cover. If the Budget FTE is changed, the Position Budget Basis is adjusted to keep the calculation in balance. NUMBER

NBRPTOT

NBRPTOT_FTE

PREMIUM_EARNINGS_ROLL_IND Premium Earnings Roll Indicator Specifies how to roll budget for premium earnings from one year to the next. Values are (C)urrent Budget Amount, (A)ctual Expenditure for Current Year, (Z)ero, or (N)ot Applicable. VARCHAR2(1)

NBBPOSN

NBBPOSN_PREMIUM_ROLL_IND

PREMIUM_EARNINGS_ROLL_IND_DESC Premium Earnings Roll Indicator Description. Description that explains the value in the premium earnings roll indicator. VARCHAR2(255)

FUNCTION

MPKFUNC.F_POSITION_DEF_DATA

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA



Ver: 9.2