Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
BARGAINING_UNIT	Bargaining Unit	Default bargaining unit code associated with this position.	VARCHAR2(63)	NBBPOSN	NBBPOSN_BARG_CODE
BARGAINING_UNIT_DESC	Bargaining Unit Description	Bargaining unit code description.	VARCHAR2(255)	PTVBARG	PTVBARG_DESC
BUDGET_ROLL_IND	Budget Roll Indicator	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(255)	CALCULATION	CASE NBBPOSN_ROLL_IND
BUDGET_TYPE	Budget Type	Budget type is the expected funding status for the position.	VARCHAR2(63)	NBBPOSN	NBBPOSN_BUDGET_TYPE
BUDGET_TYPE_DESC	Budget Type Description	Budget type description.	VARCHAR2(255)	MGT_VALIDATION	SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'BUDGET_TYPE' AND VALUE = BUDGET_TYPE
CHANGE_DATE_TIME	Change Date Time	Date and time this record was changed.	DATE	NBBPOSN	NBBPOSN_CHANGE_DATE_TIME
EEO_CATEGORY	Eeo Category	Used by institutions of higher education for Equal Employment Opportunity reporting as defined by the federal government.	VARCHAR2(63)	NTRPCLS	NTRPCLS_ESKL_CODE
EEO_CATEGORY_DESC	Eeo Category Description	EEO category code description.	VARCHAR2(255)	PTVESKL	PTVESKL_DESC
EEO_FUNCTION	Eeo Function	For government agencies only. Equal employment opportunity (EEO) function type as defined by a federal government, for use with EEO reporting.	VARCHAR2(63)	NTRPCLS	NTRPCLS_EFUN_CODE
EEO_FUNCTION_DESC	Eeo Function Description	EEO function description.	VARCHAR2(255)	PTVEFUN	PTVEFUN_DESC
EEO_SKILL	Eeo Skill	Used by institutions of higher education for Equal Employment Opportunity skills reporting as defined by the federal government.	VARCHAR2(63)	NTRPCLS	NTRPCLS_ESKL_CODE
EEO_SKILL_DESC	Eeo Skill Description	EEO skill description.	VARCHAR2(255)	PTVESKL	PTVESKL_DESC
EMPLOYMENT_CATEGORY	Employment Category	Federal employment reporting categories that identify either the number of month or whether the employment length is full time or part time.	VARCHAR2(63)	NBBPOSN	NBBPOSN_ECIP_CODE
EMPLOYMENT_CATEGORY_DESC	Employment Category Description	Employment category description	VARCHAR2(255)	PTVECIP	PTVECIP_DESC
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
OCCUPATIONAL_TITLE	Occupational Title	Occupational title classification from the dictionary of occupational titles.	VARCHAR2(63)	NBBPOSN	NBBPOSN_DOTT_CODE
OCCUPATIONAL_TITLE_DESC	Occupational Title Description	Occupational title description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
OCCUPATION_CLASSIFICATION	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(63)	NBBPOSN	NBBPOSN_PFOC_CODE
OCCUPATION_CLASSIFICATION_DESC	Occupation Classification Description	Occupation classification description.	VARCHAR2(255)	NTVPFOC	NTVPFOC_DESC
POSITION	Position	Position number.	VARCHAR2(63)	NBBPOSN	NBBPOSN_POSN
POSITION_APPOINTMENT_PCT	Position Appointment Percent	Percentage for the appointed position.	NUMBER	NBBPOSN	NBBPOSN_APPT_PCT
POSITION_BEGIN_DATE	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	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(63)	NBBPOSN	NBBPOSN_PCLS_CODE
POSITION_CLASS_DESC	Position Class Description	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(255)	NTRPCLS	NTRPCLS_DESC
POSITION_CLASS_EXEMPTION_IND	Position Class Exemption Indicator	Indicates if employees assigned to positions in this position class are exempt or non-exempt from federal overtime rules.	VARCHAR2(1)	NTRPCLS	NTRPCLS_EXEMPT_IND
POSITION_EMPLOYEE_CLASS	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(63)	NBBPOSN	NBBPOSN_ECLS_CODE
POSITION_EMPLOYEE_CLASS_DESC	Position Employee Class Description	Employee class description.	VARCHAR2(255)	PTRECLS	PTRECLS_LONG_DESC
POSITION_EMPLOYEE_GROUP	Position Employee Group	Sub-category of the position employee class.	VARCHAR2(63)	PTRECLS	PTRECLS_EGRP_CODE
POSITION_EMPLOYEE_GROUP_DESC	Position Employee Group Description	Position employee group description.	VARCHAR2(255)	PTVEGRP	PTVEGRP_DESC
POSITION_END_DATE	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	Position Exemption Indicator	Indicates if employees assigned to this position are exempt or non-exempt from federal overtime rules.	VARCHAR2(1)	NBBPOSN	NBBPOSN_EXEMPT_IND
POSITION_GROUP	Position Group	Groups like positions together for analysis of job succession and job family information.	VARCHAR2(63)	NBBPOSN	NBBPOSN_PGRP_CODE
POSITION_GROUP_DESC	Position Group Description	Position group description.	VARCHAR2(255)	PTRPGRP	PTRPGRP_DESC
POSITION_LOCATION	Position Location	Position location code.	VARCHAR2(63)	NBBPOSN	NBBPOSN_JBLN_CODE
POSITION_LOCATION_DESC	Position Location Description	Position location description.	VARCHAR2(255)	PTRJBLN	PTRJBLN_DESC
POSITION_PROGRESSION	Position Progression	Position progression family code that groups like positions in sequence order.	VARCHAR2(63)	NBBPOSN	NBBPOSN_JOBP_CODE
POSITION_PROGRESSION_DESC	Position Progression Description	Position progression description.	VARCHAR2(255)	NTVJOBP	NTVJOBP_DESC
POSITION_REPORTS	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(63)	CALCULATION	NVL(NBBPOSN_POSN_REPORTS, MPKFUNC.F_GET_POSITION_REPORTS)
POSITION_REPORTS_TITLE	Position Reports Title	Title of the position to which this position reports.	VARCHAR2(255)	FUNCTION	MPKFUNC.F_GET_POSITION_REPORTS
POSITION_STATUS	Position Status	Current status of the position (Active, Cancelled or Frozen).	VARCHAR2(63)	NBBPOSN	NBBPOSN_STATUS
POSITION_STATUS_DESC	Position Status Description	Position status description.	VARCHAR2(255)	CALCULATION	DECODE(NBBPOSN_STATUS,'A',ACTIVE,'C',CANCELLED,'F',FROZEN,'I',INACTIVE)
POSITION_TITLE	Position Title	Position title.	VARCHAR2(255)	NBBPOSN	NBBPOSN_TITLE
POSITION_TYPE	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 earning roll indicator description.	VARCHAR2(255)	CALCULATION	CASE NBBPOSN_PREMIUM_ROLL_IND
PROBATION_UNITS	Probation Units	Number of probationary units.	NUMBER	NBBPOSN	NBBPOSN_PROBATION_UNITS
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM_CLASSIFICATION	Program Classification	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	VARCHAR2(63)	NBBPOSN	NBBPOSN_CIPC_CODE
PROGRAM_CLASSIFICATION_DESC	Program Classification Description	Program classification description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SALARY_GRADE	Salary Grade	Salary grade that is associated with positions in this position class.	VARCHAR2(63)	NTRPCLS	NTRPCLS_GRADE
SALARY_GROUP	Salary Group	Salary group code.	VARCHAR2(63)	CALCULATION NTRPCLS	NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE) NTRPCLS_SGRP_CODE
SALARY_STEP	Salary Step	Salary step associated with the salary grade that is associated with positions assigned to this position class.	NUMBER	NTRPCLS	NTRPCLS_STEP
SALARY_TABLE	Salary Table	Salary table associated with positions assigned to this position class.	VARCHAR2(63)	NTRPCLS	NTRPCLS_TABLE
SENIORITY_ACCRUED_IND	Seniority Accrued Indicator	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	Standard occupational categories defined by the government for federal reporting.	VARCHAR2(63)	NBBPOSN	NBBPOSN_ESOC_CODE
STANDARD_OCCUPATIONAL_CAT_DESC	Standard Occupational Cat Description	Occupational category description.	VARCHAR2(255)	PTRESOC	PTRESOC_DESC
WORK_SCHEDULE	Work Schedule	Default work schedule.	VARCHAR2(63)	NBBPOSN	NBBPOSN_WKSH_CODE
WORK_SCHEDULE_DESC	Work Schedule Description	Work schedule description.	VARCHAR2(255)	NTVWKSH	NTVWKSH_DESC

Ver: 9.2