• Elements
  • Element: Tenure Status - Date Granted - 01238

Page Name

The date on which tenure was granted by the authorized Board

For faculty who are granted tenure as a condition of employment, the date shall be the date on which the faculty member was granted tenure by an authorized Board & may be retroactive to the begining date of the academic year.

For faculty granted tenure status through the regular tenure status review process, the date should be the date of the beginning of the next academic/fiscal year, consistent with university guidelines. For non-faculty salaried employees with tenure this element shall be coded.

When coded, this should be a complete date as responsive to local rules.

Load programs for EMPLOYEE_VACANTS will NULL value when EMPR_TYP_CODE is reserve ('O','P','R') but not summer reserve.

Load programs for EMPLOYEE_DATA will NULL value when RATE_TYP is 'L', 'N' or when BE_CD is faculty practice ('P').




ELEMENT

192001

11-SEP-2008


Allowed Values

Edit Values

Submission CodeAscending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
EMPLEMPLOYEE_DEMO0076Invalid date and has tenure9Critical Error: may cause submission to be rejected
EMPLEMPLOYEE_DEMO6032TENURE_STAT_DT is nulled if blank1Generated or Modified during SUDS Edit Process
EMPLEMPLOYEE_DEMO6192TENURE_STAT_DT is nulled if TENURE_STAT_DT < 01/01/1901 1Generated or Modified during SUDS Edit Process
SCDEMPLOYEE_DEMO6032TENURE_STAT_DT is nulled if blank1Generated or Modified during SUDS Edit Process
SCDEMPLOYEE_DEMO6192TENURE_STAT_DT is nulled if TENURE_STAT_DT < 01/01/1901 1Generated or Modified during SUDS Edit Process
  • 1 - 5

Prior Database Information:

DATE
TENDT
TEN_STAT_DT