06 macro rollup file es2rlup
Macro Rollup File (ES2RLUP)
ES2RLUP - Length 102 - Revised 3/11/2005
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 2 | 2 | Key | Char | RLUP-STATE-FIPS | FIPS State Code |
3 | 6 | 4 | Key | Char | RLUP-REQUEST-ID | Request Identification Code (used for selecting parm sets from ES2N's 46D process) |
7 | 11 | 5 | Key | Char | RLUP-MSA | Metropolitan Statistical Area (MSA) code (if blank, not in effect) |
12 | 12 | 1 | Key | Char | RLUP-OWN | Ownership code, blank = Aggregated (all ownerships), '1' = Federal government, '2' = State government, '3' = Local government, '5' = Private ownership |
13 | 15 | 3 | Key | Char | RLUP-CNTY | County FIPS code, blank = Aggregated (all counties) |
16 | 16 | 1 | Key | Char | RLUP-MAJOR-IND | Major industry code, if used as an aggregation level |
17 | 22 | 6 | Key | Char | RLUP-NAICS | North American Industry Classification System code; also may represent SIC code (see below) if last two digits are blank |
17 | 20 | 4R | Key | Char | RLUP-SIC | Standard Industrial Classification, blank = Aggregated (all industries) |
23 | 27 | 5 | Char | RLUP-YRQ | Year/quarter for macro rollup data to follow (yyyyq format) | |
28 | 102 | 75 | Char | RLUP-EMP-DATA | Group-level definition of employer aggregated data, subdivided below | |
28 | 35 | 8R | Num | RLUP-REPUNIT | Number of reporting units (establishments) in this macro aggregate record | |
36 | 44 | 9R | Num | RLUP-MONTH1 | First month employment for the macro aggregate | |
45 | 53 | 9R | Num | RLUP-MONTH2 | Second month employment | |
54 | 62 | 9R | Num | RLUP-MONTH3 | Third month employment | |
63 | 76 | 14R | Num | RLUP-TOTAL-WAGE | Total wages for macro aggregate, ranging up to $100 trillion | |
77 | 90 | 14R | Num | RLUP-TAX-WAGE | Taxable wages for macro aggregate, with the same $100 trillion limit | |
91 | 102 | 12R | Num | RLUP-CONTRIB-DUE | Contributions for macro aggregate, able to handle up to a trillion dollars in U-I taxes | |
Macro Rollup Data File Data Set Name: ES2.MACRO.DATAn (where 'n' is an integer from 1 through 9) Service Center DSN: YBUssX.A145.MACRO.DATAn, ('ss' = State FIPS code; 'n' = 1 - 9) Type of File: Sequential File Layout: (ES2RLUP) The Macro Rollup Data File is used as an optional output file, produced by the Macro Roll-up print job (ES2J246D). This file is used in place of the Roll-up Report when data are required in a machine-readable form. It contains wage and employment data for the MSA (optional), county, ownership, SIC and quarter parameters selected in the macro roll-up selection screen of ES2N. The numeric digit at the end of the file name comes from the parameter sequence number, as depicted in the row of parameter request ID's listed on the ES2N screen ('1' is used for the first parameter ID selected, etc.). Aggregated data can be represented on this file as well (with the multiple-valued fields appearing as spaces), according to the parameters specified in three aggregation switches. However, other features, such as a four-quarter total (one of the screen parameter specifications) are not included in this file. Due to the unique (parameter-based) file names, up to nine of these output files can be produced in a single Job 46D run. After they have been produced, the files can be accessed by State-specific programs to produce reports and files external to the EXPO system. |
Related Links