Page Name

The status of a faculty member in relation to other faculty members of the same educational institution.

Rank may be coded for non-faculty employees who hold rank in an academic department. For EMPLOYEE_DEMO table: For OPS employees this element is required to be coded for extra compensation, phased retirees and OPS - faculty (PAY_PLAN_NUMBER 01, 02, 06).

The required rank for some faculty class codes are:
RANK_FAC=01 CLASS_CODE=9001, 9006, 9007, 9008, 9009
RANK_FAC=02 CLASS_CODE=9002
RANK_FAC=03 CLASS_CODE=9003
RANK_FAC=04 CLASS_CODE=9004, 9014, 9015
RANK_FAC=05 CLASS_CODE=9005
RANK_FAC=06 CLASS_CODE=9150, 9160
RANK_FAC=07 CLASS_CODE=9151, 9161
RANK_FAC=08 CLASS_CODE=9152, 9162
RANK_FAC=10 CLASS_CODE=9016
RANK_FAC=11 CLASS_CODE=9017
RANK_FAC=12 CLASS_CODE=9018
RANK_FAC=13 CLASS_CODE=9019
RANK_FAC=14 CLASS_CODE=9053
RANK_FAC=15 CLASS_CODE=9054
RANK_FAC=16 CLASS_CODE=9055
RANK_FAC=17 CLASS_CODE=9056
RANK_FAC=18 CLASS_CODE=9122
RANK_FAC=19 CLASS_CODE=9123
RANK_FAC=20 CLASS_CODE=9124
RANK_FAC=21 CLASS_CODE=9125
RANK_FAC=99 CLASS_CODE=Others except above

Load programs on the EMPLOYEE_DEMO and WORKLOAD_PERSON_FUNDING tables will default to dot (.).

For IRD: Prior to May 1995 this element was program generated using rank assigned to the Position Class Code. Prior to the 20082009 collection of IRD, the load program for WORKLOAD_PERSON_FUNDING set faculty rank to dot when pay plan was NOT 01, 02, 06, or 22.




ELEMENT

192001

07-NOV-2013


Associated Submissions, Tables, and Columns

Allowed Values

'0101Professor
Rank structure progression associated with regular faculty for which incumbents meet requirements of the corresponding class specification is as follows (Rank codes must match with corresponding class code for the use of these ranks to be valid):
'0202Associate Professor
Rank structure progression associated with regular faculty for which incumbents meet requirements of the corresponding class specification is as follows (Rank codes must match with corresponding class code for the use of these ranks to be valid):
'0303Assistant Professor
Rank structure progression associated with regular faculty for which incumbents meet requirements of the corresponding class specification is as follows (Rank codes must match with corresponding class code for the use of these ranks to be valid):
'0404Instructor
Rank structure progression associated with regular faculty for which incumbents meet requirements of the corresponding class specification is as follows (Rank codes must match with corresponding class code for the use of these ranks to be valid):
'0505Lecturer
Rank structure progression associated with regular faculty for which incumbents meet requirements of the corresponding class specification is as follows (Rank codes must match with corresponding class code for the use of these ranks to be valid):
'0606Professor Equivalent
Rank structure progression associated with classes with qualifications comparable to regular ranked faculty but have duties and responsibilities more specialized in nature. Includes such classes as Scholar/Scientist/Engineer and Curator. This structure is as follows:
'0707Associate Professor Equivalent
Rank structure progression associated with classes with qualifications comparable to regular ranked faculty but have duties and responsibilities more specialized in nature. Includes such classes as Scholar/Scientist/Engineer and Curator. This structure is as follows:
'0808Assistant Professor Equivalent
Rank structure progression associated with classes with qualifications comparable to regular ranked faculty but have duties and responsibilities more specialized in nature. Includes such classes as Scholar/Scientist/Engineer and Curator. This structure is as follows:
'0909Instructor Equivalent
Rank structure progression associated with classes with qualifications comparable to regular ranked faculty but have duties and responsibilities more specialized in nature. Includes such classes as Scholar/Scientist/Engineer and Curator. This structure is as follows:
'1010University School Professor
Rank structure progression associated with developmental research schools (DRS) is as follows (Rank codes must match with corresponding class code for the use of these ranks to be valid):
'1111University School Associate Professor
Rank structure progression associated with developmental research schools (DRS) is as follows (Rank codes must match with corresponding class code for the use of these ranks to be valid):
'1212University School Assistant Professor
Rank structure progression associated with developmental research schools (DRS) is as follows (Rank codes must match with corresponding class code for the use of these ranks to be valid):
'1313University School Instructor
Rank structure progression associated with developmental research schools (DRS) is as follows (Rank codes must match with corresponding class code for the use of these ranks to be valid):
'1414University Librarian
Rank structure progression associated with libraries is as follows (Rank codes must match with corresponding class code for the use of these ranks to be valid):
'1515Associate University Librarian
Rank structure progression associated with libraries is as follows (Rank codes must match with corresponding class code for the use of these ranks to be valid):
'1616Assistant University Librarian
Rank structure progression associated with libraries is as follows (Rank codes must match with corresponding class code for the use of these ranks to be valid):
'1717Instructor Librarian
Rank structure progression associated with libraries is as follows (Rank codes must match with corresponding class code for the use of these ranks to be valid):
'1818Extension Agent IV
Rank structure progression associated with the Institute of Food and Agricultural Sciences (IFAS) is as follows:
'1919Extension Agent III
Rank structure progression associated with the Institute of Food and Agricultural Sciences (IFAS) is as follows:
'2020Extension Agent II
Rank structure progression associated with the Institute of Food and Agricultural Sciences (IFAS) is as follows:
'2121Extension Agent I
Rank structure progression associated with the Institute of Food and Agricultural Sciences (IFAS) is as follows:
'9999No Rank Assigned
Where no rank is assigned or Class Code is 9199, Faculty Administrator (out of unit), Rank Code must be 99.

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError Description
EMPLEMPLOYEE_DEMO4125Frequency of Values for EMPLOYEE_DEMO.RANK_FAC0Frequency Distribution: not an indication of an error
EMPLEMPLOYEE_DEMO6033RANK_FAC is nulled if blank1Generated or Modified during SUDS Edit Process
IRDWORKLOAD_PERSON_FUNDING0501The Rank coded is invalid9Critical Error: may cause submission to be rejected
IRDWORKLOAD_PERSON_FUNDING4123Frequency of Values for WORKLOAD_PERSON_FUNDING.RANK_FAC0Frequency Distribution: not an indication of an error
IRDWORKLOAD_PERSON_FUNDING6062RANK_FAC is nulled if (WPF.PAY_PLAN_NBR NOT IN ('01', '02', '06', '22') OR (TRIM(WPF.RANK_FAC) IS NULL AND WPF.PAY_PLAN_NBR IN ('01', '02', '06')))1Generated or Modified during SUDS Edit Process
SCDEMPLOYEE_DEMO0501The Rank coded is invalid9Critical Error: may cause submission to be rejected
SCDEMPLOYEE_DEMO4125Frequency of Values for EMPLOYEE_DEMO.RANK_FAC0Frequency Distribution: not an indication of an error
SCDEMPLOYEE_DEMO6033RANK_FAC is nulled if blank1Generated or Modified during SUDS Edit Process
  • 1 - 8

Prior Database Information:

VARCHAR2(2)
RANK
RANK_FAC