| 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.
|
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_GRADE
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)
Values:
Refer to the DWCOMP.JOB_GRADE_LIST table for values.
|
|
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:
- Executive/administrative
- Faculty
- Professional
- Secretarial/clerical
- Technical/paraprofessional
- Skilled crafts
- 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.
|
MAXIMUM_SALARY
Indexed - no
Format - number (9,3)
May be null? yes |
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 resued, however
(and only the attributes now used for those classes are available).
Values:
0-9,999,999.999
|
MINIMUM_SALARY
Indexed - no
Format - number (9,3)
May be null? yes |
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 resued, however
(and only the attributes now used for those classes are available).
Values:
0-9,999,999.99
|
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
|
