Multiple Worksite Report - File Layouts and Data Mapping
The following table lists the Multiple Worksite report fields, descriptions, whether required or optional, length, position, and location of the data.
Field | Description | Required or Optional | Length | Position | Value or location |
---|---|---|---|---|---|
Program Code | A two-digit program code indicating the type of data being reported. Valid values:
| 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:
| 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 |