March 30, 2017
  Home   |   About Us   |   Help Desk   |   Contact Us
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:

Data Tables
CES
EMPDB
INCOME
INDPRJ*
INDUSTRY
IOMATRIX*
LABFORCE
LICAUTH**
LICENSE**
OCCPRJ*
IOWAGE/OESWAGE
POPULATN Crosswalk Tables
LICXOCC**
MATXNAIC
MATXSOC
Admin Tables
INDCODES***
OCCCODES***
Lookup Tables
ADDRESTY
ANNSLFLG
AREATYPE
BENMARK
CESCODE
CREDITCD
EMPSZFLG
EMPSZRNG
GEOCODE
GEOG
GROWCODE
INCOMTYP
INCSOURC
INDDIR
INDSUB
INDTYPES
LEVELTYP
LOCSTAT
OCCDIR
OCCSUB
OCCTYPES
OWNERSHP
PERIOD
PERIODID
PERIODTY
POPSOURC
RATETYPE
STATTYPE
STFIPSTB
URLTOPIC

* Database Administrator may opt to populate the IOMATRIX data table OR both the INDPRJ and OCCPRJ data tables since the IOMATRIX data table contains much the same content as the other two tables.
** Tables to be furnished to the National Crosswalk Service Center for inclusion in America's Career InfoNet. Contact Steve Rosenow of the NCSC if you have questions. *** Need to populate additional lookup tables.
 

shim