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

File Type Posted
20-V2 - City of Burleson 906435 - OVMCR-01A - Vision Experience FI - Service 24Mo thru 2025-11.xlsx XLSX spreadsheet
9-D9 - CITY OF BURLESON ASO dental renewal.pdf PDF
17-01 - RFP 2026-015 Dental Vision Insurance Benefits.pdf PDF
22-V7 - CITY OF BURLESON VISION BENEFIT SUMMARY VH652 01.01.26.pdf PDF
4-03 - Form 1295 Certificate of Interested Parties.pdf PDF
6-D6 - City of Burleson 906435 - ODSCR-02B - Dental Experience ASO - Service CurMo thru 2025-12.pdf PDF
16-07 - Census Request Document.pdf PDF
23-V5 - City of Burleson 906435 - OVMCR-20B - Vision Membership by Tier Product - Membership 36Mo thru 2025-11.xlsx XLSX spreadsheet
8-D8 - City of Burleson 906435 - ODSCR-08B - Dental Membership by Tier Product - Membership CurMo thru 2025-12.pdf PDF
3-02 - Conflict of Interest Questionnaire.pdf PDF
18-V3 - City of Burleson 906435 - OVMCR-15A - Vision Dashboard - Service 24Mo thru 2025-11.xlsx XLSX spreadsheet
14-D2 - 906435- DENTAL PPO BUY UP PLAN.PDF PDF
21-V6 - CITY OF BURLESON sold vision renewal 09112024 jmw.pdf PDF
26-V9 - Vision RFP Questionnaire.xlsx XLSX spreadsheet
13-D1 - 2026 City of Burleson Guide.pdf PDF
24-V8 - Vision COC COB.pdf PDF
1-05 - Offeror Acknowledgment.pdf PDF
2-04 - W9 Form.pdf PDF
10-D10 - City of Burleson 906435 - ODSCR-01A - Dental Dashboard - Service 24Mo thru 2025-11.xlsx XLSX spreadsheet
11-D5 - City of Burleson 906435 - ODSCR-02B - Dental Experience ASO - Service 36Mo thru 2025-11.xlsx XLSX spreadsheet
19-V4 - City of Burleson 906435 - OVMCR-20A - Vision Membership by Tier - Membership YTD thru 2025-12.pdf PDF
5-06 - RFP 2026-015 Bid Opening Link.pdf PDF
12-D3 - 906435- PASSIVE DENTAL PPO.PDF PDF
15-D4 - City of Burleson - Dental RFP Questionnaire.xlsx XLSX spreadsheet
25-V1 - 2025-26 City of Burleson Guide.pdf PDF
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/202512/1/2022 to 11/1/2025
Group Renewal Month Day: 01/01
Group ID: 10199741019974
Group Policy Number: 0906435
Business Category: -1PPO

Product: -1 Product: -1

