OCCCODES

The occcodes table contains industry codes of all types. It references the occtypes table. Depending on what tables your state populates and how long the historical series is, which code types you need may vary quite a bit.

Data Sources

System
Versions
WID Content and Crosswalks
Notes
SOC  2018 SOC  soc2018
 soc2018xsoc2010
Not yet in use for publication – the OES program will begin collecting the data in this coding structure with the Spring 2018 panel
 2017 SOC revisions  changes This is not a separate coding structure, but some revisions were made affecting roll-ups and certain detailed industries
 2010 SOC  soc2010 This is in active use for most BLS and related products
 2000 SOC  soc2000
 1998 SOC  soc1998
ONET  2010 ONET
 Prior versions
ONET has more detail than SOC and has two more digits to reflect that. In most cases, the two systems can be crosswalked by directly matching the first 6 digits of the code, but the identification of occupations with more detail and aggregating those detailed occupations requires caution
DOT  DOT The Department of Labor (DOL) last revised DOT in 1991 and later replaced it with ONET. However, a number of specific applications still use DOT e.g. the USCIS and apprenticeships
CIP  CIP 2010 (current)
 Prior versions
 cip2000
 cip2010
Classification of Instructional Programs (CIP) is used by the Department of Education to describe classes, credentials, and courses of study. In recent years, many different approaches to matching CIP codes to occupational codes have been attempted in order to research labor force mismatches and the benefits of higher education.
Census Codes  Multiple versions Census, ACS, and CPS – surveys conducted by the Census Bureau – all use their own coding systems dictated by the survey design.  They provide classification systems and crosswalks
OES  OES (current)
 Prior versions
The OES program bases its codes on SOC, but because of survey methodology it has additional codes and roll-ups.  In prior years OES had its own coding structure
Matrix  BLS Documentation  OCCDIR The Projections program bases its codes on OES/SOC, but has some non-standard codes

Table Format

No recent changes.

WID2.7

Update Calendar

Variable by occupational coding type.

Related Tables

Links to the table description in the current structure document.  Note: Page anchors do not work in Microsoft Edge (the default browser for some states).

OCCTYPES

OCCTYPES recommended content

 

   

INDCODES

The indcodes table contains industry codes of all types. It references the indtypes table. Depending on what tables your state populates and how long the historical series is, which code types you need may vary quite a bit.

Data Sources

System
Versions
WID Content
Notes
NAICS 2017 NAICS  INDCODES
 NAICCODE
NAICS 2017 had primarily additions to the coding structure, so it was added to indcodes using the same indcodtyp as NAICS 2012

NAICS Crosswalks

2012 NAICS   Structure
2007, 2002, 1997 NAICS QCEW switched from SIC to 2002 NAICS and back-coded data to 2000. The earliest NAICS codes for most of our products are from 2002
SIC Discontinued  SICCODE Standard Industrial Classification (SIC) was in use prior to 2000.  Questions about it still come up from people doing historical research
Census Codes Multiple versions  CENIND
 CENIND2000
Census, ACS, and CPS – surveys conducted by the Census Bureau – all use their own coding systems dictated by the survey design.  They provide classification systems and crosswalks
CES Codes  Available series  CESCODE This is a NAICS-based structure that has been modified to suit the survey methodology and universe of the CES program.  Because the data is intended for use in a time series, when codes are revised they are applied retroactively to the historic series
Matrix Codes  BLS Documentation  INDDIR The Projections program combines the industry structures from several programs and outputs data in NAICS, but with some non-standard codes

Table Format

No recent changes.

WID2.7

Update Calendar

Variable by industry coding type.

Related Tables

Links to the table description in the current structure document.  Note: Page anchors do not work in Microsoft Edge (the default browser for some states).

NAICCODE

INDTYPES

INDTYPES recommended content

   

LICAUTH

The licauth table contains all agencies that issue occupational licenses.  It is furnished to the ARC by state LMI offices.  For more detail on this process, see our FAQ.

Data Sources

The source for this data varies by state.

Table Format

No recent changes.

WID2.7

Update Calendar

States should submit revisions every two years.  To find out when your state’s most recent submission was, email Amanda at ARC.DEED@state.mn.us.

   

LICENSE

The license table is furnished to the ARC by state LMI offices.  For more detail on this process, see our FAQ.

Data Sources

The source for this data varies by state.

Table Format

No recent changes.

WID2.7

Update Calendar

States should submit revisions every two years.  To find out when your state’s most recent submission was, email Amanda at ARC.DEED@state.mn.us.

   

AREATYPE

A table containing identifiers for the geographic type, i.e., MSA, SDA, county city, township, etc.

Data Sources

National State/Local Notes
WID Version? Download Here Download Here These codes are generally specific to the WID, not drawn from the data source.

Many states have analysis regions, congressional districts, and WSAs that are available from state sources that can be assigned codes between 50 and 70 at the state’s discretion.

