Description of Data Element 01668





NAME:         Health Insurance Option Code, State                               



NUMBER:       01668                                                             



FILES/TABLES: EMPL  OPER  SCD                                                   



INTENT:                                                                         
   Budgetary                                                                    
   Personnel Reporting                                                          



DEFINITION:                                                                     
   The particular health insurance option the employee has chosen.              



EDIT:                                                                           
   DIAGNOSTIC MESSAGE                                     ERROR LEVEL           
   INVALID FOR INSURANCE PROVIDER                         CRITICAL              
        EMPL                                                                    
   MISSING OR INVALID                                     CRITICAL              
        EMPL    SCD                                                             
   FREQUENCY COUNTS WILL BE PERFORMED ON                  FREQUENCY             
        EMPL    SCD                                                             



CODING INSTRUCTIONS:                                                            
   For the Operating Budget process, Schedule III, LAS/PBS Update               
   and Cost to Continue, the program will generate a cost to the                
   state. This cost will be based on the Comptrollers Payroll Manual            
   for the State Plan.  All vacant or authorized but not established            
   records will use the average of the State Plan.  All reserve                 
   records will not have a health cost generated.                               
   On the SCD and EMPL files, code 'XX' for unfilled (01181=V,A)                
   and '00' for reserves (01181 in {O,P,R,X}).                                  



TABLE VALUES:                                                                   
   00             None                                                          
   01             Individual                                                    
   02             Family                                                        
   22             Family / Subscriber Spouse                                    
   31             US Civil Service Health Individual                            
   32             US Civil Service Health Family                                
   71             Tricare Individual                                            
   72             Tricare Family                                                
   73             Tricare Family / Subscriber Spouse                            
   74             Tricare Family / Dependent Spouse                             
   81             Health Investor Individual                                    
   82             Health Investor Family                                        
   83             Health Investor Family / Subscriber Spouse                    
   84             Health Investor Family / Dependent Spouse                     
   89             Family / Dependent Spouse                                     
   XX             Average State Individual/Family                               



SOURCE RESPONSIBILITY:                                                          
   DIVISION OF STATE GROUP INSURANCE    <                                       



DATABASE INFORMATION:                                                           
   PHYSICAL DESCRIPTION: X(2)                                                   
   COLUMN NAME:          HLTH_INS_OPT_CD                                        
   SHORT NAME:           HLINSOPT                                               



CREATE-CHANGE DATE:  05/31/06                                                   



Return to Data Dictionary Main Page