{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["MacroEnable","Import Census Template","CensusCellValidations","Division Name","CensusVersionInfo","Debug","Import Census - Dropdown Values","ValidationLog","ErrData"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":38,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"MacroEnable","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Macros must be enabled in order to use this spreadsheet."]

{"sheet":"Import Census Template","index":1,"n_rows":2,"n_cols":63,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["General Information","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If Emp Status is COBRA",null,null,"If Emp Status is IL Cont",null,null,"Health Coverage",null,null,"If Waiving Health Coverage",null,"If HMO Plan is selected",null,null,null,null,null,null,null,"Dental Coverage",null,"",null,null,"Life Coverage",null,null,null,null,null,null,"Medicare Information"]
["Relationship Code","Waive All Coverage","Waive Reason Code","First Name","Mid Init","Last Name","Name Suffix","Date Of Birth","Gender","SSN","Address 1","Address 2","City","State","Zip Code","Home/Cell Phone","Business Phone","Email Address","Marital Status","Employment Status","Job Title","Hire Date","Hrs/Week","COBRA Reason Code","COBRA Start Date","COBRA Projected End Date","IL Cont Reason Code","IL Cont Start Date","IL Cont Projected End Date","Health Coverage (Y/N)","Health Coverage Type","Selected Health Plan","Health Waive Reason Code","Health Waive Description","Medical Group/IPA #","Medical Group/IPA Name","PCP #","PCP Name","PCP NPI #","WPHCP #","WPHCP Name","WPHCP NPI #","Dental Coverage (Y/N)","Dental Coverage Type","Selected Dental Plan","Dental Waive Reason Code","Dental Waive Description","Life Coverage (Y/N)","Job Class Type (2-9 -  Max 3 Life Classes &\n10+  Max 6 Life Classes)","Term Life","Dependent Life","Short Term Disability (STD)","Salary","Salary Period","Medicare Eligible","Medicare HIC Number","Medicare Reason","Medicare Primary or Secondary","Plan A Start Date","Plan A End Date","Plan B Start Date","Plan B End Date","Signature Date"]

{"sheet":"CensusCellValidations","index":2,"n_rows":43,"n_cols":65,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["Validation Item","Validation Scope","Relationship Code","Waive All Coverage","Waive Reason Code","First Name","Mid Init","Last Name","Name Suffix","Date Of Birth","Gender","SSN","Address 1","Address 2","City","State","Zip Code","Home/Cell Phone","Business Phone","Email Address","Marital Status","Employment Status","Job Title","Hire Date","Hrs/Week","COBRA Reason Code","COBRA Start Date","COBRA Projected End Date","IL Cont Reason Code","IL Cont Start Date","IL Cont Projected End Date","Health Coverage (Y/N)","Health Coverage Type","Selected Health Plan","Health Waive Reason Code","Health Waive Description","Medical Group/IPA #","Medical Group/IPA Name","PCP #","PCP Name","PCP NPI #","WPHCP #","WPHCP Name","WPHCP NPI #","Dental Coverage (Y/N)","Dental Coverage Type","Selected Dental Plan","Dental Waive Reason Code","Dental Waive Description","Life Coverage (Y/N)","Job Class Type (2-9 -  Max 3 Life Classes &\n10+  Max 6 Life Classes)","Term Life","Dependent Life","Short Term Disability (STD)","Salary","Salary Period","Medicare Eligible","Medicare HIC Number","Medicare Reason","Medicare Primary or Secondary","Plan A Start Date","Plan A End Date","Plan B Start Date","Plan B End Date","Signature Date"]
["Mandatory","Single","y","c","c","y","n","y","n","c","c","c","c","n","c","c","c","n","n","n","n","c","n","c","c","c","c","c","c","c","c","c","c","c","c","c","n","c","n","c","c","n","c","c","c","c","c","c","c","c","c","c","c","c","c","c","n","c","c","c","c","c","c","c","c"]
["Charset","Single","any","any","any","any","alpha","any","alpha","date","any","num","any","any","alpha-hyphen-space","any","num","num","num","email","any","any","any","date","num","any","date","date","any","date","date","any","any","alpha-num","any","any","num","any","num","any","num","num","any","alpha","any","any","alpha-num","any","any","any","any","any","any","any","num","any","alpha","num","any","any","date","date","date","date","date"]
["MinLength","Single","n/a","n/a","n/a","1",1,1,1,"8","n/a","9","1","1","1","n/a","5","10","10","6","n/a","n/a","0","10","1","n/a","10","10","n/a","10","10","n/a","n/a","7","n/a","0","3","1","9","0","9","9","0","9","n/a","n/a","7","n/a","0","n/a","n/a","n/a","n/a","n/a","1","n/a","n/a","12","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["MaxLength","Single","n/a","n/a","n/a","20",1,20,3,"10","n/a","9","40","40","25","n/a","5","10","10","50","n/a","n/a","40","10","3","n/a","10","10","n/a","10","10","n/a","n/a","7","n/a","50","3","50","9","50","9","9","50","9","n/a","n/a","7","n/a","50","n/a","n/a","n/a","n/a","n/a","9","n/a","n/a","12","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["DefaultValue","Single"]
["ValidationList","Single","RelationshipCodeList","WaiveAllCoverageList","WaiveAllReasonCodeList","n/a","n/a","n/a","n/a","n/a","GenderList","n/a","n/a","n/a","n/a","StateList","n/a","n/a","n/a","n/a","MaritalStatusList","EmploymentStatusList","n/a","n/a","n/a","COBRAReasonCodeList","n/a","n/a","ILContReasonCodeList","n/a","n/a","HealthCoverageList","CoverageTypeList","n/a","HealthWaiveReasonCodeList","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","DentalCoverageList","CoverageTypeList","n/a","DentalWaiveReasonCodeList","n/a","WaiveGroupTermLifeCoverageList","n/a","BasicLifeList","DependentLifeList","ShortTermDisabilityList","n/a","SalaryPeriodList","MedicareEligibleList","n/a","MedicareReasonList","MedicarePrimaryOrSecondaryList","n/a","n/a","n/a","n/a","n/a"]
["MinValue","Single","n/a","n/a","n/a","n/a","n/a","n/a","n/a",{"$f":"SetDate(TODAY(),-130,0)","v":"06/21/1886"},"n/a","n/a","n/a","Address 1","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Date Of Birth","1","n/a","Hire Date","COBRA Start Date","n/a","Hire Date","IL Cont Start Date","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","000000000","n/a","n/a","n/a","n/a","n/a","Date Of Birth","Plan A Start Date","Date Of Birth","Plan B Start Date",{"$f":"SetDate(TODAY(),0,-30)","v":"05/22/2016"}]
["MaxValue","Single","n/a","n/a","n/a","n/a","n/a","n/a","n/a",{"$f":"SetDate(TODAY(),0,0)","v":"06/21/2016"},"n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","2090-11-30","168","n/a","COBRA Projected End Date","n/a","n/a","IL Cont Projected End Date","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","999999999","n/a","n/a","n/a","n/a","n/a","Plan A End Date","n/a","Plan B End Date","n/a",{"$f":"SetDate(TODAY(),0,0)","v":"06/21/2016"}]
["Div-IL","Single","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y"]
["Div-TX","Single","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","n","n","n","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y"]
["Div-OK","Single","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","n","n","n","y","y","y","y","y","n","n","n","n","n","n","n","n","y","y","y","y","y","n","n","n","n","n","n","n","y","y","y","y","y","y","y","y","y"]
["Div-NM","Single","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","n","n","n","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","n","n","n","n","n","n","n","y","y","y","y","y","y","y","y","y"]
["Div-MT","Single","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","y","n","n","n","y","y","y","y","y","n","n","n","n","n","n","n","n","y","y","y","y","y","n","n","n","n","n","n","n","y","y","y","y","y","y","y","y","y"]
["Relationship Code","X-Field","n/a","Employee","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Employee","Employee","Employee","Employee","Employee","Employee","n/a","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee","Employee"]
["Waive All Coverage","X-Field","n/a","n/a","Y","n/a","n/a","n/a","n/a","N","N","N","N","n/a","N","N","N","n/a","n/a","n/a","n/a","N","n/a","N","N","n/a","n/a","n/a","n/a","n/a","n/a","N","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","N","n/a","n/a","n/a","n/a","N","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["SSN","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Dep","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Employment Status","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","COBRA","COBRA","COBRA","IL Cont - IL Only","IL Cont - IL Only","IL Cont - IL Only","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Active","Active","Active","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Address 1","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Health Coverage (Y/N)","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Y","Y","N","N","Y","Y","Y","Y","Y","Y","Y","Y","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Health Waive Reason Code","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Medical Group/IPA #","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Dep","has value","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Medical Group/IPA Name","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Dep","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["PCP #","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Dep","has value","has value","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["PCP Name","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Dep","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["PCP NPI #","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Dep","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["WPHCP #","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","has value","has value","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Dental Coverage (Y/N)","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Y","Y","N","N","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Dental Waive Reason Code","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Life Coverage (Y/N)","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Y","Y","Y","Y","Y","Y","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Short Term Disability (STD)","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Y","Y","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Medicare Eligible","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","Y","Y","Y","Y","Y","Y","Y","n/a"]
["Date Of Birth","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Hire Date","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["COBRA Projected End Date","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["COBRA Start Date","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["IL Cont Projected End Date","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["IL Cont Start Date","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Plan A End Date","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Plan A Start Date","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Plan B End Date","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["Plan B Start Date","X-Field","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a","n/a"]
["DefMsg","Single","Relationship Code is Required","Waive Coverage selection is a required field.","Waive Reason Code selection is a required field.","First Name can only accept upto 20 characters.","Mid Init can only accept Alphabets upto 1 character.","Last Name can only accept upto 20 characters .","Name Suffix can only accept Alphabets upto 3 characters.","Date of Birth field accept mm/dd/yyyy format.","Gender is required.","SSN can only accept 9 digits.","Address 1 can only accept alphanumeric upto 40 characters.","Address 2 can only accept alphanumeric upto 40 characters.","City can only accept alphabets, hyphen and space upto 25 characters.","State is required.","Zip Code can only accept 5 digits.","Home/Cell Phone can only accept 10 digits.","Business Phone can only accept 10 digits.","Email ID accept alphanumeric in abcd@xyz.com format.","n/a","Employment Status is required.","Job Title can accept alphanumeric including special characters upto 40 characters","Hire Date field accept mm/dd/yyyy format.","Hrs/Week can only accept digits upto 3 characters.","COBRA Reason Code selection is required.","COBRA Start Date field accept mm/dd/yyyy format.","COBRA Projected End Date field accept mm/dd/yyyy format.","IL Cont Reason Code selection is required.","IL Cont Start Date field accept mm/dd/yyyy format.","IL Cont Projected End Date field accept mm/dd/yyyy format.","Health Coverage selection is a required field.","Health Coverage Type is a required field.","Selected Health Plan can only accept Plan ID upto 7 characters .","Health Coverage Waive Reason Code is required.","Health waive Description is required. \n","Medical Group/IPA # can only accept 3 digits.","Medical Group/IPA Name is required up to 50 Characters  when IPA # is not blank .","PCP # can only accept 9 digits.","PCP Name is required up to 50 Characters  when PCP# is not blank.","PCP NPI # can only accept 9 digits.","WPHCP # can only accept 9 digits.","WPHCP Name is required up to 50 Characters  when WPHCP # is not blank. ","WPHCP NPI # can only accept 9 digits.","Dental Coverage selection is a required field.","Dental Coverage Type is a required field.","Selected Dental Plan field can only accept correct Plan ID.","Dental Coverage Waive Reason Code is required.","Dental Coverage Waive Description is required.\n","Life coverage is a required field","Job Class Type is a required field.","Term Life is a required field.","Dependent Life is a required field.","Short Term Disability is a required field when Employee Status is Active","Salary field can only accept 9 digits","Salary Period is a required field","n/a","Medicare HIC Number field can only accept 12 digits","Medicare Reason is a required field","Medicare Primary or Secondary is a required field","Plan A Start Date field can accept only mm/dd/yyyy format.","Plan A End Date field can accept only mm/dd/yyyy format.","Plan B Start Date field can accept only mm/dd/yyyy format.","Plan B End Date field can accept only mm/dd/yyyy format.","Signature Date field accept mm/dd/yyyy format."]

{"sheet":"Division Name","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"CensusVersionInfo","index":4,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Config Item","Config Value"]
["Census Version","1.0"]
["Division"]
["Ready To Upload","Y"]
["Debug","N"]

{"sheet":"Debug","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Import Census - Dropdown Values","index":6,"n_rows":65,"n_cols":34,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
["Division","Relationship Code","Relationship Code Illinois","Gender","States","Codes","Marital Status","Marital Status Illinois","Employment Status","Employment Status Illinois","Employment Status Texas","Health Coverage Needed","Health Coverage Type","Health Coverage Type Except Active","Health Coverage Type For Active","Health Waive Reason Code","COBRA Reason Code","IL Cont Reason Code","Medicare Eligible","Medicare Reason","Medicare Primary or Secondary","Job Class Type","Salary Period","BasicLifeList","DentalCoverageList","DentalCoverageTypeList","Dental Coverage Type Except Active","DentalWaiveReasonCodeList","DependentLifeList","MemberAttestationList","ShortTermDisabilityList","WaiveGroupTermLifeCoverageList","WaiveAllCoverage","WaiveAllCoverageReasonCode"]
["Illinois","Employee","Employee","M","Alabama","AL","Single","Single","Active","Active","Active","Y","EO","EO","EO","Waiving - Has other coverage","Divorce","Dependent","Y","Aged","Primary ",1,"Annual","Y","Y","EO","CO","Waiving - Has other coverage","Y","Y","Y","Y","Y","Waiving - Has other coverage"]
["Montana","Spouse","Spouse","F","Alaska","AK","Married","Married","Retired","Retired","Retired","N","EC","EC","EC","Waiving - No other coverage","Chapter 11 Bankruptcy","Employee","N","Disabled","Secondary",2,"Hourly","N","N","EC","CC","Waiving - No other coverage","N","N","N","N","N","Waiving - No other coverage"]
["New Mexico","Domestic Partner","Domestic Partner",null,"Arizona","AZ","Divorced","Divorced","COBRA","COBRA","COBRA",null,"ES","ES","ES",null,"Bakruptch/Surviving Spouse","Spouse","U","End Stage Renal Disease",null,3,"Monthly",null,null,"ES","CS"]
["Oklahoma","Dependent Child","Civil Union",null,"Arkansas","AR","Widowed","Widowed","Ineligible","IL Cont","Ineligible",null,"EF","EF","EF",null,"Loss of Dependent Status","Spouse and Dependent",null,null,null,4,"Semi-Monthly",null,null,"EF","CF"]
["Texas","Disabled Dependent","Dependent Child",null,"California","CA","Domestic Partner","Domestic Partner",null,"Ineligible","TX Cont",null,"CO","DC","DC",null,"Job Termination/Discharge",null,null,null,null,5,"Weekly",null,null,"CO","DC"]
[null,null,"Disabled Dependent",null,"Colorado","CO",null,"Civil Union",null,null,"TX Dependent Cont",null,"CC",null,null,null,"Layoff",null,null,null,null,6,null,null,null,"CC"]
[null,null,null,null,"Connecticut","CT",null,null,null,null,null,null,"CS",null,null,null,"Legal Separation",null,null,null,null,null,null,null,null,"CS"]
[null,null,null,null,"Delaware","DE",null,null,null,null,null,null,"CF",null,null,null,"Employee's Medicare Entitlement",null,null,null,null,null,null,null,null,"CF"]
[null,null,null,null,"District of Columbia","DC",null,null,null,null,null,null,"DC",null,null,null,"Reduction in Hours",null,null,null,null,null,null,null,null,"DC"]
[null,null,null,null,"Florida","FL",null,null,null,null,null,null,null,null,null,null,"Job Term/Discharge - SSD"]
[null,null,null,null,"Georgia","GA",null,null,null,null,null,null,null,null,null,null,"Layoff - SSD"]
[null,null,null,null,"Hawaii","HI",null,null,null,null,null,null,null,null,null,null,"Reduction in Hours - SSD"]
[null,null,null,null,"Idaho","ID",null,null,null,null,null,null,null,null,null,null,"Loss of Student Status"]
[null,null,null,null,"Illinois","IL",null,null,null,null,null,null,null,null,null,null,"Employee Death"]
[null,null,null,null,"Indiana","IN",null,null,null,null,null,null,null,null,null,null,"Retirement"]
[null,null,null,null,"Iowa","IA",null,null,null,null,null,null,null,null,null,null,"Student Comes of Age"]
[null,null,null,null,"Kansas","KS"]
[null,null,null,null,"Kentucky","KY"]
[null,null,null,null,"Louisiana","LA"]
[null,null,null,null,"Maine","ME"]
[null,null,null,null,"Maryland","MD"]
[null,null,null,null,"Massachusetts","MA"]
[null,null,null,null,"Michigan","MI"]
[null,null,null,null,"Minnesota","MN"]
[null,null,null,null,"Mississippi","MS"]
[null,null,null,null,"Missouri","MO"]
[null,null,null,null,"Montana","MT"]
[null,null,null,null,"Nebraska","NE"]
[null,null,null,null,"Nevada","NV"]
[null,null,null,null,"New Hampshire","NH"]
[null,null,null,null,"New Jersey","NJ"]
[null,null,null,null,"New Mexico","NM"]
[null,null,null,null,"New York","NY"]
[null,null,null,null,"North Carolina","NC"]
[null,null,null,null,"North Dakota","ND"]
[null,null,null,null,"Ohio","OH"]
[null,null,null,null,"Oklahoma","OK"]
[null,null,null,null,"Oregon","OR"]
[null,null,null,null,"Pennsylvania","PA"]
[null,null,null,null,"Rhode Island","RI"]
[null,null,null,null,"South Carolina","SC"]
[null,null,null,null,"South Dakota","SD"]
[null,null,null,null,"Tennessee","TN"]
[null,null,null,null,"Texas","TX"]
[null,null,null,null,"Utah","UT"]
[null,null,null,null,"Vermont","VT"]
[null,null,null,null,"Virginia","VA"]
[null,null,null,null,"Washington","WA"]
[null,null,null,null,"West Virginia","WV"]
[null,null,null,null,"Wisconsin","WI"]
[null,null,null,null,"Wyoming","WY"]
[null,null,null,null,"American Samoa","AS"]
[null,null,null,null,"Guam","GU"]
[null,null,null,null,"Northern Mariana Islands","MP"]
[null,null,null,null,"Puerto Rico","PR"]
[null,null,null,null,"Virgin Islands","VI"]
[null,null,null,null,"US Minor Outlying Islands ","UM"]
[null,null,null,null,"Federated States of Micronesia","FM"]
[null,null,null,null,"Marshall Islands","MH"]
[null,null,null,null,"Palau","PW"]
[null,null,null,null,"Atlantic (Military)","AA"]
[null,null,null,null,"Pacific (Military)","AP"]
[null,null,null,null,"Europe (Military)","AE"]
[null,null,null,null,"Other","Other"]

{"sheet":"ValidationLog","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"ErrData","index":8,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[null,6]