{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Group Information","Quoting Census Template","Quoting Help File","Import Census Template","Error List","CensusVersionInfo","ErrData","ACA Help File","Mid Market Census Template","Census DDL"],"not_rendered":{"images":1,"macros":1,"defined_names":48},"read":"whole","date_system":"1900"}

{"sheet":"Group Information","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"merged":[[0,1,0,4],[1,1,1,4],[25,2,25,4],[26,2,26,4],[33,2,36,4]]}
[null,"Import Census Template \nCensus Template Setup Form"]
[]
[null,"Step 1: Please Make a Selection",null,null,"Release 2017.1"]
[null,"Market Segment:","SMALL GROUP",{"$f":"IF(ISBLANK(C4),\"Required: Please select a value.\",IF(rMktSeg=\"SMALL GROUP\",\" (2-50)                                                                 \", \" (51-150)                                                            \"))","v":" (2-50)                                                                 "}]
[null,"Quoting or Enrollment:","ENROLLMENT",{"$f":"IF(ISBLANK(C5),\"Required: Please select a value.\",\"\")","v":""},0]
[null,"Division:",null,{"$f":"IF(ISBLANK(C6),\"Required: Please select a value.\",\"\")","v":"Required: Please select a value."}]
[]
[null,"Step 2: Enter Group Benefits Information"]
[null,"Has Group Selected Health?",null,{"$f":"IF(ISBLANK(C9),\"Required: Please select a value.\",\"\")","v":"Required: Please select a value."}]
[null,"HMO Plan?",null,{"$f":"IF(AND(C$9=\"N\",C10=\"Y\"),\"Please update: Has Group Selected Health? is N.\",IF(AND(C$9=\"\",C10>\" \",C$6=\"IL\"),\"Has Group Selected Health? is blank.\",IF(AND(C$9=\"Y\",C10=\"\"),\"Required: Please select a value.\",\"\")))","v":""}]
[null,"Plan 1:",null,{"$f":"IF(AND(C$9=\"N\",C11>\" \"),\"Please update: Has Group Selected Health? is N.\",IF(AND(C$9=\"\",C11>\" \"),\"Has Group Selected Health? is blank.\",IF(AND(C$9=\"Y\",C11=\"\"),\"Required: Please enter 7 digit plan code.\",\"\")))","v":""}]
[null,"Plan 2:",null,{"$f":"IF(AND(C$9=\"N\",C12>\" \"),\"Please update: Has Group Selected Health? is N.\",IF(AND(C$9=\"\",C12>\" \"),\"Has Group Selected Health? is blank.\",IF(AND(C$9=\"Y\",C12=\"\"),\"Optional: Enter 7 digit plan code as needed.\",\"\")))","v":""}]
[null,"Plan 3:",null,{"$f":"IF(AND(C$9=\"N\",C13>\" \"),\"Please update: Has Group Selected Health? is N.\",IF(AND(C$9=\"\",C13>\" \"),\"Has Group Selected Health? is blank.\",IF(AND(C$9=\"Y\",C13=\"\"),\"Optional: Enter 7 digit plan code as needed.\",\"\")))","v":""}]
[null,"Plan 4:",null,{"$f":"IF(AND(C$9=\"N\",C14>\" \"),\"Please update: Has Group Selected Health? is N.\",IF(AND(C$9=\"\",C14>\" \"),\"Has Group Selected Health? is blank.\",IF(AND(C$9=\"Y\",C14=\"\"),\"Optional: Enter 7 digit plan code as needed.\",\"\")))","v":""}]
[null,"Plan 5:",null,{"$f":"IF(AND(C$9=\"N\",C15>\" \"),\"Please update: Has Group Selected Health? is N.\",IF(AND(C$9=\"\",C15>\" \"),\"Has Group Selected Health? is blank.\",IF(AND(C$9=\"Y\",C15=\"\"),\"Optional: Enter 7 digit plan code as needed.\",\"\")))","v":""}]
[null,"Plan 6:",null,{"$f":"IF(AND(C$9=\"N\",C16>\" \"),\"Please update: Has Group Selected Health? is N.\",IF(AND(C$9=\"\",C16>\" \"),\"Has Group Selected Health? is blank.\",IF(AND(C$9=\"Y\",C16=\"\"),\"Optional: Enter 7 digit plan code as needed.\",\"\")))","v":""},{"$nulls":3},"`"]
[null,"Has Group Selected Dental?",null,{"$f":"IF(ISBLANK(C17),\"Required: Please select a value.\",\"\")","v":"Required: Please select a value."}]
[null,"Plan 1:",null,{"$f":"IF(AND(C$17=\"N\",C18>\" \"),\"Please update: Has Group Selected Dental? is N.\",IF(AND(C$17=\"\",C18>\"\"),\"Has Group Selected Dental? is blank.\",IF(AND(C$17=\"Y\",C18=\"\"),\"Required: Please enter 7 digit plan code.\",\"\")))","v":""}]
[null,"Plan 2:",null,{"$f":"IF(AND(C$17=\"N\",C19>\" \"),\"Please update: Has Group Selected Dental? is N.\",IF(AND(C$17=\"\",C19>\" \"),\"Has Group Selected Dental? is blank.\",IF(AND(C$17=\"Y\",C19=\"\"),\"Optional: Enter 7 digit plan code as needed.\",\"\")))","v":""}]
[null,"Has Group Selected Life? ",null,{"$f":"IF(ISBLANK(C20),\"Required: Please select a value.\",IF(AND(rLifeFlg=\"N\", rSalaryFlg=\"Y\"),\"\",\"\"))","v":"Required: Please select a value."}]
[null,"Is Life or STD   "]
[null,"Salary Based?",null,{"$f":"IF(AND(rLifeFlg=\"Y\",ISBLANK(rSalaryFlg)),\"Required: Please select a value.\",IF(AND(rSalaryFlg=\"Y\",rLifeFlg=\"N\"),\"Please update: Has Group Selected Life? is N.\",\"\"))","v":""}]
[]
[null,"Click on Green button for Census Data Entry"]
[null,null,"   Please Note:"]
[null,null,"  -  Health/Dental/Life census template columns\n      display/hide based on above Y or N selection.\n  -  Returning to this tab hides Import Census \n      Template tab and does not overwrite census data."]
[]
[]
[]
[]
[]
[]
[null,null,"   ATTENTION:"]
[null,null,"  - Please click this button for displaying all census columns \n     AFTER census data has been entered.\n    "]

{"sheet":"Quoting Census Template","index":1,"n_rows":2,"n_cols":11,"rows_kept":2,"hidden":true}
["Last Name (Case Sensitive)","First Name\n(Case Sensitive)","Relationship Code\n(follow Help file instructions)","Gender (M or F)","DOB (mm/dd/yyyy)","Coverage Type\n(follow Help file instructions)","State Code","Retiree (IL Only)","Annual Salary","Life Class","Zip Code (BBF Only)"]
[null,null,"Employee"]

{"sheet":"Quoting Help File","index":2,"n_rows":33,"n_cols":5,"rows_kept":33,"hidden":true,"merged":[[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[12,1,15,1],[12,3,15,3],[12,4,15,4],[18,1,27,1],[18,3,27,3],[18,4,27,4],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[38,1,38,3],[39,1,39,4],[40,1,40,3]]}
[]
[null,"Importing Census Entries:"]
[null,"Creating the Import Census File:"]
[null,"Use these rules to create an Import census file."]
[null,"1. Row 1 should not be deleted or changed. "]
[null,"2. Do NOT Delete any column in Census Import tab."]
[null,"3. Do NOT Change the order of the fields."]
[null,"4. Create a row for each census entry, containing these fields entered in this sequence"]
[null,"5. Who should be included on the excel Census? \n             Include all employees (and any cobra participants) that would be enrolling in health coverage if the employer chooses BCBS as the health insurer. \n\n    Who should be excluded on the excel Census? \n            The excel census should not include anyone that would waive or decline health coverage regardless of the decline reason. "]
[null,"Field Name","Formatting Specifications","Maximum Permissible Length","Notes"]
[null,"Last Name","Alphabetic, numeric, and special characters",20,"Applicable to all divisions\nApplicable for 1-50 Fully Insured & 10-100 Blue Balanced Funded Quote.\nOptional for Employee, Spouse & Dependent."]
[null,"First Name","Alphabetic, numeric, and special characters",20,"Applicable to all divisions\nApplicable for 1-50 Fully Insured & 10-100 Blue Balanced Funded Quote.\nOptional for Employee, Spouse & Dependent."]
[null,"Relationship Code","Allowable Values:",9,"Applicable to all divisions\nApplicablefor 1-50 Fully Insured & 10-100 Blue Balanced Funded Quote.\nRequired for Employee, Spouse & Dependent."]
[null,null,"Employee"]
[null,null,"Spouse"]
[null,null,"Dependent"]
[null,"Gender","Allowable Values:\nM\nF",1,"Applicable to all divisions\nApplicable for 1-50 Fully Insured & 10-100 Blue Balanced Funded Quote.\nRequired for Employee, Spouse & Dependent."]
[null,"Date of Birth","MM/DD/YYYY",10,"Applicable for 1-50 Fully Insured & 10-100 Blue Balanced Funded Quote.\nRequired for Employee, Spouse & Dependent."]
[null,"Coverage Type","Allowable Values: For 1-50 Fully Insured and 10-100 Blue Balanced Funded Quotes",2,"Applicable to all divisions\nApplicable for 1-50 Fully Insured & 10-100 Blue Balanced Funded Quote.\nRequired for Employee"]
[null,null,"EO - Employee Only"]
[null,null,"ES - Employee + Spouse"]
[null,null,"EC - Employee + Child"]
[null,null,"EF - Employee + Family"]
[null,null,"CO - COBRA Employee Only"]
[null,null,"CS - COBRA Employee + Spouse"]
[null,null,"CC - COBRA Employee + Child"]
[null,null,"CF - COBRA Employee + Family"]
[null,null,"LO - Life Only (NOT APPLICABLE FOR BLUE BALANCED FUNDED QUOTES)"]
[null,"State Code","Alphabetic characters only",2,"Applicable to all divisions\nApplicable for 1-50 Fully Insured & 10-100 Blue Balanced Funded Quote.\nRequired for Employee"]
[null,"Retiree (IL Only)","Allowable Values:\nY\nN",1,"Applicable to IL Division only\nApplicable for 1-50 Fully Insured & 10-100 Blue Balanced Funded Quote.\nRequired for Employee"]
[null,"Annual Salary","Numeric characters only",7,"Applicable to all divisions\nRequired for Employee\nApplicable only for Fully Insured Quotes of groups with 50 or less total employees and if multiple Life Classes are involved"]
[null,"Life Class","Alphabetic, numeric, and special characters","N/A","Applicable to all divisions\nRequired for Employee\nApplicable only for Fully Insured Quotes of groups with 50 or less total employees and if multiple Life Classes are involved"]
[null,"Zip Code (BBF Only)","Numeric characters only",5,"Applicable to all divisions\nApplicable only for 10-100 Blue Balanced Funded Quote.\nRequired for Employee"]

{"sheet":"Import Census Template","index":3,"n_rows":3,"n_cols":63,"rows_kept":3,"hidden":true}
["General Information",{"$nulls":22},"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",{"$nulls":7},"Dental Coverage",null,"",null,null,"Life Coverage",{"$nulls":6},"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"]
["Employee"]

{"sheet":"Error List","index":4,"n_rows":5,"n_cols":2,"rows_kept":5,"hidden":true}
["Row Nbr","Error Description"]
[3,"For City, alphabets, space and hyphen are accepted."]
[3,"Employment Status is required for Employee with Coverage."]
[3,"Signature Date is required for Employee."]
[4,"DOB is required for Spouse/Dependent."]

{"sheet":"CensusVersionInfo","index":5,"n_rows":5,"n_cols":2,"rows_kept":5,"hidden":true}
["Config Item","Config Value"]
["Census Version","1.0"]
["Division",{"$f":"IF(rDiv=\"IL\",\"Illinois\",(IF(rDiv=\"TX\",\"Texas\",(IF(rDiv=\"OK\",\"Oklahoma\",IF(rDiv=\"NM\",\"New Mexico\",IF(rDiv=\"MT\",\"Montana\",\"\")))))))","v":""}]
["Ready To Upload","Y"]
["Debug","Y"]

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

{"sheet":"ACA Help File","index":7,"n_rows":80,"n_cols":5,"rows_kept":80,"hidden":true,"merged":[[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[11,1,17,1],[11,3,17,3],[11,4,17,4],[80,1,80,4],[81,1,81,4],[82,1,82,3],[83,1,83,3],[84,1,84,3],[85,1,85,3],[86,1,86,3],[87,1,87,3],[88,1,88,3],[89,1,89,3],[90,1,90,3],[91,1,91,3],[92,1,92,3],[93,1,93,3],[94,1,94,4],[95,1,95,4],[96,1,96,4],[97,1,97,3],[98,1,98,3],[99,1,99,3],[100,1,100,4],[101,1,101,3],[102,1,102,3],[103,1,103,3],[104,1,104,4],[105,1,105,3],[106,1,106,3],[107,1,107,3],[108,1,108,3],[109,1,109,3],[110,1,110,3],[111,1,111,3],[112,1,112,3],[113,1,113,3],[114,1,114,3],[115,1,115,3],[116,1,116,3],[117,1,117,3],[118,1,118,3],[119,1,119,3],[120,1,120,3],[121,1,121,3],[122,1,122,3],[123,1,123,3],[124,1,124,3],[125,1,125,3],[126,1,126,3],[127,1,127,3],[128,1,128,3],[129,1,129,3],[130,1,130,3],[132,1,132,3],[133,1,133,4],[134,1,134,3]]}
[]
[]
[null,"Importing Census Entries:"]
[null,"Creating the Import Census File:"]
[null,"Use these rules to create an Import census file."]
[null,"1. Row 1 should not be deleted or changed. "]
[null,"2. Do NOT Delete any column in Census Import tab."]
[null,"3. Do NOT Change the order of the fields."]
[null,"4. Create a row for each census entry, containing these fields entered in this sequence"]
[null,"5. Who should be included on the excel Census? \n             Include all employees (and any cobra & retired participants) that would be enrolling in health, dental and/or life coverages \n             if the employer chooses BCBS as the health insurer. \n"]
[null,"Field Name","Formatting Specifications","Maximum Permissible Length","Notes"]
[null,"Relationship Code","Allowable Values:",9,"Required for Employee"]
[null,null,"Employee"]
[null,null,"Spouse"]
[null,null,"Domestic Partner"]
[null,null,"Civil Union (IL)"]
[null,null,"Dependent Child"]
[null,null,"Disabled Dependent"]
[null,"Waive All Coverage","Allowable Values:\nY\nN",1,"Required for Employee"]
[null,"Waive Reason Code","Allowable Values:\nWaiving - Has other coverage\nWaiving - No other coverage",null,"Conditional Required:\nA value is required for Employee only if Waive All Coverage is \"Y\""]
[null,"First Name","Alphabetic, numeric, and special characters",20,"Required for all Relationship Codes"]
[null,"Mid Init","Alphabetic, numeric, and special characters",1,"Optional"]
[null,"Last Name","Alphabetic, numeric, and special characters",20,"Required for all Relationship Codes"]
[null,"Name Suffix","Alphabetic, numeric, and special characters",3,"Optional"]
[null,"Date of Birth","MM/DD/YYYY",10,"Required for all Relationship Codes"]
[null,"Gender","Allowable Values:\nM\nF",1,"Required for all Relationship Codes"]
[null,"SSN","Numeric characters only",9,"Required for all Relationship Codes"]
[null,"Address 1","Alphabetic, numeric, and special characters",40,"Required for Employee"]
[null,"Address 2","Alphabetic, numeric, and special characters",40,"Optional"]
[null,"City","Alphabets, hyphen and space",25,"Required for Employee"]
[null,"State","Alphabetic characters only",2,"Required for Employee"]
[null,"Zip Code","Numeric characters only",5,"Required for Employee"]
[null,"Home/Cell Phone","Numeric characters only",10,"Optional"]
[null,"Business Phone","Numeric characters only",10,"Optional"]
[null,"Email Address","Alphabetic, numeric, and special characters",null,"Optional"]
[null,"Marital Status","Allowable Values:\nSingle\nMarried\nDivorced\nWidowed\nDomestic Partner\nCivil Union",null,"Optional"]
[null,"Employment Status","Allowable Values:\nActive\nRetired\nCOBRA\nIL Cont\nIneligible",null,"Required for Employee"]
[null,"Job Title","Alphabetic, numeric, and special characters",40,"Optional"]
[null,"Hire Date","MM/DD/YYYY",10,"Required for Employee"]
[null,"Hrs/Week","Numeric characters only",3,"Optional"]
[null,"COBRA Reason Code","Allowable Values:\nDivorce\nChapter 11 Bankruptcy\nBakruptch/Surviving Spouse\nLoss of Dependent Status\nJob Termination/Discharge\nLayoff\nLegal Separation\nEmployee's Medicare Entitlement\nReduction in Hours\nJob Term/Discharge - SSD\nLayoff - SSD\nReduction in Hours - SSD\nLoss of Student Status\nEmployee Death\nRetirement\nStudent Comes of Age",null,"Conditional Required:\nA value is required for Employee only if Employment Status is \"COBRA\""]
[null,"COBRA Start Date","MM/DD/YYYY",10,"Conditional Required:\nA value is required for Employee only if Employment Status is \"COBRA\""]
[null,"COBRA Projected End Date","MM/DD/YYYY",10,"Conditional Required:\nA value is required for Employee only if Employment Status is \"COBRA\""]
[null,"IL Cont Reason Code","Allowable Values:\nDependent\nEmployee\nSpouse\nSpouse and Dependent",null,"Conditional Required:\nA value is required for Employee only if Employment Status is \"IL Cont\""]
[null,"IL Cont Start Date","MM/DD/YYYY",10,"Conditional Required:\nA value is required for Employee only if Employment Status is \"IL Cont\""]
[null,"IL Cont Projected End Date","MM/DD/YYYY",10,"Conditional Required:\nA value is required for Employee only if Employment Status is \"IL Cont\""]
[null,"Health Coverage (Y/N)","Allowable Values:\nY\nN",1,"Required for Employee"]
[null,"Health Coverage Type","Allowable Values for Active, Retired & Ineligible:\nEO - Employee Only\nES - Employee + Spouse\nEC - Employee + Child\nEF - Employee + Family\nAllowable Values for COBRA, IL Cont:\nCO - COBRA Employee Only\nCS - COBRA Employee + Spouse\nCC - COBRA Employee + Child\nCF - COBRA Employee + Family",2,"Required for Employee"]
[null,"Selected Health Plan","Alphabetic and numeric",7,"Required for Employee"]
[null,"Health Waive Reason Code","Allowable Values:\nWaiving - Has other coverage\nWaiving - No other coverage",null,"Conditional Required:\nA value is required for Employee only if Health Coverage is \"N\""]
[null,"Health Waive Description","Alphabetic, numeric, and special characters",40,"Optional"]
[null,"Medical Group / IPA#","Numeric characters only",3,"Optional"]
[null,"Medical Group / IPA Name","Alphabetic, numeric, and special characters",50,"Optional"]
[null,"PCP#","Numeric characters only",9,"Optional"]
[null,"PCP Name","Alphabetic, numeric, and special characters",50,"Optional"]
[null,"PCP NPI#","Numeric characters only",10,"Optional"]
[null,"WPHCP#","Numeric characters only",9,"Optional"]
[null,"WPHCP Name","Alphabetic, numeric, and special characters",50,"Optional"]
[null,"WPHCP NPI#","Numeric characters only",9,"Optional"]
[null,"Dental Coverage","Allowable Values:\nY\nN",1,"Required for Employee"]
[null,"Dental Coverage Type","Allowable Values for Active, Retired & Ineligible:\nEO - Employee Only\nES - Employee + Spouse\nEC - Employee + Child\nEF - Employee + Family\nAllowable Values for COBRA, IL Cont:\nCO - COBRA Employee Only\nCS - COBRA Employee + Spouse\nCC - COBRA Employee + Child\nCF - COBRA Employee + Family",2,"Required for Employee"]
[null,"Selected Dental Plan","Alphabetic and numeric",7,"Required for Employee"]
[null,"Dental Waive Reason Code","Allowable Values:\nWaiving - Has other coverage\nWaiving - No other coverage",null,"Conditional Required:\nA value is required for Employee only if Dental Coverage is \"N\""]
[null,"Dental Waive Description","Alphabetic, numeric, and special characters",40,"Optional"]
[null,"Life Coverage","Allowable Values:\nY\nN",1,"Required for Employee"]
[null,"Job Class Type (2-9 - Max 3 Life Classes & 10+ Max 6 Life Classes)","Alphabetic, numeric, and special characters",null,"Conditional Required:\nA value is required for Employee only if Life Coverage is \"Y\""]
[null,"Term Life","Allowable Values:\nY\nN",1,"Conditional Required:\nA value is required for Employee only if Life Coverage is \"Y\""]
[null,"Dependent Life","Allowable Values:\nY\nN",1,"Conditional Required:\nA value is required for Employee only if Life Coverage is \"Y\""]
[null,"Short Term Disability (STD)","Allowable Values:\nY\nN",1,"Conditional Required:\nA value is required for Employee only if Life Coverage is \"Y\""]
[null,"Salary","Numeric characters only",9,"Conditional Required:\nA value is required for Employee only if Term Life or STD is salary based"]
[null,"Salary Period","Allowable Values:\nAnnual\nHourly\nMonthly\nSemi-Monthly\nWeekly",null,"Conditional Required:\nA value is required for Employee only if Term Life or STD is salary based"]
[null,"Medicare Eligible","Allowable Values:\nY\nN\nU",1,"Optional"]
[null,"Medicare HIC Number","Numeric characters only",12,"Optional"]
[null,"Medicare Reason","Allowable Values:\nAged\nDisabled\nEnd Stage Renal Disease",null,"Optional"]
[null,"Medicare Primary or Secondary","Allowable Values:\nPrimary\nSecondary",null,"Optional"]
[null,"Plan A Start Date","MM/DD/YYYY",10,"Optional"]
[null,"Plan A End Date","MM/DD/YYYY",10,"Optional"]
[null,"Plan B Start Date","MM/DD/YYYY",10,"Optional"]
[null,"Plan B End Date","MM/DD/YYYY",10,"Optional"]
[null,"Signature Date","MM/DD/YYYY",10,"Required for Employee"]

{"sheet":"Mid Market Census Template","index":8,"n_rows":2,"n_cols":1,"rows_kept":2,"hidden":true}
[]
[" FUTURE STATE MID MARKET CENSUS TEMPLATE "]

{"sheet":"Census DDL","index":9,"n_rows":84,"n_cols":26,"rows_kept":84,"hidden":true}
["ListYesNo","ListRelationCodeIL","ListRelationCodeSW","ListWaiveReasonCode","ListGender","ListMaritalStatusIL","ListMaritalStatusSW","ListEmployStatusIL","ListEmployStatusTX","ListEmployStatusOKNMMT","ListCobraReasonCode","ListILContReasonCode","ListHlthCoverageTypeActive","ListHlthCoverageTypeCOBRA","ListSalaryPeriod","ListMedicareElig","ListMedicareReason","ListMedicarePS","ListAddrStates","ListLettersOnly","ListNbrsOnly","ccSpouseRows","ccRelationEO","ListQuoteEnroll","ListQuoteRelationCode","ListQuoteCoverageType"]
["Y","Employee","Employee","Waiving - Has other coverage","F","Single","Single","Active","Active","Active","Divorce","Dependent","EO","CO","Annual","Y","Aged","Primary","IL","~","~","Spouse","Spouse","Quoting","Employee","EO"]
["N","Spouse","Spouse","Waiving - No other coverage","M","Married","Married","Retired","Retired","Retired","Chapter 11 Bankruptcy","Employee","ES","CS","Hourly","N","Disabled","Secondary","TX","!","!","Domestic Partner","Domestic Partner","Enrollment","Spouse","ES"]
[null,"Domestic Partner","Domestic Partner",null,null,"Divorced","Divorced","COBRA","COBRA","COBRA","Bankruptcy/Surviving Spouse","Spouse","EC","CC","Monthly","U","End Stage Renal Disease",null,"OK","@","@","Civil Union","Dependent Child",null,"Dependent","EC"]
[null,"Dependent Child","Dependent Child",null,null,"Widowed","Widowed","IL Cont","Ineligible","Ineligible","Loss of Dependent Status","Spouse and Dependent","EF","CF","Semi-Monthly",{"$nulls":3},"NM","#","#",null,"Disabled Dependent",null,null,"EF"]
[null,"Disabled Dependent","Disabled Dependent",null,null,"Domestic Partner","Domestic Partner","Ineligible","TX Cont",null,"Job Termination/Discharge",{"$nulls":3},"Weekly",{"$nulls":3},"MT","$","$",null,"Civil Union",null,null,"CO"]
[null,"Civil Union",{"$nulls":3},"Civil Union",null,null,"TX Dependent Cont ",null,"Layoff",{"$nulls":7},"AL","%","%",{"$nulls":4},"CS"]
[{"$nulls":10},"Legal Separation",{"$nulls":7},"AK","^","^",{"$nulls":4},"CC"]
[{"$nulls":10},"Employee's Medicare Entitlement",{"$nulls":7},"AZ","&","&",{"$nulls":4},"CF"]
[{"$nulls":10},"Reduction in Hours",{"$nulls":7},"AR","*","*",{"$nulls":4},"LO"]
[{"$nulls":10},"Job Term/Discharge - SSD",{"$nulls":7},"CA","(","("]
[{"$nulls":10},"Layoff - SSD",{"$nulls":7},"CO",")",")"]
[{"$nulls":10},"Reduction in Hours - SSD",{"$nulls":7},"CT","_","_"]
[{"$nulls":10},"Loss of Student Status",{"$nulls":7},"DE","+","+"]
[{"$nulls":10},"Employee Death",{"$nulls":7},"DC","`","`"]
[{"$nulls":10},"Retirement",{"$nulls":7},"FL",1,"="]
[{"$nulls":10},"Student Comes of Age",{"$nulls":7},"GA",2,"["]
[{"$nulls":18},"HI",3,"]"]
[{"$nulls":18},"ID",4,"\\"]
[{"$nulls":18},"IN",5,"{"]
[{"$nulls":18},"IA",6,"}"]
[{"$nulls":18},"KS",7,"|"]
[{"$nulls":18},"KY",8,":"]
[{"$nulls":18},"LA",9,";"]
[{"$nulls":18},"ME",0,"\""]
[{"$nulls":18},"MD","=","'"]
[{"$nulls":18},"MA","[","<"]
[{"$nulls":18},"MI","]",">"]
[{"$nulls":18},"MN","\\",","]
[{"$nulls":18},"MS","{","."]
[{"$nulls":18},"MO","}","?"]
[{"$nulls":18},"NE","|","/"]
[{"$nulls":18},"NV",":","a"]
[{"$nulls":18},"NH",";","b"]
[{"$nulls":18},"NJ","\"","c"]
[{"$nulls":18},"NY","'","d"]
[{"$nulls":18},"NC","<","e"]
[{"$nulls":18},"ND",">","f"]
[{"$nulls":18},"OH",",","g"]
[{"$nulls":18},"OR",".","h"]
[{"$nulls":18},"PA","?","i"]
[{"$nulls":18},"RI","/","j"]
[{"$nulls":18},"SC",null,"k"]
[{"$nulls":18},"SD",null,"l"]
[{"$nulls":18},"TN",null,"m"]
[{"$nulls":18},"UT",null,"n"]
[{"$nulls":18},"VT",null,"o"]
[{"$nulls":18},"VA",null,"p"]
[{"$nulls":18},"WA",null,"q"]
[{"$nulls":18},"WV",null,"r"]
[{"$nulls":18},"WI",null,"s"]
[{"$nulls":18},"WY",null,"t"]
[{"$nulls":20},"u"]
[{"$nulls":20},"v"]
[{"$nulls":20},"w"]
[{"$nulls":20},"x"]
[{"$nulls":20},"y"]
[{"$nulls":20},"z"]
[{"$nulls":20},"A"]
[{"$nulls":20},"B"]
[{"$nulls":20},"C"]
[{"$nulls":20},"D"]
[{"$nulls":20},"E"]
[{"$nulls":20},"F"]
[{"$nulls":20},"G"]
[{"$nulls":20},"H"]
[{"$nulls":20},"I"]
[{"$nulls":20},"J"]
[{"$nulls":20},"K"]
[{"$nulls":20},"L"]
[{"$nulls":20},"M"]
[{"$nulls":20},"N"]
[{"$nulls":20},"O"]
[{"$nulls":20},"P"]
[{"$nulls":20},"Q"]
[{"$nulls":20},"R"]
[{"$nulls":20},"S"]
[{"$nulls":20},"T"]
[{"$nulls":20},"U"]
[{"$nulls":20},"V"]
[{"$nulls":20},"W"]
[{"$nulls":20},"X"]
[{"$nulls":20},"Y"]
[{"$nulls":20},"Z"]