An official website of the United States government
United States Department of Labor
United States Department of Labor
The .gov means it's official.
Federal government websites often end in .gov or .mil. Before sharing sensitive information,
make sure you're on a federal government site.
The site is secure.
The
https:// ensures that you are connecting to the official website and that any
information you provide is encrypted and transmitted securely.
Quarterly Census of Employment and Wages
SHARE ON:
QCEW Field Layouts for EWB Files (SIC-Based)
This table describes the file layout for SIC-based EWB(.ewb) files. These files are available from the historical SIC-Based Data Files table. QCEW provides formatting tools which help format these files.
The table below is available as an Excel workbook (.xlsx), 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;
| 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: April 5th, 2022