Appendix_7.15_RFP%2031786-00186_MetLife%20September%202025.xlsx

XLSX spreadsheet 14 KB Posted

Attached to
Short-Term Disability And Long-Term Disability Insurance - UPDATED
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

File Type Posted
Appendix_7.15_RFP%2031786-00186_MetLife%20September%202025.xlsx XLSX spreadsheet
Appendix_7.11_RFP%2031786-00186%20Written%20Questions%20and%20Comments%20template.docx DOCX document
Appendix_7.19_RFP_31786-00186%20Marketing%20and%20Communications%20Plan.xlsx XLSX spreadsheet
RFP_31786-00186_Amendment%20_5.pdf PDF
Appendix_7.22_RFP_31786-00186%20Sample%20Customized%20Communication%20Materials.pdf PDF
Appendix_7.13_RFP%2031786-00186_161596%20MetLife%20LTD%20Certificate%20of%20Coverage%20Eff.%20March%202021.pdf PDF
Appendix_7.18_RFP_31786-00186%20Disability%20Census%20as%20of%20December%202023.xlsx XLSX spreadsheet
Appendix_7.1_RFP_31786-00186%20Retirement%20Plan%20Guides.pdf PDF
Appendix_7.3a_RFP_31786-00186%20MetLife%20STD%20Certificate%20of%20Coverage.pdf PDF
Appendix_7.5_RFP_31786-00186%20Disability%20Census%20REVISED.xlsx XLSX spreadsheet
Appendix_7.12_RFP%2031786-00186_161596%20MetLife%20LTD%20Certificate%20of%20Coverage%20Eff.%20Jan%202018.pdf PDF
Appendix_7.10_%20RFP_31786-00186%20FICA%20Tax%20Amounts%20Paid.xlsx XLSX spreadsheet
31786_00186_Short_and_Long_Term_Disability_Release_Two_for_posting.pdf PDF
Appendix_7.14_RFP%2031786-00186_161596%20MetLife%20LTD%20Certificate%20of%20Coverage%20Eff.%20Jan%202022.pdf PDF
Appendix_7.17_RFP_MetLife_Weekly_Disability_File_Transmission_Report_09-14-2025.pdf PDF
RFP%2031786-00186%20Amendment%20One.pdf PDF
Appendix_7.7_RFP_31786-00186%20Example%20Contractor%20STD%20LTD%20Decision%20Support%20System%20File%20Layout%20REVISED.xlsx XLSX spreadsheet
RFP_31786-00186_Amendment_Two.pdf PDF
Appendix_7_20_RFP_31786-00186_Communications_Efforts_Report.pdf PDF
Appendix_7.3c_RFP_31786-00186%20MetLife%20LTD%20Non-contributory%20Certificate%20of%20Coverage.pdf PDF
Disability_RFP_31786-00186_Attachment_6_3_Cost_Proposal_Scoring_Guide_REVISED.xlsx XLSX spreadsheet
31786_00186_Short_and_Long_Term_Disability_Release_Four.pdf PDF
Digital_Submission_Instructions.pdf PDF
RFP_31786_00186.pdf PDF
Appendix_7.3b_RFP_31786-00186%20MetLife%20LTD%20Contributory%20Certifcate%20of%20Coverage.pdf PDF
RFP%2031786-00186%20Amendment%20Four.pdf PDF
Appendix_7_6_RFP_31786-00186_Eligibility_Criteria_REVISED.pdf PDF
RFP_31786-00186_Amendment_Six.pdf PDF
RFP_31786-00186_Amendment_Three.pdf PDF
Appendix_7.8_RFP_31786-00186%20Claims%20History%20and%20P%20and%20L%20-%20REVISED.xlsx XLSX spreadsheet
Appendix_7.21_RFP_31786-00186%20Scorecard.xlsx XLSX spreadsheet
Appendix_7.9_RFP_31786-00186%20Disability%20Plan%20Changes%20Effective%20January%201%2c%202027%20REVISED.pdf PDF
Appendix_7.4%20RFP_31786-00186%20Enrollment%20and%20Premium%20History.xlsx XLSX spreadsheet
Appendix_7.2%20RFP_31786-00186%20State%20of%20TN%20Attendance%20and%20Leave%20Manual.pdf PDF
Appendix_7_16_RFP_31786-00186_STD_and_LTD_Premium_Rates.pdf PDF
Event_31786_00186_Release_3.pdf PDF
Appendix_7.1_RFP_31786-00186%20Retirement%20Plan%20Guides.pdf PDF
Appendix_7.22_RFP_31786-00186%20Sample%20Customized%20Communication%20Materials.pdf PDF
Appendix_7.4%20RFP_31786-00186%20Enrollment%20and%20Premium%20History.xlsx XLSX spreadsheet
Appendix_7.7_RFP_31786-00186%20Example%20Contractor%20STD%20LTD%20Decision%20Support%20System%20File%20Layout%20REVISED.xlsx XLSX spreadsheet
Appendix_7.18_RFP_31786-00186%20Disability%20Census%20as%20of%20December%202023.xlsx XLSX spreadsheet
RFP_31786-00186_Amendment_Two.pdf PDF
Appendix_7.2%20RFP_31786-00186%20State%20of%20TN%20Attendance%20and%20Leave%20Manual.pdf PDF
RFP_31786_00186.pdf PDF
Appendix_7.9_RFP_31786-00186%20Disability%20Plan%20Changes%20Effective%20January%201%2c%202027%20REVISED.pdf PDF
Appendix_7.17_RFP_MetLife_Weekly_Disability_File_Transmission_Report_09-14-2025.pdf PDF
Appendix_7.8_RFP_31786-00186%20Claims%20History%20and%20P%20and%20L%20-%20REVISED.xlsx XLSX spreadsheet
RFP_31786-00186_Amendment_Three.pdf PDF
31786_00186_Short_and_Long_Term_Disability_Release_Two_for_posting.pdf PDF
RFP_31786-00186_Amendment%20_5.pdf PDF
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 NameDeduction CodeFund CodePlan DescriptionSum of CountSum of Sum Current Deduction
Metropolitan Life Insurance CompanyLTD55000Long Term Disab Plan 1: 0-2993.00226.99
Long Term Disab Plan 1: 30-3457.00157.97
Long Term Disab Plan 1: 35-3970.00366.05
Long Term Disab Plan 1: 40-4454.00443.00
Long Term Disab Plan 1: 45-4968.00693.92
Long Term Disab Plan 1: 50-5456.00760.84
Long Term Disab Plan 1: 55-5953.00720.72
Long Term Disab Plan 1: 60-6435.00635.25
Long Term Disab Plan 1: 65-6917.00331.27
Long Term Disab Plan 1: 70+3.0047.22
Long Term Disab Plan 2: 0-2955.00118.79
Long Term Disab Plan 2: 30-3463.00143.67
Long Term Disab Plan 2: 35-3950.00207.66
Long Term Disab Plan 2: 40-4449.00362.39
Long Term Disab Plan 2: 45-4969.00651.76
Long Term Disab Plan 2: 50-5455.00610.46
Long Term Disab Plan 2: 55-5945.00554.92
Long Term Disab Plan 2: 60-6441.00777.83
Long Term Disab Plan 2: 65-6911.00211.08
Long Term Disab Plan 2: 70+8.00118.21
Long Term Disab Plan 3 Employee Paid: 0-296.0017.98
Long Term Disab Plan 3 Employee Paid: 30-346.0025.78
Long Term Disab Plan 3 Employee Paid: 35-395.0041.03
Long Term Disab Plan 3 Employee Paid: 40-443.0040.28
Long Term Disab Plan 3 Employee Paid: 45-493.0057.49
Long Term Disab Plan 3 Employee Paid: 50-546.0057.87
Long Term Disab Plan 3 Employee Paid: 55-595.0071.10
Long Term Disab Plan 3 Employee Paid: 65-691.0026.83
Long Term Disab Plan 3 Employer Paid: 0-297,990.0096,403.41
Long Term Disab Plan 3 Employer Paid: 30-347,514.00109,555.37
Long Term Disab Plan 3 Employer Paid: 35-398,481.00138,113.01
Long Term Disab Plan 3 Employer Paid: 40-448,687.00150,955.18
Long Term Disab Plan 3 Employer Paid: 45-499,074.00162,256.19
Long Term Disab Plan 3 Employer Paid: 50-549,342.00167,442.22
Long Term Disab Plan 3 Employer Paid: 55-598,632.00156,807.12
Long Term Disab Plan 3 Employer Paid: 60-646,886.00122,802.94
Long Term Disab Plan 3 Employer Paid: 65-693,283.0062,231.57
Long Term Disab Plan 3 Employer Paid: 70+1,647.0033,383.24
Long Term Disab Plan 4: 0-29250.00651.31
Long Term Disab Plan 4: 30-34232.00659.22
Long Term Disab Plan 4: 35-39160.00853.65
Long Term Disab Plan 4: 40-44125.001,057.90
Long Term Disab Plan 4: 45-49104.001,120.41
Long Term Disab Plan 4: 50-54108.001,518.18
Long Term Disab Plan 4: 55-5962.001,033.73
Long Term Disab Plan 4: 60-6460.001,038.72
Long Term Disab Plan 4: 65-6916.00257.49
Long Term Disab Plan 4: 70+13.00199.25
LTD Total73,653.001,216,818.47
STD55000Short Term Disab Higher Ed Plan A3,139.0066,165.62
Short Term Disab Higher Ed Plan B2,864.0054,736.16
Short Term Disab State Plan A3,787.0075,849.45
Short Term Disab State Plan B4,005.0070,048.35
STD Total13,795.00266,799.58
Grand Total87,448.001,483,618.05

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