06 mwr web collection historical data file es2mwhd
MWR Web-Collection Historical Data File (ES2MWHD)
ES2MWHD - Length 318 - Revised 9/9/2005
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
=== Account-level Record (Record Type '1'; First of Three Record Types) === | ||||||
1 | 2 | 2 | Key | Char | MWHD1-STATE-FIPS | Federal Information Processing Standards (FIPS) code for the State receiving these data |
3 | 12 | 10 | Key | Char | MWHD1-ACCT | U-I account number of family selected for historical data extraction from Micro File |
13 | 22 | 10 | Key | Char | FILLER | spaces |
23 | 23 | 1 | Key | Char | MWHD1-FORMAT-TYPE | Record type code; always '1' for this record layout |
24 | 32 | 9 | Char | MWHD1-EIN | Federal Employer Identification Number (EIN) | |
33 | 42 | 10 | Char | MWHD1-PRED-ACCT | Predecessor U-I account number | |
43 | 43 | 1 | Char | MWHD1-OWN | Single-digit ownership code | |
44 | 78 | 35 | Char | MWHD1-LEGAL-NAME | Legal/corporate name of employer | |
79 | 113 | 35 | Char | MWHD1-CONTACT-NAME | Name of contact person for this employer | |
114 | 148 | 35 | Char | MWHD1-MOA-ADDRESS1 | First street address line in mailing/other address | |
149 | 183 | 35 | Char | MWHD1-MOA-ADDRESS2 | Second street address line in mailing/other address | |
184 | 213 | 30 | Char | MWHD1-MOA-CITY | City portion of mailing/other address | |
214 | 215 | 2 | Char | MWHD1-MOA-STATE | State postal abbreviation from mailing/other address | |
216 | 224 | 9 | Char | MWHD1-MOA-ZIP | Full 9-digit zip code for mailing/other address | |
225 | 284 | 60 | Char | MWHD1-EMAIL-ADDRESS | E-mail address of contact person at this company | |
285 | 294 | 10 | Char | MWHD1-FAX-PHONE | 10-digit phone number (area + exchange + suffix) for employer's facsimile machine | |
295 | 304 | 10 | Char | MWHD1-PHONE-NUM | 10-digit phone number (area + exchange + suffix) of employer's contact person | |
305 | 309 | 5 | Char | MWHD1-PHONE-EXT | 5-byte extension for contact phone number, if needed to reach the contact person | |
310 | 313 | 4 | Char | MWHD1-AGENT-CODE | Payroll provider agent code for transfer to quarterly data | |
314 | 318 | 5 | Char | MWHD1-MAX-RPT-UNIT | Current largest reporting unit number recognized among the worksite sub-units | |
=== Worksite Administrative Data Record (Record type '2') === | ||||||
1 | 2 | 2 | Key | Char | MWHD2-STATE-FIPS | State FIPS code |
3 | 12 | 10 | Key | Char | MWHD2-ACCT | U-I account number |
13 | 17 | 5 | Key | Char | MWHD2-RPT-UNIT | Reporting unit number of the worksite |
18 | 22 | 5 | Key | Char | FILLER | spaces |
23 | 23 | 1 | Key | Char | MWHD2-FORMAT-TYPE | Record type code; always '2' for this type of data |
24 | 33 | 10 | Char | MWHD2-PRED-ACCT | Worksite's predecessor U-I account number | |
34 | 38 | 5 | Char | MWHD2-PRED-RUN | Worksite's predecessor reporting unit number | |
39 | 73 | 35 | Char | MWHD2-TRADE-NAME | Worksite's doing-business-as / trade name | |
74 | 108 | 35 | Char | MWHD2-PLA-ADDRESS1 | Single street address line for the worksite's physical location address block | |
109 | 138 | 30 | Char | MWHD2-PLA-CITY | Physical location address city for the worksite | |
139 | 140 | 2 | Char | MWHD2-PLA-STATE | State postal abbreviation for the worksite's physical location address | |
141 | 149 | 9 | Char | MWHD2-PLA-ZIP | Full 9-digit zip code of the physical location address | |
150 | 184 | 35 | Char | MWHD2-RPT-UNIT-DESCR | Worksite's reporting unit description (recognized identifier by the employer) | |
185 | 187 | 3 | Char | MWHD2-CNTY | County FIPS code for this worksite | |
188 | 190 | 3 | Char | MWHD2-TOWN | Sub-county township code for this worksite | |
191 | 191 | 1 | Char | MWHD2-AUX | Auxiliary code of this sub-unit ('0', '5' or '8') | |
192 | 197 | 6 | Char | MWHD2-NAICS | North American Industrial Classification System (NAICS) code for this worksite | |
198 | 318 | 121 | Char | FILLER | spaces | |
=== Worksite Historical Quarterly Data Record (Record Type '3') === | ||||||
1 | 2 | 2 | Key | Char | MWHD3-STATE-FIPS | State FIPS code, as in other record types |
3 | 12 | 10 | Key | Char | MWHD3-ACCT | U-I account number of this worksite |
13 | 17 | 5 | Key | Char | MWHD3-RPT-UNIT | Worksite's reporting unit number |
18 | 22 | 5 | Key | Char | MWHD3-YEARQ | Year and quarter of quarterly data (yyyyq format; sub-divided into MWHD3-YEAR and MWHD3-QTR fields) |
23 | 23 | 1 | Key | Char | MWHD3-FORMAT-TYPE | Record type code; always set to '3' to represent worksite quarterly data |
24 | 24 | 1 | Char | MWHD3-STATUS-CODE | Activity status code for this worksite for the indicated year/quarter ('1', '2', or '9') | |
25 | 30 | 6 | Char | MWHD3-M1-EMPL | First month's employment level | |
31 | 31 | 1 | Char | MWHD3-M1-IND | First month employment's indicator | |
32 | 37 | 6 | Char | MWHD3-M2-EMPL | Second month's employment level | |
38 | 38 | 1 | Char | MWHD3-M2-IND | Second month employment's indicator | |
39 | 44 | 6 | Char | MWHD3-M3-EMPL | Third month's employment | |
45 | 45 | 1 | Char | MWHD3-M3-IND | Indicator for third month's employment | |
46 | 56 | 11 | Char | MWHD3-TOTAL-WAGE | Total wages for the quarter for this sub-unit | |
57 | 57 | 1 | Char | MWHD3-TOTW-IND | Total wage indicator flag | |
58 | 59 | 2 | Char | MWHD3-CMNT1 | First comment code for the quarter | |
60 | 61 | 2 | Char | MWHD3-CMNT2 | Second comment code for the quarter | |
62 | 63 | 2 | Char | MWHD3-CMNT3 | Third comment code for the quarter | |
64 | 120 | 57 | Char | MWHD3-NARRATIVE | Narrative comment for the quarter | |
121 | 318 | 198 | Char | FILLER | spaces | |
MWR Web-Collection Historical Data File Data Set Name: WS.ES202.CENCO.J039D Service Center DSN: YBUssX.A145.CENCO.J039D, ('ss' = State FIPS code) Type of File: Sequential File Layout: ES2MWHD The Web-Collection Historical Data File provides BLS with quarterly data from selected multi-unit employers in order to ensure that data collected on the Internet will be reasonable and congruous with historical information. This file is produced by Job ES2J039D by examining the web-collection-flagged families in the Micro File and other related files. The three different record types perform unique functions. Record type '1' provides master account administrative data. Record type '2' lists worksite administrative data. Record type '3' notes quarterly worksite data; since the year/quarter field is included in the "key" area, multiple records can be used to provide more than one quarter of worksite data at a time. Web-based MWR data gathering is still in its testing phase, so the file names have not been finalized. The above DSN is likely to be modified to a form that is more meaningful and useful. |
Related Links