• ACADEMIC_CATEGORY
• BARGAINING_UNIT
• FACULTY_CLASS
• FAMILY
• JOB_CLASS
• JOB_CLASS_EMPLOYEE_TYPE
• JOB_CLASS_STATUS
• JOB_CLASS_STATUS_DATE

• JOB_GRADE
• JOB_GROUP
• JOB_TITLE
• MAXIMUM_SALARY
• MINIMUM_SALARY
• PERSONNEL_CLASS
• STANDING_FACULTY_RANK

A higher-level grouping of faculty classes used for aggregating faculty into groups such as Standing Faculty, Standing Faculty C-E (Clinician-Educator), Associated Faculty, Academic Support Staff, and Emeritus.

Values:
Refer to the DWCOMP.COMP_ACADEMIC_CATEGORY_LOOKUP table
for values.

The name of the union bargaining unit, if any, associated with the job class.

[Following the retirement of PennWorks and the mainframe Personnel/Payroll system in July 2019, this column is no longer updated, and values of Bargaining_Unit for Job Classes still in use as Workday Job Profiles will be null.]

Values:
Refer to the DWCOMP.COMP_UNION_LIST table
for values.

Examples: TEN (tenure track, including tenure of title and standing faculty); VIS (visiting faculty)

Following the implementation of Workday in July 2019, this column is updated with Workday Job Family and Job Profile data as follows, to support longitudinal and cross collection reporting.

FAMILY

Indexed - no
Format - char (2)
May be null? yes

Examples: D (Financial), 3(Animal Care)

[Following the retirement of PennWorks and the mainframe Personnel/Payroll system in July 2019, this column is no longer updated, and values of Family for Job Classes still in use as Workday Job Profiles will be null.]

Values:
Refer to the DWCOMP.COMP_JOB_FAMILY_LIST table for values.

The 6-digit code indicating a job classification. Refer to Job_Title to find the title which currently corresponds to the Job_Class.

Following the implementation of Workday in July 2019, this column is updated with Workday Job_Profile_ID to support longitudinal and cross collection reporting. For Job Classes no longer in use as Workday Job Profiles, rows will remain in the table, and will no longer be updated.

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. Faculty classes were unaffected by this conversion. Some classes were reused, however (and only the attributes now used for those classes are available).

Example: 226010 (Associate Professor C-E)

Values:

Refer to the DWADMIN.JOB_CLASS table for values.

Examples: 1 (monthly paid salaried; exempt from overtime); 3 (non-exempt hourly paid)

[Following the retirement of PennWorks and the mainframe Personnel/Payroll system in July 2019, this column is no longer updated, and values of Job_Class_Employee_Type for Job Classes still in use as Workday Job Profiles will be null.]

Values:
Refer to the DWCOMP.COMP_EMPLOYEE_TYPE_LIST table for values.

Indicates the active (A) or frozen (F) status of the job class.

[Following the retirement of PennWorks and the mainframe Personnel/Payroll system in July 2019, this column is no longer updated, and values of Job_Class_Status for Job Classes still in use as Workday Job Profiles will be null.]

Values:

A     Job class is active in the Payroll system
F     Job class is frozen in the Payroll system
      

Indexed - no
Format - date (7)
May be null? yes

The date the job class status went into effect.

[Following the retirement of PennWorks and the mainframe Personnel/Payroll system in July 2019, this column is no longer updated, and values of Job_Class_Status_Date for Job Classes still in use as Workday Job Profiles will be null.]

Indexed - yes
Format - char (3)
May be null? yes

The 3-character code indicating the pay grade for the Job_Class. Each Job_Grade has a specific salary range assigned to it.

With the Classification Redesign Project of April 1998 new grades were established to simplify salary administration. (For Job_Classes that are reused, only the Job_Grade now assigned to the Job_Class is available.) University exempt (monthly-paid; not eligible for overtime time) and non-exempt (weekly-paid; eligible for overtime pay) staff positions are classified within a 12-grade structure, numbered from 21 to 32 (these are stored in 3-digits, as 021-032 in the Data Warehouse). A separate Information Technology (IT) salary broadband structure, represented by the letters A - H, was also developed, and applies to IT positions at the University.

Examples: FAC (Faculty), 27 (non-exempt grade 27), D (IT band D)

[Following the retirement of PennWorks and the mainframe Personnel/Payroll system in July 2019, this column is no longer updated, and values of Job_Grade for Job Classes still in use as Workday Job Profiles will be null.]

Values:
Refer to the DWCOMP.COMP_JOB_GRADE_LIST table for values.
    

