Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-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.0