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 Services 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. |