Penn Computing

University of Pennsylvania
Penn Computing << go backback
JOB_CLASS_GENERAL Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home

JOB_CLASS_GENERAL Table

Explanation
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.

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 classifying employees by category (for example, Faculty_Class).

Primary Key Indexed Data Elements Related Tables
None

None

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_GENERAL_SNAP table.
  • 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.
JOB_CLASS_GENERAL 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