B4__STD_Experience(6009514.1).xlsx
XLSX spreadsheet 87 KB Posted
- Attached to
- Employee Benefits- Life/STD/FSA/HSA/COBRA
- Solicitation number
- 27-011CH-32RFP
- Issued by
- Maricopa County, Tucson City, Arizona
About this file
This file is a benefits claims and premium data report for Tempe Union High School District #213 in Arizona, covering the period from January 1, 2020, through August 27, 2026. The document contains two primary sections: a detailed claim list tracking 49 individual disability insurance claims with their claim numbers, filing dates, approval dates, claim status, and approved dollar amounts, and a comprehensive premium versus claims summary table displaying monthly billing statements and claim totals across the policy period. The claim list shows claim amounts ranging from negative $50.00 to $14,400.00, with most claims marked as "Closed" status, though several were denied due to condition unsatisfaction, setup errors, or claim withdrawal. The average claim processing duration was 121.5 days, and the data indicates all claims were filed under Mail Location E001 related to disability (Disability Illness category).
The premium data summary demonstrates zero premium charges throughout the entire period while documenting total claims of $314,016.70 across all billing months. All premiums listed as "Paid" show $0.00 for both employee and dependent premium contributions, suggesting either a fully employer-funded or self-insured arrangement. The claims data spans from monthly totals as low as $237.43 to as high as $14,182.68, with notable claims activity particularly concentrated in 2023, 2024, and 2025. This data corresponds to the Tempe Union High School District's procurement solicitation for Employee Benefits covering Life, Short-Term Disability (STD), Flexible Spending Accounts (FSA), Health Savings Accounts (HSA), and COBRA services, with proposals due by 2:00 p.m. on Thursday, November 19, 2026.
View the file
Other files
Show all 11
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
Claim List
Claim Number Mail Location Disability Closed Approved To Days Status Location Name Acc Ill Total Claim Dollar
| NTN-103950-DI-01-SA-01 | E001 | 08/23/2021 | 11/09/2021 | Denied | 001 - Tempe Union High School District #213 | I | |||
| NTN-669109-DI-01-SA-01 | E001 | 08/06/2024 | 09/30/2024 | 09/23/2024 | 49 | Denied - Condition Unsatisfied | 001 - Tempe Union High School District #213 | I | |
| NTN-789294-DI-01-SA-01 | E001 | 02/15/2025 | 06/15/2025 | 06/15/2025 | 121 | Closed | 001 - Tempe Union High School District #213 | I | 4,475.92 |
| NTN-834588-DI-01-SA-01 | E001 | 04/28/2025 | 07/20/2025 | 07/20/2025 | 84 | Closed | 001 - Tempe Union High School District #213 | I | 1,496.33 |
| NTN-115745-DI-01-SA-01 | E001 | 11/11/2021 | 05/10/2022 | 05/10/2022 | 181 | Closed | 001 - Tempe Union High School District #213 | I | 4,656.08 |
| NTN-672824-DI-01-SA-01 | E001 | 08/01/2024 | 11/05/2024 | 11/05/2024 | 97 | Closed | 001 - Tempe Union High School District #213 | I | 4,228.57 |
| NTN-327488-DI-01-SA-01 | E001 | 12/28/2022 | 04/09/2023 | 04/09/2023 | 103 | Closed | 001 - Tempe Union High School District #213 | I | 1,367.43 |
| NTN-752064-DI-01-SA-01 | E001 | 01/07/2025 | 07/11/2025 | 07/11/2025 | 186 | Closed | 001 - Tempe Union High School District #213 | I | 14,400.00 |
| NTN-597356-DI-01-SA-01 | E001 | 02/23/2024 | 08/25/2024 | 08/25/2024 | 185 | Closed | 001 - Tempe Union High School District #213 | I | 9,014.94 |
| NTN-747612-DI-01-SA-01 | E001 | 12/18/2024 | 02/23/2025 | 02/23/2025 | 68 | Closed | 001 - Tempe Union High School District #213 | I | 914.29 |
| NTN-301497-DI-01-SA-01 | E001 | 09/25/2022 | 01/08/2023 | 01/08/2023 | 106 | Closed | 001 - Tempe Union High School District #213 | A | 747.02 |
| NTN-420141-DI-01-SA-01 | E001 | 04/01/2023 | 06/04/2023 | 06/04/2023 | 65 | Closed | Tempe Union High School District #213 | I | |
| NTN-722359-DI-01-SA-01 | E001 | 11/12/2024 | 01/06/2025 | 01/06/2025 | 56 | Closed | 001 - Tempe Union High School District #213 | I | |
| NTN-667503-DI-01-SA-01 | E001 | 07/16/2024 | 11/21/2024 | Denied - Condition Unsatisfied | 001 - Tempe Union High School District #213 | A | |||
| NTN-372899-DI-01-SA-01 | E001 | 12/20/2022 | 06/12/2023 | 06/12/2023 | 175 | Closed | 001 - Tempe Union High School District #213 | I | 6,113.93 |
| NTN-521835-DI-01-SA-01 | E001 | 12/02/2023 | 05/19/2024 | 05/19/2024 | 170 | Closed | 001 - Tempe Union High School District #213 | I | 10,445.10 |
| NTN-429967-DI-01-SA-01 | E001 | 05/29/2023 | 11/25/2023 | 11/25/2023 | 181 | Closed | 001 - Tempe Union High School District #213 | I | 10,400.00 |
| NTN-671012-DI-01-SA-01 | E001 | 07/29/2024 | 01/30/2025 | 01/30/2025 | 186 | Closed | 001 - Tempe Union High School District #213 | I | 8,160.48 |
| NTN-520062-DI-01-SA-01 | E001 | 10/28/2023 | 12/13/2023 | 12/22/2023 | 56 | Denied Set Up in Error | 001 - Tempe Union High School District #213 | I | |
| NTN-645045-DI-01-SA-01 | E001 | 06/07/2024 | 08/29/2024 | 08/29/2024 | 84 | Closed | 001 - Tempe Union High School District #213 | I | 1,464.39 |
| NTN-747693-DI-01-SA-01 | E001 | 12/05/2024 | 06/08/2025 | 06/08/2025 | 186 | Closed | 001 - Tempe Union High School District #213 | I | 8,253.54 |
| NTN-757630-DI-01-SA-01 | E001 | 12/27/2024 | 04/23/2025 | 04/23/2025 | 118 | Closed | 001 - Tempe Union High School District #213 | I | 6,628.57 |
| NTN-75985-DI-01-SA-01 | E001 | 06/24/2021 | 11/28/2021 | 11/28/2021 | 158 | Closed | 001 - Tempe Union High School District #213 | I | 7,771.43 |
| NTN-364723-DI-01-SA-01 | E001 | 01/27/2023 | 05/28/2023 | 05/28/2023 | 122 | Closed | 001 - Tempe Union High School District #213 | I | 3,657.14 |
| NTN-1043483-DI-01-SA-01 | E001 | 01/30/2026 | 08/03/2026 | 08/03/2026 | 186 | Closed | 001 - Tempe Union High School District #213 | I | 8,381.34 |
| NTN-483894-DI-01-SA-01 | E001 | 09/12/2023 | 03/15/2024 | 03/15/2024 | 186 | Closed | 001 - Tempe Union High School District #213 | I | 8,984.89 |
| NTN-751956-DI-01-SA-01 | E001 | 12/16/2024 | 03/18/2025 | 03/18/2025 | 93 | Closed | 001 - Tempe Union High School District #213 | I | 3,662.25 |
| NTN-782828-DI-01-SA-01 | E001 | 02/21/2025 | 08/15/2025 | 04/06/2025 | 45 | Denied Claim Withdrawn | 001 - Tempe Union High School District #213 | I | |
| NTN-735213-DI-01-SA-01 | E001 | 11/11/2024 | 02/16/2025 | 02/16/2025 | 98 | Closed | 001 - Tempe Union High School District #213 | I | 4,191.07 |
| NTN-122766-DI-01-SA-01 | E001 | 09/29/2021 | 02/02/2022 | 02/02/2022 | 127 | Closed | 001 - Tempe Union High School District #213 | I | 4,228.57 |
| NTN-1028272-DI-01-SA-01 | E001 | 11/18/2025 | 05/22/2026 | 05/22/2026 | 186 | Closed | 001 - Tempe Union High School District #213 | I | 6,242.76 |
| NTN-707032-DI-01-SA-01 | E001 | 09/13/2024 | 12/05/2024 | 11/07/2024 | 56 | Denied - Condition Unsatisfied | 001 - Tempe Union High School District #213 | I | |
| NTN-478119-DI-01-SA-01 | E001 | 07/20/2023 | 01/20/2024 | 01/20/2024 | 185 | Closed | 001 - Tempe Union High School District #213 | I | 9,999.00 |
| NTN-619444-DI-01-SA-01 | E001 | 04/10/2024 | 10/11/2024 | 10/11/2024 | 185 | Closed | 001 - Tempe Union High School District #213 | I | 12,975.12 |
| NTN-653076-DI-01-SA-01 | E001 | 06/05/2024 | 08/07/2024 | Denied - Condition Unsatisfied | 001 - Tempe Union High School District #213 | I | |||
| NTN-502735-DI-01-SA-01 | E001 | 11/06/2023 | 01/01/2024 | 01/01/2024 | 57 | Closed | 001 - Tempe Union High School District #213 | I | (50.00) |
| NTN-425313-DI-01-SA-01 | E001 | 04/18/2023 | 08/27/2023 | 08/27/2023 | 132 | Closed | 001 - Tempe Union High School District #213 | I | 4,017.29 |
| NTN-719629-DI-01-SA-01 | E001 | 10/26/2024 | 02/09/2025 | 02/09/2025 | 107 | Closed | 001 - Tempe Union High School District #213 | I | 5,371.43 |
| NTN-75920-DI-01-SA-01 | E001 | 05/06/2021 | 09/21/2021 | 09/21/2021 | 139 | Closed | 001 - Tempe Union High School District #213 | I | 5,600.00 |
| NTN-824767-DI-01-SA-01 | E001 | 04/08/2025 | 10/10/2025 | 10/10/2025 | 186 | Closed | 001 - Tempe Union High School District #213 | I | 14,400.00 |
| NTN-684766-DI-01-SA-01 | E001 | 09/13/2024 | 09/25/2024 | Denied Set Up in Error | 001 - Tempe Union High School District #213 | I | |||
| NTN-508999-DI-01-SA-01 | E001 | 10/17/2023 | 04/18/2024 | 04/18/2024 | 185 | Closed | 001 - Tempe Union High School District #213 | I | 14,400.00 |
| NTN-692032-DI-01-SA-01 | E001 | 09/02/2024 | 03/06/2025 | 03/06/2025 | 186 | Closed | 001 - Tempe Union High School District #213 | I | 10,027.80 |
| NTN-657529-DI-01-SA-01 | E001 | 07/19/2024 | 01/05/2025 | 01/05/2025 | 171 | Closed | 001 - Tempe Union High School District #213 | I | 12,685.71 |
| NTN-619575-DI-01-SA-01 | E001 | 04/22/2024 | 10/23/2024 | 10/23/2024 | 185 | Closed | 001 - Tempe Union High School District #213 | I | 1,529.46 |
| NTN-716283-DI-01-SA-01 | 10/09/2024 | 11/14/2024 | Closed | 001 - Tempe Union High School District #213 | I | ||||
| NTN-517876-DI-01-SA-01 | E001 | 10/18/2023 | 04/19/2024 | 04/19/2024 | 185 | Closed | 001 - Tempe Union High School District #213 | I | 9,245.34 |
| NTN-1064705-DI-01-SA-01 | E001 | 04/01/2026 | 08/03/2026 | 125 | Approved | 001 - Tempe Union High School District #213 | I | 7,428.57 | |
| NTN-515046-DI-01-SA-01 | E001 | 09/20/2023 | 12/20/2023 | 12/20/2023 | 92 | Closed | 001 - Tempe Union High School District #213 | I | 2,373.64 |
&"Arial,Bold"&10 Total Count &"-,Bold"49 &"-,Bold"Average Duration &"-,Bold"121.5 &"-,Bold"Average Age &"-,Bold"55.8 &"-,Bold"% Male &"-,Bold"0 &"-,Bold"% Female &"-,Bold"0 &"-,Bold"8/28/2026 &"Arial,Bold"&11 ________________________________
Summary Data
| Compass Premium vs Claims | |
| Tempe Union High School District | Run Date: 8/27/2026 |
| 201656 | Start Date: 1/1/2020 |
| PREMIUM TYPE: Paid | End Date: 8/27/2026 |
| Policy # | Source Policy Number | Benefit | Billing Statement Date | Total Premium | Employee Premium | Dependent Premium | Total Claims | Employee Claims | Dependent Claims | Total Lives | Employee Lives | Dependent Lives | Volume |
| 201656 | 201656 | SUNADV | 1/1/2020 | 0.00 | 0.00 | 0 | 2174.90 | 2174.9 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 2/1/2020 | 0.00 | 0.00 | 0 | 384.93 | 384.93 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 5/1/2020 | 0.00 | 0.00 | 0 | 2483.93 | 2483.93 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 9/1/2020 | 0.00 | 0.00 | 0 | 4685.72 | 4685.72 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 1/1/2021 | 0.00 | 0.00 | 0 | 15329.19 | 15329.19 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 2/1/2021 | 0.00 | 0.00 | 0 | 4967.95 | 4967.95 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 8/1/2021 | 0.00 | 0.00 | 0 | 986.91 | 3428.57 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 8/1/2021 | 0.00 | 0.00 | 0 | 3428.57 | 3428.57 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 9/1/2021 | 0.00 | 0.00 | 0 | 1842.24 | 6400 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 9/1/2021 | 0.00 | 0.00 | 0 | 6400.00 | 6400 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 10/1/2021 | 0.00 | 0.00 | 0 | 2302.80 | 7200 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 10/1/2021 | 0.00 | 0.00 | 0 | 7200.00 | 7200 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 11/1/2021 | 0.00 | 0.00 | 0 | 855.33 | 6742.86 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 11/1/2021 | 0.00 | 0.00 | 0 | 6742.86 | 6742.86 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 1/1/2022 | 0.00 | 0.00 | 0 | 1028.57 | 1028.57 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 2/1/2022 | 0.00 | 0.00 | 0 | 3916.32 | 3916.32 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 3/1/2022 | 0.00 | 0.00 | 0 | 1790.80 | 1790.8 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 4/1/2022 | 0.00 | 0.00 | 0 | 1432.64 | 1432.64 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 5/1/2022 | 0.00 | 0.00 | 0 | 716.32 | 716.32 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 12/1/2022 | 0.00 | 0.00 | 0 | 326.82 | 326.82 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 1/1/2023 | 0.00 | 0.00 | 0 | 420.20 | 420.2 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 3/1/2023 | 0.00 | 0.00 | 0 | 503.50 | 503.5 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 4/1/2023 | 0.00 | 0.00 | 0 | 4222.93 | 4222.93 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 5/1/2023 | 0.00 | 0.00 | 0 | 6174.64 | 6174.64 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 6/1/2023 | 0.00 | 0.00 | 0 | 237.43 | 237.43 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 8/1/2023 | 0.00 | 0.00 | 0 | 2091.19 | 2091.19 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 9/1/2023 | 0.00 | 0.00 | 0 | 4211.81 | 4211.81 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 10/1/2023 | 0.00 | 0.00 | 0 | 8247.29 | 8247.29 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 11/1/2023 | 0.00 | 0.00 | 0 | 6907.69 | 6907.69 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 12/1/2023 | 0.00 | 0.00 | 0 | 8176.56 | 8176.56 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 1/1/2024 | 0.00 | 0.00 | 0 | 10997.82 | 10997.82 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 2/1/2024 | 0.00 | 0.00 | 0 | 9462.09 | 9462.09 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 3/1/2024 | 0.00 | 0.00 | 0 | 5197.46 | 5197.46 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 4/1/2024 | 0.00 | 0.00 | 0 | 3744.33 | 3744.33 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 5/1/2024 | 0.00 | 0.00 | 0 | 14182.68 | 14182.68 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 6/1/2024 | 0.00 | 0.00 | 0 | 2532.26 | 2532.26 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 7/1/2024 | 0.00 | 0.00 | 0 | 6429.25 | 6429.25 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 8/1/2024 | 0.00 | 0.00 | 0 | 4450.27 | 4450.27 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 9/1/2024 | 0.00 | 0.00 | 0 | 5853.67 | 5853.67 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 10/1/2024 | 0.00 | 0.00 | 0 | 9694.26 | 9694.26 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 11/1/2024 | 0.00 | 0.00 | 0 | 10720.57 | 10720.57 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 12/1/2024 | 0.00 | 0.00 | 0 | 8301.55 | 8301.55 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 1/1/2025 | 0.00 | 0.00 | 0 | 8987.33 | 8987.33 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 2/1/2025 | 0.00 | 0.00 | 0 | 12377.57 | 12377.57 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 3/1/2025 | 0.00 | 0.00 | 0 | 10770.17 | 10770.17 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 4/1/2025 | 0.00 | 0.00 | 0 | 9392.39 | 9392.39 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 5/1/2025 | 0.00 | 0.00 | 0 | 7888.64 | 7888.64 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 6/1/2025 | 0.00 | 0.00 | 0 | 7911.20 | 7911.2 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 7/1/2025 | 0.00 | 0.00 | 0 | 6296.33 | 6296.33 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 8/1/2025 | 0.00 | 0.00 | 0 | 4000.00 | 4000 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 9/1/2025 | 0.00 | 0.00 | 0 | 3200.00 | 3200 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 10/1/2025 | 0.00 | 0.00 | 0 | 1600.00 | 1600 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 4/1/2026 | 0.00 | 0.00 | 0 | 4855.48 | 4855.48 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 5/1/2026 | 0.00 | 0.00 | 0 | 1919.43 | 1919.43 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 6/1/2026 | 0.00 | 0.00 | 0 | 8035.33 | 8035.33 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 7/1/2026 | 0.00 | 0.00 | 0 | 5176.80 | 5176.8 | 0 | 0 | 0 | 0 | 0.00 |
| 201656 | 201656 | SUNADV | 8/1/2026 | 0.00 | 0.00 | 0 | 2065.63 | 2065.63 | 0 | 0 | 0 | 0 | 0.00 |
| Benefit Totals | 0.00 | 0.00 | 0.00 | 296,232.55 | 314,016.70 | 0.00 |
*Employee and dependent premium are combined for Life and ADD benefits *In situations where a policy has multiple bills, data will be displayed as of the date all accounts are paid. In these situations, lives, volume and premium may vary from prior months.
image1.jpg image2.png
File details come from the government source that posted it. Updated .