Multiple Worksite Report - File Layout and Data Mapping

1–2

2

Program Code

Identifies whether the file is a Bureau of Labor Statistics (BLS) Multiple Worksite Report.

The valid value is 02.

3

1

Record Type

Identifies whether each line is a worksite detail record within the MWR file format.

The valid value is 2.

4–5

2

Reference State (FIPS code)

The FIPS numeric code identifying the state.

The valid value is 50.

6–15

10

UI Account Number

The seven-digit account number assigned to the employer by VDOL.

Retrieved from the Employer VDOL Account Number field on the VT Quarterly Wage Report - Setup - Employer page.

16–20

5

Reporting Unit Number

The five-digit numeric reporting unit number assigned by the Bureau of Labor Statistics (BLS) to identify this worksite in the Multiple Worksite Report (MWR) electronic file.

Retrieved from the Reporting Unit Number field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

21–29

9

Employer Identification Number (FEIN)

The employer's nine-digit federal employer identification number.

Retrieved from the Federal Identification Number (EIN) field on the VT Quarterly Wage Report - Setup - Employer page.

30–64

35

Trade Name

The operating or trade name of the worksite, if different from the legal name.

Retrieved from the Trade Name field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

65–99

35

Street Address

The street address of the worksite location.

Retrieved from the Street Address field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

100–129

30

City

The city in which the worksite is located.

Retrieved from the City field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

130–131

2

State

The two-letter state abbreviation for the worksite location.

Retrieved from the State field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

132–136

5

ZIP Code

The five-digit ZIP code for the worksite.

Retrieved from the Zip field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

137–140

4

ZIP+4 Extension

The four-digit ZIP+4 extension for the worksite address.

Retrieved from the Zip Ext field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

141–142

2

Filler

Leave blank

spaces

143–144

2

Primary Comment Code

An optional two-character BLS-defined code that explains a significant change in employment or wages at this worksite (for example, a strike or ownership change).

Retrieved from the Primary Comment Code field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

145–146

2

Secondary Comment Code

An optional second two-character BLS comment code, used when more than one change event applies to the worksite in the reporting quarter.

Retrieved from the Secondary Comment Code field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

147–148

2

Third Comment Code

An optional third two-character BLS comment code, used when a third change event applies to the worksite in the reporting quarter.

Retrieved from the Third Comment Code field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

149–152

4

Reference Year

The reporting year for the record.

Retrieved from the Reporting Year field on the VT Quarterly Wage Report - Load page.

153

1

Reference Quarter

The quarter within the reporting year.

Retrieved from the Reporting Quarter field on the VT Quarterly Wage Report - Load page.

154–188

35

Legal Name

The legal business name of the worksite location as registered with the state.

Retrieved from the Legal Name field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

189–223

35

Worksite Description

A descriptive label for the worksite (for example, the building name or department name).

Retrieved from the Worksite Description field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

224–229

6

Month 1 Employment Count

The count of employees from the Quarterly Wage report whose assigned location matches this worksite and who were active in the pay run covering the 12th day of the first month of the quarter.

System-calculated.

The valid value is the count of employees from the Quarterly Wage report whose assigned location matches this worksite and who were active in the pay run covering the 12th day of the first month of the quarter.

230–235

6

Month 2 Employment Count

The count of employees from the Quarterly Wage report whose assigned location matches this worksite and who were active in the pay run covering the 12th day of the second month of the quarter.

System-calculated.

The valid value is the count of employees from the Quarterly Wage report whose assigned location matches this worksite and who were active in the pay run covering the 12th day of the second month of the quarter.

236–241

6

Month 3 Employment Count

The count of employees from the Quarterly Wage report whose assigned location matches this worksite and who were active in the pay run covering the 12th day of the third month of the quarter.

System-calculated.

The valid value is the count of employees from the Quarterly Wage report whose assigned location matches this worksite and who were active in the pay run covering the 12th day of the third month of the quarter.

242–251

10

Quarterly Wages

The sum of the Gross Wages field from all Employee (S) records in the Quarterly Wage report whose assigned location matches this worksite.

System-calculated.

The valid value is the sum of the Gross Wages field from all Employee (S) records in the Quarterly Wage report whose assigned location matches this worksite.

252–301

50

Comments

Additional comments about the worksite or changes reported for the quarter.

Retrieved from the Comments field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

302–322

21

Worksite Identification Code

A unique identifier for the worksite.

Retrieved from the Worksite Code field on the VT Quarterly Wage Report - Setup - Multiple Worksite page.

323–350

28

Filler

Leave blank

spaces