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

• Multi Worksite Report (MWR) Data File (ES2MWR)
• File Record Layouts Table of Contents
• EXPO/EARS Documentation Home