Table Format

No recent changes.

WID2.7

Update Calendar

N/A

   

SUBGEOG

A table containing identifiers for substate geographic areas. For each larger stfips, areatype, area combination, this table will contain a list of unique substfips, subareatyp and subarea smaller combinations that comprise the larger geographic area.

Data Sources

National State/Local Notes
Source Census Census National, state, counties, places, Metropolitan & micropolitan statistical areas, metropolitan divisions, combined statistical areas
State Specific Many states have analysis regions, congressional districts, and WSAs that are available from state sources.
WID Version? Download Here Download Here  All national, state, and local are contained in the same table.

Table Format

No recent changes.

WID2.7

Update Calendar

OMB: https://www.whitehouse.gov/sites/whitehouse.gov/files/omb/bulletins/2015/15-01.pdf

   

GEOG

The GEOG table is the central location for all geographic areas used in the database.

Data Sources

National State/Local Notes
Source Census Census National, state, counties, places, Metropolitan & micropolitan statistical areas, metropolitan divisions, combined statistical areas
State Specific Many states have analysis regions, congressional districts, and WSAs that are available from state sources.
WID Version? Download Here Download Here  All national, state, and local are contained in the same table.

Table Format

In version 2.7 the fields LATITUDE (numeric(11,6)), LONGITUDE (numeric(11,6)), GEOPCODE (char(1)) were added

WID2.7

WID2.6.1

Update Calendar

OMB: https://www.whitehouse.gov/sites/whitehouse.gov/files/omb/bulletins/2015/15-01.pdf

   

All Core Tables

As stated in the Employment and Training Administration (ETA), Workforce Information Core Products and Services Grant, “States are required to implement and maintain the most current version of the Workforce Information Database and populate all tables designated as core tables in accordance with guidelines issued by the Analyst Resource Center (ARC). Database content must be updated timely in order to be as current as the state’s most recent publications and data releases.”

See the ETA Guidelines page for more information regarding ETA requirements.

The following tables have been designated as the core Workforce Information Database tables.  Additional information is available for those tables with links.

Data Tables
CES
EMPDB
INDUSTRY
IOMATRIX
LABFORCE
LICAUTH*
LICENSE*
IOWAGE

Crosswalk Tables
LICXOCC*
MATXIND
MATXOCC

Admin Tables
INDCODES**
OCCCODES**

* Tables to be furnished to ARC for publication by CareerOneStop
** Need to populate additional lookup tables

Lookup Tables
ADDRESTY
ANNSLFLG
AREATYPE
BENMARK
CESCODE
CREDITCD
EMPSZFLG
EMPSZRNG
GEOCODE
GEOG
GROWCODE
INCOMTYP
INCSOURC
INDDIR
INDSUB
INDTYPES
LEVELTYP
LOCSTAT
OCCDIR
OCCSUB
OCCTYPES
OWNERSHP
PERIOD
PERIODID
PERIODTY
POPSOURC
RATETYPE
STATTYPE
STFIPSTB
SUBGEOG

   

INDUSTRY

Table of covered employment by industry collected for the ES-202/QCEW report.

Data Sources

National State/Local Notes
Source BLS BLS QCEW data is published quarterly with a lag of 6 to 9 months. It is available nationally, statewide, and for counties. States may have different regulations regarding QCEW publication and more detail may be available directly from states.
EXPO These are for editing and controlled access by LMI Analysts. State-level data is available for download as completed.
WID Version? Download Here This comes from publicly available BLS data and will be available shortly after the official publication date/time. This extract is for the entire year, after the annual publication.

Table Format

There have been no recent changes.

WID2.7

Update Calendar

https://www.bls.gov/schedule/news_release/cew.htm

Related Tables

Links to the table description in the current structure document.  Note: Page anchors do not work in Microsoft Edge (the default browser for some states).

GEOG

PERIOD

OWNERSHP

INDCODES

   

EMPDB

This table contains the employer data from the Workforce Information Database Employer Database.  Contents are furnished by a private contractor and use of the data in the Employer Database is subject to the terms and agreements the found in the contract signed by the states and the Employer Database supplier.

Data Sources

National State/Local Notes
Source vendor Data is released at the state level from the vendor once or twice a year. It can be arranged to download it from the vendor and a disk is sent to state LMI offices.

Career OneStop

Career OneStop (widget) CareerOneStop receives the data through the same contract as states.  They have produced a search tool and embeddable widget that meets contract requirements that states can link to or insert on their own websites.
WID Version? N/A N/A The download from the vendor is similar to EMPDB structure.

Table Format

There were some values in the most recent release that violated foreign keys.  The vendor put out this to explain the difference.

WID2.7

Update Calendar

Not published

Related Tables

Links to the table description in the current structure document.  Note: Page anchors do not work in Microsoft Edge (the default browser for some states).