Incurred DateSubscribers Count by TierMembers Count by TierTotal
Subscriber Onlyw/ Spousew/ Childw/ Childrenw/ Familyw/ Spousew/ Childw/ Childrenw/ FamilySubscribersDependentsMembers
1019974 CITY OF BURLESOND0016691UHC ASO Custom Plan 2P533December 20222,1,34,31,32,31,0,88,62,67,74,4,44,0,04,4,68,4,6
D0033459UHC ASO Custom Plan 42P97January 20232,0,94,41,42,21,1,08,82,87,54,5,53,9,94,5,68,5,5
February 20232,0,84,51,42,11,1,19,02,87,24,5,53,9,94,5,48,5,3
March 20232,1,04,51,52,11,1,19,03,07,24,5,54,0,24,5,58,5,7
April 20232,1,04,51,62,11,1,29,03,27,24,5,94,0,44,5,98,6,3
May 20232,1,44,41,62,21,1,28,83,27,74,5,84,0,84,6,18,6,9
June 20232,1,54,31,52,21,1,28,63,07,74,5,84,0,74,5,98,6,6
July 20232,1,44,21,72,11,1,38,43,47,44,6,14,0,74,6,08,6,7
August 20232,1,64,31,82,11,1,18,63,67,44,5,54,0,94,5,88,6,7
September 20232,1,64,31,82,11,1,08,63,67,44,5,24,0,84,5,68,6,4
October 20232,1,14,31,72,11,1,08,63,47,44,5,34,0,24,5,68,5,8
November 20232,1,24,31,72,21,1,08,63,47,74,5,34,0,44,5,88,6,2
December 20232,1,84,42,12,11,1,08,84,27,44,5,14,1,44,5,98,7,3
January 20241,8,73,62,11,78,77,24,26,03,5,53,4,83,6,87,1,6
February 20241,8,13,32,11,59,06,64,25,13,6,53,4,03,6,57,0,5
March 20241,8,03,32,11,58,96,64,25,13,6,33,3,83,6,47,0,2
April 20241,7,93,32,21,58,76,64,45,13,5,53,3,63,5,96,9,5
May 20241,8,03,02,21,58,56,04,45,13,4,73,3,23,5,06,8,2
June 20241,7,63,02,21,58,66,04,45,13,5,03,2,93,5,26,8,1
July 20241,7,43,02,21,58,56,04,45,13,4,73,2,63,5,06,7,6
August 20241,7,13,12,21,58,56,24,45,13,4,83,2,43,5,26,7,6
September 20241,7,13,12,21,58,56,24,45,13,4,93,2,43,5,36,7,7
October 20241,7,13,12,21,58,56,24,45,13,4,93,2,43,5,36,7,7
November 20241,7,03,02,11,58,56,04,25,13,4,83,2,13,5,06,7,1
December 20241,6,83,02,11,48,66,04,24,83,5,13,1,93,5,06,6,9
January 20251,3,92,71,91,19,15,43,83,73,6,72,8,73,4,86,3,5
February 20251,4,12,81,91,18,95,63,83,73,5,62,8,83,4,06,2,8
March 20251,4,02,81,91,09,15,63,83,43,6,32,8,83,4,36,3,1
April 20251,3,72,91,91,09,15,83,83,43,6,32,8,63,4,46,3,0
May 20251,3,92,71,91,09,25,43,83,43,6,72,8,73,4,56,3,2
June 20251,3,92,71,91,08,65,43,83,43,4,22,8,13,2,66,0,7
July 20251,4,02,51,81,08,75,03,63,43,4,52,8,03,2,56,0,5
August 20251,4,02,51,71,08,75,03,43,43,4,52,7,93,2,46,0,3
September 20251,4,22,61,61,08,55,23,23,43,3,92,7,93,2,05,9,9
October 20251,4,22,71,61,08,75,43,23,43,5,12,8,23,3,16,1,3
November 20251,4,22,61,71,08,45,23,43,43,3,92,7,93,2,26,0,1
D0036125UHC ASO Custom Plan 58P83January 20242,81,1262,42,242,49,67,11,0,31,7,4
February 20242,89262,71,842,41,0,37,21,0,51,7,7
March 20243,19253,11,841,91,2,27,81,1,61,9,4
April 20243,21,0253,12,041,91,2,38,01,1,81,9,8
May 20243,41,1253,12,241,91,2,38,31,1,92,0,2
June 20243,51,1252,92,241,91,1,58,21,1,31,9,5
July 20243,71,0252,92,041,91,1,58,31,1,21,9,5
August 20243,81,0253,02,041,91,1,98,51,1,52,0,0
September 20243,71,0253,02,041,91,1,98,41,1,51,9,9
October 20243,71,0253,02,041,91,1,98,41,1,51,9,9
November 20243,91,0263,02,042,31,1,98,71,1,82,0,5
December 20243,81,0363,02,062,31,1,98,71,1,92,0,6
January 20255,61,541,23,73,084,51,5,21,2,41,6,72,9,1
February 20255,61,541,23,63,084,51,4,81,2,31,6,42,8,7
March 20255,81,551,23,53,01,04,51,4,41,2,51,6,22,8,7
April 20255,91,551,33,73,01,04,91,5,21,2,91,7,13,0,0
May 20255,81,551,33,83,01,04,91,5,51,2,91,7,33,0,2
June 20255,61,651,33,83,21,04,91,5,41,2,81,7,33,0,1
July 20255,81,651,53,83,21,05,61,5,41,3,21,7,83,1,0
August 20255,81,651,53,63,21,05,41,4,71,3,01,7,13,0,1
September 20255,71,641,73,53,286,11,4,21,2,91,7,13,0,0
October 20255,71,641,73,63,286,11,4,81,3,01,7,63,0,6
November 20255,71,641,73,33,286,11,3,81,2,71,6,92,9,6
Product Total7,4,5,91,5,3,27,4,37,9,24,1,9,63,0,6,41,4,8,62,7,8,81,7,0,3,91,4,7,2,21,7,1,1,43,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 .