06 micro archive file es2miar
Micro Archive File (ES2MIAR)
ES2MIAR - Length 145 - Revised 2/14/2018
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 15 | 15 | Key | Char | MIAR-SESA-ID | State Employment Security Agency identification number of the Micro Archive record, subdivided below |
1 | 10 | 10R | Key | Char | MIAR-ACCT | U-I Account number portion of the SESA ID, using numeric digits, right-justified with leading zeroes |
11 | 15 | 5R | Key | Char | MIAR-RPT-UNIT-X | Reporting unit number portion of the SESA ID; numeric field excludes "-X" from name |
16 | 43 | 28 | Char | MIAR-NAME | Employer name (legal or DBA) | |
44 | 145 | 102 | Char | MIAR-QTR-DATA | Quarterly data archived from the Micro File record | |
44 | 48 | 5R | Char | MIAR-YEARQ | Year/quarter for archived micro data to follow; yyyyq format | |
44 | 45 | 2R | Char | MIAR-CENT | Century portion of the year, which needs to be set separately, due to the use of 2-digit year fields in the micro data | |
46 | 48 | 3R | Char | MIAR-YRQ | Combined 2-digit year and quarter to match micro data (yyq format) | |
46 | 47 | 2R | Char | MIAR-YR | Standard two-digit year sub-field | |
48 | 48 | 1R | Char | MIAR-QTR | Quarter of the year (1, 2, 3, or 4) | |
49 | 49 | 1R | Char | MIAR-STATUS | Activity status code for the quarter; '1' = Active; '2' = Inactive; '9' = Pending | |
50 | 52 | 3R | Char | MIAR-CNTY | FIPS county code for the archived quarter | |
53 | 54 | 2R | Char | MIAR-OWNER | Ownership code for the archived quarter | |
53 | 53 | 1R | Char | MIAR-OWN1 | Leading digit of the ownership code; '1' = Federal government, '2' = State government, '3' = Local government, '5' = Private ownership | |
55 | 60 | 6R | Char | MIAR-NAICS | NAICS code for the archived quarter | |
61 | 61 | 1R | Char | MIAR-TYPE-COV | Type of coverage code for the archived quarter | |
62 | 65 | 4R | Char | MIAR-ZONE | Sub-county zone code for the quarter | |
62 | 64 | 3R | Char | MIAR-TOWN | New England township code that may be substituted for the zone | |
66 | 67 | 2R | Num | MIAR-ECCI | Economic code change indicator, combining multiple fields' economic change notation by summing numerics in the '-CHG-IND' (numeric) equivalent of this field, using values of 08 (county), 04 (owner), 02 (NAICS), and 01 (township (or zone)) changes Former usage of values for the NSTA and SIC codes have been withdrawn; numeric equivalent field is defined as MIAR-ECCI | |
68 | 68 | 1R | Char | MIAR-MEEI | Multi-establishment employer indicator for the archived quarter (values 1 through 6) | |
69 | 71 | 3R | Pack | MIAR-PLACE | 5-digit Sub-county geographic place (community/city) code (values found in Lookup File's 'PL' records); once known as MIAR-CITY | |
72 | 73 | 2R | Char | MIAR-PLACE-CLASS | At one time known as MIAR-CITY-TYPE, the Place Class code denotes the classification of the community or geographic entity | |
74 | 81 | 8R | Pack | MIAR-CENSUS-BLOCK | Census subcategory for geographic placement, a 15-digit Census Block in the form of 'sscccttttxxbbbb', where 'ss' = State FIPS; 'ccc' = County FIPS; 'tttt' = Census tract; 'xx' = Tract extension/suffix; 'bbbb' = Census block number) | |
82 | 82 | 1R | Char | MIAR-DATA-SOURCE | Quarterly data source/EDI indicator code; 'C' = CENCO-verified EDI participant; 'E' = standard EDI participant; 'M' = MWR form submitted on the web; 'Q' = QCR form submitted on the web; 'S' = Data obtained from State media; 'X' = Former EDI participant, no longer involved in the program | |
83 | 86 | 4R | Char | MIAR-AGENT-CODE | Agent code, denoting participation with a payroll provider or related service; field is quarter specific | |
87 | 92 | 6R | Char | MIAR-NAIC12 | Final NAICS-2012 code at the end of the 2017 refiling cycle; not useful to any other time span than first quarter of 2017 | |
93 | 93 | 1R | Char | MIAR-EDIT-FLAG | Edit flag setting for the archived quarter | |
94 | 94 | 1R | Char | MIAR-EST-FLAG | Estimation flag setting for the archived quarter | |
95 | 95 | 1R | Char | MIAR-DELQ-FLAG | Delinquency indicator flag for the archived quarter | |
96 | 98 | 3R | Pack | MIAR-TAX-RATE | Archived quarter's tax rate, in thousandths of a percent (V99999 format) | |
99 | 102 | 4R | Pack | MIAR-M1-EMPL | First month's employment in archived quarter (6-digit) | |
103 | 103 | 1R | Char | MIAR-M1-IND | Reporting status indicator for the first month's employment | |
104 | 107 | 4R | Pack | MIAR-M2-EMPL | Second month's employment (6-digit) | |
108 | 108 | 1R | Char | MIAR-M2-IND | Indicator associated with second month's employment | |
109 | 112 | 4R | Pack | MIAR-M3-EMPL | Third month's employment (6-digit) | |
113 | 113 | 1R | Char | MIAR-M3-IND | Third month employment indicator code | |
114 | 119 | 6R | Char | MIAR-STATE-USAGE | Quarterly state usage field for archived quarter | |
120 | 125 | 6R | Pack | MIAR-TOTAL-WAGE | Total wages represented in archived quarter (11-digit) | |
126 | 126 | 1R | Char | MIAR-TOTW-IND | Indicator for quarter's total wages | |
127 | 132 | 6R | Pack | MIAR-TAX-WAGE | Taxable wages for the archived quarter (11-digit) | |
133 | 133 | 1R | Char | MIAR-TAXW-IND | Taxable wage indicator | |
134 | 138 | 5R | Pack | MIAR-CONTRIB-DUE | Contributions due for the archived quarter (9-digit) | |
139 | 139 | 1R | Char | MIAR-CTRB-IND | Contribution indicator | |
140 | 145 | 6R | Char | MIAR-COMMENT-CODE | Up to three comment codes assigned to the establishment for this quarter | |
140 | 141 | 2R | Char | MIAR-CMNT1 | First comment code for the quarter | |
142 | 143 | 2R | Char | MIAR-CMNT2 | Second comment code for the quarter | |
144 | 145 | 2R | Char | MIAR-CMNT3 | Third possible comment code for the quarter | |
Micro Archive File Data Set Name: WS.ES202.MICRO.ARCHIVE(+0) Service Center DSN: YBUssX.A145.MICRO.ARCHIVE(+0), ('ss' = State FIPS code) Type of File: Sequential File Layout: ES2MIAR This file is a Generation Data Group (GDG) archival of quarterly Micro File data. A quarter may be archived to this file by an option found in the Job 01Q parameters. Archiving is accomplished by the quarter-shifting program (ES2UT22), and the quarter is merged in with any other quarters already present on the file. The data on each record is identical in format to the quarterly portion of the Micro File, except that the year/quarter field uses a 4-digit year here, rather than the 2-digit year on the Micro record; this is needed to keep archival data in proper time sequence through the millennial cross-over. A name field is included in this file as well to better identify the employer. The Micro Archive File can grow to contain more than five years of micro data (the specific limit is not yet set). The file is currently only readable by the 020D job (and the CIPSEA-compliant equivalent (020C)), when a Micro Selection Report requires data for a quarter that no longer exists on the Micro File. Of course, since archived data contain no administrative fields (except for the employer name), there may be establishments that have been removed from the Micro File that will be unable to present such information as a name-and-address report. |
Related Links