Although the Workforce Information Database can contain a large amount of data, it does not, and cannot, contain all of the labor force, economic, population, occupational and other information produced by state and federal agencies. The databases and tables described on this page are not part of the Workforce Information Database. They fall into two categories:
1) comprehensive databases that are maintained and updated independently of the Workforce Information Database, and
2) tables that will be included in the Workforce Information Database for which questions or issues were unresolved at the time of the release of the current database version. The non-standard tables currently available include:
- O*NET 4.0 Database - the final version of the O*NET database that contained only anlyst data. Subsequent versions included data from the O*NET data collection program. This database is maintained for those who need to use ratings over a uniform set of descriptors. This database contains 24 lookup, data and crosswalk tables. You can view our documentation for the Workforce Information Database - compatible database or download the Visual FoxPro version from our O*NET 4.0 Database Page .
- O*NET 17.0 (Production) Database - this version of the O*NET database is in use in online O*NET applications. The documentation for the Workforce Information Database version is available, as is the Visual FoxPro database. See the NCSC O*NET 17.0 Database page .
- O*NET Related Occupations Database - The Related Occupations database has been completely updated using a new methodology. It now includes two separate tables: one for career starters and one for career changers. The NCSC has prepared a WID-friendly database that contains these new tables. You can read the structure document or download the archive file that contains the Visual FoxPro database. For more information about the development of this new resource, take a look at the O*NET Center's development report.
- Military Crosswalk Database - The Defense Manpower Data Center maintains crosswalk a file that links military occupations to their civilian counterparts from the Standard Occupational Classification. This crosswalk is updated quarterly. While this content can be included in the Workforce Information Database, we've created a separate database due to the frequent updates. You can download a structure document or Visual FoxPro and Access databases that contains the crosswalk. (Updated 5/30/13)
The tables in this section conform to the structure of the Workforce Information Database. The content of their fields fall outside that described in the database structure document. Those values may be incorporated in a future version of the database.
- New England Geography - generally speaking, the New England states, unlike the rest of the country, ignore counties. Rather, cities and towns are their basic geographic unit. The Analyst Resource Center has developed a prototype set of geography files describing the region. You can view a document describing the table contents or download Visual FoxPro or MS Access databases containing the prototype content.
Tables for Future Versions
The tables in this list have been proposed for inclusion in the Workforce Information Database. Not all issues were resolved at the time of the release of the current version, so their inclusion may be in a future release. Please note these files structures are still evolving- so check back often for updates.
- Employer Database (May 2009 contract): A new employer database contract between the Iowa Workforce Development and infoUSA was signed in May 2009. Details about the new contract can be found on the ARC website's employer database page. This contract provided some additional variables, and the table's structure was modified, and related lookup tables were added. These changes will be included in the next release of the database structure. The NCSC has created Visual FoxPro and Access databases containing the new structure. (NOTE: The new tables include both long table and variable names that are available in Visual FoxPro and Access databases.)
- National Employment Projections (2010-20): The release of the 2010-20 employment projections introduced a change to the length of the MATINCODE variable from 10 to 15. Since the structure of these tables no longer conforms to that of the Workforce Information Database, the ARC has elected to place links to that version on this page. This change will be introduced in the next release of the database. Users can use these tables with Version 2.4 of the database after changing the length of the MATINCODE variable in the INDDIR, INDPRJ, IOMATRIX and MATXNAIC tables. The NONSTD directory on our ftp server has links to a PDF File that includes the file structures and a ZIP file that contains a Visual FoxPro database containing the projections. (Added 01/19/10)
- Enhanced SOCCODE Table: With the release of the 2010-2020 national employment projections, the Bureau of Labor Statistics assigned categories for entry-level education, related work experience and typical on-the-job training to projections used in the projections. These measures replaced the OOHTRNTM variable used in SOCCODE tables through Version 2.5 of the Workforce Information Database. For background information on the development and use of these variables see the BLS Education and Training Data page in their employment projections section. The ARC and the NCSC have developed a prototype WID SOCCODE table that incorporates these variables. A structure document and populated tables are available for downloading. (Added 02/19/13)
- Population Demographics - The ARC has revised the structure of the prototype population demographics file found on this page. The file contains age, race and ethnicity characteristics of the populations of the country, states, and a growing number of counties and places. Contents are drawn from the 2000 and 2010 Census data and 2002-2011 American Community Survey (ACS) files. Five sets of ACS three-year estimates (2005-07, 2006-08, 2007-09, 2008-10, 2009-11) are included, as is the first three sets of five-year estimates, 2005-09, 2006-10, 2007-11). Inclusion of these estimates greatly increases the number of areas with estimates. However, it also complicates comparison of estimates for areas over geography and time. See the Census Bureau's guidance on using multi-year estimates. The file structure document and prototype content (for the state of Iowa) are available from the NCSC FTP server. The files contain estimates for census places, many of which are cities. The value for AREATYPE has been set to '20' for the place records. Since states might not have these areas in their GEOG table, we've developed a table that contains all of the places formatted for use in the GEOG table. Visit the ACS 20011 web page for more information. The NCSC has developed a fact sheet about the file's contents. (Revised 10/19/10, 12/16/10, 12/29/10, 1/12/11, 10/26/12, 12/07/12)
- Career Clusters and Pathways - Career clusters and career pathways are becoming a major part of the Career and Technical Education landscape. They are used for a variety of purposes, including reporting, within the education community, and have their own web site. In response to the need for more and better links between workforce and education information, the ARC has developed a prototype structure for linking both clusters and pathways to occupations and education programs. The NCSC has populated a database with content based on Table 6 on the Career Clusters crosswalks page .
- Commodities: The ARC has developed a prototype structure for a table that's designed to house production and sales data for commodities produced in a state. A structure document and prototype Access database with test data are available for downloading. (Added 05/26/10)
- Job Benefit Survey Files - the ARC has developed a table structure for incorporating benefit data into the Workforce Information Database for those states that conduct benefit surveys. You can view the structure document or download an archive file containing the structure document, MS Access and Visual FoxPro Databases here.
- Special Identifier Employment Table - the ARC has developed a table structure that allows users to identify industries and occupations that are in special, state-identified groups of interest. Variables are included that relate to "green" employment. States are encouraged to use this table for other groups by adding variables for each group. The ARC has developed a structure document and prototype database containers in MS Access and FoxPro.
- Employment Initiatives Tracking Tables: the ARC has developed table structures that allow states to track job openings, hires and wage information by industry, occupation and funding source for employment initiatives. The ARC has developed a structure document and prototype database containers as MS Access and Visual FoxPro databases.