13-Exhibit D-4 - 2026 Enrollment by Tier through September.pdf
PDF 524 KB Posted
- Attached to
- 27-002V Stop Loss Insurance
- Solicitation number
- 27-002V
- Issued by
- Savannah CDP, Texas
About this file
This document is a medical membership enrollment report for Schertz-Cibolo-Universal City Independent School District's self-insured health plan, prepared by Aetna Integrated Informatics covering the period of January 1, 2026 through September 30, 2026. The report details enrollment data across multiple account structures and tier levels, tracking employee-only coverage, employee plus spouse, employee plus child, employee plus children, and employee plus family enrollment categories. The data encompasses nine months of enrollment information, with monthly breakdowns and cumulative totals provided for each tier classification. As of September 30, 2026, the district maintained a total of 10,947 enrolled employees with 17,470 total members across all coverage tiers, representing a slight decline from the January 2026 enrollment of 1,238 employees and 1,954 members.
The enrollment data indicates the district's self-insured account structure (00237586) with varying enrollment levels across different account segments. The largest enrollment segment shows 9,329 total employees (14,905 total members) across the nine-month period, with employee-only coverage representing the predominant enrollment category at 6,455 employees. Enrollment trends show a gradual decline from January through September 2026, with employee-only coverage decreasing from 864 to 811 participants and total employees declining from 1,238 to 1,185. This enrollment report serves as supporting documentation for the district's stop loss insurance solicitation (27-002V), which is being administered by Foundation Risk Partners, d/b/a Corporate Synergies, to assist Texas-licensed insurance companies in submitting proposals for stop loss coverage.
View the file
Other files
Show all 20
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
SCHERTZ-CIBOLO-UNIVERSAL CITY INDEPENDEN
Plan Sponsor ID 0000000120911971
Medical Membership Enrollment by Tier
Membership Reporting Time Period January 01, 2026 - September 30, 2026
© Aetna Integrated Informatics® 2026
Run Date: 10/15/2026
EXHIBIT D-4: 2026 ENROLLMENT BY TIER THRU SEPTEMBER 2026
Funding Category: Account Structure:
Self Insured 00237586-All-All-All
Product: Run By:
ALL Tier Level 5
SCHERTZ-CIBOLO-UNIVERSAL CITY INDEPENDEN - 0000000120911971
Membership Reporting Time Period January 01, 2026 - September 30, 2026
Medical Membership Enrollment by Tier
© Aetna Integrated Informatics® 2026
Account Structure Month/Year Employee Only Employee+
Spouse Employee+
Child Employee+
Children Employee+
Family Total
Employees Total
Members 00237586-00000010-00001-A Jan-26 739 32 88 168 30 1,057 1,671 00237586-00000010-00001-A Feb-26 738 32 89 167 30 1,056 1,668 00237586-00000010-00001-A Mar-26 728 31 87 170 31 1,047 1,667 00237586-00000010-00001-A Apr-26 724 32 87 170 31 1,044 1,664 00237586-00000010-00001-A May-26 718 32 86 170 32 1,038 1,659 00237586-00000010-00001-A Jun-26 710 33 83 171 34 1,031 1,658 00237586-00000010-00001-A Jul-26 705 32 86 170 33 1,026 1,651 00237586-00000010-00001-A Aug-26 708 31 85 171 34 1,029 1,654 00237586-00000010-00001-A Sep-26 685 33 81 169 33 1,001 1,613
Total 6,455 288 772 1,526 288 9,329 14,905
00237586-00000010-00101-A Jan-26 2 0 0 0 0 2 2 00237586-00000010-00101-A Feb-26 2 0 0 0 0 2 2 00237586-00000010-00101-A Mar-26 2 0 0 0 0 2 2 00237586-00000010-00101-A Apr-26 2 0 0 0 0 2 2 00237586-00000010-00101-A May-26 1 0 0 0 0 1 1 00237586-00000010-00101-A Jun-26 1 0 0 0 0 1 1 00237586-00000010-00101-A Jul-26 1 0 0 0 0 1 1 00237586-00000010-00101-A Aug-26 1 0 0 0 0 1 1 00237586-00000010-00101-A Sep-26 1 0 0 0 0 1 1
Total 13 0 0 0 0 13 13
00237586-00000016-00001-G Jan-26 123 8 17 24 7 179 281 00237586-00000016-00001-G Feb-26 120 8 18 24 7 177 280 00237586-00000016-00001-G Mar-26 119 8 19 24 8 178 285 00237586-00000016-00001-G Apr-26 120 7 19 24 8 178 284 00237586-00000016-00001-G May-26 118 7 19 24 8 176 282 00237586-00000016-00001-G Jun-26 119 7 19 24 8 177 283 00237586-00000016-00001-G Jul-26 118 7 19 24 8 176 282 00237586-00000016-00001-G Aug-26 122 7 20 25 7 181 287 00237586-00000016-00001-G Sep-26 125 7 19 24 8 183 288
Total 1,084 66 169 217 69 1,605 2,552
SCHERTZ-CIBOLO-UNIVERSAL CITY INDEPENDEN - 0000000120911971
Membership Reporting Time Period January 01, 2026 - September 30, 2026
Medical Membership Enrollment by Tier
© Aetna Integrated Informatics® 2026
Account Structure Month/Year Employee Only Employee+
Spouse Employee+
Child Employee+
Children Employee+
Family Total
Employees Total
Members
SCHERTZ-CIBOLO-UNIVERSAL CITY INDEPENDEN - 0000000120911971
Membership Reporting Time Period January 01, 2026 - September 30, 2026
Medical Membership Enrollment by Tier
Total Jan-26 864 40 105 192 37 1,238 1,954 Feb-26 860 40 107 191 37 1,235 1,950 Mar-26 849 39 106 194 39 1,227 1,954 Apr-26 846 39 106 194 39 1,224 1,950 May-26 837 39 105 194 40 1,215 1,942 Jun-26 830 40 102 195 42 1,209 1,942 Jul-26 824 39 105 194 41 1,203 1,934 Aug-26 831 38 105 196 41 1,211 1,942 Sep-26 811 40 100 193 41 1,185 1,902 Total 7,552 354 941 1,743 357 10,947 17,470
© Aetna Integrated Informatics® 2026
File details come from the government source that posted it. Updated .