20-Membership Managed Ad Hoc 1223.xlsx

XLSX spreadsheet 16 KB Posted

Attached to
Stop Loss Insurance
Solicitation number
RFP 26-023KB
Issued by
Fort Bend County, Texas

About this file

The document is a membership managed ad hoc report from UnitedHealthcare, detailing medical insurance coverage enrollment data for a specific policy number (000902915) across various membership tiers from January to December 2023. The report breaks down subscriber and dependent months for different coverage types including Subscriber Only, Subscriber + Spouse, Subscriber + Child or Children, and Subscriber + Family, with data segmented across multiple coverage groups (AC, AE, AF, AG, AI).

The comprehensive membership report reveals total subscriber months of 85,771 and positively enrolled dependent months of 66,081 for the specified policy. The data shows consistent enrollment patterns across different membership tiers, with most groups showing zero subscribers for the "Subscriber Only" category and varying numbers of dependents for other coverage types. The document is marked as confidential and contains proprietary business information, with specific handling instructions to protect the data from unauthorized disclosure or misuse.

View the file

Other files

File Type Posted
25-Fort Bend ISD 2025 Stop Loss RFP 26-023KB Data Exhibits.pdf PDF
6-General Provisions for Purchasing Solicitations and Contracts (3.3.25).pdf PDF
10-PRE-EMPLOYMENT OR PRE-SERVICE AFFIDAVIT FOR EDUCATIONAL ENTITIES.pdf PDF
15-Exhibit 5. Fort Bend ISD Kelsey UHC Charter Plan SBC 2025.pdf PDF
16-Exhibit 6. Fort Bend ISD Choice HSA Plan SBC 2025.pdf PDF
18-Exhibit 8. Fort Bend ISD Kelsey UHC Charter Plan SPD 2025.pdf PDF
22-Payments by Month 0825.xlsx XLSX spreadsheet
23-Payments By Month 1223.xlsx XLSX spreadsheet
24-Payments By Month 1224.xlsx XLSX spreadsheet
8-Vendor Acknowledgement Form.pdf PDF
9-CIQ Forms-Updated 8.14.25.pdf PDF
12-Exhibit 2. Fort Bend ISD Stop Loss Policy.pdf PDF
13-Exhibit 3. Fort Bend ISD Stop Loss Policy Amendment.pdf PDF
17-Exhibit 7. Fort Bend ISD Choice HSA Plan SPD 2025.pdf PDF
2-Suspension and Debarment Certification.pdf PDF
21-Membership Managed Ad Hoc 1224.xlsx XLSX spreadsheet
7-Sample FBISD Agreement for Services FBISD (6.2.25).pdf PDF
1-Insurance Requirements.pdf PDF
11-Exhibit 1. Fort Bend ISD Stop Loss RFP Workbook RFP 26-023KB.xlsx XLSX spreadsheet
14-Exhibit 4. Fort Bend ISD Surest Plan SBC 2025.pdf PDF
19-Membership Managed Ad Hoc 0825.xlsx XLSX spreadsheet
26-RFP 26-023KB Stop Loss Scope of Work.pdf PDF
3-Form 1295 Instructions - How to Complete the Form.pdf PDF
4-EDGAR Certifications (2 CFR Section 200 REQUIRED PROVISIONS).pdf PDF
5-Sample DPA - Data Protection Agreement Addendum (v4.1).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

Membership Managed Ad Hoc

