Description of Data Element 01690





NAME:         Date of Enrollment - DROP                                         



NUMBER:       01690                                                             



FILES/TABLES: EMPL< SCD                                                         



INTENT:                                                                         
   Confidential                                                                 



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



EDIT:                                                                           
   DIAGNOSTIC MESSAGE                                     ERROR LEVEL           
   BEFORE JULY 1, 1998                                    CRITICAL              
        EMPL <  SCD                                                             
   MISSING OR INVALID AND 01047 = DP,DR,DS OR DT          CRITICAL              
        EMPL <  SCD                                                             
   MISSING VALUES GENERATED, IF MISSING                   PROGRAM GENERATED     
        EMPL <  SCD  <                                                          



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 SCD, code blanks for employees not in DROP.                           <   



SOURCE RESPONSIBILITY:                                                          
   SUS                                                                          



DATABASE INFORMATION:                                                           
   PHYSICAL DESCRIPTION: YYYY-MM-DD                                             
   COLUMN NAME:          DT_DROP_ENROLL                                         
   SHORT NAME:           DROPENRL                                               
   OTHER INFORMATION:    CONFIDENTIAL / NULLABLE                                



CREATE-CHANGE DATE:  11/25/03                                                   



Return to Data Dictionary Main Page