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 |
| Month | Regular Claims | Orthodontic Claims | Paid Claims | Number of Services | EE | EE+SP | EE+CH | FAM | Total Primary Subscribers | Premium |
| Jan-2024 | $113,078 | $7,376 | $120,455 | 1,382 | 2,592 | 121 | 347 | 161 | 3,221 | $104,952 |
| Feb-2024 | $75,960 | $8,581 | $84,542 | 1,031 | 2,620 | 123 | 347 | 161 | 3,251 | $107,383 |
| Mar-2024 | $82,484 | $7,212 | $89,697 | 1,083 | 2,630 | 124 | 347 | 160 | 3,261 | $105,484 |
| Apr-2024 | $102,870 | $2,566 | $105,436 | 1,280 | 2,624 | 124 | 345 | 160 | 3,253 | $106,652 |
| May-2024 | $79,806 | $9,490 | $89,295 | 948 | 2,627 | 127 | 346 | 158 | 3,258 | $106,650 |
| Jun-2024 | $90,814 | $5,407 | $96,221 | 1,178 | 2,628 | 125 | 347 | 158 | 3,258 | $106,228 |
| Jul-2024 | $113,412 | $4,128 | $117,540 | 1,542 | 2,620 | 125 | 345 | 158 | 3,248 | $106,679 |
| Aug-2024 | $108,268 | $6,205 | $114,473 | 1,213 | 2,635 | 126 | 346 | 165 | 3,272 | $106,018 |
| Sep-2024 | $61,308 | $7,947 | $69,255 | 799 | 2,597 | 123 | 346 | 157 | 3,223 | $108,912 |
| Oct-2024 | $84,294 | $4,106 | $88,401 | 1,112 | 2,608 | 123 | 348 | 152 | 3,231 | $103,008 |
| Nov-2024 | $70,740 | $3,717 | $74,458 | 903 | 2,629 | 122 | 351 | 151 | 3,253 | $104,983 |
| Dec-2024 | $84,095 | $5,592 | $89,687 | 1,117 | 2,649 | 122 | 350 | 150 | 3,271 | $105,518 |
| Jan-2025 | $71,403 | $3,869 | $75,272 | 943 | 2,615 | 124 | 366 | 157 | 3,262 | $107,822 |
| Feb-2025 | $90,196 | $1,832 | $92,028 | 1,085 | 2,636 | 125 | 369 | 156 | 3,286 | $107,277 |
| Mar-2025 | $90,807 | $8,387 | $99,194 | 1,165 | 2,646 | 127 | 371 | 156 | 3,300 | $107,507 |
| Apr-2025 | $99,735 | $7,521 | $107,256 | 1,194 | 2,658 | 126 | 371 | 157 | 3,312 | $108,202 |
| May-2025 | $85,655 | $2,162 | $87,817 | 1,097 | 2,677 | 124 | 375 | 158 | 3,334 | $109,295 |
| Jun-2025 | $94,170 | $2,001 | $96,170 | 1,297 | 2,691 | 123 | 375 | 160 | 3,349 | $109,282 |
| Jul-2025 | $129,847 | $9,201 | $139,048 | 1,644 | 2,698 | 122 | 372 | 159 | 3,351 | $110,008 |
| Aug-2025 | $91,756 | $6,573 | $98,329 | 1,171 | 2,701 | 122 | 373 | 157 | 3,353 | $108,819 |
| Sep-2025 | $92,570 | $4,072 | $96,641 | 1,230 | 2,672 | 115 | 361 | 149 | 3,297 | $108,878 |
| Oct-2025 | $83,147 | $2,807 | $85,954 | 1,000 | 2,703 | 114 | 365 | 149 | 3,331 | $118,833 |
| Nov-2025 | $82,095 | $6,076 | $88,171 | 928 | 2,691 | 110 | 363 | 148 | 3,312 | $94,495 |
| Dec-2025 | $81,061 | $9,924 | $90,986 | 1,090 | 2,710 | 110 | 361 | 146 | 3,327 | $106,236 |
| Jan-2026 | $86,600 | $5,329 | $91,928 | 1,212 | 2,693 | 114 | 378 | 145 | 3,330 | $107,299 |
| Feb-2026 | $84,909 | $3,895 | $88,803 | 1,074 | 2,715 | 113 | 378 | 145 | 3,351 | $108,406 |
| Total | $2,331,080 | $145,977 | $2,477,056 | 29,718 | 68,965 | 3,154 | 9,343 | 4,033 | 85,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 |
| Date | 3/11/2026 11:57:42 AM |
| Duration | 6 second(s) |
image1.jpg image2.jpg
File details come from the government source that posted it. Updated .