Related Topics   

Washington Quarterly Wage Detail

Contents

1 Overview

2 Sample Reports

3 How-to

4 Report Fields

5 Extract File Layout

 

5 Extract File Layout

The following fields are used in the extract file layout:

Field Name

File Layout Position

Length

Description or Special Rules

Wage Year

1-2

2

Last two digits of the Year of the Wage Report.

Wage Quarter

3

1

Must be 1, 2, 3, or 4.

Tax Account Number

4-11

8

Eight digit account number. No hyphens or blanks.

Employee Social Security Number

12-20

9

No hyphens or spaces.

Employee Name

21-30

10

Last name, space, first initial, space, middle initial. Left justify.

Reportable Wages

31-41

11

Reportable wages equals the sum of gross wages minus sick pay plus taxable benefits.

Dollars and cents only without a decimal.

If negative wages, then zero.

Right justify with zero fill.

Hours

42-45

4

The total work hours minus sick leave hours minus unpaid leave hours.

Page Updated 3/07