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