RFP%2031786-00193%20Appendix%207.8%20BA066%20Weekly%20Termination%20File%20Layout.xlsx

This is a data file layout specification document for RFP 31786-00193 detailing the weekly termination file format (BA066) for the Tennessee state and local life and accidental death and dismemberment insurance program. The document provides technical specifications for data mapping between source systems and PeopleSoft, defining 48 fields that comprise a 270-character record structure. The file includes employee termination data elements such as personal identifiers (SSN, name, date of birth), employment information (business unit, department, location codes), address details, life insurance coverage information (benefit plan, coverage amount, effective and termination dates), and termination reason codes. The layout specifies field positions, lengths, data formats (character, number, date), and source table references for each data element, with a timestamp indicating the file should contain the run date and time in YYYYMMDDHHMMSSSS format.

The document includes two supporting reference tables: a Group Code Translation table mapping PeopleSoft business unit codes to employee categories (state active, state retiree, local government active/retiree, and local education active/retiree classifications), and a Reason Code Translation table identifying 26 termination reason codes such as death, resignation, dismissal, job abandonment, and gross misconduct. Default values are specified for certain fields, including the source code "TENN-INSR," transaction type "TB," user ID "EDISON," and PPLI switch "N." The file layout establishes standardized data transmission protocols for processing employee terminations across Tennessee's multi-agency insurance program, enabling consistent reporting and administration of life insurance coverage changes across state, local government, and local education entities.