Education, Training, and Experience

Purpose:

Provide a mapping of O*NET-SOC codes (occupations) to Education, Training, and Experience ratings.

Download:

Education, Training, and Experience.xlsx

Structure and Description:

Column	Type	Column Content
O*NET-SOC Code	Character(10)	ONET-SOC Code (see Occupation Data)*
Title	Character Varying(150)	ONET-SOC Title (see Occupation Data)*
Element ID	Character Varying(20)	Content Model Outline Position (see Content Model Reference)
Element Name	Character Varying(150)	Content Model Element Name (see Content Model Reference)
Scale ID	Character Varying(3)	Scale ID (see Scales Reference)
Scale Name	Character Varying(50)	Scale Name (see Scales Reference)
Category	Integer(3)	Percent frequency category (see Education, Training, and Experience Categories)
Data Value	Float(5,2)	Rating associated with the O*NET-SOC occupation
N	Integer(4)	Sample size
Standard Error	Float(5,2)	Standard Error
Lower CI Bound	Float(5,2)	Lower 95% confidence interval bound
Upper CI Bound	Float(5,2)	Upper 95% confidence interval bound
Recommend Suppress	Character(1)	Low precision indicator (Y=yes, N=no)
Date	Character(7)	Date when data was updated
Domain Source	Character Varying(30)	Source of the data

This file contains the percent frequency data associated with Education, Training, and Experience Content Model elements. It is displayed in 15 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, and Domain Source. Refer to Appendix 2, Item Rating Level Statistics - Incumbent for additional information on these items. The 15 fields are represented by one row. There are a total of 40,186 rows of data in this file.

File Structure Changes:

Release Number	Description of Change
5.0	Added as a new file
5.1	Columns added for N, Standard Error, Lower CI Bound, Upper CI Bound, and Recommend Suppress
6.0 - 25.0	No structure changes

Data Example - Education, Training, and Experience:

O*NET-SOC Code	Title	Element ID	Element Name	Scale ID	Scale Name	Category	Data Value	N	Standard Error	Lower CI Bound	Upper CI Bound	Recommend Suppress	Date	Domain Source
51-6052.00	Tailors, Dressmakers, and Custom Sewers	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	1	16.87	18	11.72	3.36	54.21	N	08/2020	Incumbent
51-6052.00	Tailors, Dressmakers, and Custom Sewers	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	2	57.66	18	14.53	27.96	82.70	N	08/2020	Incumbent
51-6052.00	Tailors, Dressmakers, and Custom Sewers	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	3	16.01	18	9.06	4.40	44.13	N	08/2020	Incumbent
51-6052.00	Tailors, Dressmakers, and Custom Sewers	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	4	0.00	18	0.00			N	08/2020	Incumbent
51-6052.00	Tailors, Dressmakers, and Custom Sewers	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	5	0.00	18	0.00			N	08/2020	Incumbent
51-6052.00	Tailors, Dressmakers, and Custom Sewers	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	6	9.46	18	8.97	1.13	48.77	N	08/2020	Incumbent
51-6052.00	Tailors, Dressmakers, and Custom Sewers	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	7	0.00	18	0.00			N	08/2020	Incumbent
51-6052.00	Tailors, Dressmakers, and Custom Sewers	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	8	0.00	18	0.00			N	08/2020	Incumbent
51-6052.00	Tailors, Dressmakers, and Custom Sewers	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	9	0.00	18	0.00			N	08/2020	Incumbent
51-6052.00	Tailors, Dressmakers, and Custom Sewers	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	10	0.00	18	0.00			N	08/2020	Incumbent
51-6052.00	Tailors, Dressmakers, and Custom Sewers	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	11	0.00	18	0.00			N	08/2020	Incumbent
51-6052.00	Tailors, Dressmakers, and Custom Sewers	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	12	0.00	18	0.00			N	08/2020	Incumbent