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(7,4)	Standard Error
Lower CI Bound	Float(7,4)	Lower 95% confidence interval bound
Upper CI Bound	Float(7,4)	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 36,209 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 - 28.1	No structure changes
28.2	Standard Error, Lower CI Bound, Upper CI Bound expanded from 2 decimal places to 4
28.3 - 29.1	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	Date	Domain Source
19-5011.00	Occupational Health and Safety Specialists	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	1	0.00	23	08/2024	Occupational Expert
19-5011.00	Occupational Health and Safety Specialists	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	2	0.00	23	08/2024	Occupational Expert
19-5011.00	Occupational Health and Safety Specialists	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	3	4.35	23	08/2024	Occupational Expert
19-5011.00	Occupational Health and Safety Specialists	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	4	0.00	23	08/2024	Occupational Expert
19-5011.00	Occupational Health and Safety Specialists	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	5	4.35	23	08/2024	Occupational Expert
19-5011.00	Occupational Health and Safety Specialists	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	6	73.91	23	08/2024	Occupational Expert
19-5011.00	Occupational Health and Safety Specialists	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	7	8.70	23	08/2024	Occupational Expert
19-5011.00	Occupational Health and Safety Specialists	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	8	8.70	23	08/2024	Occupational Expert
19-5011.00	Occupational Health and Safety Specialists	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	9	0.00	23	08/2024	Occupational Expert
19-5011.00	Occupational Health and Safety Specialists	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	10	0.00	23	08/2024	Occupational Expert
19-5011.00	Occupational Health and Safety Specialists	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	11	0.00	23	08/2024	Occupational Expert
19-5011.00	Occupational Health and Safety Specialists	2.D.1	Required Level of Education	RL	Required Level Of Education (Categories 1-12)	12	0.00	23	08/2024	Occupational Expert