19-Membership Managed Ad Hoc 0825.xlsx

XLSX spreadsheet 20 KB Posted Sep 25, 2025

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

About this file

Written by GovTribe AI · Sep 25, 2025

This document is a UnitedHealthcare membership managed ad hoc report for Fort Bend Independent School District covering medical insurance membership data for the months of January through August 2025. The report provides detailed membership metrics across different coverage tiers, including Subscriber Only, Subscriber + Spouse, Subscriber + Child or Children, and Subscriber + Family categories. The data is organized by membership months and includes subscriber and dependent month counts for two specific plan options (AC and AF) associated with the district's member group contract ID 902915.

The membership data reveals consistent enrollment patterns throughout the tracked period, with total subscriber months of 30,405 and dependent months of 22,888. The majority of enrollments are in the Subscriber Only and Subscriber + Child or Children tiers, with variations between 1,450 to 1,550 subscriber-only memberships and approximately 360-370 subscriber + child memberships each month. The report is marked as confidential and contains proprietary business information, with strict guidelines for handling and protecting the data in accordance with administrative services agreements and privacy regulations.

View the file

Other files

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

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Cover Page

Membership Managed Ad Hoc

September 16, 2025

Customer Name: Fort Bend Independent School District

Member Group ID: 000902915 902915

Originating Member Group Contract ID: 902915

All Filter Details: Report Filter:

{Membership Year/Month}=2025-08, 2025-07, 2025-06, 2025-05, 2025-04, 2025-03, 2025-02, 2025-01 And {Member Group ID}=000902915 - Fort Bend Independent School District And {Type of Coverage}=Medical

Prompt 1: SELECT A MEMBER GROUP ID {Member Group ID}=000902915 - Fort Bend Independent School District Prompt 2: SELECT MEMBERSHIP DATES 2025-08, 2025-07, 2025-06, 2025-05, 2025-04, 2025-03, 2025-02, 2025-01 Prompt 3: SELECT THE METRICS FOR THIS REPORT Subscriber Months, Dependent Months Prompt 4: SELECT THE BENEFIT YOU WANT TO MEASURE Medical Prompt 5: ADD MORE DETAILS TO THIS REPORT Common Member Group Contract ID, Membership Year/Month, Membership Tier 4 Prompt 6: LIMIT THE REPORT'S CUSTOMER STRUCTURE

Prompt 7: LIMIT THE REPORT'S RESULTS

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.

Membership Mngd Ad Hoc - Sum

Membership Managed Ad Hoc
Common Member Group Contract ID	Membership Year/Month	Membership Tier 4	Subscriber Months	Dependent Months
AC	2025-08	Subscriber Only	1,485	1
		Subscriber + Spouse	116	116
		Subscriber + Child or Children	370	637
		Subscriber + Family	213	664
	2025-07	Subscriber Only	1,453	3
		Subscriber + Spouse	110	110
		Subscriber + Child or Children	364	628
		Subscriber + Family	211	658
	2025-06	Subscriber Only	1,515	1
		Subscriber + Spouse	116	116
		Subscriber + Child or Children	369	637
		Subscriber + Family	217	684
	2025-05	Subscriber Only	1,521	1
		Subscriber + Spouse	115	115
		Subscriber + Child or Children	369	638
		Subscriber + Family	218	686
	2025-04	Subscriber Only	1,527	0
		Subscriber + Spouse	116	116
		Subscriber + Child or Children	367	632
		Subscriber + Family	220	689
	2025-03	Subscriber Only	1,533	0
		Subscriber + Spouse	117	117
		Subscriber + Child or Children	364	629
		Subscriber + Family	219	686
	2025-02	Subscriber Only	1,538	1
		Subscriber + Spouse	115	115
		Subscriber + Child or Children	362	624
		Subscriber + Family	218	684
	2025-01	Subscriber Only	1,533	0
		Subscriber + Spouse	113	113
		Subscriber + Child or Children	361	624
		Subscriber + Family	217	685
AF	2025-08	Subscriber Only	929	1
		Subscriber + Spouse	49	49
		Subscriber + Child or Children	344	617
		Subscriber + Family	230	715
	2025-07	Subscriber Only	916	0
		Subscriber + Spouse	48	48
		Subscriber + Child or Children	349	627
		Subscriber + Family	234	726
	2025-06	Subscriber Only	942	0
		Subscriber + Spouse	53	53
		Subscriber + Child or Children	358	643
		Subscriber + Family	240	742
	2025-05	Subscriber Only	951	0
		Subscriber + Spouse	53	53
		Subscriber + Child or Children	357	641
		Subscriber + Family	241	751
	2025-04	Subscriber Only	957	0
		Subscriber + Spouse	54	54
		Subscriber + Child or Children	358	647
		Subscriber + Family	240	749
	2025-03	Subscriber Only	955	0
		Subscriber + Spouse	54	54
		Subscriber + Child or Children	360	651
		Subscriber + Family	240	744
	2025-02	Subscriber Only	950	1
		Subscriber + Spouse	53	53
		Subscriber + Child or Children	363	657
		Subscriber + Family	240	746
	2025-01	Subscriber Only	951	0
		Subscriber + Spouse	53	53
		Subscriber + Child or Children	362	659
		Subscriber + Family	239	744
