Description of Data Element 01691
NAME: Date of Termination - DROP
NUMBER: 01691
FILES/TABLES: EMPL SCD
INTENT:
Confidential
DEFINITION:
The date that an employee expects to terminate from the Deferred
Retirement Option Program (DROP).
EDIT:
DIAGNOSTIC MESSAGE ERROR LEVEL
LESS THEN 30 DAYS FROM ENROLLMENT (01690) CRITICAL
EMPL SCD
MISSING OR INVALID AND 01047 = DP,DR,DS OR DT CRITICAL
EMPL SCD
MORE THAN FIVE YEARS FROM ENROLLMENT (01690) CRITICAL
EMPL SCD
MISSING VALUES GENERATED, IF MISSING PROGRAM GENERATED
EMPL SCD
CODING INSTRUCTIONS:
This date is the date that a employee has set to end their
particpation in the Deferred Retirement Option Program (DROP).
This date must be between one month and five years from the Date
of Enrollment (01690).
Certain qualified DRS employees whose date is more than five <
years from Date of Enrollment will generate an error that will <
be accepted by written explanation. <
For unfilled (01181 ne E) on SCD, code blanks.
SOURCE RESPONSIBILITY:
SUS
DATABASE INFORMATION:
PHYSICAL DESCRIPTION: YYYY-MM-DD
COLUMN NAME: DT_DROP_TERMT
SHORT NAME: DROPEND
OTHER INFORMATION: CONFIDENTIAL / NULLABLE
CREATE-CHANGE DATE: 10/27/06
Return to Data Dictionary Main Page