​

ARC

Archives: Documents

  • Core Tables WID 3.0

    As stated in the Employment and Training Administration (ETA), Workforce Information Core Products and Services Grant, “Grantees must implement and maintain the most current version of WID and populate all ARC-designated core tables following ARC procedures.”

    In general, core tables should be maintained with data that is as current and as detailed as state publications.

    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
    ProjectionsMatrix
    LaborForce
    LicenseAuthorities*
    License*
    IOWage

    Crosswalk Tables
    MatrixXInd
    MatrixXOcc

    LicenseXOcc




















    * Tables to be furnished to ARC for publication by CareerOneStop
    ** Need to populate additional lookup tables
    ~ Tables associated with the Employer Database

    Lookup Tables
    AnnualSalesCodes~
    AnnualSalesRanges~
    AreaTypes
    AreaTypeVersions
    Benchmark
    CESCodes
    ContactProTitles~
    ContactTitles~
    CreditCodes~
    EmpDBInf~
    EmpSizeFlag~
    EmpSizeRange~
    GeoPrecisionCodes
    Geographies
    GrowthCodes
    IndCodeTypes
    IndDirectories
    IndSubLevels
    IndustryCodes**
    LicenseContinuingEdu
    LicenseActiveStatuses
    LicenseCertifications
    LicenseCriminal
    LicenseEducation
    LicenseExams
    LicenseExperience
    LicensePhysicalReqs
    LicenseTypes
    LicenseVeteran
    LocationStatuses
    OccupationCodes**
    OccDirectories
    OccSubLevels
    OccCodeTypes
    Ownership
    Periods
    PeriodTypes
    PeriodYears
    PrivateGovt~
    WageRateType
    StFips
    WageSources

    This list was last updated 12/13/2024.  

  • Demographics (DEMOGRAPHICS)

    This table contains population and demographic estimates for a geographic area and time period.

    Data Sources

    This comes from publicly available Census data and will be available shortly after the official publication date/time.

    NationalState/LocalNotes
    SourceNational, stateMetropolitan/ micropolitan

    County

    City and town

    Tribal areas    		This comes from Census tables B01001, B01001A, B01001B, B01001C, B01001D, B01001E, B01001F, B01001G, B01001I, B01002, and B03002. Geographic extent is dependent on ACS 5 or 1 year.
    WID Version?All areasThis comes from publicly available Census data and will be available shortly after the official publication date/time.
    CustomThis is a python script to extract the data from the Census API and format it to load into the WID. The script contains parameters to define years and areas for extraction allowing users to pull the most current data as needed. It will require a user to obtain a Census API key and insert it at the line “api_key = ” ”

    Table Format

    In WID 2.8 fields for Margins of Error were removed from the table structure, but all others remained the same.

    WID2.8 (PDF 922 KB)

    WID2.7 (PDF 919 KB)

    Update Calendar

    None

    Related Tables

    GEOG (PDF 1,003 KB)

    PERIOD (PDF 1,003 KB)

  • JOLTS

    The Bureau of Labor Statistics’ Job Openings and Labor Turnover Survey (JOLTS) program produces data on job openings, hires, and separations. Although the content is non-standard and does not have a formal WID table, there has been a recent surge in interest in the data.

    Data Sources

     Geographic ExtentNotes
    BLSState, BLS Region, U.S.The JOLTS program recently added State estimates. The publication schedule lags by two months.
    WID Version?CustomThis is a non-standard table structure and state uses vary. Instead of a download file, there is a python script to extract the data from the BLS LABSTAT database and format it to load into the WID. The script contains parameters to define years and areas for extraction allowing users to pull the most current BLS data as needed.

    Table Format

    This is non-standard content but has been structured to work seamlessly with the WID.

    Table Structure (DOCX 19 KB)

    Update Calendar

    BLS Schedule of Releases for JOLTS

    Related Tables

    The structure of related tables and the SQL are in the same files under Table Format above.

    While JOLTS closely follows CES industries, it’s not perfectly aligned. The script above creates a new industry type to be added to the indcodes table, and one other lookup table (values in above documentation) is used to describe the components.

  • Education

    Many states have a use for information about higher education providers, either for analytical purposes or to be able to direct job seekers to appropriate programs.  The National Center for Education Statistics (NCES) Integrated Postsecondary Education Data System (IPEDS) puts out data about providers and programs offered, organized by state but containing address-level data.

    Data Sources

    NationalState/LocalNotes
    SourceIPEDSSameThere are Preliminary, Provisional, and Final data sets.  Schedule is approximate and lag varies for different download files.
    WID Version?2022
    2021
    2020
    2019
    2018
    2017
    2016    		The ARC files use the Provisional source data.

    Table Format

    This source provides content for data tables PROGRAMS, SCHOOLS, and PROGCOMP.

    WID2.8:                PROGRAMS (PDF 922 KB)                 SCHOOLS (PDF 922 KB)                 PROGCOMP (PDF 922 KB)

    Update Calendar

    In general new files are published in the fall but the source data is sometimes delayed.

    Related Tables

    COMPLTYP (PDF 922 KB)                                     OCCCODES (PDF 922 KB)
    LENTYPE (PDF 922 KB)                                         CLASSTIME (PDF 922 KB)
    INSTOWN (PDF 922 KB)                                       INSTTYPE (PDF 922 KB)

  • Cost of Living

    There are a number of sources of cost of living data with different methods and products.  They’re useful for research applications and to provide a reference point for wage data.  Although cost of living is non-standard and does not have a formal WID table, the content is useful enough to states to index here.

    Data Sources

    Geographic Extent Notes
    MIT County This is an annual calculation that produces annual costs for various components (food, childcare, etc) and a required wage value to cover those costs for 14 family structures. You can find the documentation here (PDF 5 KB).
    Self Sufficiency Standard County This is an annual calculation that produces annual costs for various components (food, childcare, etc) and a required wage value to cover those costs for many family structures. You can find the documentation here.
    C2ER County and MSA This is a widely-used annual index value but is available for a cost. You can find the documentation here (PDF).
    WID Version? County and State

    2019
    2018

    		 This is an adaptation of a method developed by Minnesota. It has both component costs and an index value but is relatively new. You can find the documentation here (DOCX) and a visualization here.

    Table Format

    This is non-standard content but has been structured to work seamlessly with the WID.

    Table Structure (DOCX)

    SQL Statements to create tables

    Update Calendar

    This is a new data source at the national level. If there’s interest, it will continue to be produced in future years, with updates occurring in January or early February.

    Related Tables

    The structure of related tables and the SQL are in the same files under Table Format above.
    Lookup table contents:
    AgeCol
    FamilyChars

  • CIP-SOC Crosswalks


    Classification of Instructional Programs (CIP) are crosswalked with SOC occupation codes to analyze educational outcomes, wage premiums, and workforce supply and demand.  Job banks use them to match qualifications with job postings and labor market data.

    Data Sources

    System
    Versions
    WID Content
    Notes
    IPEDSCurrent and prior versions2020 (XLSX)
    2010
    2000
    1990

    The 2020 download file contains both the content for WID tables occcodes/cipcode and the CIP-SOC crosswalk to be loaded into occxocc.
    – The values all use stfips 00, so for state use it may need to be duplicated for the state.
    – The crosswalk goes both ways – from SOC to CIP and from CIP to SOC. In this table structure, the “from” is housed in codetype/code and the “to” is in codetype2/code2.
    – Not all CIPs have a direct occupational match and not all SOCs have a direct CIP match.

    ONETCurrentN/A

    This version uses ONET codes instead of SOC codes.

    Perkins IVCurrentN/A

    Table Format

    This crosswalk would be inserted into OCCXOCC and related look-up tables.

    WID2.8 (PDF 922 KB)

    WID2.7 (PDF 1,003 KB)

    Update Calendar

    Variable.

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

    OCCXOCC

    OCCCODES

    OCCTYPES

  • Legacy Crosswalks

    DirectoryDescription   
    cens2000Files relating to the 2000 Censusreadme.txtfiles
    cip2000Files relating to the 2000 CIPreadme.txtfiles
    cip2010Files relating to the 2010 CIPreadme.txtfiles
    militaryFiles containing military occupational information & crosswalksreadme.txtfiles
    miscMiscellaneous geography filesreadme.txtfiles
    occnamesDescriptive information about classificationsreadme.txtfiles
    ooh0809Links between OOH information and O*NET occupationsreadme.txtfiles
    soc19981998 Standard Occupational Classification filesreadme.txtfiles
    soc20002000 Standard Occupational Classification filesreadme.txtfiles
    soc20102010 Standard Occupational Classification filesreadme.txtfiles
    soccip2010BLS-NCES 2010 SOC to 2010 CIP crosswalkreadme.txtfiles
    soccip00SOC to 2000 CIP crosswalk and related filesreadme.txtfiles
    soccip90SOC to 1990 CIP crosswalk and related filesreadme.txtfiles
    spanishSpanish version of the 1998 SOC manualreadme.txtfiles
    xwalksCrosswalk files — mostly legacy classificationsreadme.txtfiles

  • Population (POPULATN)

    This table contains population estimates for a geographic area and time period.

    Data Sources

    This comes from publicly available Census data and will be available shortly after the official publication date/time. ​

    NationalState/LocalNotes
    SourceNational, stateMetropolitan/ micropolitan

    County

    City and town

    WID Version?All areasThis comes from publicly available ACS data and will be available shortly after the official publication date/time.
    Population estimatesCensus Bureau’s Population Estimates Program (PEP) – custom Python extract

    Table Format

    There have been no recent changes.

    WID2.8 (PDF 922 KB)

    WID2.7 (PDF 919 KB)

    Update Calendar

    None

    Related Tables

    GEOG (PDF 1,003 KB)

    PERIOD (PDF 1,003 KB)

    POPSOURCE

  • 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