19 - 09 - 2014

Non-Standard Data

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:

External Databases

  •  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 page.
  • O*NET 18.1 (Production) database - this version of the O*NET database was released in March 2014 and went into production in O*NET Online and other online applications at that time.  You'll find links to Access and SAS/PC versions of the O*NET Center's tab-delimited files available for downloading from our O*NET 18.1 page.  We've developed a Workforce Information Database-friendly versions in Visual FoxPro for downloading.  Download the database structure document for more information.
  • O*NET 19.0 (Development) Database - this version was released in July 2014, scheduled to go into production in the fall of the year.  You'll find MS Access and delimited text files compatible with the Workforce Information Database on our O*NET 19.0 page.
  • 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 an Access databases that contains the crosswalk.  The ZIP file that contains the Access database also contains delimited text versions. (Updated 5/30/13, 7/23/13, 1/22/14, 4/29/14, 7/16/14)
 
Supplemental Tables

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 a Visual FoxPro database 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.)  
  • Enhanced CPI Table (CPIPLUS):  The Bureau of Labor Statistics' Consumer Price Index (CPI) has been part of the Workforce Information Database since its first version.  The Analyst Resource Center provides national (all cities) indexes for all items for each month beginning with January, 1913.  This file's contents barely scratch the surface of the information that's available.  Price indexes are developed for nearly 400 market basket items.  The three most commonly referenced indexes are food, energy, and all items less food and energy.  A core set of about 40 of these indexes is available for nearly all of the 45 geographic areas for which indexes are produced.  The remainder, available only as all-cities indexes, contain data for more detailed food, services and other categories.  The WID CPI table structure is inadequate for handling this many combinations of index items and geography, so the WID Structure Committee has developed an enhanced structure designed to do just that.  The structure document and a populated Access database are available for downloading.  It is important to note that indexes for some geographic areas are not published monthly.  See the BLS CPI FAQ page for more information.  (Caution: when populated for all index items for all geographic areas, the number of records approaches 700,000, and the database occupies over 110 MB of disk space.  The archived version available for downloading is 17 MB in size.)  (Added 09/12/13)
  • National Employment Projections (2012-22): The release of the 2012-22 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, updated 12/24/13)
  • 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-2012 American Community Survey (ACS) files.  six sets of ACS three-year estimates (2005-07, 2006-08, 2007-09, 2008-10, 2009-11, 2010-12) are included, as is the first four sets of five-year estimates, 2005-09, 2006-10, 2007-11, 2008-12).  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 2012 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, 10/03/13, 11/15/13, 12/18/13) 
  • 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, Revised 2/24/14) 
  • 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.