Membership Managed Ad Hoc
Report Filter:
({Membership Year/Month} = 2023-12, 2023-11, 2023-10, 2023-09, 2023-08, 2023-07, 2023-06, 2023-05, 2023-04, 2023-03, 2023-02, 2023-01) And ({-Policy Number} = 000902915) And ({Type of Coverage} = Medical)
SuffixMembership Year/MonthMembership Tier 4Subscriber MonthsPositively Enrolled Dependent Months
AC2023-12Subscriber Only1,2500
AC2023-12Subscriber + Spouse9696
AC2023-12Subscriber + Child or Children308550
AC2023-12Subscriber + Family180584
AC2023-11Subscriber Only1,2520
AC2023-11Subscriber + Spouse9696
AC2023-11Subscriber + Child or Children309551
AC2023-11Subscriber + Family179579
AC2023-10Subscriber Only1,2450
AC2023-10Subscriber + Spouse9393
AC2023-10Subscriber + Child or Children306550
AC2023-10Subscriber + Family178579
AC2023-09Subscriber Only1,2430
AC2023-09Subscriber + Spouse9393
AC2023-09Subscriber + Child or Children309557
AC2023-09Subscriber + Family183597
AC2023-08Subscriber Only1,2710
AC2023-08Subscriber + Spouse9595
AC2023-08Subscriber + Child or Children332596
AC2023-08Subscriber + Family198641
AC2023-07Subscriber Only1,1750
AC2023-07Subscriber + Spouse8888
AC2023-07Subscriber + Child or Children306545
AC2023-07Subscriber + Family192621
AC2023-06Subscriber Only1,1990
AC2023-06Subscriber + Spouse9292
AC2023-06Subscriber + Child or Children313556
AC2023-06Subscriber + Family191618
AC2023-05Subscriber Only1,2020
AC2023-05Subscriber + Spouse9090
AC2023-05Subscriber + Child or Children316559
AC2023-05Subscriber + Family194628
AC2023-04Subscriber Only1,2020
AC2023-04Subscriber + Spouse8989
AC2023-04Subscriber + Child or Children317564
AC2023-04Subscriber + Family194628
AC2023-03Subscriber Only1,2060
AC2023-03Subscriber + Spouse9191
AC2023-03Subscriber + Child or Children310553
AC2023-03Subscriber + Family194628
AC2023-02Subscriber Only1,2060
AC2023-02Subscriber + Spouse9292
AC2023-02Subscriber + Child or Children314556
AC2023-02Subscriber + Family194629
AC2023-01Subscriber Only1,2050
AC2023-01Subscriber + Spouse9696
AC2023-01Subscriber + Child or Children310550
AC2023-01Subscriber + Family196635
AE2023-12Subscriber Only8210
AE2023-12Subscriber + Spouse6565
AE2023-12Subscriber + Child or Children378651
AE2023-12Subscriber + Family248773
AE2023-11Subscriber Only8230
AE2023-11Subscriber + Spouse6666
AE2023-11Subscriber + Child or Children380654
AE2023-11Subscriber + Family247776
AE2023-10Subscriber Only8240
AE2023-10Subscriber + Spouse6666
AE2023-10Subscriber + Child or Children383658
AE2023-10Subscriber + Family248777
AE2023-09Subscriber Only8250
AE2023-09Subscriber + Spouse6767
AE2023-09Subscriber + Child or Children382659
AE2023-09Subscriber + Family249778
AE2023-08Subscriber Only8670
AE2023-08Subscriber + Spouse6868
AE2023-08Subscriber + Child or Children387663
AE2023-08Subscriber + Family256800
AE2023-07Subscriber Only8360
AE2023-07Subscriber + Spouse6868
AE2023-07Subscriber + Child or Children372643
AE2023-07Subscriber + Family254790
AE2023-06Subscriber Only8540
AE2023-06Subscriber + Spouse6969
AE2023-06Subscriber + Child or Children377652
AE2023-06Subscriber + Family257803
AE2023-05Subscriber Only8610
AE2023-05Subscriber + Spouse6868
AE2023-05Subscriber + Child or Children375647
AE2023-05Subscriber + Family259811
AE2023-04Subscriber Only8690
AE2023-04Subscriber + Spouse6969
AE2023-04Subscriber + Child or Children374648
AE2023-04Subscriber + Family259807
AE2023-03Subscriber Only8700
AE2023-03Subscriber + Spouse6969
AE2023-03Subscriber + Child or Children377656
AE2023-03Subscriber + Family261814
AE2023-02Subscriber Only8750
AE2023-02Subscriber + Spouse7070
AE2023-02Subscriber + Child or Children376655
AE2023-02Subscriber + Family262817
AE2023-01Subscriber Only8720
AE2023-01Subscriber + Spouse7171
AE2023-01Subscriber + Child or Children381662
AE2023-01Subscriber + Family265825
AF2023-12Subscriber Only2350
AF2023-12Subscriber + Spouse66
AF2023-12Subscriber + Child or Children2242
AF2023-12Subscriber + Family1137
AF2023-11Subscriber Only2320
AF2023-11Subscriber + Spouse66
AF2023-11Subscriber + Child or Children2242
AF2023-11Subscriber + Family1240
AF2023-10Subscriber Only2260
AF2023-10Subscriber + Spouse55
AF2023-10Subscriber + Child or Children2242
AF2023-10Subscriber + Family1240
AF2023-09Subscriber Only2210
AF2023-09Subscriber + Spouse44
AF2023-09Subscriber + Child or Children2347
AF2023-09Subscriber + Family1136
AF2023-08Subscriber Only2130
AF2023-08Subscriber + Spouse44
AF2023-08Subscriber + Child or Children2041
AF2023-08Subscriber + Family1137
AF2023-07Subscriber Only1770
AF2023-07Subscriber + Spouse33
AF2023-07Subscriber + Child or Children1940
AF2023-07Subscriber + Family930
AF2023-06Subscriber Only1790
AF2023-06Subscriber + Spouse33
AF2023-06Subscriber + Child or Children2041
AF2023-06Subscriber + Family824
AF2023-05Subscriber Only1780
AF2023-05Subscriber + Spouse33
AF2023-05Subscriber + Child or Children2244
AF2023-05Subscriber + Family721
AF2023-04Subscriber Only1810
AF2023-04Subscriber + Spouse33
AF2023-04Subscriber + Child or Children2346
AF2023-04Subscriber + Family619
AF2023-03Subscriber Only1770
AF2023-03Subscriber + Spouse33
AF2023-03Subscriber + Child or Children2346
AF2023-03Subscriber + Family619
AF2023-02Subscriber Only1770
AF2023-02Subscriber + Spouse22
AF2023-02Subscriber + Child or Children2144
AF2023-02Subscriber + Family619
AF2023-01Subscriber Only1740
AF2023-01Subscriber + Spouse22
AF2023-01Subscriber + Child or Children2145
AF2023-01Subscriber + Family413
AG2023-12Subscriber Only1,2220
AG2023-12Subscriber + Spouse9494
AG2023-12Subscriber + Child or Children364628
AG2023-12Subscriber + Family226701
AG2023-11Subscriber Only1,2220
AG2023-11Subscriber + Spouse9494
AG2023-11Subscriber + Child or Children362629
AG2023-11Subscriber + Family228705
AG2023-10Subscriber Only1,2210
AG2023-10Subscriber + Spouse9696
AG2023-10Subscriber + Child or Children363632
AG2023-10Subscriber + Family229708
AG2023-09Subscriber Only1,2150
AG2023-09Subscriber + Spouse9494
AG2023-09Subscriber + Child or Children366638
AG2023-09Subscriber + Family233723
AG2023-08Subscriber Only1,2700
AG2023-08Subscriber + Spouse9797
AG2023-08Subscriber + Child or Children393683
AG2023-08Subscriber + Family257793
AG2023-07Subscriber Only1,2160
AG2023-07Subscriber + Spouse9292
AG2023-07Subscriber + Child or Children379656
AG2023-07Subscriber + Family243751
AG2023-06Subscriber Only1,2220
AG2023-06Subscriber + Spouse9696
AG2023-06Subscriber + Child or Children390672
AG2023-06Subscriber + Family248767
AG2023-05Subscriber Only1,2270
AG2023-05Subscriber + Spouse9696
AG2023-05Subscriber + Child or Children392673
AG2023-05Subscriber + Family249769
AG2023-04Subscriber Only1,2340
AG2023-04Subscriber + Spouse9898
AG2023-04Subscriber + Child or Children388672
AG2023-04Subscriber + Family245756
AG2023-03Subscriber Only1,2390
AG2023-03Subscriber + Spouse9898
AG2023-03Subscriber + Child or Children389677
AG2023-03Subscriber + Family245757
AG2023-02Subscriber Only1,2481
AG2023-02Subscriber + Spouse9898
AG2023-02Subscriber + Child or Children392680
AG2023-02Subscriber + Family246759
AG2023-01Subscriber Only1,2500
AG2023-01Subscriber + Spouse9999
AG2023-01Subscriber + Child or Children391680
AG2023-01Subscriber + Family248765
AI2023-12Subscriber Only9990
AI2023-12Subscriber + Spouse9191
AI2023-12Subscriber + Child or Children273505
AI2023-12Subscriber + Family173518
AI2023-11Subscriber Only1,0040
AI2023-11Subscriber + Spouse8989
AI2023-11Subscriber + Child or Children276511
AI2023-11Subscriber + Family177529
AI2023-10Subscriber Only9990
AI2023-10Subscriber + Spouse8888
AI2023-10Subscriber + Child or Children277510
AI2023-10Subscriber + Family178537
AI2023-09Subscriber Only1,0080
AI2023-09Subscriber + Spouse8686
AI2023-09Subscriber + Child or Children279513
AI2023-09Subscriber + Family176531
AI2023-08Subscriber Only1,0710
AI2023-08Subscriber + Spouse8686
AI2023-08Subscriber + Child or Children292535
AI2023-08Subscriber + Family183547
AI2023-07Subscriber Only1,0470
AI2023-07Subscriber + Spouse8484
AI2023-07Subscriber + Child or Children289530
AI2023-07Subscriber + Family174522
AI2023-06Subscriber Only1,0681
AI2023-06Subscriber + Spouse8383
AI2023-06Subscriber + Child or Children291536
AI2023-06Subscriber + Family178537
AI2023-05Subscriber Only1,0721
AI2023-05Subscriber + Spouse8282
AI2023-05Subscriber + Child or Children290534
AI2023-05Subscriber + Family178535
AI2023-04Subscriber Only1,0690
AI2023-04Subscriber + Spouse8585
AI2023-04Subscriber + Child or Children295540
AI2023-04Subscriber + Family177532
AI2023-03Subscriber Only1,0790
AI2023-03Subscriber + Spouse8383
AI2023-03Subscriber + Child or Children294540
AI2023-03Subscriber + Family177528
AI2023-02Subscriber Only1,0810
AI2023-02Subscriber + Spouse8585
AI2023-02Subscriber + Child or Children294541
AI2023-02Subscriber + Family178530
AI2023-01Subscriber Only1,0780
AI2023-01Subscriber + Spouse8787
AI2023-01Subscriber + Child or Children301552
AI2023-01Subscriber + Family178531
Total85,77166,081
This document contains UnitedHealthcare’s confidential and/or proprietary business information (PBI). PBI may only be used by
the recipient person/entity to which it is addressed. Recipient is liable for using and protecting UnitedHealthcare’s PBI from
further disclosure or misuse, consistent with recipient’s contractual obligations under any applicable administrative services
agreement, group policy contract, non-disclosure agreement or other applicable contract or law, including but not limited to the
U.S. Freedom of Information Act and state freedom of information law exemptions for “trade secrets”. The document may also
contain protected health information (PHI) and must be handled according to applicable state and federal law, including, but not
limited to HIPAA. Recipients who misuse information may be subject to both civil and criminal penalties.

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