06 quarterly publication output file es2pubq

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 govern­ment; '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

• Quarterly Transaction File (ES2QTRN)
• File Record Layouts Table of Contents
• EXPO/EARS Documentation Home