06 statewide macro file es2smac
Statewide Macro File (ES2SMAC)
ES2SMAC - Length 61 - Revised 9/8/2006
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
| 1 | 1 | 1 | Key | Char | SMAC-IND-TYPE | Industry type code; 'S' = SIC data used in this record; 'N' = NAICS data used here; 'Z' = Fuzzed adjustment made to account for non-CIPSEA compliant data inclusion |
| 2 | 8 | 7 | Key | Char | SMAC-ON | Ownership and NAICS combination, separated below |
| 2 | 2 | 1R | Key | Char | SMAC-OWN | Ownership code for statewide aggregation, '1' = Federal government, '2' = State government, '3' = Local government, '5' = Private ownership |
| 3 | 8 | 6R | Key | Char | SMAC-NAICS | NAICS code for statewide aggregation; also used for SIC when last two digits of NAICS code are blank, as shown below; in addition, industry type code (above)must agree with the type of industry |
| 3 | 6 | 4R | Key | Char | SMAC-SIC | SIC code for statewide aggregation (when last two digits of NAICS are blank) |
| 9 | 13 | 5 | Key | Num | SMAC-YRQ | Year and quarter for aggregating macro data statewide, yyyyq format |
| 14 | 19 | 6 | Pack | SMAC-LARGEST-UI | 10-digit U-I account number of the largest firm present in this statewide aggregation | |
| 20 | 23 | 4 | Comp | SMAC-LARGEST-EMPL | 8-digit, signed third month employment for largest firm in aggregate; limit 100 million employees | |
| 24 | 27 | 4 | Comp | SMAC-UNIQUE-ACCTS | 8-digit, signed number of firms detected as belonging to this statewide total; may not be accurate, since the aggregation of multiple counties to statewide total will often include the same U-I account in multiple cells that compose the larger totals | |
| 28 | 31 | 4 | Comp | SMAC-UNITS | 8-digit, signed total number of units (establishments) represented by the statewide aggregate total; up to 100 million establishments can be included | |
| 32 | 35 | 4 | Comp | SMAC-MON1-EMPL | 8-digit combined first month employment for the quarter, limited to 100 million people value is signed for "Z" records, which can include negative adjustments | |
| 36 | 39 | 4 | Comp | SMAC-MON2-EMPL | 8-digit combined second month employment for the quarter; value is signed for "Z" records, which can include negative adjustments | |
| 40 | 43 | 4 | Comp | SMAC-MON3-EMPL | 8-digit combined third month employment for the quarter; value is signed for "Z" records, which can include negative adjustments | |
| 44 | 49 | 6 | Pack | SMAC-TOTAL-WAGE | 11-digit combined total wages for the quarter, under this industry and ownership; since this allows for $100 billion in quarterly wages, it should suffice for most States | |
| 50 | 55 | 6 | Pack | SMAC-TAX-WAGE | 11-digit combined taxable wages for the quarter; virtually every industry code in the State show fall within the $100,000,000,000 taxable wage limit | |
| 56 | 61 | 6 | Pack | SMAC-CONTRIB | 11-digit combined contributions for the quarter under this industry and ownership; at present, $100 billion tax limit per industry has not presented a problem for any States | |
Statewide Macro File Data Set Name WS.ES202.STATE.MACRO Service Center DSN: YBUssX.A145.ALPHA, ('ss' = State FIPS code) Type of File: VSAM indexed File Layout: ES2SMAC CICS ID: ES2SMAC (Standard); EssSMAC (Service Center; ss=State) The Statewide Macro File is an aggregation of Macro File records for all counties to show a statewide total for quarterly data by industry and ownership. The file is created "from scratch", using a presorted version of the Macro File for input data. These sorted, sequential records are read into an aggregation program, which writes summed data to statewide records and merges the disclosability-related fields, such as the largest firm data. The aggregate records are then used to populate the VSAM State Macro File. Whenever aggregates of macro records are used, the disclosability detection may occasionally experience an inaccuracy. For instance, if one firm has worksites in several counties, and usually, but not always, represents the largest employment for that industry in those counties, there is a chance that the statewide totals will misrepresent the percentage of total employment represented by this firm. If that misrepresented percentage falls just below 80%, when in actuality the firm does have 80% of the employment statewide, the data would incorrectly be shown as disclosable. Such borderline cases are rare, though they can occur. The Statewide Macro File is accessed by the ES2D CICS screen when no county or MSA is included in the selection parameters at the bottom of the screen. By utilizing this file, ES2D is able to handle any statewide totaling request at many times the speed required in reading the standard Macro File. As a result, there should rarely be any problems with CICS time-out errors (due to excessive I/O activities). The Statewide Macro File is rebuilt in Jobs ES2J241D and ES2J242D, which can be run whenever they are needed. | ||||||
Related Links
