10-Exhibit C-2 - 24-26 Monthly Rx Claims.pdf
PDF 230 KB Posted
- Attached to
- 27-002V Stop Loss Insurance
- Solicitation number
- 27-002V
- Issued by
- Savannah CDP, Texas
About this file
This file is a 24-month pharmaceutical claims summary for Schertz-Cibolo-Universal City Independent School District (ISD) in Texas, presented as supporting documentation for a stop loss insurance solicitation. The document provides detailed monthly prescription claim data from September 2024 through August 2026, capturing the pharmacy utilization metrics necessary to establish baseline costs and risk profiles for the district's self-funded health plan. The exhibit presents aggregated claims data derived from Trend Central reporting systems using claim-level summary data filtered for the specified 24-month service period, with September 16, 2026 identified as the report delivery date.
The claims data demonstrates relatively stable subscriber enrollment ranging from 1,847 to 1,956 covered lives across the 24-month period, with aggregate paid pharmacy claims totaling $9,286,561.81. Monthly paid claims fluctuate significantly, ranging from a low of $194,229.71 in September 2024 to a high of $496,232.23 in July 2026, providing prospective stop loss carriers with historical trend information necessary to evaluate claims experience and establish appropriate attachment points and premium rates. This claims summary serves as essential actuarial data for insurance companies licensed in Texas responding to the district's stop loss insurance proposal, enabling informed underwriting decisions and cost projections for the self-funded plan's pharmaceutical benefit component.
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
Month Subscriber Count Paid Pharmacy Claim
Sep-2024 1,847 $194,229.71
Oct-2024 1,866 $302,068.96
Nov-2024 1,879 $270,347.61
Dec-2024 1,879 $325,592.84
Jan-2025 1,862 $360,558.26
Feb-2025 1,856 $338,829.93
Mar-2025 1,866 $308,037.91
Apr-2025 1,875 $491,209.70
May-2025 1,876 $413,853.59
Jun-2025 1,872 $496,124.59
Jul-2025 1,867 $477,424.76
Aug-2025 1,860 $471,948.40
Sep-2025 1,906 $477,927.71
Oct-2025 1,930 $369,530.75
Nov-2025 1,929 $435,973.31
Dec-2025 1,932 $440,750.32
Jan-2026 1,956 $316,426.15
Feb-2026 1,947 $342,781.28
Mar-2026 1,947 $289,747.87
Apr-2026 1,949 $422,777.16
May-2026 1,943 $417,094.69
Jun-2026 1,941 $434,214.69
Jul-2026 1,933 $496,232.23
Aug-2026 1,945 $392,879.39
45,663 $9,286,561.81
EXHIBIT C-2: 2024-2026 MONTHLY RX CLAIMS
Source: Trend Central
Report
Domain: Rx Claims
Reversals: Yes
Template: Claim Level Summary
Name: 95A4-Schertz-Cibolo-UCISD-Claim Level Summary
Type: Custom
Settings
Population: 95A4-Schertz-Cibolo-UCISD
Date Type: Service Date
Report Period: 09/01/2024 - 08/31/2026
Columns
Month ServicedAscending Sort Order
Rx Users
Plan Cost
Threshold
None
Filters
None
Delivery
Run Date: 2026 Sep 16 19:23:58 GMT
File details come from the government source that posted it. Updated .