06 micro selection parameters file es2misp es2rup
Jump to navigation
Jump to search
Micro-Selection Parameters File (ES2MISP (ES2RUP))
ES2MISP (ES2RUP) - Length 500 - Revised 2/14/2018
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
| 1 | 1 | 1 | Key | Char | MISP-REC-TYPE | Type of record; always 'I' for Micro Selection Parameters ('A' is for Macro Roll-up records, 'R' for Refiling selection records) |
| 2 | 5 | 4 | Key | Char | MISP-REC-ID | Micro Selection Parameter ID code (replaces V5 sequence number; provides more descriptive identifier for parameter sets) |
| 6 | 11 | 6 | Char | MISP-USER-ID | CICS Logon ID for person who entered (or last modified) the parameters | |
| 12 | 19 | 8 | Char | MISP-CHANGE-DATE | Date of most recent update to the parameters, by person shown above; subdivided below | |
| 12 | 15 | 4R | Num | MISP-CHG-YEAR | Year of latest change to parameters | |
| 16 | 17 | 2R | Num | MISP-CHG-MON | Month portion of latest change date | |
| 18 | 19 | 2R | Num | MISP-CHG-DAY | Day-of-the-month for latest change date | |
| 20 | 49 | 30 | Char | MISP-DESCRIP | Description of micro selection parameters, or purpose of the report | |
| 50 | 50 | 1 | Char | MISP-ALL-COUNTIES | Flag to denote whether all counties are to be initially selected; blank = use only the county codes listed below; 'X' = use all counties except those listed below | |
| 51 | 95 | 45 | Char | MISP-COUNTIES | Group-level representation of all 15 counties, as broken out below | |
| 51 | 53 | 3R | Char | MISP-COUNTY(1) | First county to select (or deselect based on All-Counties flag) | |
| 54 | 95 | 42R | Char | MISP-COUNTY(2 – 15) | Up to 14 additional counties to select or exclude | |
| 96 | 96 | 1 | Char | MISP-MSA-ZONE-SW | Switch to designate MSA versus zone selections, 'S' = MSA's, 'Z' = Zone/town's | |
| 97 | 156 | 60 | Char | MISP-MSAS or MISP-ZONES | Collection of all 12 MSA or Zone codes, as broken out below | |
| 97 | 101 | 5R | Char | MISP-MSA(1) or MISP-ZONE(1) | First MSA or zone/township selected; since the MSA is a 5-byte field, while the zone is a 4-byte field, each zone uses only the first four positions of the MSA field, with a trailing filler space; townships have two trailing spaces | |
| 102 | 156 | 55R | Char | MISP-MSA(2–12) or MISP-ZONE(2–12) | Up to eleven additional MSA or zone/township code selections (left-justified) | |
| 157 | 157 | 1 | Char | MISP-MEEI-ALL | All MEEI codes switch, 'Y' = All MEEI's selected, except those listed below | |
| 158 | 162 | 5 | Char | MISP-MEEIS | Group-level representation of all five MEEI codes that are split out below | |
| 158 | 158 | 1R | Char | MISP-MEEI(1) | First selected (or deselected via MEEI-All switch) MEEI code, '1' = Single, '2' = Master, '3' = Worksite, '4' = Refusal, '5' = Composite worksite, '6' = Non-breakout | |
| 159 | 162 | 4R | Char | MISP-MEEI(2 – 5) | Up to four additional MEEI's to include or exclude | |
| 163 | 163 | 1 | Char | MISP-OWN-ALL | All ownership switch, 'Y' = Select all owners except those listed below | |
| 164 | 166 | 3 | Char | MISP-OWNS | All three ownership code selections grouped together; the breakout appears below | |
| 164 | 164 | 1R | Char | MISP-OWN(1) | First ownership to select or exclude (based on switch above), '1' = Federal, '2' = State, '3' = Local, '5' = Private | |
| 165 | 165 | 1R | Char | MISP-OWN(2) | Second selected/deselected ownership code | |
| 166 | 166 | 1R | Char | MISP-OWN(3) | Third selected/deselected ownership code | |
| 167 | 167 | 1 | Char | MISP-TYPE-COV-ALL | All types of coverage switch, 'Y' = Select all ToC's except those listed below | |
| 168 | 169 | 2 | Char | MISP-TYPE-COVS | Collection of both type-of-coverage specifications shown below | |
| 168 | 168 | 1R | Char | MISP-TYPE-COV(1) | First type of coverage to select or exclude (0, 1, 2, 3, 8, or 9) | |
| 169 | 169 | 1R | Char | MISP-TYPE-COV(2) | Second type of coverage for inclusion/exclusion | |
| 170 | 170 | 1 | Char | MISP-RPT-TAPE-SW | Data output type code, 'R' = Produce report, 'F' = Write a tape or disk file; 'G' = Create an accounts group | |
| 171 | 171 | 1 | Char | MISP-WAGE-SW | Option to include wage data on firm list report, 'Y' = Include wage data in report | |
| 172 | 172 | 1 | Char | MISP-EMP-SW | Option to include employment data on firm list report, 'Y' = Include employment | |
| 173 | 173 | 1 | Char | MISP-MAIL-SW | Mail code recognition switch, 'Y' = Respect mail code restrictions, 'N' = Ignore code | |
| 174 | 179 | 6 | Char | MISP-LOW-IND | Lowest industry code for range selection (1-, 2-, 3-, or 4-digit SIC, or 1-6 digit NAICS code); blank if not used (sub-defined as -IND-1, -IND-2, etc.) | |
| 180 | 185 | 6 | Char | MISP-HIGH-IND | Highest industry code for range selection (1-4 digit SIC or 1-6 digit NAICS), blank if not used | |
| 186 | 215 | 30 | Char | MISP-EXCL-INDS | Collection of all 5 exclusions to the industry range listed above; breakout is below | |
| 186 | 191 | 6R | Char | MISP-EXCL-IND(1) | First industry code to exclude from above range (same number of SIC/NAICS digits as above or blank) | |
| 192 | 215 | 24R | Char | MISP-EXCL-IND(2 – 5) | Up to three more SIC or NAICS exclusions, defined as above | |
| 216 | 353 | 138 | Char | MISP-INDUSTRIES | Group-level representation of all 23 possible NAICS / SIC specifications, shown below | |
| 216 | 221 | 6R | Char | MISP-INDUSTRY(1) | First NAICS or SIC code to include (1-, 2-, 3- or 4-digit SIC or major industry, 1-6 digit NAICS code, alpha code for super-sector entry) | |
| 222 | 353 | 132R | Char | MISP-INDUSTRY(2 - 23) | Up to 22 more industries to include, same format as above; however, the entry screen allows only 21 total entries to be specified, so the last two will always remain blank | |
| 354 | 359 | 6 | Num | MISP-THIRD-MO-LOW | Minimum employment selection limit (default is zero) | |
| 360 | 365 | 6 | Num | MISP-THIRD-MO-HIGH | Maximum employment selection limit (default is 999999) | |
| 366 | 366 | 1 | Char | MISP-STATUS-ALL | All status codes switch, 'Y' = Select all status codes except for those listed below | |
| 367 | 367 | 1 | Char | MISP-STATUS-1 | First status code to select/exclude, '1' = Active, '2' = Inactive, '9' = Pending | |
| 368 | 368 | 1 | Char | MISP-STATUS-2 | Second status code to select/exclude, defined as above | |
| 369 | 369 | 1 | Char | FILLER | space | |
| 370 | 374 | 5 | Char | MISP-SORT-SEQ | Up to five sort sequencing parameter code letters, as described below in the character-based breakout below | |
| 370 | 370 | 1R | Char | MISP-SORT-1 | First sort sequencing parameter, 'A' = Account number, 'C' = County, 'E' = Descending 3rd month employment, 'M' = Mailing zip code, 'N' = Primary name, 'O' = Ownership (descending), 'S' = SIC code, 'X' = Auxiliary, 'Z' = Zone/township | |
| 371 | 371 | 1R | Char | MISP-SORT-2 | Second sort selection parameter with same options as listed above | |
| 372 | 372 | 1R | Char | MISP-SORT-3 | Third sort selection parameter | |
| 373 | 373 | 1R | Char | MISP-SORT-4 | Fourth sort selection parameter | |
| 374 | 374 | 1R | Char | MISP-SORT-5 | Fifth sort selection parameter | |
| 375 | 379 | 5 | Num | MISP-YEARQ | Year and quarter for data selection (yyyyq format; subdivided below) | |
| 375 | 378 | 4R | Num | MISP-YEAR | Four-digit year of data to be selected | |
| 377 | 379 | 3R | Num | MISP-YRQ | Year/quarter for micro data, used for direct quarter match (yyq format) | |
| 377 | 378 | 2R | Num | MISP-YR | Two-digit year of selected data, used for direct Micro File quarter comparison | |
| 379 | 379 | 1R | Num | MISP-QTR | Calendar quarter for selected data (valid values 1, 2, 3, and 4) | |
| 380 | 380 | 1 | Char | MISP-REPORT-OPTION | Type of report, '1' = Firm listing report, '2' = Name and both addresses, '3' = Name and P/L address, '4' = Mailing labels with SESA, '5' = Mailing labels w/o SESA | |
| 381 | 383 | 3 | Num | MISP-SAMP-PCT | Sampling percentage used to reduce output volume (values 001 to 100) | |
| 384 | 393 | 10 | Char | MISP-ACCT-DIGIT | Digit selection mask used as filtering agent; e.g., '.....39...' value would select micro accounts with '3' in 6th and '9' in 7th position of the U-I account number; sub-divided below | |
| 384 | 384 | 1R | Char | MISP-ACCT-DIGIT-SEL(1) | First digit selection position; blank if no special selection is based upon this digit, a numeric value will only allow accounts matching that value to be selected | |
| 385 | 393 | 9R | Char | MISP-ACCT-DIGIT-SEL(2 - 10) | Second through tenth digit selection positions; blank if not used as filters; a numeric value will allow only accounts matching that digit's value to be selected | |
| 394 | 394 | 1 | Char | MISP-DELINQ-SW | Delinquent accounts selection switch, blank = Select delinquents and non-delinq's, 'N' = Select only non-delinquents, 'Y' = Select only delinquent accounts | |
| 395 | 398 | 4 | Char | MISP-GROUP | Optional account Group ID to select only accounts in this group | |
| 399 | 428 | 30 | Char | MISP-ZIPCODES | Group-level representation of all six zip codes for selection individually (see below) | |
| 399 | 403 | 5R | Char | MISP-ZIPCODE(1) | First of up to 6 specific 5-digit zip code to select only accounts with addresses therein | |
| 404 | 408 | 5R | Char | MISP-ZIPCODE(2) | Second zip code selection | |
| 409 | 413 | 5R | Char | MISP-ZIPCODE(3) | Third zip code selection | |
| 414 | 418 | 5R | Char | MISP-ZIPCODE(4) | Fourth zip code selection | |
| 419 | 423 | 5R | Char | MISP-ZIPCODE(5) | Fifth zip code selection | |
| 424 | 428 | 5R | Char | MISP-ZIPCODE(6) | Sixth and final zip code selection to limit account inclusion to these zip codes | |
| 429 | 429 | 1 | Char | MISP-IND-TYPE | Industry type code; 'S' = SIC codes used; 'N' = NAICS data used | |
| 430 | 438 | 9 | Char | MISP-EIN | Federal Employer Identification Number (EIN - optional) to use for special search | |
| 439 | 439 | 1 | Char | MISP-PRINT-TOTAL | Option switch for including/omitting totals in the report; 'N' = Do not print totals; 'Y' = Include employment and wage totals in the report | |
| 440 | 441 | 2 | Char | MISP-SPECIAL-FIELD | Option for selecting on unusual parameters; Combination of two sub-fields, defined in the lines that follow | |
| 440 | 440 | 1R | Char | MISP-SPECIAL-1FIELD | Identifier for type of special account selection; 'A' = Select accounts with an Agent code present; 'C' = Select CES participants; 'E' = Select EDI/CENCO participants; 'F' = Select first-quarter-only mailed accounts; 'L' = Select PEO's (employee Leasing companies); 'N' = Select never-mailed accounts; 'P' = Select accounts without any physical-location address; 'T' = Select Indian Tribal Council establishments | |
| 441 | 441 | 1R | Char | MISP-SPECIAL-2FIELD | Confirmation/Negation switch; blank = Process "1FIELD" item as listed; '-' = Reverse the "1FIELD" selection; 'A-' = Select accounts without an Agent code, etc. The one exception is the 'P' (no PLA) value above. A value of 'P-' (physical location address exists) is deemed invalid. | |
| 442 | 442 | 1 | Char | MISP-ORGTYPE-FIELD | Selection of a particular organization type code; 'C' = Corporation; 'I' = Individual proprietorship; 'O' = Other organizational structure; 'P' = Partnership | |
| 443 | 448 | 6 | Char | MISP-LAST-USED-DATE | Last time this process was used; yymmdd format | |
| 449 | 500 | 52 | Char | FILLER | spaces | |
Micro Selection Parameters File (from Roll-up Parameters File) Data Set Name: WS.ES202.ROLLUP.PARMS Service Center DSN: YBUssX.A145.ROLLUP.PARMS, ('ss' = State FIPS code) Type of File: VSAM indexed File Layout: ES2MISP CICS ID: ES2RUP (standard); EssRUP (Service Center; ss=State) The Micro Selection Parameters sets are stored and updated within the ES2N series of screens, to establish selection parameters for Job 20D runs. Unlike most other ES2N screens, however, the parameter entries only specify the request ID's (at the beginning of this record). The parameters themselves, as related in this file, are maintained by a sub-screen of ES2N, accessed either by requesting new parameters (with the PF5 key), or by selecting one of the request ID's listed on the screen (for update actions). Once the parameters have been defined, and the specific parameter sets have been selected, the actual processing occurs in Job 20D. This job can interpret up to nine sets of parameters (a.k.a., request ID's). However, many other parameter sets may be maintained, but not called by the 20D job; they do not need to be deleted to be bypassed in a later job run. They may be kept on file permanently. Only the parameters that are desired in a particular run of Job 20D need to be listed in the ES2N request ID's line. | ||||||
Related Links
