06 mwr extended tape file es2mwrx

MWR Extended Tape File (ES2MWRX)

ES2MWRX - Length 424 - Revised 9/8/2006

​Columns​		Len	Key	Type	COBOL Field Name	Description & Notes
1	2	2	Key	Char	MWRX-PROG-CODE	Program code identifier, '01' = CES data (not used), '02' = MWR data
3	3	1	Key	Char	MWRX-REC-TYPE	Y2K compliance code, '3' = PEO employer MWR data; '4' = Payroll Provider (PPF) MWR data; '5' = Standard MWR data
4	5	2	Key	Char	MWRX-STATE-FIPS	FIPS State code for receiving data, must match local State FIPS code to process
6	20	15	Key	Char	MWRX-SESA-ID	State's U-I account and reporting unit number for the establishment, subdivided below
6	15	10R	Key	Char	MWRX-ACCT	U-I account number part of SESA ID
16	20	5R	Key	Char	MWRX-RPT-UNIT	Reporting unit number
21	424	404		Char	MWRX-DETAIL-RECORD	Separate layouts for standard MWR detail or predecessor/successor data
21	21	1R		Char	MWRX-FORMAT-TYPE	Flag to distinguish a standard "Detail" ("D") from a pred/successor (blank) record
22	30	9R		Char	MWRX-EIN	Federal employer ID number (EIN)
31	65	35R		Char	MWRX-TRADE-NAME	Trade or doing-business-as (DBA) name of the establishment
66	141	76R		Char	MWRX-PHYS-LOC-ADDRESS	Grouped physical location address (PLA) data, broken out below
66	100	35R		Char	MWRX-PL-STREET	Single-line street address for the physical location address
101	130	30R		Char	MWRX-PL-CITY	Physical location city
131	132	2R		Char	MWRX-PL-STATE	Physical location state postal abbreviation
133	141	9R		Char	MWRX-PL-ZIP	Full 9-byte ZIP code for the physical location address, broken out below
133	137	5R		Char	MWRX-PL-ZIP-5	Standard 5-digit ZIP code of the PLA
138	141	4R		Char	MWRX-PL-ZIP4	PLA's ZIP+4 extension
142	147	6R		Char	MWRX-COMMENT-CODES	Collection of up to three comment codes, broken out below
142	143	2R		Char	MWRX-CMNT1	First comment code
144	145	2R		Char	MWRX-CMNT2	Second comment code
146	147	2R		Char	MWRX-CMNT3	Third comment code
148	152	5R		Char	MWRX-YEARQ	Year-quarter of MWR-tape data, formatted as shown below
148	151	4R		Num	MWRX-YEAR	4-digit year portion of year/quarter combination
152	152	1R		Num	MWRX-QTR	Quarter identifier (1-4) within the year
150	152	3R		Num	MWRX-YRQ	3-digit year/quarter redefinition (removing the century digits for micro comparison)
153	187	35R		Char	MWRX-LEGAL-NAME	Legal or corporate name of the employer
188	222	35R		Char	MWRX-RPT-UNIT-DESC	Reporting unit description (reporter's identifier for this location (may include a store number, physical descriptor, etc.)
223	250	28R		Char	MWRX-EMPL-WAGE-DATA	Group level identifier for employment and wage fields for the quarter (breakout below)
223	228	6R		Num	MWRX-MON1-EMPL	First month's employment (there is also a PIC-X version called MWRX-MON1-EMPLX)
229	234	6R		Num	MWRX-MON2-EMPL	Second month's employment (also listed as PIC-X version (MWRX-MON2-EMPLX))
235	240	6R		Num	MWRX-MON3-EMPL	Third month's employment (shown also as PIC-X equivalent (MWRX-MON3-EMPLX))
241	250	10R		Num	MWRX-TOTAL-WAGE	Quarterly total wages (also shown as PIC-X version called MWRX-TOTAL-WAGEX)
251	307	57R		Char	MWRX-NARR-COMMENT	Optional narrative comment available to describe unusual data fluctuation, etc.
308	308	1R		Char	MWRX-SOURCE-CODE	Flag to denote the source and trustworthiness of the data ("E" – standard EDI data (not often used);  "C" – trusted EDI ("CENCO") data
309	311	3R		Char	MWRX-CNTY	County FIPS code of this establishment
312	314	3R		Char	MWRX-TOWN	New England township code (for sub-county data listing)
315	315	1R		Char	MWRX-OWNER	Single-digit ownership code ('1' = Federal; '2' = State; '3' = Local; '5' = Private)
316	316	1R		Char	FILLER	space (area designated for obsolete auxiliary code)
317	322	6R		Char	MWRX-NAICS	North American Industry Classification Standard (NAICS) code assignment
323	326	4R		Char	MWRX-AGENT-CODE	Agent code (such as for a payroll provider, etc.)
327	334	8R		Char	MWRX-INIT-LIAB-DATE	Initial liability date (in yyyymmdd format)
335	342	8R		Char	MWRX-END-LIAB-DATE	End-of-liability date (in yyyymmdd format)
343	350	8R		Char	MWRX-REACT-DATE	Reactivation date of the establishment (returning to business – yyyymmdd format)
351	424	74R		Char	MWRX-PEO-DATA	Data related to a Professional Employer Organization (PEO) – breakout follows
351	360	10R		Char	MWRX-PEO-PRED-ACCT	"Predecessor" in PEO/Client relationship
361	369	9R		Char	MWRX-PEO-CLIENT-EIN	Federal employer ID number of the PEO's client
370	379	10R		Char	MWRX-PEO-CLIENT-PHONE	Phone number of PEO's client worksite (3-digit area, 3-digit exchange, 4-digit suffix)
380	385	6R		Char	MWRX-PEO-START-DATE	Starting month and year of the PEO association; this translates to a substitute for the initial liability date; breakout appears below
380	381	2R		Char	MWRX-PEO-START-MON	First month of PEO association (01-12); translated into initial liability date
382	385	4R		Char	MWRX-PEO-START-YEAR	First year (2-digit) of PEO association; translated into liability date
386	391	6R		Char	MWRX-PEO-END-DATE	Ending month and year, when the employer ceased operations in this PEO association (translated to a substitute end-of-liability date); breakout shown below
386	387	2R		Char	MWRX-PEO-END-MON	Month when employer ceased operations in this PEO association (01-12); translated into end-of-liability date
388	391	4R		Char	MWRX-PEO-END-YEAR	Year (2-digit) when employer ceased operations in this PEO association; translated into end-of-liability date
392	424	33R		Cha	MWRX-PEO-ECON-ACTIVITY	Economic activity description of client's worksite location
21	424	404		Char	MWRX-PRED-SUCC-RECORD	Group-level definition of a predecessor/successor transfer record; broken out below
21	21	1R		Char	MWRX-PS-ACTION-CODE	Switch to add or delete a predecessor/successor pairing; blank = new; 'D' = delete
22	22	1R		Char	MWRX-PS-FORMAT-TYPE	Predecessor/successor identification switch; 'P' = following SESA is a predecessor; 'S' = following SESA is a successor
23	37	15R		Char	MWRX-PS-SESA-ID	Combined U-I account and reporting unit number; breakout below
23	32	10R		Char	MWRX-PS-ACCT	U-I account number
33	37	5R		Char	MWRX-PS-RPT-UNIT	Reporting unit number
38	42	5R		Char	MWRX-PS-YEARQ	Year/quarter of predecessor/successor data involved in transfer (breakout below)
38	41	4R		Char	MWRX-PS-YEAR	4-digit year portion of year/quarter field
42	42	1R		Char	MWRX-PS-QTR	Quarter for pred/successor transfer data below (valid values 1 through 4)
43	48	6R		Num	MWRX-PS-SSN-COUNT	Number of employees (social security numbers) involved in the transfer
49	59	11R		Num	MWRX-PS-TOTAL-WAGES	Sum of total wages involved in the predecessor-to-successor transfer
60	67	8R		Num	MWRX-PS-XFER-DATE	Date on which the transfer from predecessor to successor occurred (yyyymmdd format)
68	75	8R		Char	MWRX-PS-STATE-USE	State-specific information for the transfer
76	424	349		Char	FILLER	spaces
Multiple Worksite Report "Tape" Extended File Data Set Name:                   WS.ES202.MWR.TAPE Service Center DSN:           YBUssX.A145.MWR.TAPE, ('ss' = State FIPS code) Type of File:                         Sequential File Layout:                          ES2MWRX ​The MWR Tape Extended File is the Version 9 implementation of expansions to MWRT processing at the EDI Center and elsewhere.  The new format offers expanded capa­bilities over earlier versions, especially with regard to predecessor/successor transfer information.  When EDI (or the reporting employer – though this would rarely be more than a worksite-to-worksite shift) knows of transfers of employees to a successor account, or from a predecessor, this information can go directly to the Predecessor/Succes­sor Actuals (PSA) File.  This file can be used instead of the 350-byte MWRT input, and in fact shall be the new standard for CENCO files for the 024D/024E job.  Once the data have been loaded into the Micro and PSA Files, the MWRX file can be discarded.​ ​ ​ ​ ​

Related Links

• Narrative Comment File (ES2NARC)
• File Record Layouts Table of Contents
• EXPO/EARS Documentation Home