Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AN_POSITION_BUDGET

Description Source composite view contains budget funding information for specific positions.

Target Column Business Definition Database Data Type Source Name Source Column
AMOUNT_BUDGETED Amount of money budgeted for this position for a fiscal year. NUMBER(11, 2)

NBRPTOT

NBRPTOT_BUDGET

AMOUNT_ENCUMBERED Total encumbrance amount. Contains the sum of contract values of employees assigned to Employee_Positions that report to this organization. NUMBER(11, 2)

NBRPTOT

NBRPTOT_ENCUMB

AMOUNT_EXPENDED Total amount of money expended against this organization. NUMBER(11, 2)

NBRPTOT

NBRPTOT_EXPEND

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 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(3, 1)

NBRPTOT

NBRPTOT_BASE_UNITS

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

NBRPTOT

NBRPTOT_OBUD_CODE

BUDGETED_ORGANIZATION Institution organization to which this Employee_Position's time sheet is sent. VARCHAR2(6)

NBRPTOT

NBRPTOT_ORGN_CODE

BUDGET_APPOINTMENT_PCT 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(5, 2)

NBRPTOT

NBRPTOT_APPT_PCT

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

NBRPTOT

NBRPTOT_OBPH_CODE

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

NBRPTOT

NBRPTOT_STATUS

BUDGET_STATUS_DESC Position Status description. VARCHAR2(30)

CALCULATION

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

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

NBRPTOT

NBRPTOT_COAS_CODE

CREATE_FTE_RECORDS_IND Indicator whether Job FTE/Salary Calculations and Tracking records are created for this position. VARCHAR2(1)

NBRPTOT

NBRPTOT_CREATE_JFTE_IND

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

NA

SYSDATE

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

NA

NA

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 End effective date. DATE

FUNCTION

NOKODSF.F_GET_END_NBRPTOT_DATE

EFFECTIVE_START_DATE Start effective date. DATE

NBRPTOT

NBRPTOT_EFFECTIVE_DATE

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

NBRPTOT

NBRPTOT_FISC_CODE

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

POSITION Position number for this Employee_Position. VARCHAR2(6)

NBRPTOT

NBRPTOT_POSN

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(6, 2)

NBRPTOT

NBRPTOT_ANN_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(6, 2)

NBRPTOT

NBRPTOT_BUDG_BASIS

POSITION_FTE Full time equivalency budgeted for this position. The 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(7, 4)

NBRPTOT

NBRPTOT_FTE

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

NA

NA



Ver: 8.0