Electronic Data Reporting

Appendix B - MWR File Format

Shaded data elements are common to both CES and MWR.

Note: Round to the nearest dollar; do not include decimals or fractions in fields containing dollars.

MWR Data Elements
Position

Data Element

Length

Data Specification
1-2 Program Code

2

 Required. A 2-digit program code indicating the type of data being reported.
01 = CES
02 = MWR
3 Record Type

1

 Required. A 1-digit number indicating the record format is Y2K compliant. Enter "2".
4-5 Reference State

2

 Required. The 2-digit State FIPS code indicating the location of the establishment. (See Appendix D for a list of FIPS codes).
6-15 UI Account Number

10

 Required. The Unemployment Insurance (UI) account number assigned to the employer by the State. Right justify, zero fill.
16-20 Reporting Unit Number

5

 Optional. The number assigned by the State to distinguish between records with the same UI account number. Right justify, zero fill. Unless the RUN numbers are known, zero fill. The EDI Center will assign the correct RUN by using a crosswalk mapping in conjunction with positions 302-322 (Worksite Identification Code).
21-29 Employer Identification Number (EIN)

9

 Required. The 9-digit EIN assigned to the employer by the Internal Revenue Service (IRS). Numeric, right justified. If EIN is unknown, zero fill.
30-64 Trade Name

35

 Required. The division or subsidiary name of the establishment. "Mom's Restaurant" is an example of a trade name of ABC Enterprises. Left justify, blank fill.
65-99 Street Address 35 Required. The physical street address of the establishment. Abbreviate as necessary in accordance with the U.S. Postal Service’s National Zip Code and Postal Service Directory. Left justify, blank fill.
100-129 City 30 Required. The city of the establishment. Left justify, blank fill.
130-131 State 2 Required. The standard 2-letter Postal Service State abbreviation for the establishment. (See Appendix D).
132-136 Zip Code 5 Required. The 5-digit Zip Code used by the Postal Service for the establishment.
137-140 Expanded Zip Code 4 Optional. The 4-digit expanded Zip Code used by the Postal Service for the establishment. If not used, blank fill.
141-142 Delivery Point Barcode 2 Optional. The 2-digit delivery point Barcode used by the Postal Service for the establishment. If not used, zero fill.
143-144 Primary Comment Code 2 Optional. If not used, blank fill.
145-146 Secondary Comment Code 2 Optional. If not used, blank fill.
147-148 Third Comment Code 2 Optional. If not used, blank fill.
149-152 Reference Year 4 Required. Enter the four digits of the calendar year covered by the report.
153 Reference Quarter 1 Required. The 1-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
154-188 Legal Name 35 Required. The legal or corporate name of the establishment. For example "ABC Enterprises" or "Smith Companies, Inc." Left justify, blank fill.
189-223 Worksite Description 35 Required. Enter a meaningful, unique description of the establishment, such as store number or plant name (e.g., Store 101, Jones River Plant). Left justify, blank fill.
224-229 Month 1 Employment 6 Required. The number of 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 that is reported on that States' Quarterly Contribution Report. Right-justify, zero fill.
230-235 Month 2 Employment 6 Required. The number of 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 that is reported on that States' Quarterly Contribution Report. Right-justify, zero fill.
236-241 Month 3 Employment 6 Required. The number of 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 that is reported on that States' Quarterly Contribution Report. Right-justify, zero fill.
242-251 Quarterly Wages 10 Required. The total amount of wages (both 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 States' Quarterly Contribution Report. Must be numeric (no $ signs or commas). Must be right-justified and filled with leading zeros. Round to the nearest dollar (Omit cents). If no wages were paid, zero fill.
252-301 Comments 50 Optional. Explain any large 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 expansion of operations or purchase of units from another firm, please provide a description of the business activity(s) that will be conducted at each establishment. This will assist BLS in assigning industrial classification codes to the new unit(s). In addition, if units were purchased from another firm, please provide the name of the firm, the effective date of the transaction, and the UI number of the seller, if known. If units have been sold to another firm, please 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.
302-322 Worksite Identification Code 21 Required. Alpha/numeric indicator that uniquely identifies the business at this physical location. This code should not be duplicated within the State for this location. Left justify, blank fill. If unknown, blank fill.
323-350 Blank 28 For future use. Blank fill.

Chapter 1 | Chapter 2 | Chapter 3 | Chapter 4 | Chapter 5 | Chapter 6 | Appendix A, B, C, D, E, F

 

Last Modified Date: September 27, 2005