Appendix_7.15_RFP%2031786-00186_MetLife%20September%202025.xlsx
XLSX spreadsheet 14 KB Posted
- Solicitation number
- RFP 31786-00186
- Issued by
- Davidson County, Tennessee
About this file
This is a pass-through payment appendix for a Long-Term Disability (LTD) and Short-Term Disability (STD) insurance contract with Metropolitan Life Insurance Company for September 2025, associated with RFP 31786-00186. The file documents enrollment and payment data organized by plan type, age bracket, and employment status. The contract covers multiple LTD plans (Plans 1-4) with varying participation structures, including employer-paid and employee-paid options across age groups ranging from 0-29 years to 70+ years. Additionally, the file includes STD coverage data for both higher education and state employee populations, segmented into Plan A and Plan B offerings for each category.
The appendix reflects significant enrollment volumes and associated financial commitments for the September 2025 period. Total LTD enrollment spans 73,653 participants with cumulative pass-through payments of $1,216,818.47, while STD enrollment totals 13,795 participants with pass-through payments of $266,799.58. The Grand Total reflects 87,448 covered employees with aggregate payments of $1,483,618.05. Plan 3 (Employer Paid) represents the largest enrollment segment, indicating substantial employer-subsidized disability coverage. The data uses deduction code 55000 across all plans, with cost distribution varying by age bracket and plan structure, demonstrating differentiated risk assessment and premium structures typical of disability insurance underwriting practices.
View the file
Other files
Show 40 more
Latest 50 of 69 listed here. See the rest on GovTribe.
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
Dis with Plan
| September 2025 Pass Through Payments | |||||
| Vendor Name | Deduction Code | Fund Code | Plan Description | Sum of Count | Sum of Sum Current Deduction |
| Metropolitan Life Insurance Company | LTD | 55000 | Long Term Disab Plan 1: 0-29 | 93.00 | 226.99 |
| Long Term Disab Plan 1: 30-34 | 57.00 | 157.97 | |||
| Long Term Disab Plan 1: 35-39 | 70.00 | 366.05 | |||
| Long Term Disab Plan 1: 40-44 | 54.00 | 443.00 | |||
| Long Term Disab Plan 1: 45-49 | 68.00 | 693.92 | |||
| Long Term Disab Plan 1: 50-54 | 56.00 | 760.84 | |||
| Long Term Disab Plan 1: 55-59 | 53.00 | 720.72 | |||
| Long Term Disab Plan 1: 60-64 | 35.00 | 635.25 | |||
| Long Term Disab Plan 1: 65-69 | 17.00 | 331.27 | |||
| Long Term Disab Plan 1: 70+ | 3.00 | 47.22 | |||
| Long Term Disab Plan 2: 0-29 | 55.00 | 118.79 | |||
| Long Term Disab Plan 2: 30-34 | 63.00 | 143.67 | |||
| Long Term Disab Plan 2: 35-39 | 50.00 | 207.66 | |||
| Long Term Disab Plan 2: 40-44 | 49.00 | 362.39 | |||
| Long Term Disab Plan 2: 45-49 | 69.00 | 651.76 | |||
| Long Term Disab Plan 2: 50-54 | 55.00 | 610.46 | |||
| Long Term Disab Plan 2: 55-59 | 45.00 | 554.92 | |||
| Long Term Disab Plan 2: 60-64 | 41.00 | 777.83 | |||
| Long Term Disab Plan 2: 65-69 | 11.00 | 211.08 | |||
| Long Term Disab Plan 2: 70+ | 8.00 | 118.21 | |||
| Long Term Disab Plan 3 Employee Paid: 0-29 | 6.00 | 17.98 | |||
| Long Term Disab Plan 3 Employee Paid: 30-34 | 6.00 | 25.78 | |||
| Long Term Disab Plan 3 Employee Paid: 35-39 | 5.00 | 41.03 | |||
| Long Term Disab Plan 3 Employee Paid: 40-44 | 3.00 | 40.28 | |||
| Long Term Disab Plan 3 Employee Paid: 45-49 | 3.00 | 57.49 | |||
| Long Term Disab Plan 3 Employee Paid: 50-54 | 6.00 | 57.87 | |||
| Long Term Disab Plan 3 Employee Paid: 55-59 | 5.00 | 71.10 | |||
| Long Term Disab Plan 3 Employee Paid: 65-69 | 1.00 | 26.83 | |||
| Long Term Disab Plan 3 Employer Paid: 0-29 | 7,990.00 | 96,403.41 | |||
| Long Term Disab Plan 3 Employer Paid: 30-34 | 7,514.00 | 109,555.37 | |||
| Long Term Disab Plan 3 Employer Paid: 35-39 | 8,481.00 | 138,113.01 | |||
| Long Term Disab Plan 3 Employer Paid: 40-44 | 8,687.00 | 150,955.18 | |||
| Long Term Disab Plan 3 Employer Paid: 45-49 | 9,074.00 | 162,256.19 | |||
| Long Term Disab Plan 3 Employer Paid: 50-54 | 9,342.00 | 167,442.22 | |||
| Long Term Disab Plan 3 Employer Paid: 55-59 | 8,632.00 | 156,807.12 | |||
| Long Term Disab Plan 3 Employer Paid: 60-64 | 6,886.00 | 122,802.94 | |||
| Long Term Disab Plan 3 Employer Paid: 65-69 | 3,283.00 | 62,231.57 | |||
| Long Term Disab Plan 3 Employer Paid: 70+ | 1,647.00 | 33,383.24 | |||
| Long Term Disab Plan 4: 0-29 | 250.00 | 651.31 | |||
| Long Term Disab Plan 4: 30-34 | 232.00 | 659.22 | |||
| Long Term Disab Plan 4: 35-39 | 160.00 | 853.65 | |||
| Long Term Disab Plan 4: 40-44 | 125.00 | 1,057.90 | |||
| Long Term Disab Plan 4: 45-49 | 104.00 | 1,120.41 | |||
| Long Term Disab Plan 4: 50-54 | 108.00 | 1,518.18 | |||
| Long Term Disab Plan 4: 55-59 | 62.00 | 1,033.73 | |||
| Long Term Disab Plan 4: 60-64 | 60.00 | 1,038.72 | |||
| Long Term Disab Plan 4: 65-69 | 16.00 | 257.49 | |||
| Long Term Disab Plan 4: 70+ | 13.00 | 199.25 | |||
| LTD Total | 73,653.00 | 1,216,818.47 | |||
| STD | 55000 | Short Term Disab Higher Ed Plan A | 3,139.00 | 66,165.62 | |
| Short Term Disab Higher Ed Plan B | 2,864.00 | 54,736.16 | |||
| Short Term Disab State Plan A | 3,787.00 | 75,849.45 | |||
| Short Term Disab State Plan B | 4,005.00 | 70,048.35 | |||
| STD Total | 13,795.00 | 266,799.58 | |||
| Grand Total | 87,448.00 | 1,483,618.05 |
File details come from the government source that posted it. Updated .