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