MWR 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.
01 =
CES
02 = MWR |
| 3 |
Record Type |
1 |
Required. A 1-digit
number indicating the record format is Y2K compliant. Enter
"2". |
| 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. Unless the RUN numbers are known,
zero fill. The EDI Center will assign the correct RUN by using a
crosswalk mapping in conjunction with positions 302-322
(Worksite Identification Code). |
| 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 Service’s 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 |
Optional. If not used,
blank fill. |
| 145-146 |
Secondary Comment Code |
2 |
Optional. If not used,
blank fill. |
| 147-148 |
Third Comment Code |
2 |
Optional. If not used,
blank fill. |
| 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 |
Required. The legal or
corporate name of the establishment. For example "ABC Enterprises"
or "Smith Companies, Inc." Left justify, 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. The employment for all worksites should
match the employment that is reported on that States' Quarterly
Contribution Report. 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. The employment for all worksites should match the
employment that is reported on that States' Quarterly Contribution
Report. 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. The employment for all worksites should
match the employment that is reported on that States' Quarterly
Contribution Report. 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 that are subject to Unemployment
Insurance taxes. The wages for all worksites should match the wages
paid that are reported on that States' Quarterly Contribution
Report. 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-301 |
Comments |
50 |
Optional. Explain any
large changes in employment or wages due to store closure, layoffs,
bonuses, seasonal changes, etc. If any units of your firm are being
reported for the first time following expansion of operations or
purchase of units from another firm, please provide a description of
the business activity(s) that will be conducted at each
establishment. This will assist BLS in assigning industrial
classification codes to the new unit(s). In addition, if units were
purchased from another firm, please provide the name of the firm,
the effective date of the transaction, and the UI number of the
seller, if known. If units have been sold to another firm, please
provide the name of the firm, the effective date of the transaction,
and the UI number of the purchaser, if known. Left justify, blank
fill. |
| 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. If unknown, blank
fill. |
| 323-350 |
Blank |
28 |
For future use. Blank
fill. |
