21-Membership Managed Ad Hoc 1224.xlsx
XLSX spreadsheet 12 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 membership data for Policy Number 000902915 across different subscriber tiers from January 2024 to December 2024. The report breaks down membership statistics for two categories (AC and AF) across four subscriber types: Subscriber Only, Subscriber + Spouse, Subscriber + Child or Children, and Subscriber + Family, tracking subscriber and dependent months for each period.
The data reveals total membership of 48,003 subscriber months and 36,662 dependent months across the year, with consistent patterns of enrollment. Notably, the document contains confidential and proprietary business information, emphasizing the sensitive nature of the membership data. The report is directly related to a stop loss insurance solicitation by Fort Bend Independent School District in Texas, suggesting this membership data may be relevant to the district's insurance procurement process.
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
Membership Managed Ad Hoc
| Membership Managed Ad Hoc | ||||
| Report Filter: | ||||
| ({Membership Year/Month} = 2024-12, 2024-11, 2024-10, 2024-09, 2024-08, 2024-07, 2024-06, 2024-05, 2024-04, 2024-03, 2024-02, 2024-01) And ({-Policy Number} = 000902915) And ({Type of Coverage} = Medical) | ||||
| Suffix | Membership Year/Month | Membership Tier 4 | Subscriber Months | Positively Enrolled Dependent Months |
| AC | 2024-12 | Subscriber Only | 1,599 | 0 |
| AC | 2024-12 | Subscriber + Spouse | 113 | 113 |
| AC | 2024-12 | Subscriber + Child or Children | 388 | 685 |
| AC | 2024-12 | Subscriber + Family | 211 | 653 |
| AC | 2024-11 | Subscriber Only | 1,600 | 0 |
| AC | 2024-11 | Subscriber + Spouse | 112 | 112 |
| AC | 2024-11 | Subscriber + Child or Children | 386 | 682 |
| AC | 2024-11 | Subscriber + Family | 212 | 655 |
| AC | 2024-10 | Subscriber Only | 1,598 | 0 |
| AC | 2024-10 | Subscriber + Spouse | 109 | 109 |
| AC | 2024-10 | Subscriber + Child or Children | 388 | 680 |
| AC | 2024-10 | Subscriber + Family | 214 | 661 |
| AC | 2024-09 | Subscriber Only | 1,592 | 0 |
| AC | 2024-09 | Subscriber + Spouse | 109 | 109 |
| AC | 2024-09 | Subscriber + Child or Children | 384 | 677 |
| AC | 2024-09 | Subscriber + Family | 214 | 666 |
| AC | 2024-08 | Subscriber Only | 1,564 | 0 |
| AC | 2024-08 | Subscriber + Spouse | 103 | 103 |
| AC | 2024-08 | Subscriber + Child or Children | 377 | 665 |
| AC | 2024-08 | Subscriber + Family | 216 | 671 |
| AC | 2024-07 | Subscriber Only | 1,506 | 0 |
| AC | 2024-07 | Subscriber + Spouse | 97 | 97 |
| AC | 2024-07 | Subscriber + Child or Children | 357 | 635 |
| AC | 2024-07 | Subscriber + Family | 211 | 661 |
| AC | 2024-06 | Subscriber Only | 1,550 | 0 |
| AC | 2024-06 | Subscriber + Spouse | 99 | 99 |
| AC | 2024-06 | Subscriber + Child or Children | 365 | 651 |
| AC | 2024-06 | Subscriber + Family | 216 | 681 |
| AC | 2024-05 | Subscriber Only | 1,554 | 0 |
| AC | 2024-05 | Subscriber + Spouse | 101 | 101 |
| AC | 2024-05 | Subscriber + Child or Children | 362 | 643 |
| AC | 2024-05 | Subscriber + Family | 216 | 680 |
| AC | 2024-04 | Subscriber Only | 1,559 | 0 |
| AC | 2024-04 | Subscriber + Spouse | 100 | 100 |
| AC | 2024-04 | Subscriber + Child or Children | 358 | 637 |
| AC | 2024-04 | Subscriber + Family | 217 | 682 |
| AC | 2024-03 | Subscriber Only | 1,561 | 0 |
| AC | 2024-03 | Subscriber + Spouse | 101 | 101 |
| AC | 2024-03 | Subscriber + Child or Children | 359 | 640 |
| AC | 2024-03 | Subscriber + Family | 214 | 673 |
| AC | 2024-02 | Subscriber Only | 1,556 | 0 |
| AC | 2024-02 | Subscriber + Spouse | 101 | 101 |
| AC | 2024-02 | Subscriber + Child or Children | 359 | 636 |
| AC | 2024-02 | Subscriber + Family | 212 | 670 |
| AC | 2024-01 | Subscriber Only | 1,562 | 0 |
| AC | 2024-01 | Subscriber + Spouse | 101 | 101 |
| AC | 2024-01 | Subscriber + Child or Children | 359 | 634 |
| AC | 2024-01 | Subscriber + Family | 215 | 683 |
| AF | 2024-12 | Subscriber Only | 1,028 | 0 |
| AF | 2024-12 | Subscriber + Spouse | 72 | 72 |
| AF | 2024-12 | Subscriber + Child or Children | 392 | 700 |
| AF | 2024-12 | Subscriber + Family | 272 | 850 |
| AF | 2024-11 | Subscriber Only | 1,030 | 0 |
| AF | 2024-11 | Subscriber + Spouse | 72 | 72 |
| AF | 2024-11 | Subscriber + Child or Children | 393 | 702 |
| AF | 2024-11 | Subscriber + Family | 274 | 857 |
| AF | 2024-10 | Subscriber Only | 1,022 | 0 |
| AF | 2024-10 | Subscriber + Spouse | 72 | 72 |
| AF | 2024-10 | Subscriber + Child or Children | 397 | 701 |
| AF | 2024-10 | Subscriber + Family | 275 | 858 |
| AF | 2024-09 | Subscriber Only | 1,017 | 0 |
| AF | 2024-09 | Subscriber + Spouse | 71 | 71 |
| AF | 2024-09 | Subscriber + Child or Children | 397 | 707 |
| AF | 2024-09 | Subscriber + Family | 274 | 853 |
| AF | 2024-08 | Subscriber Only | 1,001 | 0 |
| AF | 2024-08 | Subscriber + Spouse | 67 | 67 |
| AF | 2024-08 | Subscriber + Child or Children | 402 | 710 |
| AF | 2024-08 | Subscriber + Family | 274 | 854 |
| AF | 2024-07 | Subscriber Only | 959 | 0 |
| AF | 2024-07 | Subscriber + Spouse | 69 | 69 |
| AF | 2024-07 | Subscriber + Child or Children | 392 | 690 |
| AF | 2024-07 | Subscriber + Family | 274 | 851 |
| AF | 2024-06 | Subscriber Only | 985 | 0 |
| AF | 2024-06 | Subscriber + Spouse | 72 | 72 |
| AF | 2024-06 | Subscriber + Child or Children | 400 | 702 |
| AF | 2024-06 | Subscriber + Family | 277 | 863 |
| AF | 2024-05 | Subscriber Only | 990 | 0 |
| AF | 2024-05 | Subscriber + Spouse | 72 | 72 |
| AF | 2024-05 | Subscriber + Child or Children | 397 | 696 |
| AF | 2024-05 | Subscriber + Family | 276 | 859 |
| AF | 2024-04 | Subscriber Only | 993 | 0 |
| AF | 2024-04 | Subscriber + Spouse | 74 | 74 |
| AF | 2024-04 | Subscriber + Child or Children | 398 | 696 |
| AF | 2024-04 | Subscriber + Family | 278 | 865 |
| AF | 2024-03 | Subscriber Only | 1,001 | 0 |
| AF | 2024-03 | Subscriber + Spouse | 75 | 75 |
| AF | 2024-03 | Subscriber + Child or Children | 397 | 697 |
| AF | 2024-03 | Subscriber + Family | 275 | 858 |
| AF | 2024-02 | Subscriber Only | 1,003 | 0 |
| AF | 2024-02 | Subscriber + Spouse | 76 | 76 |
| AF | 2024-02 | Subscriber + Child or Children | 400 | 697 |
| AF | 2024-02 | Subscriber + Family | 269 | 847 |
| AF | 2024-01 | Subscriber Only | 999 | 0 |
| AF | 2024-01 | Subscriber + Spouse | 77 | 77 |
| AF | 2024-01 | Subscriber + Child or Children | 398 | 692 |
| AF | 2024-01 | Subscriber + Family | 268 | 841 |
| Total | 48,003 | 36,662 | ||
| 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 .