17-J-3 Dental Claims Enrollment and Premium 1-1-24 - 2-28-26.xlsx

XLSX spreadsheet 150 KB Posted

Attached to
District Wide Employee Benefit Services.
Solicitation number
RFP 099-2026
Issued by
St. Louis County, Missouri

About this file

This is a Claims, Enrollment, and Premium Report for dental plan services provided to St. Louis Public Schools (SLPS) covering the period from January 1, 2024 through February 28, 2026. The report documents the dental claims processing, enrollment data, and premium payments for the district's employee benefit plan. The data encompasses regular and orthodontic claims, with enrollment categories broken down by subscriber type: employee only (EE), employee plus spouse (EE+SP), employee plus child (EE+CH), and family (FAM). Over the 26-month reporting period, the district processed total paid claims of $2,477,056, comprising $2,331,080 in regular claims and $145,977 in orthodontic claims, with 85,495 total primary subscribers across all enrollment categories.

The report demonstrates consistent premium payments totaling $2,784,826 across the reporting period, with monthly premiums ranging from approximately $94,495 to $118,833. Enrollment remained relatively stable throughout the period, fluctuating between 3,221 and 3,351 total subscribers, indicating steady participation in the dental plan. The number of dental services provided totaled 29,718 over the 26-month period. The plan is identified as a managed care product (MC2LDM4NP50HNSCV_91860801) and is administered under multiple premium groups designated as MO91860801 through MO91860806, supporting the district's broader employee benefit services that include medical, prescription drug, EAP, wellness, vision, life insurance, disability coverage, and other benefit offerings.

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

Claims, Enrollment, and Premium

St. Louis Public Schools
Claims, Enrollment and Premium Report
January 1, 2024 through February 28, 2026
MonthRegular ClaimsOrthodontic ClaimsPaid ClaimsNumber of ServicesEEEE+SPEE+CHFAMTotal Primary SubscribersPremium
Jan-2024$113,078$7,376$120,4551,3822,5921213471613,221$104,952
Feb-2024$75,960$8,581$84,5421,0312,6201233471613,251$107,383
Mar-2024$82,484$7,212$89,6971,0832,6301243471603,261$105,484
Apr-2024$102,870$2,566$105,4361,2802,6241243451603,253$106,652
May-2024$79,806$9,490$89,2959482,6271273461583,258$106,650
Jun-2024$90,814$5,407$96,2211,1782,6281253471583,258$106,228
Jul-2024$113,412$4,128$117,5401,5422,6201253451583,248$106,679
Aug-2024$108,268$6,205$114,4731,2132,6351263461653,272$106,018
Sep-2024$61,308$7,947$69,2557992,5971233461573,223$108,912
Oct-2024$84,294$4,106$88,4011,1122,6081233481523,231$103,008
Nov-2024$70,740$3,717$74,4589032,6291223511513,253$104,983
Dec-2024$84,095$5,592$89,6871,1172,6491223501503,271$105,518
Jan-2025$71,403$3,869$75,2729432,6151243661573,262$107,822
Feb-2025$90,196$1,832$92,0281,0852,6361253691563,286$107,277
Mar-2025$90,807$8,387$99,1941,1652,6461273711563,300$107,507
Apr-2025$99,735$7,521$107,2561,1942,6581263711573,312$108,202
May-2025$85,655$2,162$87,8171,0972,6771243751583,334$109,295
Jun-2025$94,170$2,001$96,1701,2972,6911233751603,349$109,282
Jul-2025$129,847$9,201$139,0481,6442,6981223721593,351$110,008
Aug-2025$91,756$6,573$98,3291,1712,7011223731573,353$108,819
Sep-2025$92,570$4,072$96,6411,2302,6721153611493,297$108,878
Oct-2025$83,147$2,807$85,9541,0002,7031143651493,331$118,833
Nov-2025$82,095$6,076$88,1719282,6911103631483,312$94,495
Dec-2025$81,061$9,924$90,9861,0902,7101103611463,327$106,236
Jan-2026$86,600$5,329$91,9281,2122,6931143781453,330$107,299
Feb-2026$84,909$3,895$88,8031,0742,7151133781453,351$108,406
Total$2,331,080$145,977$2,477,05629,71868,9653,1549,3434,03385,495$2,784,826

Claims, Enrollment, and Pre (2)

Report Parameters
Report Name:Claims Enrollment and Premium
Report Header Name:St. Louis Public Schools
Paid Start Date:1/1/2024
Paid End Date:2/28/2026
Client(s):91860801
Premium Group(s):MO91860801, MO91860802, MO91860803, MO91860804, MO91860805, MO91860806
Product(s):Benefit Plan MC2LDM4NP50HNSCV_91860801 | 01/01/2011 - 12/31/2078
Date3/11/2026 11:57:42 AM
Duration6 second(s)

image1.jpg image2.jpg

File details come from the government source that posted it. Updated .