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
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) | ||||
| Suffix | Membership Year/Month | Membership Tier 4 | Subscriber Months | Positively Enrolled Dependent Months |
| AC | 2023-12 | Subscriber Only | 1,250 | 0 |
| AC | 2023-12 | Subscriber + Spouse | 96 | 96 |
| AC | 2023-12 | Subscriber + Child or Children | 308 | 550 |
| AC | 2023-12 | Subscriber + Family | 180 | 584 |
| AC | 2023-11 | Subscriber Only | 1,252 | 0 |
| AC | 2023-11 | Subscriber + Spouse | 96 | 96 |
| AC | 2023-11 | Subscriber + Child or Children | 309 | 551 |
| AC | 2023-11 | Subscriber + Family | 179 | 579 |
| AC | 2023-10 | Subscriber Only | 1,245 | 0 |
| AC | 2023-10 | Subscriber + Spouse | 93 | 93 |
| AC | 2023-10 | Subscriber + Child or Children | 306 | 550 |
| AC | 2023-10 | Subscriber + Family | 178 | 579 |
| AC | 2023-09 | Subscriber Only | 1,243 | 0 |
| AC | 2023-09 | Subscriber + Spouse | 93 | 93 |
| AC | 2023-09 | Subscriber + Child or Children | 309 | 557 |
| AC | 2023-09 | Subscriber + Family | 183 | 597 |
| AC | 2023-08 | Subscriber Only | 1,271 | 0 |
| AC | 2023-08 | Subscriber + Spouse | 95 | 95 |
| AC | 2023-08 | Subscriber + Child or Children | 332 | 596 |
| AC | 2023-08 | Subscriber + Family | 198 | 641 |
| AC | 2023-07 | Subscriber Only | 1,175 | 0 |
| AC | 2023-07 | Subscriber + Spouse | 88 | 88 |
| AC | 2023-07 | Subscriber + Child or Children | 306 | 545 |
| AC | 2023-07 | Subscriber + Family | 192 | 621 |
| AC | 2023-06 | Subscriber Only | 1,199 | 0 |
| AC | 2023-06 | Subscriber + Spouse | 92 | 92 |
| AC | 2023-06 | Subscriber + Child or Children | 313 | 556 |
| AC | 2023-06 | Subscriber + Family | 191 | 618 |
| AC | 2023-05 | Subscriber Only | 1,202 | 0 |
| AC | 2023-05 | Subscriber + Spouse | 90 | 90 |
| AC | 2023-05 | Subscriber + Child or Children | 316 | 559 |
| AC | 2023-05 | Subscriber + Family | 194 | 628 |
| AC | 2023-04 | Subscriber Only | 1,202 | 0 |
| AC | 2023-04 | Subscriber + Spouse | 89 | 89 |
| AC | 2023-04 | Subscriber + Child or Children | 317 | 564 |
| AC | 2023-04 | Subscriber + Family | 194 | 628 |
| AC | 2023-03 | Subscriber Only | 1,206 | 0 |
| AC | 2023-03 | Subscriber + Spouse | 91 | 91 |
| AC | 2023-03 | Subscriber + Child or Children | 310 | 553 |
| AC | 2023-03 | Subscriber + Family | 194 | 628 |
| AC | 2023-02 | Subscriber Only | 1,206 | 0 |
| AC | 2023-02 | Subscriber + Spouse | 92 | 92 |
| AC | 2023-02 | Subscriber + Child or Children | 314 | 556 |
| AC | 2023-02 | Subscriber + Family | 194 | 629 |
| AC | 2023-01 | Subscriber Only | 1,205 | 0 |
| AC | 2023-01 | Subscriber + Spouse | 96 | 96 |
| AC | 2023-01 | Subscriber + Child or Children | 310 | 550 |
| AC | 2023-01 | Subscriber + Family | 196 | 635 |
| AE | 2023-12 | Subscriber Only | 821 | 0 |
| AE | 2023-12 | Subscriber + Spouse | 65 | 65 |
| AE | 2023-12 | Subscriber + Child or Children | 378 | 651 |
| AE | 2023-12 | Subscriber + Family | 248 | 773 |
| AE | 2023-11 | Subscriber Only | 823 | 0 |
| AE | 2023-11 | Subscriber + Spouse | 66 | 66 |
| AE | 2023-11 | Subscriber + Child or Children | 380 | 654 |
| AE | 2023-11 | Subscriber + Family | 247 | 776 |
| AE | 2023-10 | Subscriber Only | 824 | 0 |
| AE | 2023-10 | Subscriber + Spouse | 66 | 66 |
| AE | 2023-10 | Subscriber + Child or Children | 383 | 658 |
| AE | 2023-10 | Subscriber + Family | 248 | 777 |
| AE | 2023-09 | Subscriber Only | 825 | 0 |
| AE | 2023-09 | Subscriber + Spouse | 67 | 67 |
| AE | 2023-09 | Subscriber + Child or Children | 382 | 659 |
| AE | 2023-09 | Subscriber + Family | 249 | 778 |
| AE | 2023-08 | Subscriber Only | 867 | 0 |
| AE | 2023-08 | Subscriber + Spouse | 68 | 68 |
| AE | 2023-08 | Subscriber + Child or Children | 387 | 663 |
| AE | 2023-08 | Subscriber + Family | 256 | 800 |
| AE | 2023-07 | Subscriber Only | 836 | 0 |
| AE | 2023-07 | Subscriber + Spouse | 68 | 68 |
| AE | 2023-07 | Subscriber + Child or Children | 372 | 643 |
| AE | 2023-07 | Subscriber + Family | 254 | 790 |
| AE | 2023-06 | Subscriber Only | 854 | 0 |
| AE | 2023-06 | Subscriber + Spouse | 69 | 69 |
| AE | 2023-06 | Subscriber + Child or Children | 377 | 652 |
| AE | 2023-06 | Subscriber + Family | 257 | 803 |
| AE | 2023-05 | Subscriber Only | 861 | 0 |
| AE | 2023-05 | Subscriber + Spouse | 68 | 68 |
| AE | 2023-05 | Subscriber + Child or Children | 375 | 647 |
| AE | 2023-05 | Subscriber + Family | 259 | 811 |
| AE | 2023-04 | Subscriber Only | 869 | 0 |
| AE | 2023-04 | Subscriber + Spouse | 69 | 69 |
| AE | 2023-04 | Subscriber + Child or Children | 374 | 648 |
| AE | 2023-04 | Subscriber + Family | 259 | 807 |
| AE | 2023-03 | Subscriber Only | 870 | 0 |
| AE | 2023-03 | Subscriber + Spouse | 69 | 69 |
| AE | 2023-03 | Subscriber + Child or Children | 377 | 656 |
| AE | 2023-03 | Subscriber + Family | 261 | 814 |
| AE | 2023-02 | Subscriber Only | 875 | 0 |
| AE | 2023-02 | Subscriber + Spouse | 70 | 70 |
| AE | 2023-02 | Subscriber + Child or Children | 376 | 655 |
| AE | 2023-02 | Subscriber + Family | 262 | 817 |
| AE | 2023-01 | Subscriber Only | 872 | 0 |
| AE | 2023-01 | Subscriber + Spouse | 71 | 71 |
| AE | 2023-01 | Subscriber + Child or Children | 381 | 662 |
| AE | 2023-01 | Subscriber + Family | 265 | 825 |
| AF | 2023-12 | Subscriber Only | 235 | 0 |
| AF | 2023-12 | Subscriber + Spouse | 6 | 6 |
| AF | 2023-12 | Subscriber + Child or Children | 22 | 42 |
| AF | 2023-12 | Subscriber + Family | 11 | 37 |
| AF | 2023-11 | Subscriber Only | 232 | 0 |
| AF | 2023-11 | Subscriber + Spouse | 6 | 6 |
| AF | 2023-11 | Subscriber + Child or Children | 22 | 42 |
| AF | 2023-11 | Subscriber + Family | 12 | 40 |
| AF | 2023-10 | Subscriber Only | 226 | 0 |
| AF | 2023-10 | Subscriber + Spouse | 5 | 5 |
| AF | 2023-10 | Subscriber + Child or Children | 22 | 42 |
| AF | 2023-10 | Subscriber + Family | 12 | 40 |
| AF | 2023-09 | Subscriber Only | 221 | 0 |
| AF | 2023-09 | Subscriber + Spouse | 4 | 4 |
| AF | 2023-09 | Subscriber + Child or Children | 23 | 47 |
| AF | 2023-09 | Subscriber + Family | 11 | 36 |
| AF | 2023-08 | Subscriber Only | 213 | 0 |
| AF | 2023-08 | Subscriber + Spouse | 4 | 4 |
| AF | 2023-08 | Subscriber + Child or Children | 20 | 41 |
| AF | 2023-08 | Subscriber + Family | 11 | 37 |
| AF | 2023-07 | Subscriber Only | 177 | 0 |
| AF | 2023-07 | Subscriber + Spouse | 3 | 3 |
| AF | 2023-07 | Subscriber + Child or Children | 19 | 40 |
| AF | 2023-07 | Subscriber + Family | 9 | 30 |
| AF | 2023-06 | Subscriber Only | 179 | 0 |
| AF | 2023-06 | Subscriber + Spouse | 3 | 3 |
| AF | 2023-06 | Subscriber + Child or Children | 20 | 41 |
| AF | 2023-06 | Subscriber + Family | 8 | 24 |
| AF | 2023-05 | Subscriber Only | 178 | 0 |
| AF | 2023-05 | Subscriber + Spouse | 3 | 3 |
| AF | 2023-05 | Subscriber + Child or Children | 22 | 44 |
| AF | 2023-05 | Subscriber + Family | 7 | 21 |
| AF | 2023-04 | Subscriber Only | 181 | 0 |
| AF | 2023-04 | Subscriber + Spouse | 3 | 3 |
| AF | 2023-04 | Subscriber + Child or Children | 23 | 46 |
| AF | 2023-04 | Subscriber + Family | 6 | 19 |
| AF | 2023-03 | Subscriber Only | 177 | 0 |
| AF | 2023-03 | Subscriber + Spouse | 3 | 3 |
| AF | 2023-03 | Subscriber + Child or Children | 23 | 46 |
| AF | 2023-03 | Subscriber + Family | 6 | 19 |
| AF | 2023-02 | Subscriber Only | 177 | 0 |
| AF | 2023-02 | Subscriber + Spouse | 2 | 2 |
| AF | 2023-02 | Subscriber + Child or Children | 21 | 44 |
| AF | 2023-02 | Subscriber + Family | 6 | 19 |
| AF | 2023-01 | Subscriber Only | 174 | 0 |
| AF | 2023-01 | Subscriber + Spouse | 2 | 2 |
| AF | 2023-01 | Subscriber + Child or Children | 21 | 45 |
| AF | 2023-01 | Subscriber + Family | 4 | 13 |
| AG | 2023-12 | Subscriber Only | 1,222 | 0 |
| AG | 2023-12 | Subscriber + Spouse | 94 | 94 |
| AG | 2023-12 | Subscriber + Child or Children | 364 | 628 |
| AG | 2023-12 | Subscriber + Family | 226 | 701 |
| AG | 2023-11 | Subscriber Only | 1,222 | 0 |
| AG | 2023-11 | Subscriber + Spouse | 94 | 94 |
| AG | 2023-11 | Subscriber + Child or Children | 362 | 629 |
| AG | 2023-11 | Subscriber + Family | 228 | 705 |
| AG | 2023-10 | Subscriber Only | 1,221 | 0 |
| AG | 2023-10 | Subscriber + Spouse | 96 | 96 |
| AG | 2023-10 | Subscriber + Child or Children | 363 | 632 |
| AG | 2023-10 | Subscriber + Family | 229 | 708 |
| AG | 2023-09 | Subscriber Only | 1,215 | 0 |
| AG | 2023-09 | Subscriber + Spouse | 94 | 94 |
| AG | 2023-09 | Subscriber + Child or Children | 366 | 638 |
| AG | 2023-09 | Subscriber + Family | 233 | 723 |
| AG | 2023-08 | Subscriber Only | 1,270 | 0 |
| AG | 2023-08 | Subscriber + Spouse | 97 | 97 |
| AG | 2023-08 | Subscriber + Child or Children | 393 | 683 |
| AG | 2023-08 | Subscriber + Family | 257 | 793 |
| AG | 2023-07 | Subscriber Only | 1,216 | 0 |
| AG | 2023-07 | Subscriber + Spouse | 92 | 92 |
| AG | 2023-07 | Subscriber + Child or Children | 379 | 656 |
| AG | 2023-07 | Subscriber + Family | 243 | 751 |
| AG | 2023-06 | Subscriber Only | 1,222 | 0 |
| AG | 2023-06 | Subscriber + Spouse | 96 | 96 |
| AG | 2023-06 | Subscriber + Child or Children | 390 | 672 |
| AG | 2023-06 | Subscriber + Family | 248 | 767 |
| AG | 2023-05 | Subscriber Only | 1,227 | 0 |
| AG | 2023-05 | Subscriber + Spouse | 96 | 96 |
| AG | 2023-05 | Subscriber + Child or Children | 392 | 673 |
| AG | 2023-05 | Subscriber + Family | 249 | 769 |
| AG | 2023-04 | Subscriber Only | 1,234 | 0 |
| AG | 2023-04 | Subscriber + Spouse | 98 | 98 |
| AG | 2023-04 | Subscriber + Child or Children | 388 | 672 |
| AG | 2023-04 | Subscriber + Family | 245 | 756 |
| AG | 2023-03 | Subscriber Only | 1,239 | 0 |
| AG | 2023-03 | Subscriber + Spouse | 98 | 98 |
| AG | 2023-03 | Subscriber + Child or Children | 389 | 677 |
| AG | 2023-03 | Subscriber + Family | 245 | 757 |
| AG | 2023-02 | Subscriber Only | 1,248 | 1 |
| AG | 2023-02 | Subscriber + Spouse | 98 | 98 |
| AG | 2023-02 | Subscriber + Child or Children | 392 | 680 |
| AG | 2023-02 | Subscriber + Family | 246 | 759 |
| AG | 2023-01 | Subscriber Only | 1,250 | 0 |
| AG | 2023-01 | Subscriber + Spouse | 99 | 99 |
| AG | 2023-01 | Subscriber + Child or Children | 391 | 680 |
| AG | 2023-01 | Subscriber + Family | 248 | 765 |
| AI | 2023-12 | Subscriber Only | 999 | 0 |
| AI | 2023-12 | Subscriber + Spouse | 91 | 91 |
| AI | 2023-12 | Subscriber + Child or Children | 273 | 505 |
| AI | 2023-12 | Subscriber + Family | 173 | 518 |
| AI | 2023-11 | Subscriber Only | 1,004 | 0 |
| AI | 2023-11 | Subscriber + Spouse | 89 | 89 |
| AI | 2023-11 | Subscriber + Child or Children | 276 | 511 |
| AI | 2023-11 | Subscriber + Family | 177 | 529 |
| AI | 2023-10 | Subscriber Only | 999 | 0 |
| AI | 2023-10 | Subscriber + Spouse | 88 | 88 |
| AI | 2023-10 | Subscriber + Child or Children | 277 | 510 |
| AI | 2023-10 | Subscriber + Family | 178 | 537 |
| AI | 2023-09 | Subscriber Only | 1,008 | 0 |
| AI | 2023-09 | Subscriber + Spouse | 86 | 86 |
| AI | 2023-09 | Subscriber + Child or Children | 279 | 513 |
| AI | 2023-09 | Subscriber + Family | 176 | 531 |
| AI | 2023-08 | Subscriber Only | 1,071 | 0 |
| AI | 2023-08 | Subscriber + Spouse | 86 | 86 |
| AI | 2023-08 | Subscriber + Child or Children | 292 | 535 |
| AI | 2023-08 | Subscriber + Family | 183 | 547 |
| AI | 2023-07 | Subscriber Only | 1,047 | 0 |
| AI | 2023-07 | Subscriber + Spouse | 84 | 84 |
| AI | 2023-07 | Subscriber + Child or Children | 289 | 530 |
| AI | 2023-07 | Subscriber + Family | 174 | 522 |
| AI | 2023-06 | Subscriber Only | 1,068 | 1 |
| AI | 2023-06 | Subscriber + Spouse | 83 | 83 |
| AI | 2023-06 | Subscriber + Child or Children | 291 | 536 |
| AI | 2023-06 | Subscriber + Family | 178 | 537 |
| AI | 2023-05 | Subscriber Only | 1,072 | 1 |
| AI | 2023-05 | Subscriber + Spouse | 82 | 82 |
| AI | 2023-05 | Subscriber + Child or Children | 290 | 534 |
| AI | 2023-05 | Subscriber + Family | 178 | 535 |
| AI | 2023-04 | Subscriber Only | 1,069 | 0 |
| AI | 2023-04 | Subscriber + Spouse | 85 | 85 |
| AI | 2023-04 | Subscriber + Child or Children | 295 | 540 |
| AI | 2023-04 | Subscriber + Family | 177 | 532 |
| AI | 2023-03 | Subscriber Only | 1,079 | 0 |
| AI | 2023-03 | Subscriber + Spouse | 83 | 83 |
| AI | 2023-03 | Subscriber + Child or Children | 294 | 540 |
| AI | 2023-03 | Subscriber + Family | 177 | 528 |
| AI | 2023-02 | Subscriber Only | 1,081 | 0 |
| AI | 2023-02 | Subscriber + Spouse | 85 | 85 |
| AI | 2023-02 | Subscriber + Child or Children | 294 | 541 |
| AI | 2023-02 | Subscriber + Family | 178 | 530 |
| AI | 2023-01 | Subscriber Only | 1,078 | 0 |
| AI | 2023-01 | Subscriber + Spouse | 87 | 87 |
| AI | 2023-01 | Subscriber + Child or Children | 301 | 552 |
| AI | 2023-01 | Subscriber + Family | 178 | 531 |
| Total | 85,771 | 66,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 .