Difference between revisions of "06 multi worksite report mwr data file es2mwr"
Daniela92H (talk | contribs) |
MattSteadman (talk | contribs) m (Text replacement - "[[start" to "[[EXPO_Documentation") |
||
(One intermediate revision by one other user not shown) | |||
Line 8: | Line 8: | ||
* [[06_multi_worksite_report_mwr_tape_file_es2mwrt|Multi Worksite Report (MWR) Tape File (ES2MWRT)]] | * [[06_multi_worksite_report_mwr_tape_file_es2mwrt|Multi Worksite Report (MWR) Tape File (ES2MWRT)]] | ||
* [[06_file_record_layouts|File Record Layouts Table of Contents]] | * [[06_file_record_layouts|File Record Layouts Table of Contents]] | ||
− | * [[ | + | * [[EXPO_Documentation|EXPO/EARS Documentation Home]] |
Latest revision as of 16:38, 11 July 2019
Multi Worksite Report (MWR) Data File (ES2MWR)
ES2MWR - Length 281 - Revised 2/14/2018
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 4 | 4 | Key | Num | MWR-SORT-PAGE | Number of pages used to print this multi-worksite report form; optional sorting parameter to split out MWR's by the same number of pages for streamlined postage application; if sorts are not by page count, this field remains blank |
5 | 13 | 9 | Key | Char | MWR-MASTER-ZIP-CODE | Master account's zip code if forms are zip-code sorted, otherwise left blank |
14 | 23 | 10 | Key | Char | MWR-ACCOUNT | U-I account number for MWR data |
24 | 28 | 5 | Key | Num | MWR-RPT-UNIT | U-I reporting unit number (values 00000 through 99999) |
29 | 63 | 35 | Char | MWR-PRIMARY-NAME | Principal name field (generally DBA/Trade name) | |
64 | 98 | 35 | Char | MWR-SECONDARY-NAME | Secondary or subordinate name field (generally legal/corporate name) | |
99 | 133 | 35 | Char | MWR-ATTENTION-NAME | Contact person name (drawn from the MOA Contact record) | |
134 | 174 | 41 | Char | MWR-STREET-ADDRESS | Single street address line from mailing (master) or physical address (worksite); this is an usual definition, since it has six extra bytes | |
175 | 209 | 35 | Char | MWR-STREET-ADDRESS2 | Second street address line | |
210 | 237 | 28 | Char | MWR-CITY | Mailing (master) or physical (worksite) address city | |
238 | 239 | 2 | Char | MWR-STATE | Mailing (master) or physical (worksite) address state postal abbreviation | |
240 | 248 | 9 | Char | MWR-ZIP-CODE | Mailing/physical address zip code, subdivided below | |
240 | 244 | 5R | Char | MWR-ZIP-5 | Standard 5-digit zip code | |
245 | 248 | 4R | Char | MWR-ZIP-4 | Zip+4 extension (or last digit of Canadian zip code followed by three spaces) | |
249 | 281 | 33 | Char | MWR-MASTER-DATA | Information pertaining to the master account, subdivided below | |
249 | 253 | 5R | Num | MWRM-YEARQ | Year and quarter for MWR form, used to print report headings (yyyyq format) | |
249 | 252 | 4R | Num | MWRM-YEAR | Selected year for MWR forms | |
253 | 253 | 1R | Num | MWRM-QTR | Selected quarter for MWR forms (1, 2, 3, 4) | |
254 | 258 | 5R | Num | MWRM-WORKSITE-CT | Number of active worksites in the family, determines page count | |
259 | 259 | 1R | Num | MWRM-REQUEST-TYPE | Flag to distinguish initial mailouts from follow-ups, 1 = First mailing, 2 = Follow-up | |
260 | 261 | 2R | Char | MWRM-OWN-CODE | Family ownership code, '10' = Federal, '20' = State, '30' = Local, '50' = Private | |
262 | 273 | 12R | Char | MWRM-WEB-ACCT | Web account number | |
274 | 281 | 8R | Char | MWRM-WEB-PASSWORD | Password for web account | |
249 | 281 | 33R | Char | MWR-WORKSITE-DATA | Information pertaining to the worksite records, subdivided below | |
249 | 254 | 6R | Char | MWRW-NAICS | Worksite's NAICS code for selected quarter | |
255 | 260 | 6R | Char | MWRW-M3EMP | Worksite's third month employment for selected quarter | |
261 | 263 | 3R | Char | MWRW-CNTY | Worksite's county FIPS code for selected quarter | |
264 | 267 | 4R | Char | MWRW-ZONE | Worksite's sub-county zone/townships for selected quarter | |
268 | 281 | 14R | Char | FILLER | spaces | |
Multiple Worksite Report Data File Data Set Name: WS.ES202.MWR.DATA Service Center DSN: YBUssX.A145.MWR.DATA, ('ss' = State FIPS code) Type of File: Sequential File Layout: ES2MWR This file acts as a data transfer mechanism for Multiple Worksite Report (MWR) form printing. Although this normally remains an unseen, background, temporary file, there are instances where it needs to be used externally. Usually, the 12D, 12F, or 12R job will create this file, sort the data, and transfer it to the MWR print program (either impact or laser print version), after which this file is deleted. However, if the forms need to be printed on another computer, the data need to be transported to that other computer to complete the process. Any external print program must be able to handle the file format shown above, which is the reason it is documented here. |
Related Links