7-D7 - City of Burleson 906435 - ODSCR-08B - Dental Membership by Tier Product - Membership 36Mo thru 2025-11.xlsx
XLSX spreadsheet 100 KB Posted
- Attached to
- RFP 2026-015 Dental & Vision Insurance Benefits
- Solicitation number
- RFP 2026-015
- Issued by
- Johnson County, Texas
About this file
This is a dental membership data report for the City of Burleson, Texas, documenting enrollment and claims data for three UHC ASO Custom Plan products over a 36-month period from December 2022 through November 2025. The report tracks subscriber and dependent counts across multiple family tier categories including subscriber only, subscriber with spouse, subscriber with child, subscriber with children, and subscriber with family coverage. The data encompasses three distinct product plans: D0016691 (Plan 2P533), D0033459 (Plan 42P97), and D0036125 (Plan 58P83), with varying enrollment periods and membership fluctuations throughout the reporting timeframe.
The membership data reveals trends in plan utilization across the City of Burleson's dental insurance offerings. Total product enrollment across all three plans shows cumulative subscriber counts of 7,459 and total members (subscribers plus dependents) of 31,836 over the entire 36-month measurement period. Plan 42P97 represents the largest enrollment base with approximately 17,114 total members, followed by Plan 2P533 with varying monthly enrollment, while Plan 58P83 shows the smallest membership base but with enrollment growth beginning in January 2024. The data indicates overall membership stability with minor seasonal fluctuations, providing historical baseline information relevant to the pending RFP 2026-015 for Dental and Vision Insurance Benefits for the City of Burleson's eligible full-time employees, retirees, and dependents.
View the file
Other files
Show all 25
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
ODSCR-08B
Membership by Group, Product and Tier
Selection Parameters Values on Report
| Group Effective Date: 1/1/2016 | ||
| Incurred Date Range: 12/1/2022 to 11/30/2025 | 12/1/2022 to 11/1/2025 | |
| Group Renewal Month Day: 01/01 |
| Group ID: 1019974 | 1019974 | |
| Group Policy Number: 0906435 | ||
| Business Category: -1 | PPO |
Product: -1 Product: -1
| Incurred Date | Subscribers Count by Tier | Members Count by Tier | Total | |||||||||||
| Subscriber Only | w/ Spouse | w/ Child | w/ Children | w/ Family | w/ Spouse | w/ Child | w/ Children | w/ Family | Subscribers | Dependents | Members | |||
| 1019974 CITY OF BURLESON | D0016691UHC ASO Custom Plan 2P533 | December 2022 | 2,1,3 | 4,3 | 1,3 | 2,3 | 1,0,8 | 8,6 | 2,6 | 7,7 | 4,4,4 | 4,0,0 | 4,4,6 | 8,4,6 |
| D0033459UHC ASO Custom Plan 42P97 | January 2023 | 2,0,9 | 4,4 | 1,4 | 2,2 | 1,1,0 | 8,8 | 2,8 | 7,5 | 4,5,5 | 3,9,9 | 4,5,6 | 8,5,5 | |
| February 2023 | 2,0,8 | 4,5 | 1,4 | 2,1 | 1,1,1 | 9,0 | 2,8 | 7,2 | 4,5,5 | 3,9,9 | 4,5,4 | 8,5,3 | ||
| March 2023 | 2,1,0 | 4,5 | 1,5 | 2,1 | 1,1,1 | 9,0 | 3,0 | 7,2 | 4,5,5 | 4,0,2 | 4,5,5 | 8,5,7 | ||
| April 2023 | 2,1,0 | 4,5 | 1,6 | 2,1 | 1,1,2 | 9,0 | 3,2 | 7,2 | 4,5,9 | 4,0,4 | 4,5,9 | 8,6,3 | ||
| May 2023 | 2,1,4 | 4,4 | 1,6 | 2,2 | 1,1,2 | 8,8 | 3,2 | 7,7 | 4,5,8 | 4,0,8 | 4,6,1 | 8,6,9 | ||
| June 2023 | 2,1,5 | 4,3 | 1,5 | 2,2 | 1,1,2 | 8,6 | 3,0 | 7,7 | 4,5,8 | 4,0,7 | 4,5,9 | 8,6,6 | ||
| July 2023 | 2,1,4 | 4,2 | 1,7 | 2,1 | 1,1,3 | 8,4 | 3,4 | 7,4 | 4,6,1 | 4,0,7 | 4,6,0 | 8,6,7 | ||
| August 2023 | 2,1,6 | 4,3 | 1,8 | 2,1 | 1,1,1 | 8,6 | 3,6 | 7,4 | 4,5,5 | 4,0,9 | 4,5,8 | 8,6,7 | ||
| September 2023 | 2,1,6 | 4,3 | 1,8 | 2,1 | 1,1,0 | 8,6 | 3,6 | 7,4 | 4,5,2 | 4,0,8 | 4,5,6 | 8,6,4 | ||
| October 2023 | 2,1,1 | 4,3 | 1,7 | 2,1 | 1,1,0 | 8,6 | 3,4 | 7,4 | 4,5,3 | 4,0,2 | 4,5,6 | 8,5,8 | ||
| November 2023 | 2,1,2 | 4,3 | 1,7 | 2,2 | 1,1,0 | 8,6 | 3,4 | 7,7 | 4,5,3 | 4,0,4 | 4,5,8 | 8,6,2 | ||
| December 2023 | 2,1,8 | 4,4 | 2,1 | 2,1 | 1,1,0 | 8,8 | 4,2 | 7,4 | 4,5,1 | 4,1,4 | 4,5,9 | 8,7,3 | ||
| January 2024 | 1,8,7 | 3,6 | 2,1 | 1,7 | 8,7 | 7,2 | 4,2 | 6,0 | 3,5,5 | 3,4,8 | 3,6,8 | 7,1,6 | ||
| February 2024 | 1,8,1 | 3,3 | 2,1 | 1,5 | 9,0 | 6,6 | 4,2 | 5,1 | 3,6,5 | 3,4,0 | 3,6,5 | 7,0,5 | ||
| March 2024 | 1,8,0 | 3,3 | 2,1 | 1,5 | 8,9 | 6,6 | 4,2 | 5,1 | 3,6,3 | 3,3,8 | 3,6,4 | 7,0,2 | ||
| April 2024 | 1,7,9 | 3,3 | 2,2 | 1,5 | 8,7 | 6,6 | 4,4 | 5,1 | 3,5,5 | 3,3,6 | 3,5,9 | 6,9,5 | ||
| May 2024 | 1,8,0 | 3,0 | 2,2 | 1,5 | 8,5 | 6,0 | 4,4 | 5,1 | 3,4,7 | 3,3,2 | 3,5,0 | 6,8,2 | ||
| June 2024 | 1,7,6 | 3,0 | 2,2 | 1,5 | 8,6 | 6,0 | 4,4 | 5,1 | 3,5,0 | 3,2,9 | 3,5,2 | 6,8,1 | ||
| July 2024 | 1,7,4 | 3,0 | 2,2 | 1,5 | 8,5 | 6,0 | 4,4 | 5,1 | 3,4,7 | 3,2,6 | 3,5,0 | 6,7,6 | ||
| August 2024 | 1,7,1 | 3,1 | 2,2 | 1,5 | 8,5 | 6,2 | 4,4 | 5,1 | 3,4,8 | 3,2,4 | 3,5,2 | 6,7,6 | ||
| September 2024 | 1,7,1 | 3,1 | 2,2 | 1,5 | 8,5 | 6,2 | 4,4 | 5,1 | 3,4,9 | 3,2,4 | 3,5,3 | 6,7,7 | ||
| October 2024 | 1,7,1 | 3,1 | 2,2 | 1,5 | 8,5 | 6,2 | 4,4 | 5,1 | 3,4,9 | 3,2,4 | 3,5,3 | 6,7,7 | ||
| November 2024 | 1,7,0 | 3,0 | 2,1 | 1,5 | 8,5 | 6,0 | 4,2 | 5,1 | 3,4,8 | 3,2,1 | 3,5,0 | 6,7,1 | ||
| December 2024 | 1,6,8 | 3,0 | 2,1 | 1,4 | 8,6 | 6,0 | 4,2 | 4,8 | 3,5,1 | 3,1,9 | 3,5,0 | 6,6,9 | ||
| January 2025 | 1,3,9 | 2,7 | 1,9 | 1,1 | 9,1 | 5,4 | 3,8 | 3,7 | 3,6,7 | 2,8,7 | 3,4,8 | 6,3,5 | ||
| February 2025 | 1,4,1 | 2,8 | 1,9 | 1,1 | 8,9 | 5,6 | 3,8 | 3,7 | 3,5,6 | 2,8,8 | 3,4,0 | 6,2,8 | ||
| March 2025 | 1,4,0 | 2,8 | 1,9 | 1,0 | 9,1 | 5,6 | 3,8 | 3,4 | 3,6,3 | 2,8,8 | 3,4,3 | 6,3,1 | ||
| April 2025 | 1,3,7 | 2,9 | 1,9 | 1,0 | 9,1 | 5,8 | 3,8 | 3,4 | 3,6,3 | 2,8,6 | 3,4,4 | 6,3,0 | ||
| May 2025 | 1,3,9 | 2,7 | 1,9 | 1,0 | 9,2 | 5,4 | 3,8 | 3,4 | 3,6,7 | 2,8,7 | 3,4,5 | 6,3,2 | ||
| June 2025 | 1,3,9 | 2,7 | 1,9 | 1,0 | 8,6 | 5,4 | 3,8 | 3,4 | 3,4,2 | 2,8,1 | 3,2,6 | 6,0,7 | ||
| July 2025 | 1,4,0 | 2,5 | 1,8 | 1,0 | 8,7 | 5,0 | 3,6 | 3,4 | 3,4,5 | 2,8,0 | 3,2,5 | 6,0,5 | ||
| August 2025 | 1,4,0 | 2,5 | 1,7 | 1,0 | 8,7 | 5,0 | 3,4 | 3,4 | 3,4,5 | 2,7,9 | 3,2,4 | 6,0,3 | ||
| September 2025 | 1,4,2 | 2,6 | 1,6 | 1,0 | 8,5 | 5,2 | 3,2 | 3,4 | 3,3,9 | 2,7,9 | 3,2,0 | 5,9,9 | ||
| October 2025 | 1,4,2 | 2,7 | 1,6 | 1,0 | 8,7 | 5,4 | 3,2 | 3,4 | 3,5,1 | 2,8,2 | 3,3,1 | 6,1,3 | ||
| November 2025 | 1,4,2 | 2,6 | 1,7 | 1,0 | 8,4 | 5,2 | 3,4 | 3,4 | 3,3,9 | 2,7,9 | 3,2,2 | 6,0,1 | ||
| D0036125UHC ASO Custom Plan 58P83 | January 2024 | 2,8 | 1,1 | 2 | 6 | 2,4 | 2,2 | 4 | 2,4 | 9,6 | 7,1 | 1,0,3 | 1,7,4 | |
| February 2024 | 2,8 | 9 | 2 | 6 | 2,7 | 1,8 | 4 | 2,4 | 1,0,3 | 7,2 | 1,0,5 | 1,7,7 | ||
| March 2024 | 3,1 | 9 | 2 | 5 | 3,1 | 1,8 | 4 | 1,9 | 1,2,2 | 7,8 | 1,1,6 | 1,9,4 | ||
| April 2024 | 3,2 | 1,0 | 2 | 5 | 3,1 | 2,0 | 4 | 1,9 | 1,2,3 | 8,0 | 1,1,8 | 1,9,8 | ||
| May 2024 | 3,4 | 1,1 | 2 | 5 | 3,1 | 2,2 | 4 | 1,9 | 1,2,3 | 8,3 | 1,1,9 | 2,0,2 | ||
| June 2024 | 3,5 | 1,1 | 2 | 5 | 2,9 | 2,2 | 4 | 1,9 | 1,1,5 | 8,2 | 1,1,3 | 1,9,5 | ||
| July 2024 | 3,7 | 1,0 | 2 | 5 | 2,9 | 2,0 | 4 | 1,9 | 1,1,5 | 8,3 | 1,1,2 | 1,9,5 | ||
| August 2024 | 3,8 | 1,0 | 2 | 5 | 3,0 | 2,0 | 4 | 1,9 | 1,1,9 | 8,5 | 1,1,5 | 2,0,0 | ||
| September 2024 | 3,7 | 1,0 | 2 | 5 | 3,0 | 2,0 | 4 | 1,9 | 1,1,9 | 8,4 | 1,1,5 | 1,9,9 | ||
| October 2024 | 3,7 | 1,0 | 2 | 5 | 3,0 | 2,0 | 4 | 1,9 | 1,1,9 | 8,4 | 1,1,5 | 1,9,9 | ||
| November 2024 | 3,9 | 1,0 | 2 | 6 | 3,0 | 2,0 | 4 | 2,3 | 1,1,9 | 8,7 | 1,1,8 | 2,0,5 | ||
| December 2024 | 3,8 | 1,0 | 3 | 6 | 3,0 | 2,0 | 6 | 2,3 | 1,1,9 | 8,7 | 1,1,9 | 2,0,6 | ||
| January 2025 | 5,6 | 1,5 | 4 | 1,2 | 3,7 | 3,0 | 8 | 4,5 | 1,5,2 | 1,2,4 | 1,6,7 | 2,9,1 | ||
| February 2025 | 5,6 | 1,5 | 4 | 1,2 | 3,6 | 3,0 | 8 | 4,5 | 1,4,8 | 1,2,3 | 1,6,4 | 2,8,7 | ||
| March 2025 | 5,8 | 1,5 | 5 | 1,2 | 3,5 | 3,0 | 1,0 | 4,5 | 1,4,4 | 1,2,5 | 1,6,2 | 2,8,7 | ||
| April 2025 | 5,9 | 1,5 | 5 | 1,3 | 3,7 | 3,0 | 1,0 | 4,9 | 1,5,2 | 1,2,9 | 1,7,1 | 3,0,0 | ||
| May 2025 | 5,8 | 1,5 | 5 | 1,3 | 3,8 | 3,0 | 1,0 | 4,9 | 1,5,5 | 1,2,9 | 1,7,3 | 3,0,2 | ||
| June 2025 | 5,6 | 1,6 | 5 | 1,3 | 3,8 | 3,2 | 1,0 | 4,9 | 1,5,4 | 1,2,8 | 1,7,3 | 3,0,1 | ||
| July 2025 | 5,8 | 1,6 | 5 | 1,5 | 3,8 | 3,2 | 1,0 | 5,6 | 1,5,4 | 1,3,2 | 1,7,8 | 3,1,0 | ||
| August 2025 | 5,8 | 1,6 | 5 | 1,5 | 3,6 | 3,2 | 1,0 | 5,4 | 1,4,7 | 1,3,0 | 1,7,1 | 3,0,1 | ||
| September 2025 | 5,7 | 1,6 | 4 | 1,7 | 3,5 | 3,2 | 8 | 6,1 | 1,4,2 | 1,2,9 | 1,7,1 | 3,0,0 | ||
| October 2025 | 5,7 | 1,6 | 4 | 1,7 | 3,6 | 3,2 | 8 | 6,1 | 1,4,8 | 1,3,0 | 1,7,6 | 3,0,6 | ||
| November 2025 | 5,7 | 1,6 | 4 | 1,7 | 3,3 | 3,2 | 8 | 6,1 | 1,3,8 | 1,2,7 | 1,6,9 | 2,9,6 | ||
| Product Total | 7,4,5,9 | 1,5,3,2 | 7,4,3 | 7,9,2 | 4,1,9,6 | 3,0,6,4 | 1,4,8,6 | 2,7,8,8 | 1,7,0,3,9 | 1,4,7,2,2 | 1,7,1,1,4 | 3,1,8,3,6 |
&"Arial,Regular"&10 ODSCR-08B &"Arial,Regular"&10 Run Date Time: 12/8/2025 image3.jpg image4.jpg
File details come from the government source that posted it. Updated .