Multiple Worksite Report - File Layouts and Data Mapping

Program Code

A two-digit program code indicating the type of data being reported.

Valid values:

• 01 = CES

• 02 = MWR

Required

2

1-2

02

Record Type

A single-digit number indicating the record format is Y2K compliant. The valid value is 2.

Required

1

3

2

Reference State

The two-digit State FIPS code indicating the location of the establishment.

Required

2

4-5

fips_codes.code where state_id = “MO”

UI Account Number

The employer's Unemployment Insurance number assigned by the state.

Right justify, zero fill.

Required

10

6-15

mo_site_prof.account_no

Reporting Number

The number assigned by the State to distinguish between records with the same UI Account Number. Right justify, zero fill.

Suppose the RUN numbers are unknown, zero fill. The EDI Center will assign the correct RUN using a crosswalk mapping with positions 302-322 (Worksite Identification Code).

Optional

5

16-20

mo_site_loc.rpt_unit where the employee’s location according to the setup equals one of the locations in mo_site_loc.loc1 through mo_site_loc.loc10

Employer Identification Number (EIN)

The nine-digit EIN assigned to the employer by the Internal Revenue Service (IRS).

Numeric, right justified.

If the EIN is unknown, zero fill.

Required

9

21-29

hrm_prof.fedtax_id

Trade Name

The trade name of the worksite.

Left justify, blank fill.

Required

35

30-64

mo_site_loc.trade_name where the employee’s location according to the setup equals one of the locations in mo_site_loc.loc1 through mo_site_loc.loc10

Street Address

The worksite's address.

Abbreviate following the U.S. Postal Service’s National Zip Coe and Postal Service Directory.

Left justify, blank fill.

Required

35

65-99

mo_site_loc.address where the employee’s location according to the setup equals one of the locations in MO_site_loc.loc1 through MO_site_loc.loc10

City

The city where the worksite is located.

Left justify, blank fill.

Required

30

100-129

mo_site_loc.city where the employee’s location according to the setup equals one of the locations in mo_site_loc.loc1 through mo_site_loc.loc10

State

The two-character code identifying the state where the worksite is located.

Required

2

130-131

mo_site_loc.state_id where the employee’s location according to the setup equals one of the locations in mo_site_loc.loc1 through mo_site_loc.loc10

Zip Code

The five-digit zip code of the worksite's location.

Required

5

132-136

mo_site_loc.zip_code where the employee’s location according to the setup equals one of the locations in mo_site_loc.loc1 through mo_site_loc.loc10

Expanded Zip Code

The four-digit zip code extension.

If not used, blank fill.

Optional

4

137-140

mo_site_loc.zip_ext where the employee’s location according to the setup equals one of the locations in mo_site_loc.loc1 through mo_site_loc.loc10

Delivery Point Barcode

The two-digit delivery point Barcode used by the Postal Service for the establishment.

If not used, zero fill.

Optional

2

141-142

Not Applicable

Primary Comment Code

The two-digit primary comment code.

If not used, blank fill.

Optional

2

143-144

mo_site_loc.comment_cd1 where the employee’s location according to the setup equals one of the locations in mo_site_loc.loc1 through mo_site_loc.loc10

Secondary Comment code

The two-digit secondary comment code.

If not used, blank fill.

Optional

2

145-146

mo_site_loc.comment_cd2 where the employee’s location according to the setup equals one of the locations in mo_site_loc.loc1 through mo_site_loc.loc10

Third Comment Code

The two-digit third comment code.

If not used, blank fill.

Optional

2

147-148

mo_site_loc.comment_cd3 where the employee’s location according to the setup equals one of the locations in mo_site_loc.loc1 through mo_site_loc.loc10

Reference Year

The four digits of the calendar year covered by the report.

Required

4

149-152

Selected on the MO Quarterly Contribution and Wage Report - Multiple Worksite page.

Reference Quarter

The single-digit number indicating the reference calendar quarter for the report. The calendar quarters are:

• 1 = January – March

• 2 = April – June

• 3 = July – September

• 4 = October – December

Required

1

153

Selected on the MO Quarterly Contribution and Wage Report - Multiple Worksite page.

Legal Name

The legal name of the worksite.

Left justify, blank fill.

Required

35

154-188

mo_site_loc.legal_name where the employee’s location according to the setup equals one of the locations in mo_site_loc.loc1 through mo_site_loc.loc10

Worksite Description

The description of the worksite.

Enter a meaningful, unique description of the establishment, such as store number or plant name.

For example, Store 101, Jones River plant

Left justify, blank fill.

Required

35

189-223

mo_site_loc.descript where the employee’s location according to the setup equals one of the locations in mo_site_loc.loc1 through mo_site_loc.loc10

Month 1 Employment

The number for all full and part-time employees who worked during or received pay (subject to UI wages) for the pay period that includes the 12th of the month. The employment for all worksites should match the employment reported on that Quarterly Contribution report.

Right-justify, zero fill.

Required

6

224-229

Adds 1 to the count for each employee that has checks issued in the pay runs entered, including the 12th of the month for the 1st month of the quarter.

Month 2 Employment

The number for all full and part-time employees who worked during or received pay (subject to UI wages) for the pay period that includes the 12th of the month. The employment for all worksites should match the employment reported on that Quarterly Contribution report.

Right-justify, zero fill.

Required

6

230-235

Adds 1 to the count for each employee that has checks issued in the pay runs entered, including the 12th of the month for the 2nd month of the quarter.

Month 3 Employment

The number for all full and part-time employees who worked during or received pay (subject to UI wages) for the pay period that includes the 12th of the month. The employment for all worksites should match the employment reported on that Quarterly Contribution report.

Right-justify, zero fill.

Required

6

236-241

Adds 1 to the count for each employee that has checks issued in the pay runs entered, including the 12th of the month for the 3rd month of the quarter.

Quarterly Wages

The employee's quarterly wages.

The total wages (taxable and non-taxable) paid to employees during the entire reference quarter that are subject to Unemployment Insurance taxes. The wages for all worksites should match the wages paid that are reported on that Quarterly Contribution report.

It must be numeric (no $ signs or commas), right-justified, and filled with leading zeros.

Round to the nearest dollar (omit cents).

If no wages were paid, zero fill.

Required

10

242-251

SUM(payroll.tearn_q) for employees with a matching site code based on the setup.

Comments

Explain any significant changes in employment or wages due to store closure, layoffs, bonuses, seasonal changes, etc. If any units of your firm are being reported for the first time following an expansion of operations or purchase of units from another firm, describe the business activities conducted at each establishment. This will assist BLS in assigning industrial classification codes to the new units. Additionally, if units were purchased from another firm, provide the firm's name, the transaction's effective date, and the seller's UI number, if known. If units have been sold to another firm, provide the name of the firm, the effective date of the transaction, and the UI number of the purchaser, if known.

Left justify, blank fill.

Optional

50

252-301

mo_site_loc.comments where the employee’s location according to the setup equals one of the locations in mo_site_loc.loc1 through mo_site_loc.loc10

Worksite Identification Code

A worksite code of your choice.

Uniquely identifies the business at this physical location. This code should not be duplicated within the State for this location.

Left justify, blank fill.

Required

21

302-322

mo_site_loc.site_code where the employee’s location according to the setup equals one of the locations in mo_site_loc.loc1 through mo_site_loc.loc10

Blank

For future use.

Blank fill.

Not Applicable

28

323-350

Not Applicable