MiWAM Format - File Layout and Data Mapping - Employer Tax Report (H) Record

Record Type

Identifies the record type.

1-1

1

X(1)

The valid value is H.

Sequence

The sequence of the tax report in the file.

2-4

3

9(3)

The valid value is 001 and is system-generated.

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).

5-14

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.

15-19

5

QYYYY

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.

Gross Wages

The total gross wages for all employees for the quarter.

This value must match the Gross Wages field value on the tax portion of Form 1028.

20-32

13

9(11)V99

Calculated by summing the Gross Wages field values from all employee wage records from the Employee Information form of the MI Quarterly Unemployment Report page.

Excess Wages

The total excess wages over the taxable wage base limit.

This value must match the Excess Wages field value on Form 1028.

33-45

13

9(11)V99

Calculated by summing the Excess Wages values from all employee wage records from the Employee Information form of the MI Quarterly Unemployment Report page.

Workers 1st Month

The number of employees who received wages during the first month of the quarter.

This value must match the 1st Month field value on Form 1028.

46-51

6

9(6)

Calculated by counting employees who have Paid in Month 1 selected on the Employee Information form of the MI Quarterly Unemployment Report page.

Workers 2nd Month

The number of employees who received wages during the second month of the quarter.

This value must match the 2nd Month field value on Form 1028.

52-57

6

9(6)

Calculated by counting employees who have Paid in Month 2 selected on the Employee Information form of the MI Quarterly Unemployment Report page.

Workers 3rd Month

The number of employees who received wages during the third month of the quarter.

This value must match the 3rd Month field value on Form 1028.

58-63

6

9(6)

Calculated by counting employees who have Paid in Month 3 selected on the Employee Information form of the MI Quarterly Unemployment Report page.

Final Report

Indicates whether this is the final report for this employer.

64-64

1

9(1)

Valid values:

• 1 = Yes

• 0 = No

Retrieved from the Final Report field on the MI Quarterly Unemployment Report - Report page.

Apportionment

Indicates whether apportionment applies for multi-state employers.

65-65

1

9(1)

Valid values:

• 1 = Yes

• 0 = No

Retrieved from the Apportionment field on the MI Quarterly Unemployment Report - Report page.

Amended

Indicates whether this is an amended record.

66-66

1

9(1)

The valid value is always 0.

Number of Wage Records

The total number of employee wage (W) records included in this submission.

This value must match the total number of wages, out-of-state, and visa records reported on Form 1028.

67-73

7

9(7)

The valid value is the total number of wage records, out-of-state records, and visa records from Form 1028.

Calculated by counting the total number of employee wage records from the Employee Information form of the MI Quarterly Unemployment Report page.

Total Gross Wages

The duplicate or verification field for total gross wages.

This value must match the Gross Wages field value.

This value must match the sum of the Gross Wages fields from wage records, out-of-state records, and visa records from Form 1028.

74-86

13

9(11)V99

The valid value is the sum of the Gross Wages fields from wage records, out-of-state records, and visa records from Form 1028.

Calculated by summing the Gross Wages values from all employee wage records from the Employee Information form of the MI Quarterly Unemployment Report page.