Description of Data Element 01194





NAME:         Degree - Year of Highest                                          



NUMBER:       01194                                                             



FILES/TABLES: EMPL< SCD                                                         



INTENT:                                                                         
   OCR Reporting                                                            <   



DEFINITION:                                                                     
   The year in which the highest educational certificate or                     
   diploma was granted to an employee.                                          



EDIT:                                                                           
   DIAGNOSTIC MESSAGE                                     ERROR LEVEL           
   GT CURRENT YEAR                                        CRITICAL              
        EMPL <  SCD                                                             
   MISSING OR INVALID                                     CRITICAL              
        EMPL <  SCD                                                             
   MISSING VALUES GENERATED, IF MISSING                   PROGRAM GENERATED     
        EMPL <  SCD  <                                                          



CODING INSTRUCTIONS:                                                            
   This element is required on all employees except those with                  
   Degree - Highest Held (01112) = 'N' or 'Z'. Code blanks for these        <   
   and unfilled records (01181 ne Z) on SCD                                 <   



SOURCE RESPONSIBILITY:                                                          
   SUS                                                                          



DATABASE INFORMATION:                                                           
   PHYSICAL DESCRIPTION: YYYY                                                   
   COLUMN NAME:          DEG_YR_OF_HIGHEST                                      
   SHORT NAME:           DEGYRHI                                                
   OTHER INFORMATION:    NULLABLE                                               



CREATE-CHANGE DATE:  11/25/03                                                   



Return to Data Dictionary Main Page