Quarterly Census of Employment and Wages

QCEW Field Layouts for EWB Files(For SIC Coded Data)

This table describes the file layout for SIC-based EWB(.ewb) files. Files in this legacy format are accessible from the year specific collection of SIC-Based Data 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 EWB Files(For SIC 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

Last Modified Date: March 24, 2014

Recommend this page using: