06 roll up data collection file es2roll
Roll-up Data Collection File (ES2ROLL)
ES2ROLL - Length 75 - Revised 9/8/2006
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
= Roll-Up Report Record Key = | ||||||
1 | 4 | 4 | Key | Num | ROLL-REQUEST-ID | Roll-up Parameters record ID code (from ES2RUP) |
5 | 9 | 5 | Key | Char | ROLL-MSA | Metropolitan Statistical Area (MSA) for roll-up data, blank if not used |
10 | 10 | 1 | Key | Char | ROLL-OWNER | Ownership code, blank = Aggregate, '1' = Federal, '2' = State, '3' = Local, '5' = Private |
11 | 13 | 3 | Key | Char | ROLL-COUNTY | County FIPS code, blank if counties aggregated |
14 | 14 | 1 | Key | Char | ROLL-MAJOR-IND | Major Industry classification code, blank = Unused or aggregated, 'A' = Agriculture, 'B' = Mining, 'C' = Construction, 'D' = Manufacturing, 'E' = Transportation and Public Utilities, 'F' = Wholesale Trade, 'G' = Retail Trade, 'H' = Finance, Insurance, and Real Estate, 'I' = Services, 'J' = Public Administration, 'K' = Nonclassified Establishments -- or – NAICS-based grouped sector code, blank = Unused or aggregated, 'A' = Raw Materials, 'B' = Good Production, 'C' = Distribution and Transportation of Goods, 'D' = Information, 'E' = Finance, Real Estate, Rentals, 'F' = Professional / Business Services, 'G' = Education, Health, Social Services and Assistance, 'H' = Leisure, Accommodations, and Food Services, 'I' = Other Services, 'J' = Public Administration, 'K' = Unclassified Establishments |
15 | 20 | 6 | Key | Char | ROLL-NAICS | North American Industry Classification code; will be SIC if last two digits blank |
15 | 18 | 4R | Key | Char | ROLL-SIC | SIC code, substitutes for NAICS where needed, blank = aggregated industries |
19 | 20 | 2R | Key | Char | ROLL-NAICS-EXT | Determinant for industry type; if numeric, NAICS used; if blank, SIC in use |
= Matrix Report Record Key = | ||||||
1 | 4 | 4 | Key | Num | ROLL-MTRX-REQ-ID | Roll-up Parameters record ID code (from ES2RUP) |
5 | 9 | 5 | Key | Char | ROLL-MTRX-YRQ | Year and quarter of matrix data (repeated here to aid in data sorting) |
10 | 12 | 3 | Key | Char | ROLL-MTRX-COUNTY | County FIPS code |
13 | 13 | 1 | Key | Char | ROLL-MTRX-MAJ-IND | Major Industry Code (see values for ROLL-MAJOR-IND) |
14 | 20 | 7 | Key | Char | FILLER | spaces |
= Data Portion of the Record = | ||||||
21 | 25 | 5 | Num | ROLL-YRQ | Year and quarter for rollup data (yyyyq format) | |
21 | 24 | 4R | Num | ROLL-YEAR | Year portion of year/quarter identifier | |
25 | 25 | 1R | Num | ROLL-QTR | Quarter portion of year/quarter identifier (1, 2, 3 or 4) | |
26 | 29 | 4 | Comp | ROLL-UNITS | Reporting unit count (8 digits, signed) | |
30 | 33 | 4 | Comp | ROLL-MONTH1 | First month's employment (9 digits, signed) | |
34 | 37 | 4 | Comp | ROLL-MONTH2 | Second month's employment (9 digits, signed) | |
38 | 41 | 4 | Comp | ROLL-MONTH3 | Third month's employment (9 digits, signed) | |
42 | 48 | 7 | Pack | ROLL-TOTAL-WAGE | Total wages (13 digits) | |
49 | 55 | 7 | Pack | ROLL-TAX-WAGE | Taxable wages (13 digits) | |
56 | 61 | 6 | Pack | ROLL-CONTRIB-DUE | Contributions due (11 digits) | |
62 | 67 | 6 | Pack | ROLL-BIG-M3-UI | U-I account number (10 digits) of firm with the largest third month employment | |
68 | 71 | 4 | Comp | ROLL-BIG-M3-EMPL | Largest firm's employment (can not exceed 100 million employees) | |
72 | 75 | 4 | Comp | ROLL-UNIQUE-ACCTS | Number of unique firms in the macro cell or aggregate | |
Macro Rollup Data Collection File Data Set Name: ES2.ROLLUP.DATA Service Center DSN: YBUssX.A145.ROLLUP.DATA, ('ss' = State FIPS code) Type of File: Sequential File Layout: ES2ROLL The Rollup Data Collection File is created by Job 246D, during the data collection phase. One program performs the data gathering, while another uses the collection (following an external sort of the records), to produce the macro roll-up reports and/or output files. This process provides the information needed to fill the requests for macro-level data as specified by CICS ES2N screens. Two formats are possible for the record key, one for county-by-major-industry matrix report option, the other for the standard macro rollup report. The Macro Rollup Parameters File (ES2RUP) provides the selection parameter specifications. |
Related Links