Description of Data Element 01024





NAME:         Date of Birth                                                     



NUMBER:       01024                                                             



FILES/TABLES: ADM   EMPL  HTD   PSTU< RET   SCD   SDCF  SFA   TEF               



INTENT:                                                                         
   Budgetary                                                                    
   Personnel Reporting                                                          



DEFINITION:                                                                     
   Legal date of birth.                                                         



EDIT:                                                                           
   DIAGNOSTIC MESSAGE                                     ERROR LEVEL           
   AGE IS LESS THAN 14                                    CRITICAL              
        EMPL    SCD                                                             
   BIRTHDATE IS IN THE FUTURE                             CRITICAL              
        SDCF    SFA                                                             
   MISSING OR INVALID                                     CRITICAL              
        ADM     EMPL    SCD     SDCF                                            
   NON-NUMERIC                                            CRITICAL              
        SFA     TEF                                                             
   3RD DIGIT = 3RD DIGIT OF TERM YR                       CRITICAL              
        SDCF                                                                    
   AGE IS OVER 80                                         WARNING               
        EMPL    SCD                                                             
   AGE IS 14 OR 15                                        WARNING               
        EMPL    SCD                                                             
   AGE OVER 85                                            WARNING               
        ADM     SDCF    SFA     TEF                                             
   TOO RECENT - AGE 15 OR LESS                            WARNING               
        ADM     SDCF    SFA     TEF                                             
   MISSING VALUES GENERATED, IF MISSING                   PROGRAM GENERATED     
        EMPL    SCD                                                             
   PROGRAM GENERATED FROM SDCF                            PROGRAM GENERATED     
        HTD                                                                     
   FREQUENCY COUNTS WILL BE PERFORMED ON                  FREQUENCY             
        ADM     SDCF    SFA     TEF                                             



CODING INSTRUCTIONS:                                                            
   For student reporting code 9999-99-99 if the birth date is                   
   unknown.                                                                     
   Required for reporting employees and OPS. For unfilled (01181 ne             
   E), should be coded blanks.                                                  



SOURCE RESPONSIBILITY:                                                          
   FFAMIS                                                                       



DATABASE INFORMATION:                                                           
   PHYSICAL DESCRIPTION: YYYY-MM-DD                                             
   COLUMN NAME:          DATE_OF_BIRTH                                          
   SHORT NAME:           DTBIRTH                                                
   OTHER INFORMATION:    NULLABLE                                               



CREATE-CHANGE DATE:  10/10/05                                                   



Return to Data Dictionary Main Page