​

ARC

Document Category: Core Tables

  • OccupationCodes (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 changesThis is not a separate coding structure, but some revisions were made affecting roll-ups and certain detailed industries
     2010 SOC soc2010This is in active use for most BLS and related products
     2000 SOC soc2000
     1998 SOC soc1998
    ONET Current 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 DOTThe 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 2020 (current)
     Prior versions    		 cip2000
     cip2010
    cip2020 (XLSX 686 KB)    		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 versionsCensus, 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 (XLSX)The Projections program bases its codes on OES/SOC, but has some non-standard codes

    Table Format

    Title field was lengthened in version 2.8.

    WID2.8 (PDF 922 KB)

    WID2.7 (PDF 919 KB)

    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

  • IndustryCodes (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
    NAICS2022 NAICS INDCODES
     NAICCODE    		NAICS 2022 had primarily additions to the coding structure, so it was added to indcodes using the same indcodtyp as NAICS 2012
    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
    2012 NAICS  Structure
    2007, 2002, 1997 NAICSQCEW switched from SIC to 2002 NAICS and back-coded data to 2000. The earliest NAICS codes for most of our products are from 2002
    SICDiscontinued SICCODEStandard Industrial Classification (SIC) was in use prior to 2000.  Questions about it still come up from people doing historical research
    Census CodesMultiple 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 CESCODEThis 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 (XLSX)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.8 (PDF 922 KB)

    WID2.7 (PDF 919 KB)

    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

  • LicenseAuthorities (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

    In version 2.8 the authority name fields were changed from name1, name2, and name3 to department, division, and board to improve consistency between states.

    WID2.8 (PDF 922 KB)

    WID2.7 (PDF 919 KB)

    Update Calendar

    States should submit revisions every year by June 30.  To find out when your state’s most recent submission was, email [email protected].

  • License (LICENSE)

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

    A review of the data quality and contents was conducted in 2018-2019. A summary of that work is available here (PDF).

    Data Sources

    The original source for this data varies by state. Once it’s been submitted to the ARC it’s reviewed and standardized and made available to the public. The primary means of publication is through the CareerOneStop LicenseFinder tool, but download files are also available from their site and on a state-by-state basis from the ARC. While these are useful for states to review and are helpful for cross-state comparisons, this is not a source for the deliverable that is to be submitted.

    NationalStateNotes
    SourceCSOR

    NCSL

    License to Work    		There are a number of organizations that have made efforts to track occupational licenses. They rarely are related back to SOC or ONET occupational coding, they may be limited in scope to certain types of occupations, and they may not be frequently updated. However, many add value that the WID structure doesn’t have, such as richer descriptive content or detail on types of requirements (“good moral character”, for example).
    VariesEvery state manages this differently and some are handled at the department level rather than by a central source.
    WID Version?Download HereState-specific files hereThis comes from state-submitted data. Improvements made centrally include
    – standardizing occupational coding so it compares across states,
    – adding licenses identified as missing by other sources or collected centrally,
    – adding license compacts,
    – adding industry where relevant,
    – organizing descriptions into indicator values for key requirements

    Table Format

    In version 2.8 several requirements fields were added to allow comparison of license characteristics between states. Preliminary values have been generated from existing license descriptions and other data sources for most licenses.

    WID2.8 (PDF 922 KB)

    WID2.7 (PDF 919 KB)

    Update Calendar

    States should submit revisions every year by June 30.  To find out when your state’s most recent submission was, email [email protected].

  • AreaTypes (AREATYPE)

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

    Data Sources

    NationalState/LocalNotes
    WID Version?Download HereDownload HereThese 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.8 (PDF 922 KB)

    WID2.7 (PDF 919 KB)

    Update Calendar

    N/A

  • SubGeographies (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

    Geographic ExtentNotes
    CensusNational and LocalNational, state, counties, places, Metropolitan & micropolitan statistical areas, metropolitan divisions, combined statistical areas
    State SpecificVariesMany states have analysis regions, congressional districts, and WSAs that are available from state sources.
    WID Version?National and Local All national, state, and local are contained in the same table.
    Workforce Development Boards (XLSX 141 KB)Workforce Development Boards (WDB) are state program areas. They’re defined locally but tracked by CareerOneStop and reviewed annually to ensure they remain current. This data set makes COS verified WDB definitions available in standard GEOG/SUBGEOG format.
    MSAThe Office of Management and Budget (OMB) defines Metropolitan and Micropolitan Statistical Areas and the Census Bureau publishes the bulletins as delineation files.

    July 2023 (XLSX 100 KB) (combined with geog)
    Sep 2018  GEOG
    Apr 2018  GEOG
    Aug 2017  GEOG
    Jul 2015  GEOG
    Feb 2013 GEOG

    Note: July 2023 continues to use 31 and 32 for areatypes because of the upcoming change to WID 3.0 and the implementation of AreaTypeVersion to distinguish between vintages of areas instead of the previous practice of adding new codes.

    Table Format

    No recent changes.

    WID2.8 (PDF 1.9 MB)

    WID2.7 (PDF 919 KB)

    Update Calendar

    Census: https://www.census.gov/programs-surveys/metro-micro.html

  • Geographies (GEOG)

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

    Data Sources

    NationalState/LocalNotes
    SourceCensusCensusNational, state, counties, places, Metropolitan & micropolitan statistical areas, metropolitan divisions, combined statistical areas
    State SpecificMany states have analysis regions, congressional districts, and WSAs that are available from state sources.
    WID Version?Download HereDownload Here All national, state, and local are contained in the same table.
    July 2023 (XLSX 100 KB)
    Sep 2018
    Apr 2018
    Aug 2017
    Jul 2015
    Feb 2013     		Current MSA.  Component areas can be found through the Census Bureau or on the subgeog page.

    Note: July 2023 continues to use 31 and 32 for areatypes because of the upcoming change to WID 3.0 and the implementation of AreaTypeVersion to distinguish between vintages of areas instead of the previous practice of adding new codes.

    Table Format Archive

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

    WID2.8 (PDF 1.9 MB)

    WID2.7 (PDF 919 KB)

    WID2.6.1 (PDF 881 KB)

    Update Calendar

    Census: https://www.census.gov/programs-surveys/metro-micro.html

  • Core Tables WID 2.8

    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.

    [one-half-first]

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

    Crosswalk Tables
    LICXOCC*
    MATXIND
    MATXOCC

    Admin Tables
    INDCODES**
    OCCCODES**
    EMPDBINF

    * Tables to be furnished to ARC for publication by CareerOneStop
    ** Need to populate additional lookup tables
    [/one-half-first]

    [one-half]

    Lookup Tables
    ANNSLFLG
    ANNSLRNG
    AREATYPE
    BENMARK
    CESCODE
    CONTACTTITLE
    CONTACTPRO
    CREDITCD
    EMPSZFLG
    EMPSZRNG
    GEOCODE
    GEOG
    GROWCODE
    INDDIR
    INDSUB
    INDTYPES
    LEVELTYP
    LOCSTAT
    OCCDIR
    OCCSUB
    OCCTYPES
    OWNERSHP
    PERIOD
    PERIODID
    PERIODTY
    PRVGOVST
    RATETYPE
    STFIPSTB
    WGSOURCE

    [/one-half]

    This list was last updated 11/21/2019.  Changes were made to the lookup tables list to bring it in line with the foreign keys of the data tables and the WID28 documentation.

  • Industry (INDUSTRY)

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

    Data Sources

    NationalState/LocalNotes
    SourceBLSBLSQCEW 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.
    EXPOThese are for editing and controlled access by LMI Analysts. State-level data is available for download as completed.
    WID Version?Download HereThis 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.8 (PDF 922 KB)

    WID2.7 (PDF 919 KB)

    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 (PDF 1,003 KB)

    PERIOD (PDF 1,003 KB)

    OWNERSHP (PDF 1,003 KB)

    INDCODES (PDF 1,003 KB)

  • EmpDB (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

    NationalState/LocalNotes
    SourcevendorData 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/AN/AThe 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 (XLSX 13 KB) to explain the difference.

    WID2.8 (PDF 922 KB)

    WID2.7 (PDF 919 KB)

    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).

    [one-half-first]

    GEOG (PDF 1,003 KB)

    GEOCODE (PDF 1,003 KB)

    CONTACTTITLE (PDF 1,003 KB)

    CONTACTPRO (PDF 1,003 KB)

    PRVGOVST (PDF 1,003 KB)

    LOCSTAT (PDF 1,003 KB)

    STOCKEXCH (PDF 1,003 KB)

    [/one-half-first]

    [one-half]

    ANNSLFLG (PDF 1,003 KB)

    CREDITCD (PDF 1,003 KB)

    EMPDBINF (PDF 1,003 KB)

    ANNSLRNG (PDF 1,003 KB)

    EMPSZRNG (PDF 1,003 KB)

    EMPSZFLG (PDF 1,003 KB)

    [/one-half]