Total			30,405	22,888

Membership Mngd Ad Hoc - Dtl

Common Member Group ID	Member Group ID	Common Member Group Contract ID	Common Plan Option ID	Common Population ID	Common Plan Option Name	Common Population Name	Customer Attribute 1	Customer Attribute 2	Customer Attribute 3	Customer Attribute 4	Membership Year/Month	Membership Tier 4	Subscriber Months	Dependent Months
902915	000902915	AC	007	0007	0007						2025-08	Subscriber Only	1,485	1
902915	000902915	AC	007	0007	0007						2025-08	Subscriber + Spouse	116	116
902915	000902915	AC	007	0007	0007						2025-08	Subscriber + Child or Children	370	637
902915	000902915	AC	007	0007	0007						2025-08	Subscriber + Family	212	659
902915	000902915	AC	007	0007	0007						2025-07	Subscriber Only	1,453	3
902915	000902915	AC	007	0007	0007						2025-07	Subscriber + Spouse	110	110
902915	000902915	AC	007	0007	0007						2025-07	Subscriber + Child or Children	364	628
902915	000902915	AC	007	0007	0007						2025-07	Subscriber + Family	210	653
902915	000902915	AC	007	0007	0007						2025-06	Subscriber Only	1,515	1
902915	000902915	AC	007	0007	0007						2025-06	Subscriber + Spouse	116	116
902915	000902915	AC	007	0007	0007						2025-06	Subscriber + Child or Children	369	637
902915	000902915	AC	007	0007	0007						2025-06	Subscriber + Family	217	684
902915	000902915	AC	007	0007	0007						2025-05	Subscriber Only	1,521	1
902915	000902915	AC	007	0007	0007						2025-05	Subscriber + Spouse	115	115
902915	000902915	AC	007	0007	0007						2025-05	Subscriber + Child or Children	369	638
902915	000902915	AC	007	0007	0007						2025-05	Subscriber + Family	218	686
902915	000902915	AC	007	0007	0007						2025-04	Subscriber Only	1,527	0
902915	000902915	AC	007	0007	0007						2025-04	Subscriber + Spouse	116	116
902915	000902915	AC	007	0007	0007						2025-04	Subscriber + Child or Children	367	632
902915	000902915	AC	007	0007	0007						2025-04	Subscriber + Family	220	689
902915	000902915	AC	007	0007	0007						2025-03	Subscriber Only	1,533	0
902915	000902915	AC	007	0007	0007						2025-03	Subscriber + Spouse	117	117
902915	000902915	AC	007	0007	0007						2025-03	Subscriber + Child or Children	364	629
902915	000902915	AC	007	0007	0007						2025-03	Subscriber + Family	219	686
902915	000902915	AC	007	0007	0007						2025-02	Subscriber Only	1,538	1
902915	000902915	AC	007	0007	0007						2025-02	Subscriber + Spouse	115	115
902915	000902915	AC	007	0007	0007						2025-02	Subscriber + Child or Children	362	624
902915	000902915	AC	007	0007	0007						2025-02	Subscriber + Family	218	684
902915	000902915	AC	007	0007	0007						2025-01	Subscriber Only	1,533	0
902915	000902915	AC	007	0007	0007						2025-01	Subscriber + Spouse	113	113
902915	000902915	AC	007	0007	0007						2025-01	Subscriber + Child or Children	361	624
902915	000902915	AC	007	0007	0007						2025-01	Subscriber + Family	217	685
902915	000902915	AC	008	0008	0008						2025-08	Subscriber + Family	1	5
902915	000902915	AC	008	0008	0008						2025-07	Subscriber + Family	1	5
902915	000902915	AF	013	0013	0013						2025-08	Subscriber Only	925	1
902915	000902915	AF	013	0013	0013						2025-08	Subscriber + Spouse	49	49
902915	000902915	AF	013	0013	0013						2025-08	Subscriber + Child or Children	343	615
902915	000902915	AF	013	0013	0013						2025-08	Subscriber + Family	228	707
902915	000902915	AF	013	0013	0013						2025-07	Subscriber Only	913	0
902915	000902915	AF	013	0013	0013						2025-07	Subscriber + Spouse	48	48
902915	000902915	AF	013	0013	0013						2025-07	Subscriber + Child or Children	347	624
902915	000902915	AF	013	0013	0013						2025-07	Subscriber + Family	232	718
902915	000902915	AF	013	0013	0013						2025-06	Subscriber Only	940	0
902915	000902915	AF	013	0013	0013						2025-06	Subscriber + Spouse	53	53
902915	000902915	AF	013	0013	0013						2025-06	Subscriber + Child or Children	357	641
902915	000902915	AF	013	0013	0013						2025-06	Subscriber + Family	238	736
902915	000902915	AF	013	0013	0013						2025-05	Subscriber Only	949	0
902915	000902915	AF	013	0013	0013						2025-05	Subscriber + Spouse	53	53
902915	000902915	AF	013	0013	0013						2025-05	Subscriber + Child or Children	356	639
902915	000902915	AF	013	0013	0013						2025-05	Subscriber + Family	239	745
902915	000902915	AF	013	0013	0013						2025-04	Subscriber Only	955	0
902915	000902915	AF	013	0013	0013						2025-04	Subscriber + Spouse	54	54
902915	000902915	AF	013	0013	0013						2025-04	Subscriber + Child or Children	357	645
902915	000902915	AF	013	0013	0013						2025-04	Subscriber + Family	238	743
902915	000902915	AF	013	0013	0013						2025-03	Subscriber Only	953	0
902915	000902915	AF	013	0013	0013						2025-03	Subscriber + Spouse	54	54
902915	000902915	AF	013	0013	0013						2025-03	Subscriber + Child or Children	359	649
902915	000902915	AF	013	0013	0013						2025-03	Subscriber + Family	238	738
902915	000902915	AF	013	0013	0013						2025-02	Subscriber Only	949	1
902915	000902915	AF	013	0013	0013						2025-02	Subscriber + Spouse	53	53
902915	000902915	AF	013	0013	0013						2025-02	Subscriber + Child or Children	361	650
902915	000902915	AF	013	0013	0013						2025-02	Subscriber + Family	239	743
902915	000902915	AF	013	0013	0013						2025-01	Subscriber Only	950	0
902915	000902915	AF	013	0013	0013						2025-01	Subscriber + Spouse	53	53
902915	000902915	AF	013	0013	0013						2025-01	Subscriber + Child or Children	360	652
902915	000902915	AF	013	0013	0013						2025-01	Subscriber + Family	238	741
902915	000902915	AF	014	0014	0014						2025-08	Subscriber Only	4	0
902915	000902915	AF	014	0014	0014						2025-08	Subscriber + Child or Children	1	2
902915	000902915	AF	014	0014	0014						2025-08	Subscriber + Family	2	8
902915	000902915	AF	014	0014	0014						2025-07	Subscriber Only	3	0
902915	000902915	AF	014	0014	0014						2025-07	Subscriber + Child or Children	2	3
902915	000902915	AF	014	0014	0014						2025-07	Subscriber + Family	2	8
902915	000902915	AF	014	0014	0014						2025-06	Subscriber Only	2	0
902915	000902915	AF	014	0014	0014						2025-06	Subscriber + Child or Children	1	2
902915	000902915	AF	014	0014	0014						2025-06	Subscriber + Family	2	6
902915	000902915	AF	014	0014	0014						2025-05	Subscriber Only	2	0
902915	000902915	AF	014	0014	0014						2025-05	Subscriber + Child or Children	1	2
902915	000902915	AF	014	0014	0014						2025-05	Subscriber + Family	2	6
902915	000902915	AF	014	0014	0014						2025-04	Subscriber Only	2	0
902915	000902915	AF	014	0014	0014						2025-04	Subscriber + Child or Children	1	2
902915	000902915	AF	014	0014	0014						2025-04	Subscriber + Family	2	6
902915	000902915	AF	014	0014	0014						2025-03	Subscriber Only	2	0
902915	000902915	AF	014	0014	0014						2025-03	Subscriber + Child or Children	1	2
902915	000902915	AF	014	0014	0014						2025-03	Subscriber + Family	2	6
902915	000902915	AF	014	0014	0014						2025-02	Subscriber Only	1	0
902915	000902915	AF	014	0014	0014						2025-02	Subscriber + Child or Children	2	7
902915	000902915	AF	014	0014	0014						2025-02	Subscriber + Family	1	3
902915	000902915	AF	014	0014	0014						2025-01	Subscriber Only	1	0
902915	000902915	AF	014	0014	0014						2025-01	Subscriber + Child or Children	2	7
902915	000902915	AF	014	0014	0014						2025-01	Subscriber + Family	1	3

File details come from the government source that posted it. Updated Sep 25, 2025.