MiWAM Format - File Layout and Data Mapping - Wage Portion of the Quarterly Wage or Tax Report (W) Record

Record Type

Identifies the record type.

1-1

1

X(1)

The valid value is W.

Employer Number

Your Michigan Unemployment Insurance Agency (UIA) account number assigned by the state (7 characters), followed by the location (multi-unit number) (3 digits).

2-11

10

9(10)

The first seven digits are retrieved from the Employer Account Number field on the MI Quarterly Wage Report - Setup - Employer page.

The next three digits are derived from the Unit Number Location on the MI Quarterly Wage Report - Setup - Employer page and the location mapping logic on the Location Table page.

Quarter Ending

The filing calendar quarter.

The first digit is the reporting quarter (1-4), and the next four digits are the reporting year.

12-16

5

QCCYY

Valid values:

• 1<YYYY>

• 2<YYYY>

• 3<YYYY>

• 4<YYYY>

Retrieved from the Reporting Quarter and Reporting Year fields on the MI Quarterly Unemployment Report - Report page.

SSN

The employee's Social Security Number or Individual Taxpayer Identification Number (ITIN).

17-25

9

9(9)

Retrieved from the Social Security Number field on the Employee Information form of the MI Quarterly Unemployment Report page.

Employee Last Name

The employee's last name.

26-41

16

X(16)

Retrieved from the Last Name field on the Employee Information form of the MI Quarterly Unemployment Report page.

Employee First Name

The employee’s first name.

42-53

12

X(12)

Retrieved from the First Name field on the Employee Information form of the MI Quarterly Unemployment Report page.

Employee Middle in

The employee's middle initial.

54-54

1

X(1)

Retrieved from the Middle Name field on the Employee Information form of the MI Quarterly Unemployment Report page.

Employee Gross Wages

The total gross wages paid to the employee during the quarter.

55-64

10

9(8)V99

Retrieved from the Gross Wages field on the Employee Information form of the MI Quarterly Unemployment Report page.

Family Status Indicator

identifies whether the employee is a family member of the business owner.

65-65

1

X(1)

The valid value is always 0.