| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ADMINISTRATIVE_GROUP
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
BARGAINING_UNIT
|
Default bargaining unit code associated with this position.
|
VARCHAR2(63)
|
NBBPOSN
|
NBBPOSN_BARG_CODE
|
|
BARGAINING_UNIT_DESC
|
Bargaining unit code description.
|
VARCHAR2(255)
|
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
|
NBBPOSN
|
NBBPOSN_CHANGE_DATE_TIME
|
|
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 code description.
|
VARCHAR2(255)
|
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(63)
|
NTRPCLS
|
NTRPCLS_EFUN_CODE
|
|
EEO_FUNCTION_DESC
|
EEO function description.
|
VARCHAR2(255)
|
PTVEFUN
|
PTVEFUN_DESC
|
|
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.
|
VARCHAR2(255)
|
PTVESKL
|
PTVESKL_DESC
|
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
|
OCCUPATIONAL_TITLE
|
Occupational title classification from the dictionary of occupational titles.
|
VARCHAR2(63)
|
NBBPOSN
|
NBBPOSN_DOTT_CODE
|
|
OCCUPATIONAL_TITLE_DESC
|
Occupational title description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_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(63)
|
NBBPOSN
|
NBBPOSN_PFOC_CODE
|
|
OCCUPATION_CLASSIFICATION_DESC
|
Occupation classification description.
|
VARCHAR2(255)
|
NTVPFOC
|
NTVPFOC_DESC
|
|
POSITION
|
Position number.
|
VARCHAR2(63)
|
NBBPOSN
|
NBBPOSN_POSN
|
|
POSITION_APPOINTMENT_PCT
|
Percentage for the appointed position.
|
NUMBER
|
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(63)
|
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(255)
|
NTRPCLS
|
NTRPCLS_DESC
|
|
POSITION_CLASS_EXEMPTION_IND
|
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
|
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
|
Employee class description.
|
VARCHAR2(255)
|
PTRECLS
|
PTRECLS_LONG_DESC
|
|
POSITION_EMPLOYEE_GROUP
|
Sub-category of the position employee class.
|
VARCHAR2(63)
|
PTRECLS
|
PTRECLS_EGRP_CODE
|
|
POSITION_EMPLOYEE_GROUP_DESC
|
Position employee group description.
|
VARCHAR2(255)
|
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(63)
|
NBBPOSN
|
NBBPOSN_PGRP_CODE
|
|
POSITION_GROUP_DESC
|
Position group description.
|
VARCHAR2(255)
|
PTRPGRP
|
PTRPGRP_DESC
|
|
POSITION_LOCATION
|
Position location code.
|
VARCHAR2(63)
|
NBBPOSN
|
NBBPOSN_JBLN_CODE
|
|
POSITION_LOCATION_DESC
|
Position location description.
|
VARCHAR2(255)
|
PTRJBLN
|
PTRJBLN_DESC
|
|
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.
|
VARCHAR2(255)
|
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(63)
|
CALCULATION
|
NVL(NBBPOSN_POSN_REPORTS, MPKFUNC.F_GET_POSITION_REPORTS)
|
|
POSITION_REPORTS_TITLE
|
Title of the posiiton to which this position reports.
|
VARCHAR2(255)
|
FUNCTION
|
MPKFUNC.F_GET_POSITION_REPORTS
|
|
POSITION_STATUS
|
Current status of the position (Active, Cancelled or Frozen).
|
VARCHAR2(63)
|
NBBPOSN
|
NBBPOSN_STATUS
|
|
POSITION_STATUS_DESC
|
Position status description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(NBBPOSN_STATUS,'A',ACTIVE,'C',CANCELLED,'F',FROZEN,'I',INACTIVE)
|
|
POSITION_TITLE
|
Position title.
|
VARCHAR2(63)
|
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
|
NBBPOSN
|
NBBPOSN_PROBATION_UNITS
|
|
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 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(63)
|
NBBPOSN
|
NBBPOSN_CIPC_CODE
|
|
PROGRAM_CLASSIFICATION_DESC
|
Program classification description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
SALARY_GRADE
|
Salary grade that is associated with positions in this position class.
|
VARCHAR2(63)
|
NTRPCLS
|
NTRPCLS_GRADE
|
|
SALARY_GROUP
|
Salary group code.
|
VARCHAR2(63)
|
CALCULATION NTRPCLS
|
NVL(NBBPOSN_SGRP_CODE, NTRPCLS_SGRP_CODE) NTRPCLS_SGRP_CODE
|
|
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 associated with positions assigned to this position class.
|
VARCHAR2(63)
|
NTRPCLS
|
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(63)
|
NBBPOSN
|
NBBPOSN_WKSH_CODE
|
|
WORK_SCHEDULE_DESC
|
Work schedule description.
|
VARCHAR2(255)
|
NTVWKSH
|
NTVWKSH_DESC
|