Difference between revisions of "06 quarterly publication output file es2pubq"
Daniela92H (talk | contribs) |
MattSteadman (talk | contribs) m (Text replacement - "[[start" to "[[EXPO_Documentation") |
||
(One intermediate revision by one other user not shown) | |||
Line 8: | Line 8: | ||
* [[06_quarterly_transaction_file_es2qtrn|Quarterly Transaction File (ES2QTRN)]] | * [[06_quarterly_transaction_file_es2qtrn|Quarterly Transaction File (ES2QTRN)]] | ||
* [[06_file_record_layouts|File Record Layouts Table of Contents]] | * [[06_file_record_layouts|File Record Layouts Table of Contents]] | ||
− | * [[ | + | * [[EXPO_Documentation|EXPO/EARS Documentation Home]] |
Latest revision as of 16:40, 11 July 2019
Quarterly Publication Output File (ES2PUBQ)
ES2PUBQ - Length 124 - Revised 2/15/2018
Columns | Len | Key | Type | COBOL Field Name | Description & Notes | |
1 | 124 | 124 | Char | PUBQ-DETAIL | Standard quarterly publication detail record | |
1 | 1 | 1R | Char | PUBQ-PART | Switch to denote partial masking of non-disclosable data; blank = disclosable data; 'D' = Nondisclosable data, partially masked | |
2 | 6 | 5R | Char | PUBQ-MSA | Metropolitan Statistical Area specification for data collection | |
4 | 6 | 3R | Char | PUBQ-CNTY | County FIPS Code, substitute for QMSA selection, above | |
7 | 7 | 1R | Char | FILLER | space | |
8 | 8 | 1R | Char | PUBQ-OWNER | Ownership code for publication data; '1' = Federal government; '2' = State government; '3' = Local government; '5' = Private industry | |
9 | 9 | 1R | Char | FILLER | space | |
10 | 49 | 40R | Char | PUBQ-DESC | Industry code description | |
50 | 50 | 1R | Char | FILLER | space | |
51 | 56 | 6R | Char | PUBQ-NAICS-CODE | NAICS coding for publication data | |
57 | 57 | 1R | Char | FILLER | space | |
58 | 64 | 7R | Num | PUBQ-FST-QTR-ESTAB | Number of establishments included in the oldest quarter of the selected time span | |
65 | 65 | 1R | Char | FILLER | space | |
66 | 73 | 8R | Num | PUBQ-EMPL1 | First month employment for selected quarter (or first 100 million people thereof) | |
74 | 74 | 1R | Char | FILLER | space | |
75 | 82 | 8R | Num | PUBQ-EMPL2 | Second month of employment in selected quarter | |
83 | 83 | 1R | Char | FILLER | space | |
84 | 91 | 8R | Num | PUBQ-EMPL3 | Third month's employment for selected quarter | |
92 | 92 | 1R | Char | FILLER | space | |
93 | 100 | 8R | Num | PUBQ-EMPL | Average monthly employment for selected quarter | |
101 | 101 | 1R | Char | FILLER | space | |
102 | 116 | 15R | Num | PUBQ-WAGE | Total wages for the selected quarter (limited to first $1 quadrillion) | |
117 | 117 | 1R | Char | FILLER | space | |
118 | 124 | 7R | Num | PUBQ-AWW | Average weekly wage; those macro aggregates with wages exceeding $10,000,000 per week will not be properly reported in this field | |
1 | 124 | 124 | Char | PUBQ-MASK-DETAIL | Alternate detail line with employment, wages, and establishment count removed; this line is used when the macro aggregate represents fully-masked non-disclosable data | |
1 | 1 | 1R | Char | PUBQ-MASK-PART | The "PART" name is a misnomer here, since this is used only for fully-masked, rather than partially-masked non-disclosable data. At any rate, the field is set to a 'D' for any fully-masked non-disclosable publication data. | |
2 | 6 | 5R | Char | PUBQ-MASK-MSA | MSA code of masked data | |
4 | 6 | 3R | Char | PUBQ-MASK-CNTY | County FIPS code of masked data; alternate to MSA code specification | |
7 | 7 | 1R | Char | FILLER | space | |
8 | 8 | 1R | Char | PUBQ-MASK-OWNER | Ownership code of masked macro data | |
9 | 9 | 1R | Char | FILLER | space | |
10 | 49 | 40R | Char | PUBQ-MASK-DESC | Description for industry code of masked data | |
50 | 50 | 1R | Char | FILLER | space | |
51 | 56 | 6R | Char | PUBQ-MASK-NAICS-CODE | NAICS code of masked macro data | |
57 | 57 | 1R | Char | FILLER | space | |
58 | 65 | 7R | Num | PUBQ-MASK-FST-QTR-ESTAB | This field is defined as numeric whereas the rest of them have been defined as character, since the establishment count is not non-disclosable as would the other fields be (employment and wages) | |
66 | 124 | 60R | Char | FILLER | have an asterisk at the end of each of the fields, namely 4 times 8 spaces and an '*'; once with 15 spaces and an "*", once with 7 spaces and an "*", and 1 space | |
Publication Single-Quarter Disk Output File Data Set Name: ES2.PUB.QTR.REPORT Service Center DSN: YBUssX.A145.PUB.QTR.REPORT, ('ss' = State FIPS code) Type of File: Sequential File Layout: ES2PUBQ The "PUBQ" Publication Output File is an alternative format to the PUBF file described previously. It is selected by the ES2J244D process automatically when a single quarter of data has been selected. Multi-quarter ranges must produce the PUBF output instead. This file includes three individual months of employment, not found in the other format. This information is immaterial to the multi-quarter averaging process. The additional fields in this record add to the record length, but no other significant difference exists between the multi- and single-quarter publication output formats. Once this file has been created, it can be downloaded to a PC for processing in a graphical interface system, or used in a more colorful publication environment that could use charts and graphs to assist in the visualization of the data. |
Related Links