This is the total record for all wage records (code ‘S’) reported for each employer (code ‘E’). Each ‘E’ record must have a corresponding ‘T’ record.
| RECORD LENGTH: 275
|
FIELD
POSITION |
FIELD
LENGTH |
FIELD DESCRIPTION |
|
1 |
1 |
CONSTANT "T" |
|
2-12 |
11 |
FILLER |
|
13-26 |
14 |
QUARTERLY GROSS WAGES |
|
27-40 |
14 |
FILLER |
|
41-54 |
14 |
EXCESS WAGES |
|
55-68 |
14 |
TAXABLE WAGES |
|
69-81 |
13 |
TAX DUE |
|
82-87 |
6 |
TAX RATE FOR THIS REPORTING
PERIOD (see below) |
|
88-226 |
139 |
FILLER |
|
227-233 |
7 |
MONTH 1 EMPLOYMENT |
|
234-240 |
7 |
MONTH 2 EMPLOYMENT |
|
241-247 |
7 |
MONTH 3 EMPLOYMENT |
|
248-275 |
28 |
FILLER |
DATA TYPES: |
|
|
| - |
all money fields and total fields
are strictly numeric |
| - |
right justify and zero fill all wage
amounts and total fields |
| - |
include the cents amount with the
decimal point assumed
(rounding is not necessary) |
| - |
do not use any punctuation (i.e.,
commas for thousands) |
| - |
no negative amounts are allowed |
| - |
EXCESS WAGES are the total of those
wages paid to each individual worker in excess of $8000 in a calendar year |
| - |
TAXABLE WAGES are the total of gross
wages for all workers less excess wages for all workers |
| - |
TAX RATE - the tax rate will be
found on the quarterly wage and tax report or reminder notice sent in lieu of a
report. The tax rate is defined by a decimal point in position 82 followed by
five digits (e.g., 2.8% = .02800) |
| - |
TAX DUE - the total of Taxable Wages multiplied by the Tax Rate. |
| - |
MONTH EMPLOYMENT fields – enter the
total number of employees on the payroll as of the 12th day of each month in the
report quarter. Failure to provide this information will result in
failure to process the submittal. |
