Page Name

Description:

A code which identifies work that is sufficiently similar as to kind or subject matter of work, level of difficulty, responsibility and qualification requirements of the work to warrant the same treatment as to title, pay range and other personnel transactions.

Coding Instructions:

For EMPLOYEE_DATA table on SCD and EMPL: Every faculty or OPS record must have valid value. All records except faculty and OPS pay plan classes must have a title provided.
OPS pay plans may use the following class codes:

PAY_PLAN_NUMBER	APPT_STAT_CLASS	CLASS_CODE
00	A	0012 - 0017
00	P	9189
01	Any	Any Faculty
02	O	Any Faculty
05	M	9181 - 9185
06	L	Any House Staff
06	F, C, E, V	Any Faculty
09		9190

Load programs for EMPLOYEE_VACANTS table on SCD submissions will NULL when EMPR_TYP_CODE is 'O', 'R', or 'P' (rate reserve other than summer reserve).

Algorithm:

Usage Type:

ELEMENT

Begin Term:

192001

End Term:

Last Modified:

24-AUG-2023

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Salary Category Detail (SCD)	EMPLOYEE_DATA (EDAT)	CLASS_CD	19	1767	30	Salary Category Detail
Salary Category Detail (SCD)	EMPLOYEE_VACANTS (EVAC)	CLASS_CD	19	1875	31	Salary Category Detail
Student Instruction (SIF)	STIPENDS (STIP)	CLASS_CD	19	211	12	Student Instruction
Student Instruction Preliminary (SIFP)	STIPENDS (STIP)	CLASS_CD	19	211	12	Student Instruction Preliminary
University Employee/OPS (EMPL)	EMPLOYEE_DATA (EDAT)	CLASS_CD	19	1767	30	University Employee/OPS

1 - 5

Excel code	Code	Description	Grouping
'.	.	MISSING	-
'0012	0012	Executive, Administrative and Managerial	OPS Class Codes-Temporary
'0013	0013	Other Professionals (Support/Service)	OPS Class Codes-Temporary
'0014	0014	Clerical and Secretarial	OPS Class Codes-Temporary
'0015	0015	Technical and Paraprofessional	OPS Class Codes-Temporary
'0016	0016	Skilled Craft	OPS Class Codes-Temporary
'0017	0017	Services/Maintenance	OPS Class Codes-Temporary
'9000	9000	Faculty (Generic)	Faculty Class Codes
'9001	9001	Professor	Faculty Class Codes
'9002	9002	Associate Professor	Faculty Class Codes
'9003	9003	Assistant Professor	Faculty Class Codes
'9004	9004	Instructor	Faculty Class Codes
'9005	9005	Lecturer	Faculty Class Codes
'9006	9006	Graduate Research Professor	Faculty Class Codes
'9007	9007	Distinguished Professor	Faculty Class Codes
'9008	9008	Regents Professor	Faculty Class Codes
'9009	9009	Eminent Scholar	Faculty Class Codes
'9014	9014	Instructor II	Faculty Class Codes
'9015	9015	Instructor III	Faculty Class Codes
'9016	9016	University School Professor	Faculty Class Codes
'9017	9017	University School Associate Professor	Faculty Class Codes
'9018	9018	University School Assistant Professor	Faculty Class Codes
'9019	9019	University School Instructor	Faculty Class Codes
'9053	9053	Librarian	Faculty Class Codes
'9054	9054	Associate Librarian	Faculty Class Codes
'9055	9055	Assistant Librarian	Faculty Class Codes
'9056	9056	Instructor, Librarian	Faculty Class Codes
'9060	9060	Teaching Faculty I	Faculty Class Codes
'9061	9061	Teaching Faculty II	Faculty Class Codes
'9062	9062	Teaching Faculty III	Faculty Class Codes

Download

Select Pagination

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
EMPL	EMPLOYEE_DATA	0007	Missing	9	Critical Error: may cause submission to be rejected
EMPL	EMPLOYEE_DATA	0689	Faculty or OPS and invalid Class Code	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_DATA	0007	Missing	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_VACANTS	0537	Class Code is invalid or missing and Employment Resource code is equal to E,V,or A	9	Critical Error: may cause submission to be rejected

1 - 4

Physical Description:

VARCHAR2(4)

Short Name:

CLCD

Column Name:

CLASS_CODE

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: Classification Code - 01014

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: