• Elements
  • Element: Date of Termination - DROP - 01691

Page Name

The date that an employee expects to terminate from the Deferred Retirement Option Program (DROP).

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 DROP_ENROLL_DT (01690). 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.




ELEMENT

192001

17-SEP-2008


Allowed Values

Edit Values

Submission CodeAscending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
EMPLEMPLOYEE_DEMO0465Missing and retirement code equals drop9Critical Error: may cause submission to be rejected
EMPLEMPLOYEE_DEMO0468Less than 30 days from enrollment9Critical Error: may cause submission to be rejected
EMPLEMPLOYEE_DEMO0889More than 8 years from enrollment9Critical Error: may cause submission to be rejected
EMPLEMPLOYEE_DEMO6236DROP_TERMT_DT is nulled if RETIRE_CD_EMP not in ('DP', 'DR', 'DS', 'DT') AND SUB_TYP in ('F', 'R') 1Generated or Modified during SUDS Edit Process
SCDEMPLOYEE_DEMO6236DROP_TERMT_DT is nulled if RETIRE_CD_EMP not in ('DP', 'DR', 'DS', 'DT') AND SUB_TYP in ('F', 'R') 1Generated or Modified during SUDS Edit Process
  • 1 - 5

Prior Database Information:

DATE
DROPEND
DT_DROP_TERMT