RFP%2031786-00193%20Appendix%207.11%20BA246%20Annual%20Head%20of%20Contract%20Life%20Insurance%20Reduction%20File%20Layout.xlsx

This file is a data layout specification for the State of Tennessee's Life and Accidental Death and Dismemberment Insurance contract (RFP 31786-00193, Appendix 7.11 BA246). The document defines the required structure and format for annual head of contract life insurance reduction files that vendors must process and submit. The specification includes thirteen data fields with defined formats and data types: Employee ID (character, 11 digits), Employee Record Number (numeric, 3.0 decimal places), Department ID (character, 10 digits), First Name (character, 30 digits), Last Name (character, 30 digits), Address 1 (character, 100 digits), Address 2 (character, 55 digits), City (character, 30 digits), State (character, 6 digits), Postal Code (character, 12 digits), Coverage Begin Date (date format), Age (numeric, 3.0 decimal places), Birthdate (date format), Old Coverage Amount (numeric, 8.2 decimal places), and New Coverage Amount (numeric, 8.2 decimal places).

This technical specification establishes the standardized data format requirements for processing annual reductions in life insurance coverage amounts for Tennessee state employees. The file layout ensures that vendors can accurately receive, process, and manage employee insurance reduction transactions with consistent data field definitions and formatting standards across all submissions.