# Hawaii 1/25/2024 data submission feedback

The file submitted on 1/25/2024 for FY24Q1 could not be processed. To help resolve this, we have included details and recommendations for each file below. In brief, the records in the file do not follow the expected record layout.

## Summary

Below is a summary of the Section 1 file (`TANF_FY2024_QTR1A_ACTIVE.txt`) submitted on 1/25/2024. It includes record counts and lengths by record type and reporting month, where applicable.

<div>
<style scoped>
.dataframe tbody tr th:only-of-type {
vertical-align: middle;
}

.dataframe tbody tr th {
vertical-align: top;
}

.dataframe thead th {
text-align: right;
}
</style>
<table border="1" class="dataframe">
<thead>
<tr style="text-align: right;">
<th></th>
<th>RecordType</th>
<th>RPT_MONTH_YEAR</th>
<th>RecordLength</th>
<th>RecordCount</th>
</tr>
</thead>
<tbody>
<tr>
<th>0</th>
<td>HE</td>
<td> <i>N/A</i> </td>
<td>23</td>
<td>1</td>
</tr>
<tr>
<th>1</th>
<td><mark>T1</mark></td>
<td><mark>202310</mark></td>
<td><mark>117</mark></td>
<td><mark>3309</mark></td>
</tr>
<tr>
<th>2</th>
<td><mark>T1</mark></td>
<td><mark>202311</mark></td>
<td><mark>117</mark></td>
<td><mark>3318</mark></td>
</tr>
<tr>
<th>3</th>
<td><mark>T1</mark></td>
<td><mark>202312</mark></td>
<td><mark>117</mark></td>
<td><mark>3184</mark></td>
</tr>
<tr>
<th>4</th>
<td>T2</td>
<td>202310</td>
<td>156</td>
<td>3334</td>
</tr>
<tr>
<th>5</th>
<td>T2</td>
<td>202311</td>
<td>156</td>
<td>3337</td>
</tr>
<tr>
<th>6</th>
<td>T2</td>
<td>202312</td>
<td>156</td>
<td>3174</td>
</tr>
<tr>
<th>7</th>
<td><mark>T3</td>
<td><mark>202310</td>
<td><mark>89</td>
<td><mark>1</td>
</tr>
<tr>
<th>8</th>
<td><mark>T3</mark></td>
<td><mark>202310</mark></td>
<td><mark>97</mark></td>
<td><mark>2107</mark></td>
</tr>
<tr>
<th>9</th>
<td><mark>T3</mark></td>
<td><mark>202310</mark></td>
<td><mark>101</mark></td>
<td><mark>2233</mark></td>
</tr>
<tr>
<th>10</th>
<td><mark>T3</mark></td>
<td><mark>202311</mark></td>
<td><mark>97</mark></td>
<td><mark>2122</mark></td>
</tr>
<tr>
<th>11</th>
<td><mark>T3</mark></td>
<td><mark>202311</mark></td>
<td><mark>101</mark></td>
<td><mark>2228</mark></td>
</tr>
<tr>
<th>12</th>
<td><mark>T3</mark></td>
<td><mark>202312</mark></td>
<td><mark>97</mark></td>
<td><mark>2043</mark></td>
</tr>
<tr>
<th>13</th>
<td><mark>T3</mark></td>
<td><mark>202312</mark></td>
<td><mark>101</mark></td>
<td><mark>2144</mark></td>
</tr>
<tr>
<th>14</th>
<td><mark>TR</mark></td>
<td><mark><i>N/A</i></mark></td>
<td><mark>14</mark></td>
<td><mark>1</mark></td>
</tr>
</tbody>
</table>
</div>

The <mark>highlighted</mark> rows in this table indicate what is preventing this file from being processed successfully.

### T1

The `T1` records --which refer to the `Active FAMILY` records in the file-- are too short (`RecordLength is 117`). The expected length of this record is `156` (Note: this expected length includes `39` trailing spaces after the value for item #29: _Is the TANF Family A New Child-Only Family?_). See [**record layout**](https://www.acf.hhs.gov/sites/default/files/documents/ofa/ACF-199-%26amp%3B-209-TANF-SSP-data-report-layouts-thru-2026-10.xlsx) and snapshot below for reference:


### T3

Additionally, the expected length for the `T3` records (which refer to the `Active CHILD` records in the file) is also `156`, but the `T3` records in the file have lengths that range between `89` and `101`. Please note:

- For `T3` records that include data for 1 child, there should be `96` trailing blanks or spaces after the value for item #77B: _Other Unearned Income_
- For `T3` records that include data for 2 children, there should be `55` trailing blanks or spaces after the value for item #77B: _Other Unearned Income_

See [**record layout**](https://www.acf.hhs.gov/sites/default/files/documents/ofa/ACF-199-%26amp%3B-209-TANF-SSP-data-report-layouts-thru-2026-10.xlsx) snapshot and examples below for reference:

# example of a correctly formatted T3 record with 1 child
T3202310112233355131200404077654234752222112204305100000000                                                                                                 

# example of a correctly formatted T3 record with 2 children
T320231011111111151220170525WTTTT@BYY12222112204399400000000220151113WTTTT9TTY12222122204399                                                                


### Trailer
- The `TRAILER` record --which is the last record in the file--is too short (`RecordLength is 14`). As documented [**here**](https://www.acf.hhs.gov/sites/default/files/documents/ofa/transmission_file_header_trailer_record.pdf), the expected length of this record is `23` (Note: this expected length includes 9 trailing blanks or spaces after the number of records). See below and the reference above for recommendation on how to resolve:

    # Current
    TRAILER0032534

    # Correction
    TRAILER0032534