06 micro edit cross reference file es2mexr
Micro Edit Cross-Reference File (ES2MEXR)
ES2MEXR - Length 46 - Revised 2/14/2018
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
General Record (Meaningless Except for Defining the Record Key Area) | ||||||
1 | 25 | 25 | Key | Char | MEXR-KEY | Record Key area (some records have fields that cross the key boundary, so it is specifically defined here |
26 | 46 | 21 | Char | MEXR-DATA | Data portion of the record (in previous versions, the entire record was used as the key, but this has been found to be unnecessary and wasteful of resources) | |
Account-based Cross-Reference Record | ||||||
1 | 15 | 15 | Key | Char | MEXR-SESA-ID | SESA ID (U-I account number and RUN) of an employer found in the micro edits; sub-defined below |
1 | 10 | 10R | Key | Char | MEXR-ACCT | U-I account number portion of SESA ID of establishment found in micro edits |
11 | 15 | 5R | Key | Char | MEXR-RPT-UNIT | Reporting unit number portion of SESA ID of establishment found in micro edits |
16 | 46 | 31 | (Key) | Char | MEXR-MIED-KEY | Micro Edit key used for this establishment; the first 10 bytes are in the key area, while the remaining 21 bytes are outside of the key area; this group-level field is sub-defined below |
16 | 16 | 1R | Key | Char | MEXR-REC-TYPE | Record type code found in the Micro Edit record; 'E' = standard micro edit record; 'H' = multi-balance edit record |
17 | 19 | 3R | Key | Char | MEXR-USER-ID | Assigned user for this micro edit record (not yet used; set to spaces) |
20 | 20 | 1R | Key | Char | MEXR-FAMILY-SPLIT-SW | Designation of multi-families to be separated from single-account sort parameters to appear in strictly SESA ID sequence among their various types ('E' = EDI employer (if broken out separately), 'M' = multi families (not elsewhere broken out by special action (i.e., for EDI's and PEO's), 'P' = PEO employer (if broken out separately)); blank = no special separation of this account (single or no multi breakouts used); 'W' = split on the web reporters, so that they are listed separately |
21 | 22 | 2R | Key | Char | MEXR-QMSA | QMSA for segregated edit output (for those states using geographic regions); used only for single accounts and integrated edits (standard multi-family records will have the QMSA set to spaces, so that families can be examined as a group) |
21 | 22 | 2R | Key | Comp | MEXR-UI-DIGITS | Alternative to QMSA for California, using a 4-digit computational (binary) field comprised of a leading zero, followed by three digits of the U-I account number; the multi-family exemption of QMSA's does not apply to U-I digit sorting, since these can be used for singles or multi-families equally; however, integrated edits do not use the U-I digit field (i.e., it is left as low-values (binary zeroes)) |
23 | 23 | 1R | Key | Char | MEXR-MAED-SW | Macro-edit inclusion (integration) switch ('Y' = integrated; 'N' = non-integrated (standard) |
24 | 46 | 23R | (Key) | Char | MEXR-SORT-PARMS | Sorting parameters applied to singles (and multi's if no multi-segregation is applied); only the first two characters are included in the sort key |
24 | 46 | 23R | (Key) | Char | MEXR-MAED-KEY | Alternative to the sort parameters, used only when the MEXR-MAED-SW = 'Y'; this alternate area, like the sort parms, is only keyed on the first two bytes |
24 | 33 | 10R | Key | Char | MEXR-MAED-CON | Macro edit association, combined county, owner, NAICS connection; this can be set to the alternate (ownership-NAICS-county) sequence, but doesn't need to be separately referenced, since the macro edit key is examined only as a group |
34 | 46 | 13R | Char | FILLER | spaces | |
Error Code Cross Reference Record Format | ||||||
1 | 1 | 1 | Key | Char | MEXR-ERR-XREF-SW | Switch to distinguish the two types of records, 'X' = Error cross-reference record |
2 | 4 | 3 | Key | Char | MEXRX-USER-ID | User ID assigned to this subset of the error-code based records (not yet used) |
5 | 7 | 3 | Key | Char | MEXRX-ERR-CODE | Error code being matched to a Micro File record |
8 | 10 | 3 | Key | Char | MEXRX-YRQ | Year/quarter for which error code occurred (if quarterly in nature, yyq format, blank for non-quarter-specific (administrative) edit exceptions) |
11 | 25 | 15 | Key | Char | MEXRX-SESA-ID | Account number and reporting unit number associated with this error code |
11 | 20 | 10R | Key | Char | MEXRX-ACCT | U-I account number portion of SESA ID |
21 | 25 | 5R | Key | Num | MEXRX-RPT-UNIT | Reporting unit number (RUN) portion of SESA ID |
26 | 26 | 1 | Char | MEXRX-BYPASS-FLAG-SW | Bypass or Flagging switch, used for filtering search during browsing by error code (B/F code on the entry) | |
27 | 27 | 1 | Char | MEXRX-FAMILY-SPLIT-SW | Family split switch to assist in identification of multi families of various types that are separated out from the singles ('E', 'M', 'P' or 'W'; blank = not split out) | |
28 | 46 | 19 | Char | FILLER | spaces | |
Page Number Cross Reference Record Format | ||||||
1 | 5 | 5 | Key | Char | MEXRP-HEADER | Header data to distinguish page-number records from all other MEXR records; always set to 'PAGE ' (with a trailing space) |
6 | 10 | 5 | Key | Char | MEXRP-PAGE-NUMBER | Page number found in the most recent Micro Edit Exception (employment/wage-related) Report |
11 | 25 | 15 | Key | Char | MEXRP-SESA-ID | First account's SESA ID appearing on this page of the Edit Exception Report |
26 | 46 | 21 | Char | FILLER | spaces | |
Micro Edit Cross-Reference File Data Set Name: WS.ES202.MICED.XREF Service Center DSN: YBUssX.A145.MICED.XREF, ('ss' = State FIPS code) Type of File: VSAM indexed File Layout: ES2MEXR CICS ID: ES2MEXR (standard); EssMEXR (Service Center; ss=State) The Micro Edit Cross-Reference (or "MEXR") File serves a three-fold role. First, it provides a mapping from the Micro File to the Micro Edit File by swapping the position of the SESA ID (normally at the end) with the rest of the Micro Edit key. This is used to locate records in the ES2E screen, to identify whether an ES2E transfer is possible from the ES2C screen (i.e., highlighting the SESA ID on ES2C to denote the presence of errors), and other similar look-up functions. Second, it groups accounts by a common edit exception code. These are needed in ES2E to scan the Micro Edit File by error code. Third, it allows a cross-reference to show the first record atop each page of the most recently processed micro edits (using the Micro Exception Report, rather than the non-employment/wage edit report, which is less comprehensive). The MEXR File is rebuilt from scratch with every micro edit run (Jobs 001D, 001Q, 002D, 028D, and 242D). The only updates made to this file occur on-line with the ES2E screen, and the ES2H screen, when errors are corrected, new edit exceptions are added, or Micro Edit records are deleted by clearing up all edit exceptions. |
Related Links