Penn Computing

University of Pennsylvania
Penn Computing << go backback
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).

Primary Key Indexed Data Elements Related Tables
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

  • 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

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania