• Elements
  • Element: Classification Code - 01014

Page Name

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.

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




ELEMENT

192001

24-AUG-2023


Allowed Values

'..
MISSING
-
'00120012Executive, Administrative and Managerial
OPS Class Codes-Temporary
'00130013Other Professionals (Support/Service)
OPS Class Codes-Temporary
'00140014Clerical and Secretarial
OPS Class Codes-Temporary
'00150015Technical and Paraprofessional
OPS Class Codes-Temporary
'00160016Skilled Craft
OPS Class Codes-Temporary
'00170017Services/Maintenance
OPS Class Codes-Temporary
'90009000Faculty (Generic)
Faculty Class Codes
'90019001Professor
Faculty Class Codes
'90029002Associate Professor
Faculty Class Codes
'90039003Assistant Professor
Faculty Class Codes
'90049004Instructor
Faculty Class Codes
'90059005Lecturer
Faculty Class Codes
'90069006Graduate Research Professor
Faculty Class Codes
'90079007Distinguished Professor
Faculty Class Codes
'90089008Regents Professor
Faculty Class Codes
'90099009Eminent Scholar
Faculty Class Codes
'90149014Instructor II
Faculty Class Codes
'90159015Instructor III
Faculty Class Codes
'90169016University School Professor
Faculty Class Codes
'90179017University School Associate Professor
Faculty Class Codes
'90189018University School Assistant Professor
Faculty Class Codes
'90199019University School Instructor
Faculty Class Codes
'90539053Librarian
Faculty Class Codes
'90549054Associate Librarian
Faculty Class Codes
'90559055Assistant Librarian
Faculty Class Codes
'90569056Instructor, Librarian
Faculty Class Codes
'90609060Teaching Faculty I
Faculty Class Codes
'90619061Teaching Faculty II
Faculty Class Codes
'90629062Teaching Faculty III
Faculty Class Codes

Edit Values

Submission CodeAscending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
EMPLEMPLOYEE_DATA0007Missing9Critical Error: may cause submission to be rejected
EMPLEMPLOYEE_DATA0689Faculty or OPS and invalid Class Code9Critical Error: may cause submission to be rejected
SCDEMPLOYEE_DATA0007Missing9Critical Error: may cause submission to be rejected
SCDEMPLOYEE_VACANTS0537Class Code is invalid or missing and Employment Resource code is equal to E,V,or A9Critical Error: may cause submission to be rejected
  • 1 - 4

Prior Database Information:

VARCHAR2(4)
CLCD
CLASS_CODE