RFP%2031786-00193%20Appendix%207.7%20BA067%20Weekly%20Enrollment%20File%20Layout.xlsx

This file is a technical specification document for the Weekly Enrollment File Layout (BA067) related to RFP 31786-00193 for the State of Tennessee's Life and Accidental Death and Dismemberment Insurance eligibility program. The document outlines the data structure and field requirements for weekly enrollment files submitted to the eligibility system, specifying 30 data fields with their corresponding format types, field positions, lengths, and source tables. The file layout captures essential employee information including personal demographics (name, sex, birthdate, marital status), employment details (hire date, appointment date, appointment type, annual salary, county of work), identification numbers (SSN, user ID), contact information (address, city, state, zip code, email), and eligibility-related data (ineligible reason, ineligible status date, DOP backout flag). The source code is designated as TENN-INSR, with timestamps recorded in CCYYMMDD format to track when files are created.

This technical specification serves as a data mapping document that establishes standardized requirements for how employee enrollment information must be formatted and transmitted to the Tennessee insurance eligibility system. The file includes provisions for higher education transfers (designated with XFR display) and establishes field specifications that interface with PeopleSoft tables and the state's payroll and human resources systems. The document indicates that the eligibility file runs by effective date, allowing for extraction of the last run date from system parameters. This specification document is essential for vendors and system administrators responsible for generating, validating, and submitting weekly enrollment data to ensure compliance with the state's insurance administration and eligibility determination processes.