Knowledge

Purpose:

Provide a mapping of O*NET-SOC codes (occupations) to Knowledge ratings.

Table Name:

knowledge

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)
data_value	Decimal(5,2)	Rating associated with the O*NET-SOC occupation
n	Decimal(4,0)	Sample size
standard_error	Decimal(5,2)	Standard Error
lower_ci_bound	Decimal(5,2)	Lower 95% confidence interval bound
upper_ci_bound	Decimal(5,2)	Upper 95% confidence interval bound
recommend_suppress	Character(1)	Low precision indicator (Y=yes, N=no)
not_relevant	Character(1)	Not relevant for the occupation (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 Content Model Knowledge data associated with each O*NET-SOC occupation. 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, not_relevant, 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 63,822 rows of data in this file.

File Structure Changes:

Release Number	Description of Change
5.0	Date and Source columns added
5.1	Columns added for N, Standard Error, Lower CI Bound, Upper CI Bound, Recommend Suppress, and Not Relevant
6.0 - 23.0	No structure changes

Data Example - knowledge:

onetsoc_code	element_id	scale_id	data_value	n	standard_error	lower_ci_bound	upper_ci_bound	recommend_suppress	not_relevant	date_updated	domain_source
15-1199.03	2.C.8.b	IM	2.47	19	NULL	NULL	NULL	NULL	NULL	2018-08-01	Occupational Expert
15-1199.03	2.C.8.b	LV	2.50	20	NULL	NULL	NULL	NULL	N	2018-08-01	Occupational Expert
15-1199.03	2.C.9.a	IM	2.70	20	NULL	NULL	NULL	NULL	NULL	2018-08-01	Occupational Expert
15-1199.03	2.C.9.a	LV	2.80	20	NULL	NULL	NULL	NULL	N	2018-08-01	Occupational Expert
15-1199.03	2.C.9.b	IM	4.10	20	NULL	NULL	NULL	NULL	NULL	2018-08-01	Occupational Expert
15-1199.03	2.C.9.b	LV	4.20	20	NULL	NULL	NULL	NULL	N	2018-08-01	Occupational Expert
15-1199.03	2.C.10	IM	1.40	20	NULL	NULL	NULL	NULL	NULL	2018-08-01	Occupational Expert
15-1199.03	2.C.10	LV	0.90	20	NULL	NULL	NULL	NULL	N	2018-08-01	Occupational Expert

Was this page helpful?

Job Seeker Help • Contact Us

Link to Us • Cite this Page

License

About this Site • Privacy • Disclaimer

Site updated March 4, 2025