Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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 which has primary responsibility for this Position.	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: