06 mwr web collected data file es2mwcd

MWR Web-Collected Data File (ES2MWCD)

ES2MWCD - Length 799 - Revised 11/11/2008

​Columns​		Len	Key	Type	COBOL Field Name	Description & Notes
1	2	2	Key	Char	MWCD-PROGRAM-CODE	Always contains '02' to denote MWR data
3	3	1	Key	Char	MWCD-REC-TYPE	Record type, used for multi-purpose web data collection selection; '2' = MWR data; '3' = PEO data; '4' = PPF data; '5' = Web-data collection of Federal accounts; '6' = Web-data collection of non-Federal MWR's
4	5	2	Key	Char	MWCD-STATE-FIPS	Federal Information Processing Standards (FIPS) code for the State receiving these data
6	20	15	Key	Char	MWCD-SESA-ID	State Employment Security Agency (SESA) identifier for the establishment; combines the U-I account number and reporting unit number, as broken out below
6	15	10R	Key	Char	MWCD-ACCT	U-I account number portion of SESA ID receiving web-collected data
16	20	5R	Key	Char	MWCD-RPT-UNIT	Reporting unit number of single/master (00000) or sub-unit (00001-99999) listed here
21	21	1		Char	MWCD-FORMAT-TYPE	This must be set to 'D' to denote a detail record
22	30	9		Char	MWCD-EIN	Federal Employer Identification Number (EIN)
31	65	35		Char	MWCD-TRADE-NAME	Trade (or doing-business-as) name of the establishment
66	141	76		Char	MWCD-PHYS-LOC-ADDRESS	Physical location address block (broken out below)
66	100	35R		Char	MWCD-PL-STREET	Single street address line for physical location address block
101	130	30R		Char	MWCD-PL-CITY	Physical-location-address city
131	132	2R		Char	MWCD-PL-STATE	PLA state postal abbreviation
133	141	9R		Char	MWCD-PL-ZIP	Full 9-digit PLA zip code; broken out below
133	137	5R		Char	MWCD-PL-ZIP-5	Standard 5-digit PLA zip code
138	141	4R		Char	MWCD-PL-ZIP-4	PLA ZIP+4 expansion
142	147	6		Char	MWCD-COMMENT-CODE	Combined three 2-digit comment codes, broken out below
142	143	2R		Char	MWCD-CMNT1	First comment code
144	145	2R		Char	MWCD-CMNT2	Second comment code
146	147	2R		Char	MWCD-CMNT3	Third comment code
​Standard Record Layout​ ​ ​ ​ ​ ​
148	152	5		Char	MWCD-YEARQ	Year/quarter of input MWR-collected data (yyyyq format)
150	152	3R		Char	MWCD-YRQ	Redefinition of year/qtr without century digits
153	187	35		Char	MWCD-LEGAL-NAME	Legal/corporate name of this establishment
188	222	35		Char	MWCD-RPT-UNIT-DESC	Reporting unit description
223	228	6		Num	MWCD-MON1-EMPL	First month's employment for the quarter; also redefined as MWCD-MON1-EMPLX to represent blank employment data; the same holds for other employment and total wage fields
229	234	6		Num	MWCD-MON2-EMPL	Second month's employment
235	240	6		Num	MWCD-MON3-EMPL	Third month's employment
241	250	10		Num	MWCD-TOTAL-WAGE	Total wages for the quarter
251	307	57		Char	MWCD-NARR-COMMENT	Narrative comment related to the quarter's data
308	308	1		Char	MWCD-SOURCE-CODE	Data source code related to EDI collection; 'C' = CENCO data; 'W' = MWR web data
309	311	3		Char	MWCD-CNTY	County FIPS code
312	314	3		Char	MWCD-TOWN	New England township code for the quarter
315	315	1		Char	MWCD-OWNER	Single-digit ownership code (1-3, or 5)
316	316	1		Char	MWCD-AUX	Obsolete - Auxiliary code (0, 5, or 8)
317	322	6		Char	MWCD-NAICS	North American Industry Classification System (NAICS) code
323	326	4		Char	MWCD-AGENT-CODE	Payroll provider agent code
327	334	8		Char	MWCD-INIT-LIAB-DATE	Initial liability date (yyyymmdd format)
335	342	8		Char	MWCD-END-LIAB-DATE	End-of-liability date (yyyymmdd format)
343	492	150		Char	MWCD-ECON-ACTIVITY-DESC	Description of the economic activity of this establishment
493	527	35		Char	MWCD-MWR-CONTACT	Contact name of person providing information for this employer
528	562	35		Char	MWCD-MWR-CONTACT-TITLE	Job title of the contact person
563	673	111		Char	MWCD-MOA-ADDRESS	Mailing / other address block; subdivided below
563	597	35R		Char	MWCD-MOA-STREET	Mailing/other first line street address
598	632	35R		Char	MWCD-MOA-STREET-2	Mailing/other second street address line
633	662	30R		Char	MWCD-MOA-CITY	Mailing/other address city
663	664	2R		Char	MWCD-MOA-STATE	Mailing/other address state postal abbreviation
665	673	9R		Char	MWCD-MOA-ZIP	Mailing/other address full 9-digit zip code (broken out below)
665	669	5R		Char	MWCD-MOA-ZIP-5	Mailing/other address standard 5-digit zip code
670	673	4R		Char	MWCD-MOA-ZIP-4	Mailing/other address ZIP+4 extension
674	688	15		Char	MWCD-PHONE-NUM	Complete phone number and extension, broken out below
674	676	3R		Char	MWCD-AREA	Area code portion of phone number
677	683	7R		Char	MWCD-PHONE	Standard seven-digit phone number (MWCD-PH-PFX + MWCD-PH-SFX)
684	688	5R		Char	MWCD-PHONE-EXT	Extension to phone number to reach contact person directly
689	698	10		Char	MWCD-FAX-NUM	Facsimile machine phone number (aaaxxxssss format, where 'aaa' is the area code, 'xxx' is the exchange, and 'ssss' is the suffix)
699	758	60		Char	MWCD-EMAIL-ADDR	Contact person's e-mail address
759	759	1		Char	MWCD-BUS-XFER-EVENT-1	First business transfer event code; '1' = Acquired another company
760	760	1		Char	MWCD-BUS-XFER-EVENT-2	Second business transfer event code; '1' = Sold to another company
761	761	1		Char	MWCD-BUS-XFER-EVENT-3	Third business transfer event code; '1' = Company merged with another
762	762	1		Char	MWCD-BUS-XFER-EVENT-4	Fourth business transfer event code; '1' = Company reorganized
763	763	1		Char	MWCD-BUS-XFER-EVENT-5	Fifth business transfer event code; '1' = Employer opened a new U-I account number
764	798	35		Char	MWCD-BUS-XFER-COMPANY	Name of other company involved in business transfer codes above
799	799	1		Char	MWCD-COLLECTION-STATUS	Data collection status code; '2' = Mailing indicator was set; '3' = Employer has become a single; '4' = Employer is no longer active; values of '1' '5' and '6' require no spe­cial action
MWR Web Collection Data File Data Set Name:                   WS.ES202.CENCO.WEB41D Service Center DSN:           YBUssX.A145.CENCO.WEB41D, ('ss' = State FIPS code) Type of File:                         Sequential File Layout:                          ES2MWCD The Web Collection Data File represents the culmination of multiple worksite report data collection via the Internet.  Data for the State's multi-unit families are transmitted from the National Office of BLS via EUS Direct or placed on the SunGard mainframe.  Since this system has not yet been fully activated into production, the data set name has not yet been determined, so is shown as a test file name.  The information in this file is used to update multiple EXPO files in Job ES2J041D.  The updated files are all backed up in case anything goes awry during the update process.​ ​ ​ ​ ​ ​

Related Links

• MWR Web-Collection Historical Data File (ES2MWHD)
• File Record Layouts Table of Contents
• EXPO/EARS Documentation Home