RFP%2031786-00193%20Appendix%207.9%20Monthly%20Premiums%20Due%20Deduction%20File%20Layout.xlsx

This is a technical specification document for the State of Tennessee's monthly premiums due deduction file layout, related to a Life and Accidental Death and Dismemberment Insurance contract (RFP 31786-00193). The document establishes the data structure and field requirements for transmitting employee insurance premium deduction records to the state's billing system on a monthly basis, processing both new enrollments (ADD) and changes to existing coverage (CHG), but excluding terminations.

The file layout specifies a fixed-length record format with a total record length of 160 characters, containing 18 distinct data fields that capture essential employee and premium information. Key fields include the billing source code (always 'PR'), change type designation, date-time stamp with sequence numbering for multiple deductions, transaction type (always 'OD'), employee Social Security Number, last name, five-digit department identification code, program identifier, current premium amount due, due date, Edison Employee ID, and division code. The specification requires low-value entries for multiple filler fields and establishes precise character positions and lengths for each data element, enabling systematic processing of monthly premium adjustments across the state's employee population.