All Core Tables

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.

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

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

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.