{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Employee Census","Insurance Carrier Plans","COBRA Continuent Info"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Instructions","index":0,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["INSTRUCTIONS FOR DATA UPLOAD FILE LAYOUT (DATA WORKSHEET) FOR BENAFICA"]
[]
[]
["Column Field","Short Description","Applicability","Notes"]
[null,null,"(Employee vs. Dependent)"]
["Employer","Employer's Account ID","Both","Must be pre-populated by Benafica"]
["First Name","First Name","Both"]
["Middle Name","Middle Name","Both","combine all middle names into one"]
["Last Name","Last Name","Both","if suffix exists tack on at end"]
["Employee ID","Employer's Assigned Employee ID","Employees","The ID of the employee"]
["Dependent ID","Employee ID who dependent is related to","Dependent/Spouse","The ID of the employee that the dependent is related to"]
["Location","Employee's (main) work location","Employees","Must match what is defined for employer"]
["Relationship","Dependents relationship to the employee","Dependent/Spouse","Value can be either: Dependent or Spouse"]
["SSN","Social Security Number","Both","Format: xxx-xx-xxxx"]
["Gender Code","gender","Both","Acceptable values: M, F, Male, Female.  All other values will default to: Unknown)"]
["DOB","Birth date","Both","Format: MM/DD/YYYY"]
["Mailing Address","Home address line 1","Both"]
["Mailing Address Line 2","Home address line 2","Both"]
["Mailing City","Home address city","Both"]
["Mailing State","Home address state","Both","Common 2 character code for state"]
["Mailing ZIP Code","Home address city","Both","5 or 10 in lenth.  If 10, then the last 4 chars are the ZIP 4 (Ex: 55125-1234)"]
["County",null,"Both"]
["Country",null,"Both"]
["Primary Phone","Primary Phone Number","Both","9 numerical characters however specified it will reformat into: (###) ###-####"]
["Mobile Phone","Mobile Phone Number","Both","9 numerical characters however specified it will reformat into: (###) ###-####"]
["Primary Email","email address","Both","Recommended: if employee, specify work email address, else personal email address"]
["Personal Email","personal email address","Both","Recommended: personal email address (if not already specified)"]
["Job Class","Employee's job class","Employees","Must match what is defined for employer"]
["Salary","Salary amount of Employee","Employees","Salary amount of employee, if unknown/unspecified default to $0.00"]
["Employee Status","Active or Terminated"]
["Hours Worked","Employee's work hours","Employees","How many hours per week does the employee work?  (F-T is 40 hours/week)"]
["Employment Start Date","Employee's Start date","Both","Format: MM/DD/YYYY.  If dependent, put start date of the related employee instead"]
["Employment End Date","Employee's End date","Both","Format: MM/DD/YYYY.  If dependent, put end date of the related employee instead"]
["Title","Job title of Employee","Employees","Job title of employee"]
[]
[]
["** Confidential Information of Benafica, LLC"]

{"sheet":"Employee Census","index":1,"n_rows":1,"n_cols":29,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Employer","First Name","Middle Name","Last Name","Employee ID","Dependent ID","Location","Relationship","SSN","Gender Code","DOB","Mailing Address","Mailing Address Line 2","Mailing City","Mailing State","Mailing Zip Code","County","Country","Primary Phone","Mobile Phone","Primary Email","Personal Email","Job Class","Salary","Employee Status","Hours Worked","Employment Start Date","Employment End Date","Job Title"]

{"sheet":"Insurance Carrier Plans","index":2,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Product Type","Insurance Company/Provider","Plan Name","Group Policy Number","Coverage Tier*","Renewal Date","COBRA Eligible: Y/N"]
[]
[]
["Medical Plans:"]
[]
[]
[]
[]
["Dental Plans:"]
[]
[]
[]
["Vision Plans:"]
[]
[]
["Disability Income - Long Term Plan: "]
[]
["Disability Income - Short Term Plan: "]
[" "]
["Life Insurance:"]
["Basic Life:"]
[]
["Family Basic Life"]
[]
["Voluntary Life Employee, Spouse or Child(ren)"]
[]
["Other Group Insurance Plans: "]
[]
[]
[]
[]
["Services:"]
["Health Reimbursement Plan"]
[]
["Flexible Savings Plan (FSA)"]
[]
[]
["Notes: "]
["*  1=Employee Only, 2=Employee+Spouse, 3=Employee+Child(ren), 4=Family"]

{"sheet":"COBRA Continuent Info","index":3,"n_rows":3,"n_cols":18,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Instructions:  Please list all people currently on COBRA and their applicable COBRA plans."]
["Status:  Pending=Eligible employees who have not yet responded to a COBRA notice, Active=on COBRA, Retiree=Retired and age 65 or older and on COBRA."]
["Employer","First Name","Last Name","COBRA Plan 1","Status: Pending, Active, a Retiree"," Plan 1 Premium","COBRA Plan 2","Status: Pending, Active, a Retiree"," Plan 2 Premium","COBRA Plan 3","Status: Pending, Active, a Retiree"," Plan 3 Premium","COBRA Plan 4","Status: Pending, Active, a Retiree"," Plan 4 Premium","COBRA Plan 5","Status: Pending, Active, a Retiree"," Plan 5 Premium"]