Full name of Job Family for affirmative action purposes.
This is a defined field.
XX:JOBFAMNA/A40 = DECODE XX:JOBFAM (E 'EXECUTIVE, ADMINISTRATIVE AND MANAGEMENT' F 'FACULTY' P 'PROFESSIONAL NON-FACULTY'
C 'SECRETARIAL/CLERICAL' S 'SKILLED CRAFTS' X 'EXCLUDED'
T 'TECHNICAL/PARAPROFESSIONAL' M 'SERVICE/MAINTENANCE' ELSE 'UNKNOWN');
For MPP (M80) this field is defined from JC:JOBFAM
All others use PS:JOBFAM
Job Family, AA = Job Family Name, AA
C = Secretarial/Clerical
E = Executive, Administrative and Management
F = Faculty
M = Service/Maintenance
P = Professional Non-Faculty
S = Skilled Crafts
T = Technical/Paraprofessional
X = Excluded
PS Systemwide Pay Scales
JC Job Code
Last Updated: September 9, 2010