06 micro edit file es2mied
Jump to navigation
Jump to search
Micro Edit File (ES2MIED)
ES2MIED - Length 205 - Revised 2/14/2018
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
| 1 | 1 | 1 | Key | Char | MIED-REC-TYPE | Record type indicator; 'E' = Micro Edit record for ES2E display' 'H' = Multi-balance edit for ES2H display; 'A' = Administrative Micro Edit Distribution record (not yet used); 'G' = Predecessor/Successor Edit record for ES2G display (not yet implemented) |
| 2 | 4 | 3 | Key | Char | MIED-USER-ID | Portion of CICS User ID (from positions 4-6) for Micro Edit Distribution process (not to be developed); 'MED' = tag for "A" record type to verify that it is a Micro Edit Distribution (MED) record (not to be developed) |
| 5 | 46 | 42R | Key | Char | MIED-EDIT-SORT-FIELDS | Remaining fields used to sequence micro edit records; sub-divided below |
| 5 | 5 | 1R | Key | Char | MIED-FAMILY-SPLIT-SW | Switch to segregate single accounts from various types of multi employers; blank = Single account or no multi splits utilized; 'M' = multi-family member, sorted by SESA ID; 'E' = EDI employer, broken out by SESA ID; 'P' = PEO employer, broken out by SESA ID; 'W' = Web reporter |
| 6 | 7 | 2R | Key | Char | MIED-QMSA | Quasi-Metro Statistical Area (QMSA), a two-digit numeric value for states that utilize these codes to break up the State into geographic regions |
| 6 | 7 | 2R | Key | Comp | MIED-UI-DIGITS | Alternative to the QMSA used in California, this 4-digit computational (binary) field is comprised of three U-I digits, with a leading zero |
| 8 | 8 | 1R | Key | Char | MIED-MAED-SW | Switch to distinguish between standard micro edit records and those tied to the macro edits by the integration process (Job 242D); 'N' = Standard micro edit record; 'Y' = macro-micro integrated edit record (followed by the macro key instead of standard micro edit sort parameters |
| 9 | 31 | 23R | Key | Char | MIED-SORT-PARMS | Collection of fields drawn from micro record (and/or this Micro Edit record) to coincide with edit sort parameters; this composite of up to five fields is subordinate to User ID, Family Split Switch, QMSA, and MAED-switch values; for macro-integrated records, this field is replaced by the macro county/owner/NAICS (or owner/NAICS/ county for some states); for records with a non-blank family split switch value, the sorting parms are always blank |
| 9 | 18 | 10R | Key | Char | MIED-MAED-CON | Macro edit county, owner and NAICS code, used as a substitute for the sort parms only when the MIED-MAED-SW = 'Y'; breakout appears below |
| 9 | 11 | 3R | Key | Char | MIED-MAED-CNTY | County FIPS code associated with the macro edit to which this micro has been connected; only used if MAED-SW = 'Y' |
| 12 | 12 | 1R | Key | Char | MIED-MAED-OWN | Macro ownership code involved in the related macro edit cell; used only if MAED-SW is set to "Y" |
| 13 | 18 | 6R | Key | Char | MIED-MAED-NAICS | Macro NAICS code connected to a related macro edit exception |
| 9 | 18 | 10R | Key | Char | MIED-MAED-ONC | Alternate macro key, using industry basis rather than county sequence; individual fields are broken out below; as with MIED-MAED-CON, this definition only applies when the MIED-MAED-SW = 'Y' |
| 9 | 9 | 1R | Key | Char | MIED-MAEDO-OWN | Macro ownership in "ONC" state key, if tied in to integrated edit exception |
| 10 | 15 | 6R | Key | Char | MIED-MAEDO-NAICS | Macro NAICS code for ONC state, when micro record connected to macro exceptions |
| 16 | 18 | 3R | Key | Char | MIED-MAEDO-CNTY | Macro county in ONC state, when related to macro edit exception |
| 32 | 46 | 15 | Key | Char | MIED-SESA-ID | Edited account's SESA ID (combined U-I account number and RUN (see below)) |
| 32 | 41 | 10R | Key | Char | MIED-ACCT | U-I account number portion of SESA ID |
| 42 | 46 | 5R | Key | Num | MIED-RPT-UNIT | Reporting unit number portion of the SESA ID |
| 5 | 41 | 37R | Key | Char | MIED-MED-BEGIN-RANGE | Micro Edit Distribution Beginning-of-Edit-Range value, used in place of the above Micro Edit Sort Fields when the Record Type is "A" |
| 47 | 205 | 159 | Char | MIED-DATA | Standard micro edit record, as broken out below | |
| 47 | 47 | 1R | Char | MIED-BYPASS-FLAG-SW | Switch to show whether record has been bypassed or flagged in ES2E; 'B' = Bypassed from further edit report printing; 'F' = Flagged for later review (paper-clipped); blank = neither flagged nor bypassed (a "standard" record) | |
| 48 | 53 | 6R | Char | MIED-UPDATE-DATE | Date on which the most recent change was made to the Micro Edit record (yymmdd format) | |
| 54 | 59 | 6R | Char | MIED-UPDATE-BY | CICS user ID of the person who made the most recent change to the Micro Edit record | |
| 60 | 64 | 5R | Num | MIED-PAGE | Page number (of most recent Micro Exception Report) on which this record appeared (or would have appeared – since some records are not reprinted in later runs) | |
| 60 | 62 | 3R | Char | MIED-ES2H-YRQ | Used only in Multi-balance edit record – shows the processing year/quarter for the multi-balance edits rather than the page number, since the quarters may disagree with those found in the Micro Edit header record (described later) | |
| 65 | 65 | 1R | Char | MIED-ON-RPT-SW | Indicator noting whether this establishment was printed on the report; 'N' = Not on the most recent report; 'Y' = Record was present on most recent micro edits | |
| 66 | 127 | 62R | Char | MIED-ADMIN | Administrative edit exception group-level data; subdivided below | |
| 66 | 67 | 2R | Num | MIED-ADMCT | Number of administrative edit exceptions, if zero, the rest of ADMIN will be blank | |
| 68 | 70 | 3R | Char | MIED-ADMERR(1) | First administrative edit exception code | |
| 71 | 73 | 3R | Char | MIED-ADMERR(2) | Second administrative edit exception code | |
| 74 | 76 | 3R | Char | MIED-ADMERR(3) | Third administrative edit exception code | |
| 77 | 79 | 3R | Char | MIED-ADMERR(4) | Fourth administrative edit exception code | |
| 80 | 82 | 3R | Char | MIED-ADMERR(5) | Fifth administrative edit exception code | |
| 83 | 85 | 3R | Char | MIED-ADMERR(6) | Sixth administrative edit exception code | |
| 86 | 88 | 3R | Char | MIED-ADMERR(7) | Seventh administrative edit exception code | |
| 89 | 91 | 3R | Char | MIED-ADMERR(8) | Eighth administrative edit exception code | |
| 92 | 94 | 3R | Char | MIED-ADMERR(9) | Ninth administrative edit exception code | |
| 95 | 97 | 3R | Char | MIED-ADMERR(10) | Tenth administrative edit exception code | |
| 98 | 119 | 22R | Char | MIED-ADM-FLAGS | Series of flags denoting possible fields with edit exceptions that will be underscored in the micro edit report and displayed in red on the ES2E screen, subdivided below | |
| 98 | 98 | 1R | Char | MIED-AF-EIN | Flag for federal EIN errors, 'X' = Flagged for review | |
| 99 | 99 | 1R | Char | MIED-AF-NAME | Flag for legal or trade name errors, 'X' = Flagged for review | |
| 100 | 100 | 1R | Char | MIED-AF-SETUP-DATE | Set-up date edit exception flag, 'X' = Flagged for review | |
| 101 | 101 | 1R | Char | MIED-AF-LIAB-DATE | Initial liability date exception flag, 'X' = Flagged for review | |
| 102 | 102 | 1R | Char | MIED-AF-EOL-DATE | End-of-liability ("termination") date exception flag, 'X' = Flagged for review | |
| 103 | 103 | 1R | Char | MIED-AF-REACT-DATE | Reactivation date edit exception flag, 'X' = Flagged for review | |
| 104 | 104 | 1R | Char | MIED-AF-PL-STR | Physical location street address edit exception flag, 'X' = Flagged for review | |
| 105 | 105 | 1R | Char | MIED-AF-PL-CITY | Physical location city edit exception flag, 'X' = Flagged for review | |
| 106 | 106 | 1R | Char | MIED-AF-PL-STATE | Physical location state edit exception flag, 'X' = Flagged for review | |
| 107 | 107 | 1R | Char | MIED-AF-PL-ZIP | Physical location zip code edit exception flag, 'X' = Flagged for review | |
| 108 | 108 | 1R | Char | MIED-AF-ADDR-TYPE | U-I or M-O address type code edit exception flag, 'X' = Flagged for review | |
| 109 | 109 | 1R | Char | MIED-AF-UI-STR | U-I street address line edit exception flag, 'X' = Flagged for review | |
| 110 | 110 | 1R | Char | MIED-AF-UI-CITY | U-I city edit exception flag, 'X' = Flagged for review | |
| 111 | 111 | 1R | Char | MIED-AF-UI-STATE | U-I state edit exception flag, 'X' = Flagged for review | |
| 112 | 112 | 1R | Char | MIED-AF-UI-ZIP | U-I zip code edit exception flag, 'X' = Flagged for review | |
| 113 | 113 | 1R | Char | MIED-AF-MO-CITY | MOA city edit exception flag, 'X' = Flagged for review | |
| 114 | 114 | 1R | Char | MIED-AF-MO-STATE | MOA state edit exception flag, 'X' = Flagged for review | |
| 115 | 115 | 1R | Char | MIED-AF-MO-ZIP | MOA zip code edit exception flag, 'X' = Flagged for review | |
| 116 | 116 | 1R | Char | MIED-AF-PHONE | Phone number edit exception flag, 'X' = Flagged for review | |
| 117 | 117 | 1R | Char | MIED-AF-FAX-PHONE | Fax phone number edit exception flag, 'X' = Flagged for review | |
| 118 | 118 | 1R | Char | MIED-AF-SPCL | Special indicator exception flag; 'X' = Flagged for review | |
| 119 | 119 | 1R | Char | MIED-AF-RESP-CD | Refiling response code edit exception flag, 'X' = Flagged for review | |
| 120 | 162 | 43 | Char | MIED-QUARTER-TABLE(1) | Group-level current quarter edit exception data, subdivided below | |
| 120 | 121 | 2R | Num | MIED-QTRCT(1) | Current quarter edit exception count, if zero, the rest of Quarter-Table is blank | |
| 122 | 124 | 3R | Char | MIED-QTRERR(1 1) | First current-quarter edit exception code | |
| 125 | 127 | 3R | Char | MIED-QTRERR(1 2) | Second current-quarter edit exception code | |
| 128 | 130 | 3R | Char | MIED-QTRERR(1 3) | Third current-quarter edit exception code | |
| 131 | 133 | 3R | Char | MIED-QTRERR(1 4) | Fourth current-quarter edit exception code | |
| 134 | 136 | 3R | Char | MIED-QTRERR(1 5) | Fifth current-quarter edit exception code | |
| 137 | 139 | 3R | Char | MIED-QTRERR(1 6) | Sixth current-quarter edit exception code | |
| 140 | 142 | 3R | Char | MIED-QTRERR(1 7) | Seventh current-quarter edit exception code | |
| 143 | 145 | 3R | Char | MIED-QTRERR(1 8) | Eighth current-quarter edit exception code | |
| 146 | 162 | 17R | Char | MIED-QTR-FLAGS(1) | Current quarter edit exception flags, sub-defined below | |
| 146 | 146 | 1R | Char | MIED-QF-STATUS(1) | Current quarter status code edit exception flag, 'X' = Flagged for review | |
| 147 | 147 | 1R | Char | MIED-QF-CNTY(1) | Current quarter county code edit exception flag, 'X' = Flagged for review | |
| 148 | 148 | 1R | Char | MIED-QF-OWN(1) | Current quarter ownership code edit exception flag, 'X' = Flagged for review | |
| 149 | 149 | 1R | Char | MIED-QF-NAICS(1) | Current quarter NAICS code edit exception flag, 'X' = Flagged for review | |
| 150 | 150 | 1R | Char | MIED-QF-TCOV(1) | Current quarter type-of-coverage exception flag, 'X' = Flagged for review | |
| 151 | 151 | 1R | Char | MIED-QF-ZONE(1) | Current quarter zone code edit exception flag, 'X' = Flagged for review | |
| 152 | 152 | 1R | Char | MIED-QF-MEEI(1) | Current quarter MEEI code edit exception flag, 'X' = Flagged for review | |
| 153 | 153 | 1R | Char | MIED-QF-TXRT(1) | Current quarter tax rate edit exception flag, 'X' = Flagged for review | |
| 154 | 154 | 1R | Char | MIED-QF-MON1(1) | Current quarter 1st month employment edit exception flag, 'X' = Flagged for review | |
| 155 | 155 | 1R | Char | MIED-QF-MON2(1) | Current quarter 2nd month employment edit exception flag, 'X' = Flagged for review | |
| 156 | 156 | 1R | Char | MIED-QF-MON3(1) | Current quarter 3rd month employment edit exception flag, 'X' = Flagged for review | |
| 157 | 157 | 1R | Char | MIED-QF-TOTW(1) | Current quarter total wage edit exception flag, 'X' = Flagged for review | |
| 158 | 158 | 1R | Char | MIED-QF-TAXW(1) | Current quarter taxable wage edit exception flag, 'X' = Flagged for review | |
| 159 | 159 | 1R | Char | MIED-QF-CTRB(1) | Current quarter contribution edit exception flag, 'X' = Flagged for review | |
| 160 | 160 | 1R | Char | MIED-QF-CMT1(1) | Current quarter first comment code edit exception; 'X' = Flagged for review | |
| 161 | 161 | 1R | Char | MIED-QF-CMT2(1) | Current quarter second comment code edit exception; 'X' = Flagged for review | |
| 162 | 162 | 1R | Char | MIED-QF-CMT3(1) | Current quarter third comment code edit exception flag, 'X' = Flagged for review | |
| 163 | 205 | 43 | Char | MIED-QUARTER-TABLE(2) | Prior quarter edit exception data in same format as listed above | |
| 47 | 205 | 159 | Char | MIED-MED-DATA | Micro Edit Distribution (MED) Parameter Record (Record Type "A") – Not to be implemented; breakout is shown below | |
| 47 | 87 | 41R | Char | MIED-MED-END-RANGE | Ending range for Micro Edit Distribution parameter record; broken out below | |
| 47 | 47 | 1R | Char | MIED-MER-FAMILY-SPLIT-SW | MED Ending Range Family Split Switch parameter (blank, 'E', 'M', P', 'W') | |
| 48 | 49 | 2R | Char | MIED-MER-QMSA | MED Ending Range QMSA Code (for states using QMSA's) | |
| 48 | 49 | 2R | Comp | MIED-MER-UI-DIGITS | MED Ending Range U-I digit specifications (for California – 3 U-I digits are converted to binary with a leading zero applied | |
| 50 | 50 | 1R | Char | MIED-MER-MAED-SW | MED Ending Range Macro Edit inclusion (integration) switch ('N', 'Y') | |
| 51 | 73 | 23R | Char | MIED-MER-SORT-PARMS | MED Ending Range Sorting Parameters (for singles) or macro edit associated key | |
| 51 | 60 | 10R | Char | MIED-MER-MAED-CON | Alternate to MED Ending Range sort parameters – the ending range macro edit key (county/owner/NAICS combination – only used when MAED-SW = 'Y') | |
| 51 | 60 | 10R | Char | MIED-MER-MAED-ONC | Rearrangement of the MED Ending Range macro edit key in ownership-NAICS-county sequence (used by certain states for industry-based macro editing) | |
| 74 | 83 | 10R | Char | MIED-MER-ACCT | MED Ending Range U-I account number (if needed in association with the ending-range key) | |
| 84 | 86 | 3R | Char | MIED-MED-USER-ID | Abbreviated User ID of Person assigned to this range of micro edit keys as part of his or her area of responsibility; there may be several ranges assigned to each QCEW analyst | |
| 87 | 90 | 4R | Char | MIED-MED-SEQ-NO | Sequential identification number indicating the order in which this set of parameters was added to the Micro Edit Distribution parameter collection (used in cross-referencing MED records with individuals) | |
| 91 | 96 | 6R | Char | MIED-MED-ADD-DATE | Date on which this parameter range was first added to the MED parameters (yymmdd format) | |
| 97 | 102 | 6R | Char | MIED-MED-UPDATE-DATE | Date on which this parameter range was most recently modified among the MED parameters (yymmdd format) | |
| 103 | 205 | 103R | Char | FILLER | spaces | |
| 47 | 205 | 159 | Char | MIED-HEADER-DATA | Micro Edit Header information, used to reconstruct micro edits; this record is stored with a record key of all spaces; breakout appears below | |
| 47 | 47 | 1R | Char | MIEDH-FAM-SPLIT-SW | Family Split Parameter, indicating the method of segregation of various types of multi-worksite families; blank = 'N' = No multi-families splits are used; 'M' = All multi-unit families are split out to appear in SESA ID sequence, while singles use the sorting parameters (described later) for sequencing; 'E' = Both "standard" multi-worksite families and EDI employers are broken out into separate groups in micro edits, with EDI employers (family switch "E") and all other multi families (family switch "M") broken out by SESA ID; 'P' = Both "standard" multi-worksite families and PEO employers are broken out into separate groups, with PEO (family switch "P") and all other multi families (family switch "M") listed in SESA ID sequence within their groupings; 'B' = Combination of "E" and "P" options, providing three classes of multi families (EDI ("E"), PEO ("P"), and all other multi's ("M"), each listed in SESA ID sequence within their groups; in all cases, singles use the sort parameter codes (described shortly) | |
| 48 | 53 | 6R | Char | MIEDH-QTR-DATA | Listing of current and prior year/quarter so that edits can be linked to the appropriate quarters on the Micro File (and it can be easily determined whether a quarter shift has occurred); breakout appears below | |
| 48 | 50 | 3R | Num | MIEDH-CURR-YRQ | Micro editing current quarter (yyq format) | |
| 51 | 53 | 3R | Num | MIEDH-PRIOR-YRQ | Micro editing prior quarter (yyq format) | |
r54
| 58 | 5R | Char | MIEDH-SORT-CHARS | Up to five code letters used to resequenced accounts (generally only for singles) in the Micro Edit Report and in ES2E processing; These fields are entered in the Job 001Q parameters (entered in the ES2N screen see the job parms section (ES2JPRM copy member and Appendix H parameter listing for Job 001Q) and can be modified in the State-specific constants (accessed from the ES2L screen – see the CICS documentation for this screen) | |
| 59 | 59 | 1R | Char | MIEDH-QMSA-USE-SW | Switch designating whether this State utilizes the use of QMSA's to partition the State into geographic regions; 'N' = QMSA's are not used, so don't need to be listed on ES2E either; 'Y' = QMSA's found in Lookup File; include the field for display and entry of a QMSA on the ES2E screen | |
| 60 | 60 | 1R | Char | MIEDH-NEW-SCORE-SW | Not yet developed; switch to identify the use of the new scoring method in both the batch and on-line edits (Y/N) | |
| 61 | 205 | 145 | Char | FILLER | spaces | |
Micro Edit File Data Set Name: WS.ES202.MICRO.EDIT Service Center DSN: YBUssX.A145.MICRO.EDIT, ('ss' = State FIPS code) Type of File: VSAM indexed File Layout: ES2MIED CICS ID: ES2MIED (standard); EssMIED (Service Center; ss=State) As the name implies, this file stores information related to current micro edits. The Micro Edit File is updated by standard editing batch jobs (001D, 001Q, 002D, 028D, and 242D). By "standard", we mean dealing with the current and immediate prior quarter of the Micro File, as these are the edits that are stored for on-line review. Other jobs also conduct the micro edits, but only store them temporarily; these jobs include 002F (dealing with future and current quarter), 008D (processing any specific Micro File quarter, except for the very oldest), and 028S (editing two consecutive historical or "back" quarters). Since the saving of such information would interfere with the primary edit reconciliation process, these alternate jobs will only produce an edit report. Two other jobs (008S – faster Fester, and 018D – "A" list edit report) read the current Micro Edit File, but it could contain obsolete data, rendering the report from these jobs less useful. The only on-line update capability for this file is found with the ES2E and ES2H screens. Here, accounts found on the Micro Edit File are re-edited on-line, with the results posted to the Micro Edit File. If all former edit conditions have been reconciled, the record is removed from this file. Locating micro edit information based on account number or a targeted error code, is accomplished with the Micro Edit Cross-Reference (MEXR) File, described earlier. | ||||||
Related Links
