Page Name

Description:

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.

Coding Instructions:

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

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

Algorithm:

Usage Type:

ELEMENT

Begin Term:

192001

End Term:

Last Modified:

17-SEP-2008

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Instruction & Research (IRD)	WORKLOAD_PERSON_FUNDING (WKPF)	TENURE_STAT	369	1499	26	Instruction & Research
Salary Category Detail (SCD)	EMPLOYEE_DEMO (EDEM)	TENURE_STAT	369	1677	29	Salary Category Detail
University Employee/OPS (EMPL)	EMPLOYEE_DEMO (EDEM)	TENURE_STAT	369	1677	29	University Employee/OPS

1 - 3

Excel code	Code	Description	Grouping
'.	.	MISSING	-
'1	1	Tenure
'2	2	Non-Tenured, Tenure-Earning
'3	3	Not Tenured, Not-Tenure Earning
'4	4	Non-Tenured, Tenure-Earning, Not Eligible e.g.-Provisional
'M	M	Multi-Year An appointment which extends beyond one academic or fiscal year.

Download

1 - 6

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
EMPL	EMPLOYEE_DEMO	4166	Frequency of Values for EMPLOYEE_DEMO.TENURE_STAT	0	Frequency Distribution: not an indication of an error
EMPL	EMPLOYEE_DEMO	5416	Faculty records must have a valid Tenure Status (01671). OPS and other pay plans must have a valid Tenure Status if coded.	9	Critical Error: may cause submission to be rejected
EMPL	EMPLOYEE_DEMO	6037	TENURE_STAT is nulled if blank	1	Generated or Modified during SUDS Edit Process
IRD	WORKLOAD_PERSON_FUNDING	0289	Tenure status is either invalid or missing for a faculty record	9	Critical Error: may cause submission to be rejected
IRD	WORKLOAD_PERSON_FUNDING	4165	Frequency of Values for WORKLOAD_PERSON_FUNDING.TENURE_STAT	0	Frequency Distribution: not an indication of an error
SCD	EMPLOYEE_DEMO	4166	Frequency of Values for EMPLOYEE_DEMO.TENURE_STAT	0	Frequency Distribution: not an indication of an error
SCD	EMPLOYEE_DEMO	6037	TENURE_STAT is nulled if blank	1	Generated or Modified during SUDS Edit Process

1 - 7

Physical Description:

VARCHAR2(1)

Short Name:

TENSTAT

Column Name:

TEN_STATUS

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: Tenure Status - 01671

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: