Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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
BUDGET_ROLL_IND_DESC	Budget Roll Indicator Description	Budget roll indicator description.	VARCHAR2(4000)
BUDGET_TYPE	Budget Type		VARCHAR2(1)
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
EMPLOYMENT_CATEGORY	Employment Category		VARCHAR2(2)
EMPLOYMENT_CATEGORY_DESC	Employment Category Description		VARCHAR2(100)
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	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	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	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	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	Premium earnings roll indicator description.	VARCHAR2(4000)
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)
STANDARD_OCCUPATIONAL_CATEGORY	Standard Occupational Category		VARCHAR2(8)
STANDARD_OCCUPATIONAL_CAT_DESC	Standard Occupational Cat Description		VARCHAR2(100)
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: