Education, Training, and Experience

Purpose:Provide a mapping of O*NET-SOC codes (occupations) to Education, Training, and Experience ratings.
Table Name:education_training_experience
Structure and Description:
ColumnTypeColumn Content
onetsoc_codeCharacter(10)O*NET-SOC Code (see Occupation Data)
element_idCharacter Varying(20)Content Model Outline Position (see Content Model Reference)
scale_idCharacter Varying(3)Scale ID (see Scales Reference)
categoryDecimal(3,0)Percent frequency category (see Education, Training, and Experience Categories)
data_valueDecimal(5,2)Rating associated with the O*NET-SOC occupation

This file contains the percent frequency data associated with Education, Training, and Experience Content Model elements. It is displayed in 12 tab delimited fields and identified using the column names provided above. Item rating level metadata is provided in columns named n, standard_error, lower_ci_bound, upper_ci_bound, recommend_suppress, date_updated, and domain_source. Refer to Appendix 2, Item Rating Level Statistics - Incumbent for additional information on these items. The 12 fields are represented by one row. There are a total of 39,693 rows of data in this file.

File Structure Changes:
Release NumberDescription of Change
5.0Added as a new file
5.1Columns added for N, Standard Error, Lower CI Bound, Upper CI Bound, and Recommend Suppress
6.0 - 23.0No structure changes

Data Example - education_training_experience:
onetsoc_​codeelement_​idscale_​idcategorydata_​valuenstandard_​errorlower_​ci_​boundupper_​ci_​boundrecommend_​suppressdate_​updateddomain_​source
35-2015.002.D.1RL133.71299.5017.5654.84N2018-08-01Incumbent
35-2015.002.D.1RL254.672911.5631.6875.82N2018-08-01Incumbent
35-2015.002.D.1RL30.00290.00NULLNULLN2018-08-01Incumbent
35-2015.002.D.1RL410.69297.232.4736.09N2018-08-01Incumbent
35-2015.002.D.1RL50.93290.980.117.61N2018-08-01Incumbent
35-2015.002.D.1RL60.00290.00NULLNULLN2018-08-01Incumbent
35-2015.002.D.1RL70.00290.00NULLNULLN2018-08-01Incumbent
35-2015.002.D.1RL80.00290.00NULLNULLN2018-08-01Incumbent
35-2015.002.D.1RL90.00290.00NULLNULLN2018-08-01Incumbent
35-2015.002.D.1RL100.00290.00NULLNULLN2018-08-01Incumbent
35-2015.002.D.1RL110.00290.00NULLNULLN2018-08-01Incumbent
35-2015.002.D.1RL120.00290.00NULLNULLN2018-08-01Incumbent