This view of the JOB_CLASS table contains basic data about each job class, including
title and several category codes. There is one row per job class.
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 classifying employees by category (for example, Faculty_Class).
||Indexed Data Elements
- Following the retirement of PennWorks and the mainframe Personnel/Payroll system in July 2019, select columns in the JOB_CLASS_GENERAL 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_GENERAL_SNAP
- If you are using JOB_CLASS_GENERAL 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).
- If you authorized to use the EMPLOYEE_GENERAL table, you can access basic
biographic/demographic data for all Penn employees, and can access basic data
related to their primary jobs in the JOB_CLASS_GENERAL Table. To access restricted
job class data (e.g, grade, minimum/maximum salaries), use the JOB_CLASS 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_GENERAL view can be found in the DWADMIN schema, as JOB_CLASS_GENERAL_V.
Questions about this page? Email us at firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania