QCEW Field Layouts for ENB-END Files

The tables below describe the file layouts for ENB(.enb) and END(.end) formatted QCEW data files. Files in these legacy formats are accessible from the year specific collection of NAICS-Based Data Files. ENB files contain four quarters of data along with annual averages. When a complete year of data is not available for the most-recent year, data are instead stored in END files. END files are broken down by quarter. The first table below details the ENB file layout. The second table below details the END file layout.



ENB File Layout

This table describes the file layout for NAICS-based ENB(.enb) files. QCEW provides formatting tools which help format these files. The table below is available as an Excel workbook (.xls), a comma separated values file (.csv), and as a flat, text file (.txt). Click the links below to download.

Related Documentation:   QCEW Data Guide;   Documentation Guide;  

DOWNLOAD: XLS CSV TXT

QCEW Field Layouts for ENB Files(For NAICS Coded Data)
Field
Number
Field
Title
Field
Name
Data
Type
Start
Position
End
Position
Field
Length
1 Survey Prefix prefix Text 1 3 3
2 Area Code area_fips Text 4 8 5
3 Datatype Code datatype Text 9 9 1
4 Size Code size_code Numeric 10 10 1
5 Ownership Code own_code Text 11 11 1
6 Industry Code industry_code Text 12 17 6
7 Year year Numeric 18 21 4
8 Aggregation Level agglvl_code Numeric 22 23 2
9 First Quarter Disclosure Code q1_disclosure_code Text 24 24 1
10 First Quarter Quarterly Number of Establishments q1_estabs_count Numeric 25 32 8
11 First Quarter January Employment q1_jan_emplvl Numeric 33 41 9
12 First Quarter February Employment q1_feb_emplvl Numeric 42 50 9
13 First Quarter March Employment q1_mar_emplvl Numeric 51 59 9
14 First Quarter Total Quarterly Wages q1_total_qtrly_wages Numeric 60 74 15
15 First Quarter Taxable Quarterly Wages q1_taxable_qtrly_wages Numeric 75 89 15
16 First Quarter Quarterly Contributions q1_contributions Numeric 90 102 13
17 First Quarter Average Weekly Wage q1_avg_wkly_wage Numeric 103 110 8
18 Second Quarter Disclosure Code q2_disclosure_code Text 111 111 1
19 Second Quarter Quarterly Number of Establishments q2_estabs_count Numeric 112 119 8
20 Second Quarter April Employment q2_apr_emplvl Numeric 120 128 9
21 Second Quarter May Employment q2_may_emplvl Numeric 129 137 9
22 Second Quarter June Employment q2_jun_emplvl Numeric 138 146 9
23 Second Quarter Total Quarterly Wages q2_total_qtrly_wages Numeric 147 161 15
24 Second Quarter Taxable Quarterly Wages q2_taxable_qtrly_wages Numeric 162 176 15
25 Second Quarter Quarterly Contributions q2_contributions Numeric 177 189 13
26 Second Quarter Average Weekly Wage q2_avg_wkly_wage Numeric 190 197 8
27 Third Quarter Disclosure Code q3_disclosure_code Text 198 198 1
28 Third Quarter Quarterly Number of Establishments q3_estabs_count Numeric 199 206 8
29 Third Quarter July Employment q3_jul_emplvl Numeric 207 215 9
30 Third Quarter August Employment q3_aug_emplvl Numeric 216 224 9
31 Third Quarter September Employment q3_sep_emplvl Numeric 225 233 9
32 Third Quarter Total Quarterly Wages q3_total_qtrly_wages Numeric 234 248 15
33 Third Quarter Taxable Quarterly Wages q3_taxable_qtrly_wages Numeric 249 263 15
34 Third Quarter Quarterly Contributions q3_contributions Numeric 264 276 13
35 Third Quarter Average Weekly Wage q3_avg_wkly_wage Numeric 277 284 8
36 Fourth Quarter Disclosure Code q4_disclosure_code Text 285 285 1
37 Fourth Quarter Quarterly Number of Establishments q4_estabs_count Numeric 286 293 8
38 Fourth Quarter October Employment q4_oct_emplvl Numeric 294 302 9
39 Fourth Quarter November Employment q4_nov_emplvl Numeric 303 311 9
40 Fourth Quarter December Employment q4_dec_emplvl Numeric 312 320 9
41 Fourth Quarter Total Quarterly Wages q4_total_qtrly_wages Numeric 321 335 15
42 Fourth Quarter Taxable Quarterly Wages q4_taxable_qtrly_wages Numeric 336 350 15
43 Fourth Quarter Quarterly Contributions q4_contributions Numeric 351 363 13
44 Fourth Quarter Average Weekly Wage q4_avg_wkly_wage Numeric 364 371 8
45 Annual Disclosure Code annual_disclosure_code Text 372 372 1
46 Annual Average Number of Establishments annual_avg_estabs_count Numeric 373 380 8
47 Annual Average Employment annual_avg_emplvl Numeric 381 389 9
48 Total Annual Wages total_annual_wages Numeric 390 404 15
49 Taxable Annual Wages taxable_annual_wages Numeric 405 419 15
50 Annual Contributions annual_contributions Numeric 420 432 13
51 Annual Average Weekly Wage annual_avg_wkly_wage Numeric 433 440 8
52 Average Annual Pay avg_annual_pay Numeric 441 449 9


END File Layout

The table below describes the file layout for NAICS-based END(.end) files. END files are provided when a full year's worth of data is not yet published. Each END file contains one quarter's worth of data. QCEW provides formatting tools which help format these files. The table below is available as an Excel workbook (.xls), a comma separated values file (.csv), and as a flat, text file (.txt). Click the links below to download.

DOWNLOAD: XLS CSV TXT

QCEW Field Layouts for END Files(For NAICS Coded Data)
Field
Number
Field
Title
Field
Name
Data
Type
Start
Position
End
Position
Field
Length
1 Survey Prefix prefix Text 1 3 3
2 Area Code area_fips Text 4 8 5
3 Datatype Code datatype Text 9 9 1
4 Size Code size_code Numeric 10 10 1
5 Ownership Code own_code Text 11 11 1
6 Industry Code industry_code Text 12 17 6
7 Year year Numeric 18 21 4
8 Quarter qtr Numeric 22 22 1
9 Aggregation Level agglvl_code Numeric 23 24 2
10 Disclosure Code disclosure_code Text 25 25 1
11 Quarterly Number of Establishments estabs_count Numeric 26 33 8
12 Month 1 Employment month1_emplvl Numeric 34 42 9
13 Month 2 Employment month2_emplvl Numeric 43 51 9
14 Month 3 Employment month3_emplvl Numeric 52 60 9
15 Total Quarterly Wages total_qtrly_wages Numeric 61 75 15
16 Taxable Quarterly Wages taxable_qtrly_wages Numeric 76 90 15
17 Quarterly Contributions contributions Numeric 91 103 13
18 Average Weekly Wage avg_wkly_wage Numeric 104 111 8

 

Last Modified Date: March 24, 2014