Page Name

Description:

The date that an employee is enrolled in the Deferred Retirement Option Program (DROP).

Coding Instructions:

This date is the date that an employee began participation in the Deferred Retirement Option Program (DROP) and can not be before July 1, 1998. On EMPLOYEE_DEMO table code blanks or '.' for employees not in DROP.

Load programs for EMPLOYEE_DEMO will NULL value when RETIRE_CD is not a DROP retirement program and when SUB_TYP is EMPL.

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
Salary Category Detail (SCD)	EMPLOYEE_DEMO (EDEM)	DROP_ENROLL_DT	370	1693	29	Salary Category Detail
University Employee/OPS (EMPL)	EMPLOYEE_DEMO (EDEM)	DROP_ENROLL_DT	370	1693	29	University Employee/OPS

1 - 2

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
EMPL	EMPLOYEE_DEMO	0465	Missing and retirement code equals drop	9	Critical Error: may cause submission to be rejected
EMPL	EMPLOYEE_DEMO	0466	DROP enrollment date must be after JULY 1, 1998	9	Critical Error: may cause submission to be rejected
EMPL	EMPLOYEE_DEMO	6235	DROP_ENROLL_DT is nulled if RETIRE_CD_EMP not in ('DP', 'DR', 'DS', 'DT') AND SUB_TYP in ('F', 'R')	1	Generated or Modified during SUDS Edit Process
SCD	EMPLOYEE_DEMO	6235	DROP_ENROLL_DT is nulled if RETIRE_CD_EMP not in ('DP', 'DR', 'DS', 'DT') AND SUB_TYP in ('F', 'R')	1	Generated or Modified during SUDS Edit Process

1 - 4

Physical Description:

DATE

Short Name:

DROPENRL

Column Name:

DT_DROP_ENROLL

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: Date of Enrollment - DROP - 01690

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: