MWR PPF 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 PPF. Enter
"4". |
4-5 |
Reference 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-15 |
UI Account Number |
10 |
Required. The Unemployment Insurance (UI) account number assigned to the employer by the State. 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 employer by the Internal Revenue Service (IRS). Numeric, right justified. If EIN is unknown, zero fill. |
30-64 |
Trade 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-99 |
Street Address |
35 |
Required. The physical street address of the 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 establishment. Left justify, blank fill. |
130-131 |
State |
2 |
Required. The standard 2-letter Postal Service State abbreviation for the establishment. (See Appendix D). |
132-136 |
Zip Code |
5 |
Required. The 5-digit Zip Code used by the Postal Service for the establishment. |
137-140 |
Expanded Zip Code |
4 |
Optional. The 4-digit expanded Zip Code used by the Postal Service for the 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 establishment. 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 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 Contact Phone Number |
10 |
Required. The phone number (with area code) of the client's contact person to call in reference to data questions. Omit parentheses and hyphens. |
262-301 |
Client Contact Name |
40 |
Required. The name of the client's contact person. 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-350 |
Blank fill |
28 |
For future use. Blank fill. |