Appendix_7.7_RFP_31786-00186%20Example%20Contractor%20STD%20LTD%20Decision%20Support%20System%20File%20Layout%20REVISED.xlsx
XLSX spreadsheet 11 KB Posted
- Solicitation number
- RFP 31786-00186
- Issued by
- Davidson County, Tennessee
About this file
This file is a data layout specification document for the State of Tennessee's Department of Finance and Administration's Short-Term Disability (STD) and Long-Term Disability (LTD) Insurance procurement (RFP #31786-00186). The specification defines the required file structure and data elements that the selected contractor must use for the decision support system to manage disability claims and member information. The RFP seeks a single fully-insured contractor to administer voluntary STD coverage (100% employee-paid) and mandatory LTD-N coverage (100% employer-paid) for central state government and state higher education agency employees, covering approximately 10,000+ members. Implementation activities occur from March 2026 through December 2026, with benefits commencing January 1, 2027. Critical procurement dates include a pre-response conference on September 10, 2025, a written questions deadline of September 17, 2025, a proposal response deadline of November 21, 2025, technical evaluations by January 6, 2026, cost proposal scoring on January 7, 2026, and contract negotiations scheduled for January 12-14, 2026. The contract term spans 70 months total, consisting of 10 months of implementation and 60 months of benefit delivery through December 31, 2031.
The data layout specification establishes mandatory fields for tracking member eligibility information, case management details, STD-specific payment metrics, and return-to-work dates. Required data elements include employee identification, calendar days absent, case payment amounts, offsets, case status codes, diagnosis information, and dates for return to full and restricted duty. Contractor compensation is structured as per-member monthly premiums for both STD and LTD coverage. The evaluation criteria allocate 40 points to technical qualifications, 10 points to general qualifications and experience, and 50 points to cost proposals. Respondents must demonstrate six years of disability insurance administration experience, including at least five employer accounts with one account having 10,000+ members, and must possess a current Tennessee Certificate of Authority for group disability benefits. The incumbent vendor, Metropolitan Life Insurance Company (MetLife), will transition all current plan members to the new contractor on January 1, 2027, with guaranteed issue coverage and pre-existing condition limitation credits applied based on prior enrollment length. The contract includes performance requirements with at-risk payments tied to service level agreements and potential liquidated damages for failures to meet implementation milestones, plan design accuracy, and data security standards.
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
Sheet1
| Appendix_7.7 RFP_31786-00186 Example Contractor STD LTD Decision Support System File Layout REVISED |
| Layout LTD/STD |
| Name | Type | Description |
| Plan | CHAR |
| Eligibility / Member Data | CHAR | First Name |
| CHAR | Last Name | |
| NUMERIC | Employee ID | |
| NUMERIC | SSN |
Calendar Days Absent STD NUMERIC The total number of calendar days absent to date for the STD benefit.
Case Base Payment STD NUMERIC Amount of disability payments paid by the employer for STD lost time.
Case Close Event Disability CHAR Client-specific code for the event which closed the disability case.
Case ID CHAR A client-specific unique identifier for the case.
Case Offset Amount STD NUMERIC Total amount of the offset(s) to date applied to reduce the gross STD benefit
Case Payment STD NUMERIC Total $ of STD payments to date paid to the employee (I.e., gross disability benefits less offsets).
Diagnosis CHAR
| Case Status | CHAR | Current status code of the disability case. |
| Closed | ||
| Denied | ||
| Open | ||
| Reopened |
Case Supplemental Pay Amount STD NUMERIC Total disability payments (gross less offsets) attributable to the employee-funded STD benefit.
Date Pay Period Start STD DATE The end date for the period of disability covered by the payment (STD).
Date Pay Period End STD DATE The end date for the period of disability covered by the payment (STD).
Date Return to Full Duty STD DATE The date on which the employee returned to full-duty (unrestricted) work (STD).
Date Return to Restricted Duty STD DATE The date on which the employee returned to work on a restricted basis (modified-duty).
File details come from the government source that posted it. Updated .