06 county based macro micro crosswalk file es2xwlk
County-based Macro-to-Micro Crosswalk File (ES2XWLK)
ES2XWLK - Length 28 - Revised 3/12/2004
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 3 | 3 | Key | Num | XWLK-YRQ | Year and quarter of cross-walk relationship, yyq format, sub-defined below |
1 | 2 | 2 | Key | Num | XWLK-YEAR | Year portion of year/quarter for crosswalk relationship |
3 | 3 | 1 | Key | Num | XWLK-QTR | Quarter portion of year/quarter for crosswalk relationship, 1, 2, 3, or 4 |
4 | 6 | 3 | Key | Char | XWLK-CNTY | FIPS County code assigned to the account for this quarter |
7 | 7 | 1 | Key | Char | XWLK-OWN | Ownership code assigned to the account this year/quarter, '1' = Federal government, '2' = State government, '3' = Local government, '5' = Private industry |
8 | 13 | 6 | Key | Char | XWLK-NAICS | North American Industry Classification System code |
14 | 28 | 15 | Key | Char | XWLK-SESA-ID | SESA ID (combined U-I account and RUN) found in this code group (see below) |
14 | 23 | 10R | Key | Char | XWLK-ACCT | U-I account number portion of SESA ID, right-justified with leading zeroes |
24 | 28 | 5R | Key | Char | XWLK-RPT-UNIT | Reporting unit portion of the SESA ID, values 00000 through 99999 are possible |
County-based Macro-to-Micro Crosswalk File Data Set Name: WS.ES202.CNTY.XWLK Service Center DSN: YBUssX.A145.CNTY.XWLK, ('ss' = State FIPS code) Type of File: VSAM indexed File Layout: ES2XWLK CICS ID: ES2XWLK (Standard); EssXWLK (Service Center; ss=State) The County Crosswalk File provides a direct correlation between micro and macro-level data. The crosswalk data collection (ES2UT04) program builds the initial sequential Crosswalk File in U-I account number sequence at the same time that the initial Statewide Crosswalk File is written. The data are then externally sorted to appear in year/quarter, county, ownership, NAICS sequence. The sorted output file is reproduced (or "REPRO'ed") into the VSAM County-based Crosswalk File, at which point it becomes a read-only file. Since an establishment can periodically change its industry classification, county or even its ownership code, a single matching of a SESA ID to its county-owner-NAICS affiliation is only legitimate for a single quarter. To reconcile this problem, the Crosswalk File format is augmented to include the year and quarter of the Micro File account's county-owner-NAICS assignment. In this way, the micro-level detail of the ES2D CICS transaction can be complete and accurate for any quarter present on all three files (the Macro, Micro, and Crosswalk Files). The ES2D screen lists U-I accounts that match a specified county, ownership and 6-digit NAICS code on the Macro File. This can be further reduced by the notation of employment limits and required percentage changes of employment and total wages. These same specifications can be applied to the ES2F firm list display screen, but the selection is expanded to include multiple NAICS codes and/or ownerships. The Statewide Crosswalk File is substituted in the ES2F selections if the county code is not specified. The County-based Crosswalk File is automatically rebuilt in Jobs ES2J001D, ES2J001Q, ES2J241D and ES2J242D, but may be rebuilt more frequently by submitting Job ES2J051D. These jobs all run the same (ES2UT04) data collection program. |
Related Links