Knowledge

Purpose:Provide a mapping of O*NET-SOC codes (occupations) to Knowledge ratings.
Table Name:knowledge
Download: 15_knowledge.sql
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)
data_valueDecimal(5,2)Rating associated with the O*NET-SOC occupation

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,888 rows of data in this file.

File Structure Changes:
Release NumberDescription of Change
5.0Date and Source columns added
5.1Columns added for N, Standard Error, Lower CI Bound, Upper CI Bound, Recommend Suppress, and Not Relevant
6.0 - 24.3No structure changes

Data Example - knowledge:
onetsoc_​codeelement_​idscale_​iddata_​valuenstandard_​errorlower_​ci_​boundupper_​ci_​boundrecommend_​suppressnot_​relevantdate_​updateddomain_​source
25-1082.002.C.8.bIM2.90200.282.303.49NNULL2019-08-01Incumbent
25-1082.002.C.8.bLV3.03200.362.283.77NN2019-08-01Incumbent
25-1082.002.C.9.aIM2.72200.351.993.45NNULL2019-08-01Incumbent
25-1082.002.C.9.aLV2.85200.641.514.19NN2019-08-01Incumbent
25-1082.002.C.9.bIM3.60200.312.954.25NNULL2019-08-01Incumbent
25-1082.002.C.9.bLV4.28200.403.455.12NN2019-08-01Incumbent
25-1082.002.C.10IM1.22200.101.001.43NNULL2019-08-01Incumbent
25-1082.002.C.10LV0.58200.290.001.19YY2019-08-01Incumbent