Page Name

The classification which identifies the discipline in which the employee holds tenure or in which the employee is earning tenure. (FAC 6C-5.225)

Faculty in non-instructional fields should be coded 000000 - not reported by discipline. The only non-instructional tenured or tenure-earning faculty that are not required to have a CIP are the following groups:
- Librarians Classes 9050-9056
- Museum Curators 9150-9152

Tenure codes of 1 and 2 are required to have a valid tenure CIP.
Tenure codes of 3,4,M should be coded blanks or '.'.

Load programs on EMPLOYEE_DEMO will value NULL when TENURE_STAT is not '1' or '2' or CIP_TENURE is '.' or blanks.




ELEMENT

192001

17-SEP-2008


Associated Submissions, Tables, and Columns

Allowed Values

'..MISSING
MISSING
-
'000000000000No Discipline Reported
'010000010000Agriculture Science
'010100010100Agricultural Business and Management
'010101010101Agricultural Business and Management General
'010102010102Agricultural Business/Operations
'010103010103Ag (Food and Resource) Economics
'010104010104Farm/Farm and Ranch Management
'010105010105Agricultural/Farm Supplies Retailing and Wholesaling
'010106010106Agricultural Business Technology
'010199010199Agricultural Business and Management Other
'010200010200Agricultural Mechanization
'010201010201Agricultural Mechanization General
'010204010204Agricultural Power Machinery Operator
'010205010205Agricultural Mechanics and Equipment/Machine Tech
'010207010207Irrigation Management Technology/Technician.
-
'010299010299Agricultural Mechanization Oth
'010300010300Agricultural Production Operations
'010301010301Agricultural Production Operations General
'010302010302Animal/Livestock Husbandry & Production
'010303010303Aquaculture
'010304010304Crop Production
'010306010306Dairy Husbandry and Production
'010307010307Horse Husbandry/Equine Science and Management
'010308010308Agroecology and Sustainable Agriculture.
-
'010309010309Viticulture and Enology
-
'010310010310Apiculture.
-
'010399010399Agricultural Production Operations Other
'010400010400Agricultural and Food Product Processing
'010401010401Packaging Science

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError Description
EMPLEMPLOYEE_DEMO0603Tenure Cip must be valid when TENURE_STAT equals ('1','2','M')9Critical Error: may cause submission to be rejected
EMPLEMPLOYEE_DEMO6040CIP_TENURE is nulled if (EMPLOYEE_DEMO.TENURE_STAT NOT IN ('1', '2', 'M') OR TRIM(EMPLOYEE_DEMO.TENURE_STAT) IS NULL OR EMPLOYEE_DEMO.TENURE_STAT = '.')1Generated or Modified during SUDS Edit Process
SCDEMPLOYEE_DEMO0603Tenure Cip must be valid when TENURE_STAT equals ('1','2','M')9Critical Error: may cause submission to be rejected
SCDEMPLOYEE_DEMO4168Frequency of Values for EMPLOYEE_DEMO.CIP_TENURE0Frequency Distribution: not an indication of an error
SCDEMPLOYEE_DEMO6040CIP_TENURE is nulled if (EMPLOYEE_DEMO.TENURE_STAT NOT IN ('1', '2', 'M') OR TRIM(EMPLOYEE_DEMO.TENURE_STAT) IS NULL OR EMPLOYEE_DEMO.TENURE_STAT = '.')1Generated or Modified during SUDS Edit Process
  • 1 - 5

Prior Database Information:

VARCHAR2(6)
TENCIP
TENURE_CIP