23-V5 - City of Burleson 906435 - OVMCR-20B - Vision Membership by Tier Product - Membership 36Mo thru 2025-11.xlsx
XLSX spreadsheet 97 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 membership enrollment data report for the City of Burleson's Vision Insurance plan (Policy Number 0906435, Client ID 336654) under the OVMCR-20B product tier structure. The report captures subscriber and dependent enrollment counts across six membership tier categories—individual coverage, coverage with spouse, coverage with child, coverage with children, coverage with spouse and child, and coverage with spouse and children—from December 2022 through November 2025. The data reflects the client's effective date of January 1, 2016, with renewal scheduled for January 1, 2027. The three-year reporting period demonstrates membership trends across 36 months, tracking both the number of subscribers and total members (subscribers plus dependents) in each tier category.
The report shows total enrollment across the contract period of 5,769 subscribers with 21,666 dependents, resulting in 27,435 total members. Membership remained relatively stable throughout the period, with subscriber counts ranging from a low of 1,510 in June 2025 to a high of 1,680 in January 2024. The data indicates sustained demand for vision coverage across all tier options, with the highest enrollment concentrations in the "with spouse and children" and "with spouse" categories. This enrollment information serves as the baseline data for tracking utilization and plan performance under the City of Burleson's vision insurance benefits program.
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
OVMCR-20B
Membership Tiers by Product and Month
Selection Parameters Values on Report
| Client Effective Date: 1/1/2016 | ||
| Incurred Date Range: 12/1/2022 to 11/30/2025 | 12/1/2022 to 11/1/2025 | |
| Client Renewal Month Day: 1/1/2027 |
| Client ID: 336654 | |
| Client Policy Number: 0906435 |
Group ID: -1
City of Burleson
| Incurred Date | Subscribers Count by Tier | Members Count by Tier | Total | ||||||||||||
| Subscriber Only | w/ Spouse | w/ Child | w/ Children | w/ Spouse & Child | w/ Spouse & Children | w/ Spouse | w/ Child | w/ Children | w/ Spouse & Child | w/ Spouse & Children | Subscribers | Dependents | Members | ||
| VH652 | December 2022 | 1,5,9 | 3,9 | 1,2 | 1,6 | 2,7 | 6,4 | 7,8 | 2,4 | 5,4 | 8,1 | 2,9,2 | 3,1,7 | 3,7,1 | 6,8,8 |
| January 2023 | 1,5,7 | 4,0 | 1,2 | 1,8 | 2,7 | 7,1 | 8,0 | 2,4 | 6,1 | 8,1 | 3,2,3 | 3,2,5 | 4,0,1 | 7,2,6 | |
| February 2023 | 1,5,7 | 4,1 | 1,2 | 1,7 | 2,8 | 7,1 | 8,2 | 2,4 | 5,8 | 8,4 | 3,2,0 | 3,2,6 | 3,9,9 | 7,2,5 | |
| March 2023 | 1,5,9 | 4,1 | 1,3 | 1,7 | 2,8 | 7,1 | 8,2 | 2,6 | 5,8 | 8,4 | 3,2,0 | 3,2,9 | 4,0,0 | 7,2,9 | |
| April 2023 | 1,6,0 | 4,2 | 1,3 | 1,8 | 2,8 | 7,1 | 8,4 | 2,6 | 6,1 | 8,4 | 3,2,0 | 3,3,2 | 4,0,3 | 7,3,5 | |
| May 2023 | 1,6,4 | 4,0 | 1,3 | 1,9 | 2,8 | 7,2 | 8,0 | 2,6 | 6,6 | 8,4 | 3,2,5 | 3,3,6 | 4,0,9 | 7,4,5 | |
| June 2023 | 1,6,5 | 4,1 | 1,2 | 1,9 | 2,9 | 7,1 | 8,2 | 2,4 | 6,6 | 8,7 | 3,2,2 | 3,3,7 | 4,0,9 | 7,4,6 | |
| July 2023 | 1,6,5 | 4,0 | 1,3 | 1,8 | 3,0 | 7,1 | 8,0 | 2,6 | 6,3 | 9,0 | 3,2,2 | 3,3,7 | 4,0,9 | 7,4,6 | |
| August 2023 | 1,6,4 | 4,1 | 1,4 | 1,8 | 2,8 | 7,2 | 8,2 | 2,8 | 6,3 | 8,4 | 3,2,6 | 3,3,7 | 4,1,0 | 7,4,7 | |
| September 2023 | 1,6,4 | 4,1 | 1,4 | 1,8 | 2,7 | 7,2 | 8,2 | 2,8 | 6,3 | 8,1 | 3,2,6 | 3,3,6 | 4,0,8 | 7,4,4 | |
| October 2023 | 1,6,1 | 4,1 | 1,2 | 1,8 | 2,8 | 7,2 | 8,2 | 2,4 | 6,3 | 8,4 | 3,2,6 | 3,3,2 | 4,0,8 | 7,4,0 | |
| November 2023 | 1,6,1 | 4,0 | 1,3 | 1,8 | 2,8 | 7,2 | 8,0 | 2,6 | 6,3 | 8,4 | 3,2,6 | 3,3,2 | 4,0,8 | 7,4,0 | |
| December 2023 | 1,6,6 | 4,1 | 1,6 | 1,8 | 2,7 | 7,2 | 8,2 | 3,2 | 6,3 | 8,1 | 3,2,4 | 3,4,0 | 4,0,8 | 7,4,8 | |
| January 2024 | 1,6,8 | 3,8 | 1,8 | 1,9 | 3,5 | 7,1 | 7,6 | 3,6 | 6,8 | 1,0,5 | 3,1,9 | 3,4,9 | 4,2,3 | 7,7,2 | |
| February 2024 | 1,6,4 | 3,5 | 1,8 | 1,7 | 3,9 | 7,2 | 7,0 | 3,6 | 6,2 | 1,1,7 | 3,2,3 | 3,4,5 | 4,2,7 | 7,7,2 | |
| March 2024 | 1,6,3 | 3,5 | 1,8 | 1,6 | 3,8 | 7,6 | 7,0 | 3,6 | 5,7 | 1,1,4 | 3,4,3 | 3,4,6 | 4,3,7 | 7,8,3 | |
| April 2024 | 1,6,6 | 3,4 | 1,9 | 1,6 | 3,6 | 7,5 | 6,8 | 3,8 | 5,7 | 1,0,8 | 3,3,9 | 3,4,6 | 4,3,0 | 7,7,6 | |
| May 2024 | 1,6,8 | 3,2 | 1,9 | 1,6 | 3,6 | 7,3 | 6,4 | 3,8 | 5,7 | 1,0,8 | 3,3,1 | 3,4,4 | 4,2,2 | 7,6,6 | |
| June 2024 | 1,6,6 | 3,2 | 1,9 | 1,6 | 3,7 | 7,1 | 6,4 | 3,8 | 5,7 | 1,1,1 | 3,2,3 | 3,4,1 | 4,1,8 | 7,5,9 | |
| July 2024 | 1,6,7 | 3,2 | 1,9 | 1,6 | 3,6 | 7,1 | 6,4 | 3,8 | 5,7 | 1,0,8 | 3,2,3 | 3,4,1 | 4,1,6 | 7,5,7 | |
| August 2024 | 1,6,5 | 3,3 | 2,0 | 1,6 | 3,6 | 7,2 | 6,6 | 4,0 | 5,7 | 1,0,8 | 3,2,8 | 3,4,2 | 4,2,2 | 7,6,4 | |
| September 2024 | 1,6,0 | 3,2 | 2,0 | 1,6 | 3,5 | 7,3 | 6,4 | 4,0 | 5,7 | 1,0,5 | 3,3,2 | 3,3,6 | 4,2,2 | 7,5,8 | |
| October 2024 | 1,5,9 | 3,2 | 2,0 | 1,6 | 3,5 | 7,3 | 6,4 | 4,0 | 5,7 | 1,0,5 | 3,3,2 | 3,3,5 | 4,2,2 | 7,5,7 | |
| November 2024 | 1,6,4 | 3,1 | 2,0 | 1,7 | 3,6 | 7,3 | 6,2 | 4,0 | 6,1 | 1,0,8 | 3,3,2 | 3,4,1 | 4,2,6 | 7,6,7 | |
| December 2024 | 1,6,2 | 3,1 | 2,0 | 1,6 | 3,7 | 7,3 | 6,2 | 4,0 | 5,8 | 1,1,1 | 3,3,2 | 3,3,9 | 4,2,6 | 7,6,5 | |
| January 2025 | 1,5,5 | 3,3 | 1,8 | 1,7 | 4,1 | 7,7 | 6,6 | 3,6 | 6,2 | 1,2,3 | 3,5,4 | 3,4,1 | 4,5,5 | 7,9,6 | |
| February 2025 | 1,5,7 | 3,2 | 1,8 | 1,7 | 4,2 | 7,5 | 6,4 | 3,6 | 6,2 | 1,2,6 | 3,4,2 | 3,4,1 | 4,4,6 | 7,8,7 | |
| March 2025 | 1,5,8 | 3,2 | 1,9 | 1,6 | 4,4 | 7,4 | 6,4 | 3,8 | 5,9 | 1,3,2 | 3,3,9 | 3,4,3 | 4,4,7 | 7,9,0 | |
| April 2025 | 1,5,6 | 3,2 | 1,9 | 1,7 | 4,5 | 7,6 | 6,4 | 3,8 | 6,3 | 1,3,5 | 3,4,7 | 3,4,5 | 4,5,8 | 8,0,3 | |
| May 2025 | 1,5,5 | 3,1 | 1,9 | 1,7 | 4,6 | 7,7 | 6,2 | 3,8 | 6,3 | 1,3,8 | 3,5,1 | 3,4,5 | 4,6,2 | 8,0,7 | |
| June 2025 | 1,5,1 | 3,2 | 1,9 | 1,7 | 4,5 | 7,2 | 6,4 | 3,8 | 6,3 | 1,3,5 | 3,2,8 | 3,3,6 | 4,4,3 | 7,7,9 | |
| July 2025 | 1,5,4 | 3,3 | 1,8 | 1,9 | 4,3 | 7,3 | 6,6 | 3,6 | 7,0 | 1,2,9 | 3,3,2 | 3,4,0 | 4,4,7 | 7,8,7 | |
| August 2025 | 1,5,3 | 3,4 | 1,7 | 1,9 | 4,2 | 7,2 | 6,8 | 3,4 | 6,8 | 1,2,6 | 3,2,8 | 3,3,7 | 4,4,0 | 7,7,7 | |
| September 2025 | 1,5,2 | 3,5 | 1,7 | 2,1 | 4,0 | 7,1 | 7,0 | 3,4 | 7,5 | 1,2,0 | 3,2,3 | 3,3,6 | 4,3,8 | 7,7,4 | |
| October 2025 | 1,5,2 | 3,6 | 1,7 | 2,1 | 3,9 | 7,6 | 7,2 | 3,4 | 7,5 | 1,1,7 | 3,5,0 | 3,4,1 | 4,5,9 | 8,0,0 | |
| November 2025 | 1,5,2 | 3,6 | 1,8 | 2,1 | 3,7 | 7,2 | 7,2 | 3,6 | 7,5 | 1,1,1 | 3,3,4 | 3,3,6 | 4,4,4 | 7,8,0 | |
| Total | 5,7,6,9 | 1,2,9,1 | 5,9,8 | 6,3,1 | 1,2,6,3 | 2,6,1,0 | 2,5,8,2 | 1,1,9,6 | 2,2,4,2 | 3,7,8,9 | 1,1,8,5,7 | 1,2,1,6,2 | 1,5,2,7,3 | 2,7,4,3,5 | |
| Report Total | 5,7,6,9 | 1,2,9,1 | 5,9,8 | 6,3,1 | 1,2,6,3 | 2,6,1,0 | 2,5,8,2 | 1,1,9,6 | 2,2,4,2 | 3,7,8,9 | 1,1,8,5,7 | 1,2,1,6,2 | 1,5,2,7,3 | 2,7,4,3,5 |
&"Arial,Regular"&10 OVMCR-20B &"Arial,Regular"&10 Run Date Time: 12/8/2025 image3.jpg image4.jpg
File details come from the government source that posted it. Updated .