2-Exhibit B-6 - 2026 Monthly Claims through September.pdf
PDF 273 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 monthly claims report for stop loss insurance coverage submitted by Schertz-Cibolo-Universal City ISD (SCUC ISD) in Texas. The exhibit presents detailed claims data through September 2026, supporting the district's stop loss insurance program administration. The report documents individual claims and aggregate loss information relevant to the district's self-funded health plan operations, serving as documentation for the ongoing insurance coverage period and claims substantiation required under the stop loss insurance contract terms.
The monthly claims data presented in this exhibit provides essential financial records for the district's stop loss insurance coverage, demonstrating actual loss experience and claim activity. This type of documentation typically supports premium calculations, coverage verification, and compliance with policy requirements established under the insurance agreement between SCUC ISD and the selected stop loss insurance carrier. The claims information reflects the district's healthcare cost management and the functioning of its self-insured health plan during the specified reporting period.
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
January - 26 Through September - 26
Product Month *(1) Estimated
Employees *(2) Customer Funded Claims
*(3) Individual Stop Loss Claims
*(4) Aggregate Stop Loss Claims
Total Claims
Open Acc EPO 01/01/2026 1,238 $898,813.60 $0.00 $0.00 $898,813.60
02/01/2026 1,235 $455,937.81 $0.00 $0.00 $455,937.81
03/01/2026 1,227 $1,023,674.93 $0.00 $0.00 $1,023,674.93
04/01/2026 1,224 $852,332.56 $0.00 $0.00 $852,332.56
05/01/2026 1,215 $728,033.70 $0.00 $0.00 $728,033.70
06/01/2026 1,209 $729,431.98 $0.00 $0.00 $729,431.98
07/01/2026 1,203 $1,061,898.70 $0.00 $0.00 $1,061,898.70
08/01/2026 1,211 $999,946.20 $0.00 $0.00 $999,946.20
09/01/2026 1,211 $1,063,921.28 $0.00 $0.00 $1,063,921.28
Open Acc EPO Total 10,973 $7,813,990.76 $0.00 $0.00 $7,813,990.76
Open Acc POS 01/01/2026 0 $309,968.04 $0.00 $0.00 $309,968.04
02/01/2026 0 $359,662.48 $0.00 $0.00 $359,662.48
03/01/2026 0 -$84,229.42 $0.00 $0.00 -$84,229.42
04/01/2026 0 $27,010.43 $0.00 $0.00 $27,010.43
05/01/2026 0 $17,256.92 $0.00 $0.00 $17,256.92
06/01/2026 0 $5.85 $0.00 $0.00 $5.85
07/01/2026 0 -$6,080.38 $0.00 $0.00 -$6,080.38
08/01/2026 0 -$531.79 $0.00 $0.00 -$531.79
09/01/2026 0 -$1,666.80 $0.00 $0.00 -$1,666.80
Open Acc POS Total 0 $621,395.33 $0.00 $0.00 $621,395.33
Grand Total $8,435,386.09 $0.00 $0.00 $8,435,386.09
EXHIBIT B-6: 2026 MONTHLY SELF FUNDED MONTHLY CLAIMS REPORT THRU SEPTEMBER 2026
SCHERTZ-CIBOLO-UNIVERSAL CITY INDEPENDENT SCHOOL DISTRICT
Customer Number 237586
(1) Due to timing, current month lives are NOT available and therefore the prior month's lives are used for both months. Estimated Employee counts are unedited and exclude retroactive changes.
Audited counts will be used for accounting results.
(2) If applicable, claims displayed include charges for the National Advantage Program, Value-Based Pricing and/or specific buy-up program fees/ad hoc service charges that are billed through the claim wire. The monthly Claim Detail Report is available to identify specific claim wire billed fees/charges.
(3) Stop Loss claim values (including 0.00) display only if applicable. Absence of values in a Stop Loss column indicates that arrangement is not in effect.
(4) Stop Loss claims may be greater than displayed if subject to a year end reconciliation.
(5) If applicable, Rx Rebate dollars are excluded in the pharmacy claims and, as such, this data will not match the monthly Claim Detail Reports or Fund Summary Reports.
File details come from the government source that posted it. Updated .