06 summary output file job 007d es2summ
Summary Output File (from Job 007D) (ES2SUMM)
ES2SUMM - Length 106 - Revised 12/27/2007
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 5 | 5 | Key | Char | SUMM-MSA | (Optional) Metropolitan Statistical Area (MSA) Code for aggregating multiple counties within the MSA; if county is used instead, first two characters of the MSA field will be blank |
3 | 5 | 3R | Key | Char | SUMM-CNTY | County FIPS code, an alternative to (and redefinition of) the MSA code shown above; if an MSA is used instead, the two characters prior to the county field will be numeric |
6 | 6 | 1 | Key | Char | SUMM-OWN | Ownership code for the aggregate to follow (1, 2, 3, or 5) |
7 | 7 | 1 | Key | Char | SUMM-TYPE-COV | Type of coverage for the aggregate that follows (0, 1, 2, 3, 8, 9) |
8 | 11 | 4 | Key | Char | SUMM-ZONE | Sub –county zone (or optionally, the 3-digit township followed by a space) of aggregated data to follow |
12 | 17 | 6 | Key | Char | SUMM-NAICS | NAICS code for the following aggregate |
18 | 24 | 7 | Key | Num | SUMM-UNITS | Number of establishments included in this aggregate; it is unknown why this field has been included as part of the key, with the possible exception of a means of distinguishing between two otherwise identical aggregates |
25 | 32 | 8 | Num | SUMM-MON1-EMPL | Employment count for the first month of the selected quarter; since the quarter is not specified anywhere in the record layout, its identity must either be found in the file ID itself or through the memory of the analyst. | |
33 | 40 | 8 | Num | SUMM-MON2-EMPL | Summed employment for the second month of the quarter | |
41 | 48 | 8 | Num | SUMM-MON3-EMPL | Employment aggregate for the third month of the quarter | |
49 | 56 | 8 | Num | SUMM-AVG-WORKERS | Average monthly employment for the three months of the designated quarter | |
57 | 69 | 13 | Num | SUMM-TOT-WAGE | Aggregate total wages for the quarter among all of the establishments contained within this sum | |
70 | 76 | 7 | Num | SUMM-AVG-WAGE | Average Quarterly Wage (AQW) value for this aggregate (based on the formulation – SUMM-AVG-WAGE = SUMM-TOT-WAGE / (SUMM-MON1-EMPL + SUMM-MON2-EMPL + SUMM-MON3-EMPL) x 3; the $10 million limit is considered adequate for all areas of the country | |
77 | 88 | 12 | Num | SUMM-TAX-WAGE | Aggregated taxable portion of wages for all establishments that comprise this total | |
89 | 98 | 10 | Num | SUMM-CONTRIB | Assessed contributions, aggregated over the population of establishments that comprise this sum | |
99 | 106 | 8 | Num | SUMM-STATE-USAGE | Summed data from the quarterly State Usage field for all establishments included in the current aggregate; the state usage field may or may not contain numeric data, depending on how it is used by the State; of course, non-numeric data will be ignored | |
Summarized Micro Data Output File (optional output from Job 007D) Data Set Name: ES2.JOB007D.FILE Service Center DSN: YBUssX.A145.JOB007D.FILE, ('ss' = State FIPS code) Type of File: Sequential File Layout: ES2SUMM The Summarized Micro Data Output File is an optional output for the Firm Listing/Summary Report Job (007D). It serves as an alternative to the Summary Report, but provides the same information in a machine-readable form. The data can be downloaded for additional analysis on a PC, or it can be used as an alternative data source on the mainframe for supplemental investigation. Note: The year/quarter field was never included in this file format. Therefore, it is imperative that the QCEW analyst using this file be aware of the quarter it represents; otherwise, the analysis may be skewed. |
Related Links