Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
BARGAINING_UNIT	Default bargaining unit code associated with this position.	VARCHAR2(2)	NBBPOSN	NBBPOSN_BARG_CODE	NO	NO
BARGAINING_UNIT_DESC	Bargaining unit code description.	VARCHAR2(30)	PTVBARG	PTVBARG_DESC	NO	NO
BUDGET_ROLL_IND	Budget roll indicator. Identifies the budget amount to be rolled into a new fiscal year.	VARCHAR2(1)	NBBPOSN	NBBPOSN_ROLL_IND	NO	NO
BUDGET_ROLL_IND_DESC	Budget roll indicator description.	VARCHAR2(4000)				NO
BUDGET_TYPE		VARCHAR2(1)				NO
CHANGE_DATE_TIME	Date and time this record was changed.	DATE	NBRCLSH	NBRCLSH_CHANGE_DATE_TIME	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
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	NO	NO
EEO_CATEGORY_DESC	EEO category code description.	VARCHAR2(30)	PTVESKL	PTVESKL_DESC	NO	NO
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	NO	NO
EEO_FUNCTION_DESC	EEO function description.	VARCHAR2(30)	PTVEFUN	PTVEFUN_DESC	NO	NO
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	NO	NO
EEO_SKILL_DESC	EEO skill description.	VARCHAR2(30)	PTVESKL	PTVESKL_DESC	NO	NO
EMPLOYMENT_CATEGORY		VARCHAR2(2)				NO
EMPLOYMENT_CATEGORY_DESC		VARCHAR2(100)				NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
OCCUPATIONAL_TITLE	Occupational title classification from the dictionary of occupational titles.	VARCHAR2(11)	NBBPOSN	NBBPOSN_DOTT_CODE	NO	NO
OCCUPATIONAL_TITLE_DESC	Occupational title description.	VARCHAR2(60)	NTVDOTT	NTVDOTT_DESC	NO	NO
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	NO	NO
OCCUPATION_CLASSIFICATION_DESC	Occupation classification description.	VARCHAR2(60)	NTVPFOC	NTVPFOC_DESC	NO	NO
POSITION	Position number.	VARCHAR2(6)	NBBPOSN	NBBPOSN_POSN	NO	NO
POSITION_APPOINTMENT_PCT	Establishes the percentage of full time appointment. The Low, Mid and High salary fields are adjusted by this percentage.	NUMBER	NBBPOSN	NBBPOSN_APPT_PCT	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
POSITION_EMPLOYEE_CLASS_DESC	Employee class description.	VARCHAR2(30)	PTRECLS	PTRECLS_LONG_DESC	NO	NO
POSITION_EMPLOYEE_GROUP	Sub-category of the position employee class.	VARCHAR2(4)	PTRECLS	PTRECLS_EGRP_CODE	NO	NO
POSITION_EMPLOYEE_GROUP_DESC	Position employee group description.	VARCHAR2(30)	PTVEGRP	PTVEGRP_DESC	NO	NO
POSITION_END_DATE	End date of the position. If NA, the position is presumed to be a permanent position.	DATE	NBBPOSN	NBBPOSN_END_DATE	NO	NO
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	NO	NO
POSITION_GROUP	Groups like positions together for analysis of job succession and job family information.	VARCHAR2(4)	NBBPOSN	NBBPOSN_PGRP_CODE	NO	NO
POSITION_GROUP_DESC	Position group description.	VARCHAR2(30)	PTRPGRP	PTRPGRP_DESC	NO	NO
POSITION_LOCATION	Position location code.	VARCHAR2(6)	NBBPOSN	NBBPOSN_JBLN_CODE	NO	NO
POSITION_LOCATION_DESC	Position location code description.	VARCHAR2(30)	PTRJBLN	PTRJBLN_DESC	NO	NO
POSITION_PROGRESSION	Position progression family code that groups like positions in sequence order.	VARCHAR2(5)	NBBPOSN	NBBPOSN_JOBP_CODE	NO	NO
POSITION_PROGRESSION_DESC	Position progression description.	VARCHAR2(30)	NTVJOBP	NTVJOBP_DESC	NO	NO
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	NO	NO
POSITION_REPORTS_TITLE	Title of the posiiton to which this position reports.	VARCHAR2(30)	FUNCTION	MPKFUNC.F_GET_POSITION_REPORTS	NO	NO
POSITION_STATUS	Current status of the position (Active, Cancelled or Frozen).	VARCHAR2(1)	NBBPOSN	NBBPOSN_STATUS	NO	NO
POSITION_STATUS_DESC	Position Status description.	VARCHAR2(30)	CALCULATION	DECODE(NBBPOSN_STATUS,'A',ACTIVE,'C',CANCELLED,'F',FROZEN,'I',INACTIVE)	NO	NO
POSITION_TITLE	Position title.	VARCHAR2(30)	NBBPOSN	NBBPOSN_TITLE	NO	NO
POSITION_TYPE	Single or pooled position.	VARCHAR2(1)	NBBPOSN	NBBPOSN_TYPE	NO	NO
PREMIUM_EARNINGS_ROLL_IND	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	NO	NO
PREMIUM_EARNINGS_ROLL_IND_DESC	Premium earnings roll indicator description.	VARCHAR2(4000)				NO
PROBATION_UNITS	Number of probationary units.	NUMBER	NBBPOSN	NBBPOSN_PROBATION_UNITS	NO	NO
PROGRAM_CLASSIFICATION	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	VARCHAR2(6)	NBBPOSN	NBBPOSN_CIPC_CODE	NO	NO
PROGRAM_CLASSIFICATION_DESC	Program classification description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SALARY_GRADE	Salary grade that is associated with positions in this position class.	VARCHAR2(5)	CALCULATION	NVL(NBBPOSN_GRADE,NTRPCLS_GRADE)	NO	NO
SALARY_GROUP	Salary group code.	VARCHAR2(6)	NTRPCLS	NTRPCLS_SGRP_CODE	NO	NO
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)	NO	NO
SALARY_TABLE	Salary table that is associated with positions assigned to this position class.	VARCHAR2(2)	CALCULATION	NVL(NBBPOSN_TABLE,NTRPCLS_TABLE)	NO	NO
SENIORITY_ACCRUED_IND	Indicates if seniority hours are accrued against this position.	VARCHAR2(1)	CALCULATION	NVL(NBBPOSN_ACCRUE_SENIORITY_IND,NTRPCLS_ACCRUE_SENIORITY_IND)	NO	NO
STANDARD_OCCUPATIONAL_CATEGORY		VARCHAR2(8)				NO
STANDARD_OCCUPATIONAL_CAT_DESC		VARCHAR2(100)				NO
WORK_SCHEDULE	Default work schedule.	VARCHAR2(4)	NBBPOSN	NBBPOSN_WKSH_CODE	NO	NO
WORK_SCHEDULE_DESC	Work schedule description.	VARCHAR2(30)	NTVWKSH	NTVWKSH_DESC	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: