ESBD_360338_1716477843854_Attachment G - Hays County Structure.pdf

PDF 56 KB Posted

Attached to
RFP 2024-P11 Employee Group Health, Dental, and Employee Assistance Plans
Solicitation number
RFp2024-P11
Issued by
Hays County, Texas

About this file

This document appears to be an Attachment G - Hays County Structure related to RFP 2024-P11 for Employee Group Health, Dental, and Employee Assistance Plans. The RFP is issued by Hays County, Texas seeking proposals from qualified companies to provide a comprehensive package of medical, pharmacy, dental, and employee wellness/assistance plans effective January 1, 2025 with open enrollment starting October 1, 2024. The County is looking to partner with insurance companies to achieve competitive long-term and stable financial success while offering a robust benefits package. This does not include banking for the Health Savings Account.

The attachment contains information on the various medical, dental, and employee benefit plans offered to different employee groups within Hays County, including active employees, COBRA, retirees, and surviving spouses, with corresponding plan details such as product codes, coverage types, plan numbers, and reporting codes. Pricing terms, set asides, incumbents, or funding details are not provided in this attachment.

View the file

Other files

File Type Posted
ESBD_360338_1716477848050_Attachment K - Medical Disruption File.xlsx XLSX spreadsheet
ESBD_360338_1716477854452_Attachment L - Rx Usage for Disruption and pricing April 2023-March 2024.xlsx XLSX spreadsheet
ESBD_360338_1716477846456_Attachment N - PY 2024 Funded Insurance Rates.pdf PDF
ESBD_360338_1717797769305_Attachment S - DHMO Fee Schedule.pdf PDF
ESBD_360338_1717797769699_Attachment R - Dental PPO Summary of Benefits.pdf PDF
ESBD_360338_1716477849668_Attachment A - Response Forms.xlsx XLSX spreadsheet
ESBD_360338_1716477845643_Attachment H - March 2024 Invoice with Counts.pdf PDF
ESBD_360338_1717797768907_Addendum 1 - RFP 2024-P11.pdf PDF
ESBD_360338_1716477853396_Attachment B - Hays County Census (April 2024).pdf PDF
ESBD_360338_1716477849236_Attachment P - 2024 Medical Renewal.pdf PDF
ESBD_360338_1717797770098_Attachment B - Hays County Census (April 2024) Excel.xlsx XLSX spreadsheet
ESBD_360338_1716477847667_Attachment Q - 2024 Dental Renewal.pdf PDF
ESBD_360338_1716477852919_RFP 2024-P11 Employee Group Health, Dental and Employee Assistance Plans.pdf PDF
ESBD_360338_1717797768324_Attachment I - Updated - Additional Supporting Claims and Enrollment Information.xlsx XLSX spreadsheet
ESBD_360338_1716477846068_Attachment O - Stop Loss amendment (2024).pdf PDF
ESBD_360338_1716477847276_Attachment D.3 - Large Loss Claim Payments CY 2021-March 2024.pdf PDF
ESBD_360338_1716477844264_Attachment D.1 - Aggregate Stop-Loss 2021-March 2024.pdf PDF
ESBD_360338_1716477853901_Attachment E - Deer Oaks EAP Utilization.pdf PDF
ESBD_360338_1716477843084_Attachment I - Additional Supporting Claims and Enrollment Information.xlsx XLSX spreadsheet
ESBD_360338_1716477846878_Attachment D.2 - March 2024 invoice with counts.pdf PDF
ESBD_360338_1716477844656_Attachment J - Dental PPO and DHMO Disruption Information.xlsx XLSX spreadsheet
ESBD_360338_1716477845223_Attachment M - PY 2024 Retiree Rates.pdf PDF
ESBD_360338_1716477852456_Attachment F - Hays County SBCs 2022-2024.pdf PDF
Show all 23

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

customer_name effective_date contract_number group_name product_code coverage_type plan_number plan_name funding suffix claim_account premium_account plan_variation_code reporting_code County of Hays 01/01/2024 912772 Active EP1 M 2 ASO 2007 CH EP1 AGU2 UHPD Plan 2 ASO AE 002 002 0002 0002 County of Hays 01/01/2024 912772 Active PS1 M 3 ASO 2007 CH+ PS1 AGU2 HSA Plan 3 ASO AF 002 002 0003 0003 County of Hays 01/01/2024 912772 Active PS1 M 1 ASO 2007 CH+ PS1 AGU2 UHPD Plan 1 ASO AD 002 002 0001 0001 County of Hays 01/01/2024 912772 Active HMO D 4 Dental DHMO Plan D094C FI A 001 001 0004 0004 County of Hays 01/01/2024 912772 Active PPO D 5 Dental PPO Plan 4P648 ASO AG 002 002 0005 0005 County of Hays 01/01/2024 912772 CAD EP1 M 2 ASO 2007 CH EP1 AGU2 UHPD Plan 2 ASO AE 005 002 0017 0017 County of Hays 01/01/2024 912772 CAD PS1 M 3 ASO 2007 CH+ PS1 AGU2 HSA Plan 3 ASO AF 005 002 0018 0018 County of Hays 01/01/2024 912772 CAD PS1 M 1 ASO 2007 CH+ PS1 AGU2 UHPD Plan 1 ASO AD 005 002 0016 0016 County of Hays 01/01/2024 912772 CAD HMO D 4 Dental DHMO Plan D094C FI AC 001 001 0019 0019 County of Hays 01/01/2024 912772 CAD PPO D 5 Dental PPO Plan 4P648 ASO AG 005 002 0020 0020 County of Hays 01/01/2024 912772 COBRA EP1 M 2 ASO 2007 CH EP1 AGU2 UHPD Plan 2 ASO AE 003 002 0007 0007 County of Hays 01/01/2024 912772 COBRA PS1 M 3 ASO 2007 CH+ PS1 AGU2 HSA Plan 3 ASO AF 003 002 0008 0008 County of Hays 01/01/2024 912772 COBRA PS1 M 1 ASO 2007 CH+ PS1 AGU2 UHPD Plan 1 ASO AD 003 002 0006 0006 County of Hays 01/01/2024 912772 COBRA HMO D 4 Dental DHMO Plan D094C FI AA 001 001 0009 0009 County of Hays 01/01/2024 912772 COBRA PPO D 5 Dental PPO Plan 4P648 ASO AG 003 002 0010 0010 County of Hays 01/01/2024 912772 Retirees EP1 M 2 ASO 2007 CH EP1 AGU2 UHPD Plan 2 ASO AE 004 002 0012 0012 County of Hays 01/01/2024 912772 Retirees PS1 M 3 ASO 2007 CH+ PS1 AGU2 HSA Plan 3 ASO AF 004 002 0013 0013 County of Hays 01/01/2024 912772 Retirees PS1 M 1 ASO 2007 CH+ PS1 AGU2 UHPD Plan 1 ASO AD 004 002 0011 0011 County of Hays 01/01/2024 912772 Retirees HMO D 4 Dental DHMO Plan D094C FI AB 001 001 0014 0014 County of Hays 01/01/2024 912772 Retirees PPO D 5 Dental PPO Plan 4P648 ASO AG 004 002 0015 0015 County of Hays 01/01/2024 912772 Surviving Spouses EP1 M 2 ASO 2007 CH EP1 AGU2 UHPD Plan 2 ASO AE 006 003 0022 0022 County of Hays 01/01/2024 912772 Surviving Spouses PS1 M 3 ASO 2007 CH+ PS1 AGU2 HSA Plan 3 ASO AF 006 003 0023 0023 County of Hays 01/01/2024 912772 Surviving Spouses PS1 M 1 ASO 2007 CH+ PS1 AGU2 UHPD Plan 1 ASO AD 006 003 0021 0021 County of Hays 01/01/2024 912772 Surviving Spouses HMO D 4 Dental DHMO Plan D094C FI AH 001 001 0024 0024 County of Hays 01/01/2024 912772 Surviving Spouses PPO D 5 Dental PPO Plan 4P648 ASO AG 006 003 0025 0025

RFP 2024-P11 Employee Group Health, Dental, and Employee Assistance Plans Attachment G - Hays County Structure

Hays County 2024 Structure

File details come from the government source that posted it. Updated .