Skip to Content

Abbreviated ICESA Format for Wage Reporting

  • Data must be sent in ASCII Text Format.
  • All Records must have carriage return/line feed.
  • External Label must be included with employer name, quarter year and contact person's name and phone number.
 
E-RECORD
         
LOCATION FIELD NAME LENGTH TYPE DESCRIPTION
1 - 1 Record Identifier 1 A/N Constant "E" --denotes E record
2 - 5 Payment Year 4 A/N 4 digit year of the report being prepared
6 - 14 Federal EIN 9 A/N Numberic characters only--Omit hyphens or other editing
15 - 160 Filler 146 A/N Enter spaces
161 - 162 Blocking Factor 2 A/N Must be "25"
163 - 170 Filler 8 A/N Enter spaces
171 - 172 State identifier code 2 A/N Must be "47" for Tennessee employers
173 - 180 Tennessee Unemployment Insurance Employer Account Number 8 A/N 8-digit number employer account number found on the quarterly premium report--Omit any hyphens or other editing
181 - 187 Filler 7 A/N Enter spaces
188 - 189 Reporting Period 2 A/N Enter the last month of the calendar quarter to which the report applies:
"03" --- First quarter
"06" --- Second quarter
"09" --- Third quarter
"12" --- Fourth quarter
190 Filler 1 N Enter zeros
191 - 275 Filler 85 A/N Enter spaces
 
S - RECORD
         
LOCATION FIELD NAME LENGTH TYPE DESCRIPTION
1 - 1 Record Identified 1 A/N Constant "S" -- denotes S record
2 - 10 Social Security Number 9 A/N Employee's social security number--if not known enter "l" in position '2' and blanks in positions '3' - '10'
11 - 30 Employee's Last Name 20 A/N Employee's Last Name
31 - 42 Employee's First Name 12 A/N Employee's First Name
43 - 43 Employee's Middle Initial 1 A/N Employee's Middle Initial
44 - 45 State Code 2 A/N Must be '47' for Tennessee employees
46 - 49 Filler 4 A/N Enter Blanks
50 - 63 Filler 14 N Enter zeros
64 - 77 Employee's quarterly Unemployment Insurance 14 N Enter quarterly wages subject to unemployment taxes--include tips, 401k, cafeteria plans, etc.
  Total Wages      
78 - 275 Filler 198   Enter spaces
         
F - RECORD        
         
LOCATION FIELD NAME LENGTH TYPE DESCRIPTION
1 - 1 Record Identifier 1 A/N Constant "F"--denotes F record
2 - 275 Filler 274   Enter spaces

  • THE PREMIUM REPORT, THE WAGE REPORT, THE CD OR DISKETTE, AND YOUR CHECK MUST BE MAILED TOGETHER. IN LIEU OF THE ITEMS BEING LISTED ON THE WAGE REPORT, MARK THE NOTATION "WAGES REPORTED ON CD/DISKETTE" ON THE BOTTOM OF THE WAGE REPORT.
IF YOU HAVE ANY QUESTIONS ABOUT REPORTING ON CD OR DISKETTE, PLEASE CALL 615-741-3280.