Page Name

The award of this status shall provide annual reappointment until voluntary resignation, retirement, removal for just cause, or layoff. Tenure is awarded upon demonstration of highly competent teaching, research or other scholarly activities, service, and contributions to the university and to society. Tenure shall be held as ranked faculty in an academic department/unit and shall not extend to administrative appointments.

Required for faculty. Must be reported on other payplan employees if applicable.

Load programs on EMPLOYEE_DEMO table will NULL value when missing or '.'.




ELEMENT

192001

17-SEP-2008


Allowed Values

'..
MISSING
-
'11Tenure
'22Non-Tenured, Tenure-Earning
'33Not Tenured, Not-Tenure Earning
'44Non-Tenured, Tenure-Earning, Not Eligible
e.g.-Provisional
'MMMulti-Year
An appointment which extends beyond one academic or fiscal year.

Edit Values

Submission CodeAscending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
EMPLEMPLOYEE_DEMO4166Frequency of Values for EMPLOYEE_DEMO.TENURE_STAT0Frequency Distribution: not an indication of an error
EMPLEMPLOYEE_DEMO5416Faculty records must have a valid Tenure Status (01671). OPS and other pay plans must have a valid Tenure Status if coded.9Critical Error: may cause submission to be rejected
EMPLEMPLOYEE_DEMO6037TENURE_STAT is nulled if blank 1Generated or Modified during SUDS Edit Process
IRDWORKLOAD_PERSON_FUNDING0289Tenure status is either invalid or missing for a faculty record9Critical Error: may cause submission to be rejected
IRDWORKLOAD_PERSON_FUNDING4165Frequency of Values for WORKLOAD_PERSON_FUNDING.TENURE_STAT0Frequency Distribution: not an indication of an error
SCDEMPLOYEE_DEMO4166Frequency of Values for EMPLOYEE_DEMO.TENURE_STAT0Frequency Distribution: not an indication of an error
SCDEMPLOYEE_DEMO6037TENURE_STAT is nulled if blank 1Generated or Modified during SUDS Edit Process
  • 1 - 7

Prior Database Information:

VARCHAR2(1)
TENSTAT
TEN_STATUS