Target Column	Business Definition	Database Data Type	Source Name	Source Column
BARGAINING_UNIT	Default bargaining unit code associated with this position.	VARCHAR2(2)	NBBPOSN	NBBPOSN_BARG_CODE
BARGAINING_UNIT_DESC	Bargaining unit code description.	VARCHAR2(30)	PTVBARG	PTVBARG_DESC
BUDGET_ROLL_IND	Budget roll indicator. Identifies the budget amount to be rolled into a new fiscal year.	VARCHAR2(1)	NBBPOSN	NBBPOSN_ROLL_IND
CHANGE_DATE_TIME	Date and time this record was changed.	DATE	NBRCLSH	NBRCLSH_CHANGE_DATE_TIME
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
EEO_CATEGORY	Used by institutions of higher education for Equal Employment Opportunity reporting as defined by the federal government.	VARCHAR2(2)	NTRPCLS	NTRPCLS_ESKL_CODE
EEO_CATEGORY_DESC	EEO category code description.	VARCHAR2(30)	PTVESKL	PTVESKL_DESC
EEO_FUNCTION	For government agencies only. Equal employment opportunity (EEO) function type as defined by a federal government, for use with EEO reporting.	VARCHAR2(2)	NTRPCLS	NTRPCLS_EFUN_CODE
EEO_FUNCTION_DESC	EEO function description.	VARCHAR2(30)	PTVEFUN	PTVEFUN_DESC
EEO_SKILL	Used by institutions of higher education for Equal Employment Opportunity skills reporting as defined by the federal government.	VARCHAR2(2)	NTRPCLS	NTRPCLS_ESKL_CODE
EEO_SKILL_DESC	EEO skill description.	VARCHAR2(30)	PTVESKL	PTVESKL_DESC
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
OCCUPATIONAL_TITLE	Occupational title classification from the dictionary of occupational titles.	VARCHAR2(11)	NBBPOSN	NBBPOSN_DOTT_CODE
OCCUPATIONAL_TITLE_DESC	Occupational title description.	VARCHAR2(60)	NTVDOTT	NTVDOTT_DESC
OCCUPATION_CLASSIFICATION	General occupation classification in which a title is included for government reporting purposes. Provides a standardized framework for organizing occupations into a manageable, understandable and coherent system.	VARCHAR2(3)	NBBPOSN	NBBPOSN_PFOC_CODE
OCCUPATION_CLASSIFICATION_DESC	Occupation classification description.	VARCHAR2(60)	NTVPFOC	NTVPFOC_DESC
POSITION	Position number.	VARCHAR2(6)	NBBPOSN	NBBPOSN_POSN
POSITION_APPOINTMENT_PCT	Establishes the percentage of full time appointment. The Low, Mid and High salary fields are adjusted by this percentage.	NUMBER(5, 2)	NBBPOSN	NBBPOSN_APPT_PCT
POSITION_BEGIN_DATE	First date the position is funded to begin. The Begin Date must be within a defined fiscal year and must be before the End Date.	DATE	NBBPOSN	NBBPOSN_BEGIN_DATE
POSITION_CLASS	Organizes the job classifications for the institution and holds attributes that control title, employee class, eel code and wage and salary data. Also, the primary organizer for the design and maintenance of the position definition. These attributes are inherited when the employee is assigned to the position.	VARCHAR2(5)	NBBPOSN	NBBPOSN_PCLS_CODE
POSITION_CLASS_DESC	Position class description or title. Organizes the job classifications for the institution and holds attributes that control title, employee class, eel code and wage and salary data. Also, the primary organizer for the design and maintenance of the position definition. These attributes are inherited when the employee is assigned to the position.	VARCHAR2(30)	NTRPCLS	NTRPCLS_DESC
POSITION_CLASS_EXEMPTION_IND	Indicates if employees assigned to this position are exempt or non-exempt from federal overtime rules.	VARCHAR2(1)	NTRPCLS	NTRPCLS_EXEMPT_IND
POSITION_EMPLOYEE_CLASS	Employee class code. Organizes position information consistent with employee groupings. At the employee level, used to help determine controls for benefits, leave, payroll and self-service rules.	VARCHAR2(2)	NBBPOSN	NBBPOSN_ECLS_CODE
POSITION_EMPLOYEE_CLASS_DESC	Employee class description.	VARCHAR2(30)	PTRECLS	PTRECLS_LONG_DESC
POSITION_EMPLOYEE_GROUP	Sub-category of the position employee class.	VARCHAR2(4)	PTRECLS	PTRECLS_EGRP_CODE
POSITION_EMPLOYEE_GROUP_DESC	Position employee group description.	VARCHAR2(30)	PTVEGRP	PTVEGRP_DESC
POSITION_END_DATE	End date of the position. If NA, the position is presumed to be a permanent position.	DATE	NBBPOSN	NBBPOSN_END_DATE
POSITION_EXEMPTION_IND	Indicates if employees assigned to this position are exempt or non-exempt from federal overtime rules.	VARCHAR2(1)	NBBPOSN	NBBPOSN_EXEMPT_IND
POSITION_GROUP	Groups like positions together for analysis of job succession and job family information.	VARCHAR2(4)	NBBPOSN	NBBPOSN_PGRP_CODE
POSITION_GROUP_DESC	Position group description.	VARCHAR2(30)	PTRPGRP	PTRPGRP_DESC
POSITION_LOCATION	Position location code.	VARCHAR2(6)	NBBPOSN	NBBPOSN_JBLN_CODE
POSITION_LOCATION_DESC	Position location code description.	VARCHAR2(30)	PTRJBLN	PTRJBLN_DESC
POSITION_PROGRESSION	Position progression family code that groups like positions in sequence order.	VARCHAR2(5)	NBBPOSN	NBBPOSN_JOBP_CODE
POSITION_PROGRESSION_DESC	Position progression description.	VARCHAR2(30)	NTVJOBP	NTVJOBP_DESC
POSITION_REPORTS	Position to which this position reports. Identifies the next position in the organizational hierarchy. The reports to position must have a position definition and cannot report to itself.	VARCHAR2(6)	NBBPOSN	NBBPOSN_POSN_REPORTS
POSITION_REPORTS_TITLE	Title of the posiiton to which this position reports.	VARCHAR2(30)	FUNCTION	MPKFUNC.F_GET_POSITION_REPORTS
POSITION_STATUS	Current status of the position (Active, Cancelled or Frozen).	VARCHAR2(1)	NBBPOSN	NBBPOSN_STATUS
POSITION_STATUS_DESC	Position Status description.	VARCHAR2(30)	CALCULATION	DECODE(NBBPOSN_STATUS,'A',ACTIVE,'C',CANCELLED,'F',FROZEN,'I',INACTIVE)
POSITION_TITLE	Position title.	VARCHAR2(30)	NBBPOSN	NBBPOSN_TITLE
POSITION_TYPE	Single or pooled position.	VARCHAR2(1)	NBBPOSN	NBBPOSN_TYPE
PREMIUM_EARNINGS_ROLL_IND	Indicator that specifies how to roll budget for premium earnings.	VARCHAR2(1)	NBBPOSN	NBBPOSN_PREMIUM_ROLL_IND
PROBATION_UNITS	Number of probationary units.	NUMBER(3)	NBBPOSN	NBBPOSN_PROBATION_UNITS
PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for this outcome. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government.	VARCHAR2(6)	NBBPOSN	NBBPOSN_CIPC_CODE
PROGRAM_CLASSIFICATION_DESC	Program classification description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
SALARY_GRADE	Salary grade that is associated with positions in this position class.	VARCHAR2(5)	CALCULATION	NVL(NBBPOSN_GRADE,NTRPCLS_GRADE)
SALARY_GROUP	Salary group code.	VARCHAR2(6)	NTRPCLS	NTRPCLS_SGRP_CODE
SALARY_STEP	Salary step associated with the salary grade that is associated with positions assigned to this position class.	NUMBER	CALCULATION	NVL(NBBPOSN_STEP,NTRPCLS_STEP)
SALARY_TABLE	Salary table that is associated with positions assigned to this position class.	VARCHAR2(2)	CALCULATION	NVL(NBBPOSN_TABLE,NTRPCLS_TABLE)
SENIORITY_ACCRUED_IND	Indicates if seniority hours are accrued against this position.	VARCHAR2(1)	CALCULATION	NVL(NBBPOSN_ACCRUE_SENIORITY_IND,NTRPCLS_ACCRUE_SENIORITY_IND)
WORK_SCHEDULE	Default work schedule.	VARCHAR2(4)	NBBPOSN	NBBPOSN_WKSH_CODE
WORK_SCHEDULE_DESC	Work schedule description.	VARCHAR2(30)	NTVWKSH	NTVWKSH_DESC
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: 8.1