JOB_GROUP

Indexed - no
Format - char (4)
May be null? yes

1. Executive/administrative
   
2. Faculty
   
3. Professional
   
4. Secretarial/clerical
   
5. Technical/paraprofessional
   
6. Skilled crafts
   
7. Service

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. Faculty classes were unaffected by this conversion. Some classes were reused, however (and only the attributes now used for those classes are available).

[Following the retirement of PennWorks and the mainframe Personnel/Payroll system in July 2019, this column is no longer updated, and values of Job_Group for Job Classes still in use as Workday Job Profiles will be null.]

The title currently associated with the Job_Class. The title associated with a given Job_Class may vary over time.

Following the implementation of Workday in July 2019, this column is updated with Workday Job_Profile_Name to support longitudinal and cross collection reporting. For Job Classes no longer in use as Workday Job Profiles, rows will remain in the table, and will no longer be updated.

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. Faculty classes were unaffected by this conversion. Some classes were reused, however (and only the attributes now used for those classes are available).

Examples: ASSOCIATE PROFESSOR C-E (226010); CLERK, LIMITED SERVICE (515037)

Values:

Refer to the DWADMIN.JOB_CLASS table for values.

For exempt jobs, the highest amount of the annual salary that may be paid to an employee in this Job_Class. For non-exempt jobs, the highest hourly rate that may be paid to an employee in this Job_Class. The Maximum_Salary is invalid for union jobs. 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. Faculty classes were unaffected by this conversion. Some classes were reused, however (and only the attributes now used for those classes are available).

[Following the retirement of PennWorks and the mainframe Personnel/Payroll system in July 2019, this column is no longer updated, and values of Maximum_Salary for Job Classes still in use as Workday Job Profiles will be null.]

Values:

0-9,999,999.999

For exempt jobs, the lowest amount of the annual salary that may be paid to an employee in this Job_Class. For non-exempt jobs, the lowest hourly rate that may be paid to an employee in this Job_Class. The Minimum_Salary is invalid for union jobs. 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. Faculty classes were unaffected by this conversion. Some classes were reused, however (and only the attributes now used for those classes are available).

[Following the retirement of PennWorks and the mainframe Personnel/Payroll system in July 2019, this column is no longer updated, and values of Minimum_Salary for Job Classes still in use as Workday Job Profiles will be null.]

Values:

0-9,999,999.99

Examples: AP (Administrative / Professional), US (Unionized staff).

Following the implementation of Workday in July 2019, this column is updated with Workday Job Family and Job Profile data as follows, to support longitudinal and cross collection reporting.

Prior to the implementation of Workday, this field was calculated in the Data Warehouse. The logic to determine the code was as follows (the classes were calculated according to the order listed):

EX: EMPLOYEE_JOB.Appt_Employee_Type = 6 [this class is not included in the Data Warehouse]

SS: EMPLOYEE_JOB.Appt_Employee_Type = 2 AND (Job_Grade is between 021 and 032 or Job_Grade is A, B, C, D, E, F, G, H) OR
EMPLOYEE_JOB.Appt_Employee_Type = 2 or 3 AND Job_Grade = LIM OR
Job_Class = 515550 or 515555 OR
EMPLOYEE_JOB.Appt_Employee_Type = 2 or 3 AND Job_Grade = PT OR
EMPLOYEE_JOB.Appt_Employee_Type = 2 and Job_Grade = INT
[OR, for pre-Classification Redesign job class codes:
EMPLOYEE_JOB.Appt_Employee_Type = 2 and Job_Grade = Gxx or space]

TS: Job_Grade = TEM OR Job_Class = 855150

NE: Job_Class = 8xxxxx OR Job_Class = 399055, 399057, or 140005

FA: Job_Class = 2xxxxx OR Job_Grade = FAC

AP: EMPLOYEE_JOB.Appt_Employee_Type = 1 AND Job_Grade NOT = FAC

US: Job_Grade = U

ST: EMPLOYEE_JOB.Appt_Employee_Type = 5

NC: any classes not covered by the criteria above

Values:

AP  Administrative/Professional
EX  Executive Pay (not included in the Data Warehouse)
FA  Faculty
NC  No category
NE  Non-employees (courtesy appointments, etc.)
SS  Support Staff
ST  Student
TS  Temporary Staff
US  Unionized Staff

Examples: FULL (full professor), ASSO (associate professor)

Following the implementation of Workday in July 2019, this column is updated with Workday Job Family and Job Profile data as follows, to support longitudinal and cross collection reporting.