Employers Quarterly Report File Layout


Employers Quarterly Contributions Report Wage Detail File Layout
File layout for reporting wages is available from the NASWA (formerly ICESA) national site http://www.icesa.org/articles/template.cfm?results_art_filename=uitable.htm

The NASWA (ICESA) layout has been abbreviated below to indicate those fields required by Oklahoma:

Record A - Transmitter Record

Optional - Not used by Oklahoma

Record B - Basic Authorization

Optional - Not used by Oklahoma

Record E - Employer Record

 

 

Position   1

Enter "E"

 

Position   2 - 5

Year being reported (20YY)

 

Position   6 - 14

Federal EIN

 

Position  15 - 23

Blank - Not used by Oklahoma

 

Position  24 - 73

Left Justified. Employer's Name

 

Position  74 - 159

Blank - Not used by Oklahoma

 

Position  160

Enter "R"

 

Position  161 - 162

Blocking Factor    Diskette = Blanks; Cartridge = 10 or 25

 

Position  163 - 166

Blank - Not used by Oklahoma

 

Position  167 - 170

Enter "UTAX"

 

Position  171 - 172

Enter "40"

 

Position  173 - 187

Left Justified. Oklahoma Account Number. (9 digits followed by blanks. Omit hyphen.)

 

Position  188 - 189

Last month of quarter being reported

 

Position  190

Enter "1"

 

Position  191 - 275

Blank - Not used by Oklahoma

Record S - Supplemental Record (Employee Social Security Record)

 

Position   1

Enter "S"

 

Position   2 - 10

Employee Social Security Number

 

Position  11 - 30

Left Justified. Employee Last Name

 

Position  31 - 42

Left Justified. Employee First Name

 

Position  43

Left Justified. Employee Middle Initial

 

Position  44 - 45

Enter "40"

 

Position  46 - 63

Blank - Not used by Oklahoma

 

Position  64 - 77

Right Justified. Total of quarterly wages paid subject to state unemployment tax. Omit decimal.

 

Position  78 - 91

Blank - Not used by Oklahoma

 

Position  92 - 105

Right Justified. Portion of wages reported in positions 64 - 77 required to meet the taxable limitation. Omit decimal.

 

Position  106 - 142

Blank - Not used by Oklahoma

 

Position  143 - 146

Enter "UTAX"

 

Position  147 - 161

Left Justified. Oklahoma Account Number. (9 digits followed by blanks. Omit hyphen.)

 

Position  162 - 214

Blank

 

Position  215 - 220

Last month and year of calendar quarter being reported. Example: If quarter is Jan, Feb, Mar of 2003, enter: "032003".

 

Position  221 - 275

Blank - Not used by Oklahoma

Record T - Total Record

Optional

Record F - Final Record

Optional