Difference between revisions of "06 mwr web collected data file es2mwcd"
Daniela92H (talk | contribs) |
m (1 revision imported) |
(No difference)
|
Revision as of 16:41, 10 July 2019
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 special 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