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 is a technical specification document for RFP 31786-00186, detailing the file layout and data requirements for a Short-Term Disability (STD) and Long-Term Disability (LTD) Decision Support System. The document serves as an example contractor specification for data structure and field definitions that must be incorporated into the system. The specification outlines the required data fields, including member eligibility information, employee identification details, and disability case management data elements. No specific response dates, due dates, site visits, bidder meetings, award dates, or contract terms are identified in this technical specification document.
The specification defines data requirements across multiple categories including plan identification, member demographics (name, employee ID, Social Security number), STD-specific metrics (calendar days absent, case base payment, case payment amounts, offset amounts, supplemental pay), case management information (case ID, status, diagnosis, close events), and return-to-work dates for both restricted and full-duty assignments. The document establishes standardized data field types (character, numeric, and date formats) and descriptions necessary for the contractor to develop or integrate the decision support system. No pricing terms, set asides, incumbent information, funding sources, or other financial details are included in this technical layout specification.
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 .