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.
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
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.
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.
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
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.
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.
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).
Every state manages this differently and some are handled at the department level rather than by a central source.
This 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
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.
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.
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.
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.
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.
These are for editing and controlled access by LMI Analysts. State-level data is available for download as completed.
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 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.
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.
The download from the vendor is similar to EMPDB structure.
There were some values in the most recent release that violated foreign keys. The vendor put out this to explain the difference.