Appendix%207.15%20Simplified%20Wellness%20Activity%20Layout.xlsx

This is a data file layout specification document for the State of Tennessee's Third Party Administrator Services for the State's Public Sector Health Plans, outlining the required format for submitting wellness activity completion data from worksite health programs. The document establishes a fixed-width or CSV file format for reporting member health challenge completions, with each row representing one member per completion event. The specification requires that initial data transmissions contain only the latest member responses, with subsequent submissions including only new or changed responses since the previous submission. Production files must follow a standardized naming convention (Client_HRA_YYYYMMDD.csv) and include specific data elements positioned at defined column locations, including member demographic information (sex, date of birth, first and last names), Social Security numbers for both members and subscribers, data type classification, custom data descriptions (such as WELLNESS_ACTIVITY1, WELLNESS_ACTIVITY2, or WELLNESS_ACTIVITY3), and completion date stamps in YYYY-MM-DD format.

The file layout specifies 18 distinct data fields distributed across 318 total character positions, with designated blank columns interspersed throughout the fixed-width format to maintain structural consistency. Member sex must be recorded as a single character (M/F), date of birth in YYYYMMDD format, and the data description field indicates completion by its presence in the file, with descriptions assigned by designated administrators. The document includes a sample data file demonstrating proper formatting with three example records showing different wellness activity types completed on specified dates. This specification ensures standardized data collection and reporting for tracking member participation in employer-sponsored wellness initiatives across Tennessee's public sector health plans.