Penn Computing

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

JOB_CLASS_GENERAL Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
ACADEMIC_CATEGORY

Indexed - no
Format - varchar2 (20)
May be null? yes

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.

BARGAINING_UNIT

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

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

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

Indexed - yes
Format - char (3)
May be null? yes
For faculty jobs, the 3-character code that indicates the faculty classification. Non-faculty will have null values for this column.

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

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

FAMILY

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

The 2-character code that indicates the field of knowledge for the Job_Class. Job families are designed to group jobs of the same nature which require different skill and responsibility levels.

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

Values:
Refer to the DWCOMP.JOB_FAMILY_LIST table for values.
JOB_CLASS

Indexed - yes
Format - char (6)
May be null? no
The 6-digit code indicating a job classification. Refer to Job_Title to find the title which currently corresponds to the Job_Class. 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 resued, 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.

JOB_CLASS_EMPLOYEE_TYPE

Indexed - no
Format - varchar2 (1)
May be null? yes
Code indicating the Payroll system employee type for the job class. This code can be used to distinguish whether the job class indicates a monthy, weekly, full-time, paid professional, support staff or student job.

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

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

Indexed - no
Format - varchar2 (1)
May be null? yes
Indicates the active (A) or frozen (F) status of the job class.

Values:

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

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

The date the job class status went into effect. The Employment_Status_Date is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a format including 4 digits for the year. (To specify the date format in Windows, use the Control Panel's Regional Settings, selecting the Date tab and specifying the Short date style. On the Macintosh, use the Date & Time Control Panel.)

JOB_GROUP

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

For full-time, permanent jobs, the 4-character code indicating the Federal Equal Employment Opportunity group for the federal job title for the job. (Note: The federal job title is not the same as the Job_Title used at Penn.) The Job_Group is used for federal affirmation action reports. For more information, contact the Office of Affirmative Action. The first character of the Job_Group indicates one of the seven major groups:
  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 resued, however (and only the attributes now used for those classes are available).
JOB_TITLE

Indexed - no
Format - char (25)
May be null? yes
The title currently associated with the Job_Class. The title associated with a given Job_Class may vary over time, as the Data Warehouse does not store historical data on Job_Classes. A report listing titles of past jobs for an employee may therefore not exactly reflect the title associated with the Job_Class at the time the person held the job. 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 resued, 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.

PERSONNEL_CLASS

Indexed - yes
Format - char (2)
May be null? yes
The 2-character code that identifies the kind of position associated with the Job_Class. 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 resued, however (and only the attributes now used for those classes are available).

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

This field is calculated in the Data Warehouse. The logic to determine the code is as follows (the classes are 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

STANDING_FACULTY_RANK

Indexed - yes
Format - char (5)
May be null? yes
For standing faculty jobs (all faculty members including Clinician-Educators), the 4-character code that indicates the professorial rank for the Job_Class. The standing faculty is composed of all faculty members with tenure or in tenure probationary status. (This includes inviduals such as those of Job_Class 206047 (Lecturer C) who have been admitted to the standing faculty, but lack either appropriate terminal degree or visa status. Conversion to standing faculty is immediate upon presentation of documentation to the Provost staff.) Employees who are not standing faculty will have null values for this column.

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


Values:

FULL     Full          Job Class = 216000-216003, 226000

ASSO     Associate     Job Class = 216020, 226010

ASST     Assistant     Job Class = 216020, 226020


JOB_CLASS_GENERAL Table   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