Contains data about each job class, including title, grade, minimum and maximum
salary, 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 categorizing employees by grade or by one of the other
categories (for example, Faculty_Class).
||Indexed Data Elements
- 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
- 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.
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