Quarterly Census of Employment and Wages

Electronic Data Reporting

Appendix E - MWR File Format (PEO)

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

MWR PEO 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.
02 = MWR
3 Record Type

1

Required. A 1-digit number indicating the reporter is a PEO. Enter "3".
4-5 Reference State

2

Required. The 2-digit State FIPS code indicating the location of the client establishment. (See where PEO pays UI taxes for that client). (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 PEO and pertaining to the State listed above. 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.
21-29 Employer Identification Number (EIN)

9

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

35

Required. The name of the client 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 client 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 client establishment. Left justify, blank fill.
130-131 State 2 Required. The standard 2-letter Postal Service State abbreviation for the client establishment. (See Appendix D).
132-136 Zip Code 5 Required. The 5-digit Zip Code used by the Postal Service for the client establishment.
137-140 Expanded Zip Code 4 Optional. The 4-digit expanded Zip Code used by the Postal Service for the client 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 Not currently Used. Leave blank.
145-146 Secondary Comment Code 2 Not currently Used. Leave blank.
147-148 Third Comment Code 2 Not currently Used. Leave blank.
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 Optional. The legal or corporate name of the PEO. For example "ABC Enterprises" or "Smith Companies, Inc." Left justify, blank fill. If same as Trade Name, blank fill.
189-223 Worksite Description 35 Required. Enter a meaningful, unique description of the client 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. 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. 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. 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. 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-261 Client UI Account Number 10 Required. The Unemployment Insurance (UI) account number assigned to the client before entering the co-employer relationship with the Professional Employer Organization (PEO). Right justify, zero fill.
262-267 Client NAICS Code 6 Required. The North American Industrial Classification System (NAICS) code assigned to the client. The NAICS code identifies the economic activity of the client. Right justify, zero fill.
268-301 Client Economic Activity 34 Required. The Client Economic Activity describes the principal business(es) in which the client is engaged. Left justify.
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.
323-331 Client EIN 9 Required. The federal Employer Identification Number (EIN) assigned to the client before entering the co-employer relationship with the Professional Employer Organization (PEO).
332-341 Client Telephone Number 10 Required. The Telephone Number of the Client.
342-343 Month Became Client 2 Required. The first month that the Client entered into contract for the PEO's service.
344-345 Year Became Client 2 Required. The first year that the Client entered into contract for the PEO's service.
346-347 Client Month of Termination 2 Required. The month of termination of the contract for the PEO's service.
348-349 Client Year of Termination 2 Required. The year of the termination of the contract for the PEO's service.
350 Blank 1 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

Recommend this page using: