06 refiling report selection parameters file earresp es2rup redef
Refiling Report Selection Parameters File (EARRESP (ES2RUP redef.))
EARRESP - Length 500 - Revised 9/9/2005
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 1 | 1 | Key | Char | RESP-REC-TYPE | Parameters record type; always 'R' for this set of records; other types are 'A' for macro roll-up parameters and 'I' for micro selection parameters |
2 | 5 | 4 | Key | Char | RESP-REC-ID | Parameter set identification code (4-byte alpha-numeric, entered from ES2N screens) |
6 | 11 | 6 | Char | RESP-USER-ID | CICS Logon identifier for the person who entered or modified the parameter set | |
12 | 19 | 8 | Char | RESP-CHANGE-DATE | Date when the parameters were most recently modified (yyyymmdd format) | |
20 | 49 | 30 | Char | RESP-DESCRIP | User-supplied description of the report to be produced from these parameters | |
50 | 50 | 1 | Char | RESP-ALL-COUNTIES | Selection switch available to select all counties except for those listed below; 'X' = all-county selection mode is in effect; blank = only counties listed below are used | |
51 | 53 | 3 | Char | RESP-COUNTY(1) | First of up to 15 county FIPS codes to be selected or (if the all-counties switch is set to 'X') deselected | |
54 | 95 | 42 | Char | RESP-COUNTY(2 - 15) | Up to 14 additional county FIPS codes to be selected or deselected (via all-county opt) | |
96 | 96 | 1 | Char | RESP-OLD-NEW-CNTY-IND | Selection switch to distinguish between "old" (pre-refiling) or "new" (post-refiling county code values when selecting records for the Refiling report in Job 107D; 'O' = use old (pre-refiling) county codes for report selection; 'N' = use post-refiling counties, but default to the old code when the new code is blank (i.e., is unchanged during refiling operations) | |
97 | 97 | 1 | Char | RESP-MSA-ZONE-SW | Selection switch to determine whether MSA codes ('M') or sub-county zone codes ('Z') are to be selected by the redefined parameter set that appears below | |
98 | 102 | 5 | Char | RESP-MSA(1) | First MSA code selected, if the MSA-ZONE switch above has been set to "M" | |
98 | 101 | 4R | Char | RESP-ZONE(1) | First sub-county zone field, when the MSA-Zone switch is set to "Z"; since this is a 4-byte field, compared to the 5-byte MSA, a 1-byte filler is inserted to maintain proper alignment within the table | |
103 | 147 | 45 | Char | RESP-MSA(2 - 10) -- OR -- RESP-ZONE(2 - 10) (with 1-byte filler each) | Second through tenth MSA or zone code selection, also determined by the value of the MSA-ZONE switch above; zones use four bytes each; MSA's use five bytes | |
148 | 148 | 1 | Char | RESP-OLD-NEW-ZONE-IND | Old or new zone (or MSA) selection indicator, determining whether to use pre- or post-refiling zone or MSA (via county) values for selection; 'O' = use old (pre-refiled) codes; 'N' = use new (post-refiling) codes unless no change was encountered, then use old codes | |
149 | 149 | 1 | Char | RESP-MEEI-ALL | Switch to select all multi-establishment employer indicator code values, except for the ones listed below; 'X' = select all MEEI's, but omit the ones below; blank = select only the MEEI codes listed below | |
150 | 150 | 1 | Char | RESP-MEEI(1) | First MEEI code to select (or deselect when the MEEI-ALL is set to 'X'); valid values are '1' through '6' and blank | |
151 | 154 | 4 | Char | RESP-MEEI(2 - 5) | Up to four more MEEI codes to select or deselect (based on the MEEI-ALL setting) | |
155 | 155 | 1 | Char | RESP-OLD-NEW-MEEI-IND | Selection switch to distinguish between selection by old or new (pre- or post-refiling) MEEI codes; 'O' = use only the old/pre-refiling MEEI codes; 'N' = use new / post-refiling MEEI code if it was changed with refiling, otherwise default to the old code | |
156 | 156 | 1 | Char | RESP-OWNERSHIP-ALL | Option to include all ownership codes; blank = use only the ownership codes listed below; 'X' = include all ownership codes, except for the ones listed below | |
157 | 157 | 1 | Char | RESP-OWNERSHIP(1) | First ownership code to include (or to exclude when the all-owner switch is 'X') | |
158 | 159 | 2 | Char | RESP-OWNERSHIP(2 - 3) | Second and third ownership code to include or exclude from selection processing | |
160 | 160 | 1 | Char | RESP-OLD-NEW-OWN-IND | Selection switch to distinguish between pre-refiling/old ('O') or post-refiling/new ('N') ownership code values | |
161 | 162 | 2 | Char | RESP-RESP-CODE(1) | First response code to select; blank if no special selection based on RC is to occur | |
163 | 166 | 4 | Char | RESP-RESP-CODE(2 - 3) | Second and third response code to select | |
167 | 170 | 4 | Char | RESP-BATCH-NO(1) | First refiling batch code to isolate in report selections; blank if no batches to select | |
171 | 178 | 8 | Char | RESP-BATCH-NO(2 - 3) | Second and third batch code to bring in as a filtering agent | |
179 | 181 | 3 | Char | RESP-ERR-CD(1) | First of two optional error codes to use for a selection rule | |
182 | 184 | 3 | Char | RESP-ERR-CD(2) | Second optional error code to select | |
185 | 190 | 6 | Char | RESP-LOW-IND | Low-end industry code specification for an industry range; if left blank, the specific industry codes (in the RESP-INDUSTRY table) must be listed | |
191 | 196 | 6 | Char | RESP-HIGH-IND | High-end industry code (or some digits thereof) to be used as the ending point of an industry range; if left blank, the specific industry codes (below) must be identified | |
197 | 202 | 6 | Char | RESP-EXCL-IND(1) | First industry classification to remove from the range of industries just specified by the LOW-IND and HIGH-IND values above; if the range endpoints are left blank, then these exclusion industries should also remain blank, and the specific industries (in the RESP-INDUSTRY table) need to be included. | |
203 | 226 | 24 | Char | RESP-EXCL-IND(2 - 5) | Up to four more industry classifications to remove from the above industry range | |
227 | 232 | 6 | Char | RESP-INDUSTRY(1) | First of up to 23 specific or generalized industry classifications to be included in the record selection process; these may be 2- to 6-digit numeric values, alpha codes for super-sectors, etc. | |
233 | 364 | 132 | Char | RESP-INDUSTRY(2 - 23) | Up to 22 more industry codes to be selected for the 107D report; these are mutually exclusive of the industry range and exclusions listed above; i.e., only one of the two sets may be specified in a parameter set | |
365 | 365 | 1 | Char | RESP-OLD-NEW-IND-IND | Switch to distinguish whether new (post-refiling) or old (pre-refiling) industry codes are to be selected for processing from the range or industry selection set shown above; 'O' = Use only the old-code industries; 'N' = Use the new-code industries if they are present, otherwise default to the pre-refiling code when no change has occurred | |
366 | 371 | 6 | Char | RESP-AME-LOW | Minimum employment level that must be met by the quarterly average monthly employment (AME) value to be selected. If blank, no minimum has been applied; otherwise, must be fully numeric to be processed | |
372 | 377 | 6 | Char | RESP-DECEMPL-LOW | Minimum December employment that must be attained in order to select the record for the report. If blank, no limit is applied; otherwise, the value must be fully numeric | |
378 | 378 | 1 | Char | RESP-MICRO-STATUS-ALL | Switch to allow selection of all status codes from the Micro File data, excluding any values listed in the two fields below; 'X' = Select all status codes except those below | |
379 | 379 | 1 | Char | RESP-MICRO-STATUS-1 | Status code value to select from micro data (or deselect if the ALL-STATUS switch above is set to 'X'). If entered, it must show a valid value (namely '1', '2', or '9') | |
380 | 380 | 1 | Char | RESP-MICRO-STATUS-2 | Second status code value to select from micro data (or deselect if the ALL-STATUS switch is set to 'X'). If entered, it must show a valid value (namely '1', '2', or '9') | |
381 | 381 | 1 | Char | RESP-CARRY-OVER | Carry-over indicator filter to select only those establishments with the specified value in the carry-over indicator; if blank, no filtering is performed on the carry-over indicator (all records can pass through this "gate") | |
382 | 382 | 1 | Char | RESP-AUX | Auxiliary code selection filter, which may optionally be set; if blank, no auxiliary code filtering is performed; if specified, it must be a valid value ('0', '5', or '8') | |
383 | 383 | 1 | Char | RESP-OLD-NEW-AUX-IND | Switch to designate whether new ('N' = post-refiling) or old ('O' = pre-refiling) auxiliary codes are to be selected; however, if no auxiliary code was selected, this has no significance | |
384 | 388 | 5 | Char | RESP-SORT-SEQ | Up to five sorting codes used to resequence the output of the report data in the designated fashion; valid values include 'A' (for U-I account number), 'B' (for batch ID), 'C' (for county), 'D' (for December employment), 'E' (for average monthly employment (AME)), 'I' (for industry (NAICS) code), 'N' (for employer name), 'O' (for ownership code), 'Z' (for sub-county zone or township), blank = no sort parameter; the individual fields are named RESP-SORT-1 through RESP-SORT-5 | |
389 | 389 | 1 | Char | RESP-OLD-NEW-SORT-IND | Switch to designate whether the sort fields indicated above should utilize pre- or post-refiling values (if they relate to refiled codes); 'O' = Use strictly old / pre-refiling code values in the sort; 'N' = Use new / post-refiling codes if there have been changes in the refiling cycle; otherwise, default to the old code | |
390 | 392 | 3 | Char | RESP-YRQ | Year/quarter to use for quarter-specific data (yyq format) | |
393 | 402 | 10 | Char | RESP-NAME | Name of person preparing the refiling selection parameter set (entered on the EARN screen) | |
403 | 406 | 4 | Char | RESP-GROUP | Group ID used instead of most of the parameters listed above; a group selection will attempt to include all of the accounts listed therein to establish group records | |
407 | 407 | 1 | Char | RESP-CMI-ALL | Switch to note that all Collection Mode Indicator (CMI) codes are to be selected, except for the ones listed below (if set to "Y"); if set to "N", only those CMI codes listed below will be selected | |
408 | 409 | 2 | Char | RESP-CMI(1) | First CMI code to select or deselect (if CMI-ALL = 'Y') | |
410 | 411 | 2 | Char | RESP-CMI(2) | Second CMI code to select / deselect | |
412 | 417 | 6 | Char | RESP-UPD-BEG | Beginning of update date range selection (yymmdd format) | |
418 | 423 | 6 | Char | RESP-UPD-END | End of update date range selection (yymmdd format) | |
424 | 500 | 77 | Char | FILLER | spaces | |
Refiling Report 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: EARRESP CICS ID: ES2RUP (standard); EssRUP (Service Center; ss=State) The Refiling Selection Parameters sets are stored and updated within the EARN series of screens, to establish selection parameters for Job 107D runs. Unlike most other EARN 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 EARN, 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 107D. This job can interpret up to nine sets of parameters, identified by their four-byte record ID's near the beginning of the record. Each parameter set is processed individually with record selection from the Refiling File and specialized sorting enacted before the report is prepared. Since the parameter sets may be selected whenever they are needed, there is no need to delete parameter sets from the file. If one of the parameter sets is no longer needed, however, it can be removed from the file by typing "*D" in the selection field appearing to the left of the entry on the EARN 107D menu screen. |
Related Links