Department of Labor Logo United States Department of Labor
Dot gov

The .gov means it's official.
Federal government websites often end in .gov or .mil. Before sharing sensitive information, make sure you're on a federal government site.

Https

The site is secure.
The https:// ensures that you are connecting to the official website and that any information you provide is encrypted and transmitted securely.

Multiple Worksite Report (MWR) Respondents
PRINT:Print
CEW CEW Program Links

Electronic Data Reporting

Appendix F - MWR File Format (PPF)

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

MWR PPF Data Elements

Position

Data Element

Length

Data Specification

1-2Program Code

2

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

1

Required. A 1-digit number indicating the reporter is a PPF. Enter "4".
4-5Reference 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-15UI Account Number

10

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

5

Optional. The number assigned by the State to distinguish between records with the same UI account number. Right justify, zero fill.
21-29Employer 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-64Trade 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-99Street Address35Required. 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-129City30Required. The city of the establishment. Left justify, blank fill.
130-131State2Required. The standard 2-letter Postal Service State abbreviation for the establishment. (See Appendix D).
132-136Zip Code5Required. The 5-digit Zip Code used by the Postal Service for the establishment.
137-140Expanded Zip Code4Optional. The 4-digit expanded Zip Code used by the Postal Service for the establishment. If not used, blank fill.
141-142Delivery Point Barcode2Optional. The 2-digit delivery point Barcode used by the Postal Service for the establishment. If not used, zero fill.
143-144Primary Comment Code2Not currently used. Leave blank.
145-146Secondary Comment Code2Not currently used. Leave blank.
147-148Third Comment Code2Not currently used. Leave blank.
149-152Reference Year4Required. Enter the four digits of the calendar year covered by the report.
153Reference Quarter1Required. 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-188Legal Name35Optional. The legal or corporate name of the establishment. For example "ABC Enterprises" or "Smith Companies, Inc." Left justify, blank fill. If same as Trade Name, blank fill.
189-223Worksite Description35Required. 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-229Month 1 Employment6Required. 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. Right-justify, zero fill.
230-235Month 2 Employment6Required. 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. Right-justify, zero fill.
236-241Month 3 Employment6Required. 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. Right-justify, zero fill.
242-251Quarterly Wages10Required. The total amount of wages (both taxable and non-taxable) paid to employees during the entire reference quarter. 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-261Client Contact Phone Number10Required. The phone number (with area code) of the client's contact person to call in reference to data questions. Omit parentheses and hyphens.
262-301Client Contact Name40Required. The name of the client's contact person. Left justify.
302-322Worksite Identification Code21Required. 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.
323-350Blank fill28For 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