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
|