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