06 enhanced macro file without field compression es2emac
Enhanced Macro File (without field compression) (ES2EMAC)
ES2EMAC - Length 121 - Revised 2/13/2018
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 1 | 1 | Key | Char | EMAC-IND-TYPE | The type of data that will follow; 'N' = NAICS; 'S' = SIC |
2 | 11 | 10 | Key | Char | EMAC-CON | Combined County (EMAC-CNTY), Owner (EMAC-OWN) NAICS (EMAC-NAICS or SIC (EMAC-SIC) with two blank digits – EMAC-NAICS-5-6) |
2 | 11 | 10 | Key | Char | EMAC-ONC | For states that have ownership first, it would be a combination of ownership (EMACO-OWN), NAICS (EMACO-NAICS) or SIC (EMACO-SIC) with two blank digits (EMACO-NAICS-5-6), and county (EMACO-CNTY) |
12 | 16 | 5 | Key | Char | EMAC-YRQ | A combination of 4-digit year (EMAC-YEAR) and 1-digit quarter (EMAC-QTR); both of these sub-fields would be numeric |
17 | 26 | 10 | Num | EMAC-LARGEST-UI | Account number of largest contributor to the cell | |
27 | 35 | 9 | Num | EMAC-LARGEST-EMPL | Largest account's third month employment; signed numeric with picture of -99999999 | |
35 | 44 | 9 | Num | EMAC-UNIQUE-ACCTS | Number of unique accounts (10-digit accounts); signed numeric with picture of -9(08) | |
44 | 53 | 9 | Num | EMAC-UNITS | Number of worksites and singles; signed numeric, with a picture of -99999999 | |
54 | 62 | 9 | Num | EMAC-NON-ZERO-UNITS | Number of non-zero worksites and singles; signed numeric with picture of -99999999 | |
63 | 71 | 9 | Num | EMAC-MON1-EMPL | First month's employment; signed numeric with picture of -99999999 | |
72 | 80 | 9 | Num | EMAC-MON2-EMPL | Second month's employment; signed numeric with picture of -99999999 | |
81 | 89 | 9 | Num | EMAC-MON3-EMPL | Third month's employment; signed numeric with picture of -99999999 | |
90 | 100 | 11 | Num | EMAC-TOTAL-WAGE | Summed total wages; an unsigned numeric value | |
101 | 111 | 11 | Num | EMAC-TAX-WAGE | Summed taxable wages; an unsigned numeric value | |
112 | 121 | 10 | Num | EMAC-CONTRIB | Summed contributions due; a signed numeric with a picture of -999999999 | |
Enhanced Macro Output File Data Set Name: ES2.SEQL.MACRO Service Center DSN: YBUssX.A145.SEQL.MACRO, ('ss' = State FIPS code) Type of File: Sequential File Layout: ES2EMAC The Enhanced Macro (EMAC) Output File is essentially the same as the standard Macro File, except that all of the fields that had been packed, have been re-expanded. This causes the expanded version of the file to have over 70% longer records than the production Macro File. The EMAC File is most useful for States that desire to have all of their macro data put up front. Job 099B has been developed in part to convert the Macro File to the Enhanced Macro format. This job can be run only by a programmer, which also runs the Micro conversion. An oddity of this job has the record length is 113 characters rather than the 113 that this file claims; perhaps the sign byte is embedded within the records, which would be 8 bytes less. |
Related Links