Difference between revisions of "06 micro super selection parameter file es2mssp es2rup"
m (1 revision imported) |
MattSteadman (talk | contribs) m (Text replacement - "[[start" to "[[EXPO_Documentation") |
||
Line 8: | Line 8: | ||
* [[06_micro_omni_aux_transaction_file_es2mtrn|Micro-Omni-Aux Transaction File (ES2MTRN)]] | * [[06_micro_omni_aux_transaction_file_es2mtrn|Micro-Omni-Aux Transaction File (ES2MTRN)]] | ||
* [[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:36, 11 July 2019
Micro Super-Selection Parameter File (ES2MSSP (ES2RUP))
ES2MSSP (ES2RUP) - Length 500 - Revised 2/14/2018
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 1 | 1 | Key | Char | MSSP-REC-TYPE | Indicator showing the type of parameters represented by this record; always set to 'M' for Micro Super-selection Parameter record type |
2 | 5 | 4 | Key | Char | MSSP-REC-ID | Micro record selection parameter set identification code; eventually, this will be a user-enterable field; for now it is a constant, set to 'MSSP' |
6 | 11 | 6 | Char | MSSP-USER-ID | CICS Log-on ID of person creating or modifying this parameter set | |
12 | 19 | 8 | Char | MSSP-CHANGE-DATE | Date on which the parameters were last modified (yyyymmdd format) | |
20 | 49 | 30 | Char | MSSP-DESCRIPT | Description of the selection parameters represented here | |
50 | 52 | 3 | Char | MSSP-YYQ | Year/quarter of quarterly data represented in the selection set (breakout below); if left blank, current quarter will be offered as a default during data selection | |
50 | 51 | 2R | Num | MSSP-YR | 2-digit year portion of yr/qtr identifier (numeric or blank) | |
52 | 52 | 1R | Num | MSSP-QTR | Quarter used for quarterly data (1-4 or blank) | |
53 | 53 | 1 | Char | MSSP-REPORT-OPTION | Report option type, a field designed to mimic the 20D report option; this is a pseudo-option, however, since it must always be set to '1' (firm-list type report) | |
54 | 54 | 1 | Char | MSSP-WAGE-SW | Option to include total wage data in the firm list report (Y/N) | |
55 | 55 | 1 | Char | MSSP-EMP-SW | Option to include employment data in the firm list report (Y/N) | |
56 | 102 | 47 | Char | MSSP-PARM-LINE(1) | First line of selection parameters, broken out into the fields shown below | |
56 | 56 | 1R | Char | MSSP-ANDOR(1) | Linkage (not used) between this line and the one before (which doesn't exist, since this is the first line); check other "ANDOR" fields later to see how this field is used in subsequent occurrences of this table | |
57 | 61 | 5R | Char | MSSP-FIELD(1) | Field identifier code for base comparison in this line; standard codes are those listed in the ES2N (Job 040D) documentation; this field with remain blank if a micro record offset value is supplied instead of a field ID (shown in MSSP-BPOS below) | |
62 | 62 | 1R | Char | MSSP-FLD-QTR(1) | Quarter identifier to accompany the field identifier code above; blank unless applied to a quarter-specific data item; valid values for quarterly items are- '1' (future), '2' (current), '3', '4', '5', '6', '7', '8' (successively farther back historical quarters), 'F' (future), 'C' (current) or 'P' (prior) quarter | |
63 | 63 | 1R | Char | MSSP-FILE-ID | Code denoting the source of the field's data ('I' = Micro File; 'A' = MOA File address record; 'C' = MOA File contact record; 'E' = MOA File E-mail record; 'W' = MOA File website record | |
64 | 67 | 4R | Char | MSSP-BPOS(1) | First character position in the base comparison field; this value is found from a table when the field ID is entered, or drawn directly from the entry when a numeric value is substituted for the field ID entry | |
68 | 69 | 2R | Char | MSSP-LENGTH(1) | Number of characters to be checked in this comparison; this will either be the entire length of the field, or the number of characters entered into a comparison string, or the length of the other compared field (when comparing one field against another), whichever is smaller | |
70 | 70 | 1R | Char | MSSP-FLD-TYPE | Field type code, noting whether the data needs to receive special treatment because it is packed or binary format, or has embedded sub-fields; these can require further specialization for decimal placement, structure (date, census block, longitude/latitude, tax rate, etc.); 'B' = Census block fields; 'C' = Computational (binary) field; 'D' = packed-decimal date field (year/month/day); 'L' = Longitude/latitude (comp); 'N' = Standard numeric field; 'P' = Packed numeric; 'X' = Character (alpha/numeric) field | |
71 | 72 | 2R | Char | MSSP-COMPARE-CODE(1) | Comparison code used to match against the comparison field, value or range in the remaining fields of this occurrence; when comparing against a single value or another field, any of the following values can be used – 'CT', 'EQ', 'GE', 'GT', 'LE', 'LT', 'NE', '()', '<', '<=', '=', '>', '>=', '<>'; when using a range of values, the only valid comparators are for equal (i.e., within the range ('=' or 'EQ')) or not-equal (i.e., outside the range ('<>' or 'NE')); the other values (less-than, greater-than, etc.,) have no meaning for a range-of-values comparison | |
73 | 87 | 15R | Char | MSSP-COMP-VALUE(1) | Value for comparison against the base field; must meet the specifications of the field to which it is compared; for instance, a date field must have a date comparison value, and a numeric field can not be compared against alphabetic characters; the ES2N entry screen will reformat the entered field as much as possible | |
Comparison Byte List (used as multiple allowed / disallowed single-character values in a combined comparison) | ||||||
73 | 73 | 1R | Char | MSSP-CLL-VALUE(1) | First comparison single-byte value | |
74 | 74 | 1R | Char | MSSP-CLL-COMMA(1) | Separator between first and second comparison values (must = comma (','), or it is not a byte comparison list | |
75 | 75 | 1R | Char | MSSP-CLL-VALUE(2) | Second comparison byte value | |
76 | 76 | 1R | Char | MSSP-CLL-COMMA(2) | Separator between second and third comparison values (blank if no other values remain; ',' = another value is coming) | |
77 | 77 | 1R | Char | MSSP-CLL-VALUE(3) | Third comparison byte value | |
78 | 78 | 1R | Char | MSSP-CLL-COMMA(3) | Separator between the third and fourth comparison byte values (blank if no other values remain; ',' = another value is coming) | |
79 | 79 | 1R | Char | MSSP-CLL-VALUE(4) | Fourth comparison byte value | |
80 | 80 | 1R | Char | MSSP-CLL-COMMA(4) | Would-be separator between the fourth byte and a fifth; currently, this only extends to four possible values; this field should always be blank | |
81 | 87 | 7R | Char | FILLER | spaces | |
Comparison Field Data (used to compare one field against another, instead of a field against a fixed value) | ||||||
73 | 73 | 1R | Char | MSSP-CF-FLAG(1) | Flag to denote when the comparison is against another field rather than against a true literal; if a field ID will appear, this flag is set to a back-slash ('\'); then the remaining sub-fields will be set up as well | |
74 | 78 | 5R | Char | MSSP-CF-FIELD(1) | Comparison field ID; must be a valid identification code in order for the comparison to take place | |
79 | 79 | 1R | Char | MSSP-CF-QTR(1) | Comparison field's quarter ID; blank if field is non-quarter-specific; quarterly-occurrence fields will use a value of 1, 2, 3, 4, 5, 6, 7, 8, F, C, or P | |
80 | 80 | 1R | Char | MSSP-CF-FILE(1) | File ID code showing whence the field was drawn (A, C, E, I, W) | |
81 | 84 | 4R | Char | MSSP-CF-BPOS(1) | Starting character position for the comparison field (length will be the same as the length field, listed earlier | |
85 | 86 | 1R | Char | MSSP-CF-TYPE(1) | Comparison field type code (B, C, D, L, N, P, or X) | |
86 | 87 | 2R | Char | FILLER (1) | spaces | |
88 | 102 | 15R | Char | MSSP-END-VALUE(1) | Ending value for a value range; this field will be blank unless a full range of values is requested; when a range is used, the ending value, like the beginning value, must coordinate with the field type | |
103 | 149 | 47 | Char | MSSP-PARM-LINE(2) | Second line of selection parameters (optional); uses the format shown below | |
103 | 103 | 1R | Char | MSSP-ANDOR(2) | Linkage to connect this line to the first parameter line; value is 'A' (for "And"), 'O' (for "Or"), or 'L' for "Linked Or" (a set of either/or alternatives linked in an "and" chain); an "And" condition combines the two lines together, so that both conditions must be true; an "Or" condition breaks the link, so that if either the previous line or this line's parameters are true, the record will be selected for the report; the linked-or provides alternate ways to get across one of the "quot;and" link statements, like an inner set of parentheses around "or" conditions | |
104 | 108 | 5R | Char | MSSP-FIELD(2) | Field identifier code for base comparison in this line; standard codes are those listed in the ES2N (Job 040D) documentation; this field with remain blank if a micro record offset value is supplied instead of a field ID (shown in MSSP-BPOS below) | |
109 | 109 | 1R | Char | MSSP-FLD-QTR(2) | Quarter identifier to accompany the field identifier code above; blank unless applied to a quarter-specific data item; valid values for quarterly items are- '1' (future), '2' (current), '3', '4', '5', '6', '7', '8' (successively farther back historical quarters), 'F' (future), 'C' (current) or 'P' (prior) quarter | |
110 | 110 | 1R | Char | MSSP-FILE-ID(2) | Code denoting the source of the field's data ('I' = Micro File; 'A' = MOA File address record; 'C' = MOA File contact record; 'E' = MOA File E-mail record; 'W' = MOA File website record | |
111 | 114 | 4R | Char | MSSP-BPOS(2) | First character position in the base comparison field; this value is found from a table when the field ID is entered, or drawn directly from the entry when a numeric value is substituted for the field ID entry | |
115 | 116 | 2R | Char | MSSP-LENGTH(2) | Number of characters to be checked in this comparison; this will either be the entire length of the field, or the number of characters entered into a comparison string, or the length of the other compared field (when comparing one field against another), whichever is smaller | |
117 | 117 | 1R | Char | MSSP-FLD-TYPE(2) | Field type code, noting whether the data needs to receive special treatment because it is packed or binary format, or has embedded sub-fields; these can require further specialization for decimal placement, structure (date, census block, longitude/latitude, tax rate, etc.); 'B' = Census block fields; 'C' = Computational (binary) field; 'D' = packed-decimal date field (year/month/day); 'L' = Longitude/latitude (comp); 'N' = Standard numeric field; 'P' = Packed numeric; 'X' = Character (alpha/numeric) field | |
118 | 119 | 2R | Char | MSSP-COMPARE-CODE(2) | Comparison code used to match against the comparison field, value or range in the remaining fields of this occurrence; when comparing against a single value or an other field, any of the following values can be used- 'CT', 'EQ', 'GE', 'GT', 'LE', 'LT', 'NE', '()', '<', '<=', '=', '>', '>=', '<>'; when using a range of values, the only valid comparators are for equal (i.e., within the range ('=' or 'EQ')) or not-equal (i.e., outside the range ('<>' or 'NE')); the other values (less-than, greater-than, etc.,) have no meaning for a range-of-values comparison | |
120 | 134 | 15R | Char | MSSP-COMP-VALUE(2) | Value for comparison against the base field; must meet the specifications of the field to which it is compared; for instance, a date field must have a date comparison value, and a numeric field can not be compared against alphabetic characters; the ES2N entry screen will reformat the entered field as much as possible | |
Comparison Byte List (used as multiple allowed / disallowed single-character values in a combined comparison) | ||||||
120 | 120 | 1R | Char | MSSP-CLL-VALUE(1) | First comparison single-byte value | |
121 | 121 | 1R | Char | MSSP-CLL-COMMA(1) | Separator between first and second comparison values (must = comma (','), or it is not a byte comparison list | |
122 | 122 | 1R | Char | MSSP-CLL-VALUE(2) | Second comparison byte value | |
123 | 123 | 1R | Char | MSSP-CLL-COMMA(2) | Separator between second and third comparison values (blank if no other values remain; ',' = another value is coming) | |
124 | 124 | 1R | Char | MSSP-CLL-VALUE(3) | Third comparison byte value | |
125 | 125 | 1R | Char | MSSP-CLL-COMMA(3) | Separator between the third and fourth comparison byte values (blank if no other values remain; ',' = another value is coming) | |
126 | 126 | 1R | Char | MSSP-CLL-VALUE(4) | Fourth comparison byte value | |
127 | 127 | 1R | Char | MSSP-CLL-COMMA(4) | Would-be separator between the fourth byte and a fifth; currently, this only extends to four possible values; this field should always be blank | |
128 | 134 | 7R | Char | FILLER | spaces | |
Comparison Field Data (used to compare one field against another, instead of a field against a fixed value) | ||||||
120 | 120 | 1R | Char | MSSP-CF-FLAG(2) | Flag to denote when the comparison is against another field rather than against a true literal; if a field ID will appear, this flag is set to a back-slash ('\'); then the remaining sub-fields will be set up as well | |
121 | 125 | 5R | Char | MSSP-CF-FIELD(2) | Comparison field ID; must be a valid identification code in order for the comparison to take place | |
126 | 126 | 1R | Char | MSSP-CF-QTR(2) | Comparison field's quarter ID; blank if field is non-quarter-specific; quarterly-occurrence fields will use a value of 1, 2, 3, 4, 5, 6, 7, 8, F, C, or P | |
127 | 127 | 1R | Char | MSSP-CF-FILE(2) | File ID code showing whence the field was drawn (A, C, E, I, W) | |
128 | 131 | 4R | Char | MSSP-CF-BPOS(2) | Starting character position for the comparison field (length will be the same as the length field, listed earlier | |
132 | 132 | 1R | Char | MSSP-CF-TYPE(2) | Comparison field type for the second line comparison (B, C, D, L, N, P, or X) | |
133 | 134 | 2R | Char | FILLER (2) | spaces | |
135 | 149 | 15R | Char | MSSP-END-VALUE(2) | Ending value for a value range; this field will be blank unless a full range of values is requested; when a range is used, the ending value, like the beginning value, must coordinate with the field type | |
150 | 196 | 47 | Char | MSSP-PARM-LINE(3) | Third line of selection parameters (optional); uses the same format as shown above | |
197 | 243 | 47 | Char | MSSP-PARM-LINE(4) | Fourth line of selection parameters (optional), using the same format as shown before | |
244 | 290 | 47 | Char | MSSP-PARM-LINE(5) | Fifth line of selection parameters (optional), using the same format as shown before | |
291 | 337 | 47 | Char | MSSP-PARM-LINE(6) | Sixth line of selection parameters (optional), using the same format as shown before | |
338 | 384 | 47 | Char | MSSP-PARM-LINE(7) | Seventh line of selection parameters (optional), with the same format as shown before | |
385 | 431 | 47 | Char | MSSP-PARM-LINE(8) | Eighth line of selection parameters (optional), using the same format as shown before | |
432 | 478 | 47 | Char | MSSP-PARM-LINE(9) | Ninth line of selection parameters (optional), using the same format as shown before | |
479 | 483 | 5 | Char | MSSP-SORT-SEQ | Up to five individual sorting parameter code letters, used to resequence the data in the final output report; 'A' = Account number (i.e., SESA-ID sequence); 'C' = County; 'E' = Employment; 'I' = SIC; 'M' = Mailing (U-I) zip code; 'N' = NAICS; 'O' = Owner; 'X' = Auxiliary code; 'Z' = Zone or township | |
484 | 484 | 1 | Char | MSSP-OUT-TYPE-SW | Output type for selected data; 'R' = Print report; 'F' = Produce output file; 'G' Group records | |
485 | 488 | 4 | Char | MSSP-GROUP-ID | Group ID code, if the group ("G") output type is selected | |
489 | 500 | 12 | Char | FILLER | spaces | |
Micro Super-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: ES2MSSP CICS ID: ES2RUP (standard); EssRUP (Service Center; ss=State) The Micro Super-Selection Parameters sets are stored and updated within the ES2N series of screens, to establish selection parameters for Job 040D runs. It is a spin-off from the 020D parameter screen (which uses the ES2MISP parameter layout). Innumerable sets of parameters may be stored in the file, and up to nine sets of parameters can be selected for any Job 040D run. 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 or more of the request ID's listed on the screen (for update actions). |
Related Links