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