JOB_CLASS Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home

JOB_CLASS Table

Explanation
Contains data about each job class, including title, grade, minimum and maximum salary, and several category codes. There is one row per job class.

Common Uses
Displaying the employee's job title, rather than the Job_Class code that appears in a related table. ("Don't show the codes in the report. Show the English instead.") Another common use is categorizing employees by grade or by one of the other categories (for example, Faculty_Class).

JOB_CLASS

FACULTY_CLASS
JOB_CLASS
JOB_GRADE
PERSONNEL_CLASS
STANDING_FACULTY_RANK

BUDGET_DISTRIBUTION (DWADMIN)
COMP_ACADEMIC_CATEGORY_LOOKUP (DWCOMP)
COMP_FACULTY_CLASS_LOOKUP (DWCOMP)
COMP_JOB_FAMILY_LIST (DWCOMP)
COMP_JOB_GRADE_LIST (DWCOMP)
COMP_PERSON_ROLE (DWCOMP)
COMP_ROLE_JOB_CLASS_XREF (DWCOMP)
EMPLOYEE (DWADMIN)
EMPLOYEE_DISTRIBUTION (DWADMIN)
EMPLOYEE_ENCUMBRANCE (DWADMIN)
EMPLOYEE_ENCUMBRANCE_CURRENT (DWADMIN)
EMPLOYEE_GENERAL (DWADMIN)
EMPLOYEE_JOB (DWADMIN)
EMPLOYEE_PAYMENT (DWADMIN)
EMPLOYEE_PAYMENT_SUMMARY (DWADMIN)
JOB_CLASS_GENERAL (DWADMIN)
PAR_EARNINGS (DWPAY)

Cautions

• Following the retirement of PennWorks and the mainframe Personnel/Payroll system in July 2019, select columns in the JOB_CLASS table will be updated with Workday data, to support longitudinal and cross collection reporting. Refer to the data element index for details on mapping.

• Keep in mind that this is the latest information about a job class. Historical snapshots of job class information are available in the JOB_CLASS_SNAP table.

• If you are using JOB_CLASS to decode the title for an individual's payment, encumbrance or distribution record, be sure to join on Job_Class in your query (this join is already built into the Business Objects universes).

• You can access JOB_CLASS data for an employee's job only if you authorized to access data for the employee's home school or organization, the job school or organization, or the account CNAC, Org or Responsible_Org. To access basic data related to an employee's job class, use the JOB_CLASS_GENERAL Table.

• As a result of the University's Classification Redesign Project, a new job classification system for staff positions was developed in 1998. Job classes in the online Payroll system and the Data Warehouse were converted to this new system over April 8 - 9, 1998. Some classes were reused, however; only the attributes now used for those classes are available. Faculty classes were unaffected by this conversion.

• The JOB_CLASS table can be found in the DWADMIN schema.

JOB_CLASS Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home