06 summary differences file earsdif
Summary of Differences File (EARSDIF)
EARSDIF - Length 160 - Revised 8/2/2002
| Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
| 1 | 2 | 2 | Key | Num | SDIF-STATE-CODE | State FIPS code |
| 1 | 2 | 2R | Key | Char | SDIF-QMSA | Alternative use for State FIPS code to show the QMSA association for the county listed immediately below. This is only used in Job 42D when the integrated edits may need to include QMSA sorting for states using this geographic partitioning. |
| 3 | 12 | 10 | Key | Char | SDIF-CON | Codes portion of the record key -- combined county/ownership/NAICS code, broken out as listed below |
| 3 | 5 | 3R | Key | Char | SDIF-CNTY | FIPS County code |
| 6 | 6 | 1R | Key | Char | SDIF-OWN | Ownership code, '1' =Federal government, '2' = State government, '3' = Local government, '5' = Private industry |
| 7 | 12 | 6R | Key | Char | SDIF-NAICS | NAICS code |
| 3 | 12 | 10R | Key | Char | SDIF-ONC | Alternative codes key used for industry-based state processing; uses ownership/ NAICS/county sequence instead of the standard county/ownership/NAICS sequence the breakout appears below |
| 3 | 3 | 1R | Key | Char | SDIFO-OWN | Ownership code in O-N-C sequencing |
| 4 | 9 | 6R | Key | Char | SDIFO-NAICS | NAICS code in O-N-C sequencing |
| 10 | 12 | 3R | Key | Char | SDIFO-CNTY | FIPS county code in O-N-C sequencing |
| 13 | 16 | 4 | Key | Char | SDIF-YEAR | Ending year of refiling cycle (e.g., 2001 represents the 2000-2001 refiling year) |
| 17 | 25 | 9 | Num | SDIF-FROM-DEC-EMPL | December employment of establishments leaving the county, ownership, and industry during the refiling year; since there have been few instances of a billion employees (the limit) from a particular macro cell, all data should be safe | |
| 26 | 39 | 14 | Num | SDIF-FROM-QTR4-WAGES | Fourth quarter total wages of establishments exiting the county, owner, industry combination; up to $100 trillion in lost wages may be represented | |
| 40 | 48 | 9 | Num | SDIF-TO-DEC-EMPL | December employment of establishments introduced to this macro cell (billion limit) | |
| 49 | 62 | 14 | Num | SDIF-TO-QTR4-WAGES | Fourth quarter wages of establishments entering the macro cell ($100 trillion limit) | |
| 63 | 71 | 9 | Num | SDIF-FROM-JAN-EMPL | January employment of all establishments leaving this county/owner/industry | |
| 72 | 80 | 9 | Num | SDIF-FROM-FEB-EMPL | February employment of establishments leaving the macro cell | |
| 81 | 89 | 9 | Num | SDIF-FROM-MAR-EMPL | Summed March employment for establishments leaving this macro cell | |
| 90 | 103 | 14 | Num | SDIF-FROM-QTR1-WAGES | First calendar quarter total wages of establishments exiting this county, ownership, and industry (SIC/NAICS) combination during the refiling cycle | |
| 104 | 112 | 9 | Num | SDIF-TO-JAN-EMPL | January employment of establishments entering the macro cell | |
| 113 | 121 | 9 | Num | SDIF-TO-FEB-EMPL | February employment of establishments entering this macro cell | |
| 122 | 130 | 9 | Num | SDIF-TO-MAR-EMPL | March employment of establishments arriving in this macro cell during refiling | |
| 131 | 144 | 14 | Num | SDIF-TO-QTR1-WAGES | Combined first calendar quarter total wages (or the first $100,000,000,000,000 there-of) of all establishments joining this county/ownership/industry through refiling | |
| 145 | 152 | 8 | Num | SDIF-UNITS-LEAVING | Number of establishments exiting this county, ownership and SIC/NAICS during the refiling year (can only take the first 100 million establishments) | |
| 153 | 160 | 8 | Num | SDIF-UNITS-ENTERING | Number of establishments that were added to this county/ownership/industry via this year's refiling cycle (up to 100,000,000 units can be accommodated) | |
Summary of Differences File Data Set Name: EAR.SUMM.DIFFS Service Center DSN: YBUssR.A145.SUMM.DIFFS ('ss' = State FIPS code) Type of File: Sequential File Layout: EARSDIF The Summary of Differences File provides auxiliary data to the first quarter macro edit processing in EXPO. This file shows summarized code change data, merged into the county-owner-NAICS (or owner-NAICS-county) affiliations they possess. Although listed as an EARS file, it is produced with EXPO data. The file is produced by Job ES2J242D (to perform the EXPO micro- and macro-level edits and integrating the two reports). First an EXPO program (ES2UT25) builds the CCS File, which would be an EARS-related program as well, except that it uses the EXPO Micro File for drawing source data, and is used in an EXPO batch job. The CCS File contains individual code change records that had already been transferred to the EXPO Micro File by Job 13D. The CCS records are then externally sorted twice, once by new codes and the other time by old codes. The two resultant files are merged by the Summary of Differences File producing program (an EARS program, EARRF10). The file is then utilized in the macro edit program to offset code-change-related employment and wage fluctuations. It is also taken in by the micro/integrated edit program to list the code change totals with the macro data to prepare the integrated edit report. After this processing has finished, the file is eliminated. | ||||||
Related Links
