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

Download:

Structure and Description:

Column	Type	Column Content
onetsoc_code	Character(10)	ONET-SOC Code (see Occupation Data)*
element_id	Character Varying(20)	Content Model Outline Position (see Content Model Reference)
scale_id	Character Varying(3)	Scale ID (see Scales Reference)
category	Decimal(3,0)	Percent frequency category (see Education, Training, and Experience Categories)
data_value	Decimal(5,2)	Rating associated with the O*NET-SOC occupation
n	Decimal(4,0)	Sample size
standard_error	Decimal(7,4)	Standard Error
lower_ci_bound	Decimal(7,4)	Lower 95% confidence interval bound
upper_ci_bound	Decimal(7,4)	Upper 95% confidence interval bound
recommend_suppress	Character(1)	Low precision indicator (Y=yes, N=no)
date_updated	Date	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 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 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_experience:

onetsoc_code	element_id	scale_id	category	data_value	n	standard_error	lower_ci_bound	upper_ci_bound	recommend_suppress	date_updated	domain_source
19-5011.00	2.D.1	RL	1	0.00	23	NULL	NULL	NULL	NULL	2024-08-01	Occupational Expert
19-5011.00	2.D.1	RL	2	0.00	23	NULL	NULL	NULL	NULL	2024-08-01	Occupational Expert
19-5011.00	2.D.1	RL	3	4.35	23	NULL	NULL	NULL	NULL	2024-08-01	Occupational Expert
19-5011.00	2.D.1	RL	4	0.00	23	NULL	NULL	NULL	NULL	2024-08-01	Occupational Expert
19-5011.00	2.D.1	RL	5	4.35	23	NULL	NULL	NULL	NULL	2024-08-01	Occupational Expert
19-5011.00	2.D.1	RL	6	73.91	23	NULL	NULL	NULL	NULL	2024-08-01	Occupational Expert
19-5011.00	2.D.1	RL	7	8.70	23	NULL	NULL	NULL	NULL	2024-08-01	Occupational Expert
19-5011.00	2.D.1	RL	8	8.70	23	NULL	NULL	NULL	NULL	2024-08-01	Occupational Expert
19-5011.00	2.D.1	RL	9	0.00	23	NULL	NULL	NULL	NULL	2024-08-01	Occupational Expert
19-5011.00	2.D.1	RL	10	0.00	23	NULL	NULL	NULL	NULL	2024-08-01	Occupational Expert
19-5011.00	2.D.1	RL	11	0.00	23	NULL	NULL	NULL	NULL	2024-08-01	Occupational Expert
19-5011.00	2.D.1	RL	12	0.00	23	NULL	NULL	NULL	NULL	2024-08-01	Occupational Expert