RFP%2031786-00193%20Appendix%207.10%20Monthly%20Premiums%20Collected%20File%20Layout.xlsx

This is a technical file specification document (Appendix 7.10) for RFP 31786-00193 related to Tennessee's Life and Accidental Death and Dismemberment Insurance program, detailing the required format and field layout for the Monthly Premiums Collected file submission. The specification defines 18 data fields with precise positioning, field lengths, and content requirements that vendors must follow when submitting premium collection records. Key fields include source code identifier, file creation timestamp, transaction type codes, employee identifiers (partial Social Security number and last name), group code, budget code, program ID, current premium collected amounts, original due dates, and certification dates. The file uses a fixed-length format with specific character positions and data types (alphanumeric strings, numeric values with decimal precision) to ensure consistent data structure and integration with the state's PeopleSoft system.

The file specification includes detailed business rules governing data validation, particularly concerning deduction codes (PERMA, TERMCH, TERMEE, TERMSP, UNUMSG, UNUMSP, UNUMCH) and transaction type assignments based on premium collection status and plan characteristics. The document establishes standardized codes for different insurance categories, such as term life for employee, spouse, and child coverage, as well as permanent life insurance options. Date calculations are specified for original due dates based on pay period end dates, with month-dependent logic to account for calendar variations. Vendors must strictly adhere to these technical requirements, including proper handling of filler fields (spaces) and field length constraints, to ensure successful file transmission and processing within the state's benefits administration system.