Purpose:Provide a mapping of O*NET-SOC codes (occupations) to Knowledge ratings.
Download: excel Knowledge.xlsx
Structure and Description:
ColumnTypeColumn Content
O*NET-SOC CodeCharacter(10)O*NET-SOC Code (see Occupation Data)
TitleCharacter Varying(150)O*NET-SOC Title (see Occupation Data)
Element IDCharacter Varying(20)Content Model Outline Position (see Content Model Reference)
Element NameCharacter Varying(150)Content Model Element Name (see Content Model Reference)
Scale IDCharacter Varying(3)Scale ID (see Scales Reference)
Scale NameCharacter Varying(50)Scale Name (see Scales Reference)
Data ValueFloat(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 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, Not Relevant, 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 63,624 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 - 21.1No structure changes

Data Example - Knowledge:
O*NET-SOC CodeTitleElement IDElement NameScale IDScale NameData ValueNStandard ErrorLower CI BoundUpper CI BoundRecommend SuppressNot RelevantDateDomain Source
17-2199.03Energy Engineers2.C.8.bLaw and GovernmentIMImportance2.9122     07/2016Occupational Expert
17-2199.03Energy Engineers2.C.8.bLaw and GovernmentLVLevel3.5522    N07/2016Occupational Expert
17-2199.03Energy Engineers2.C.9.aTelecommunicationsIMImportance1.8622     07/2016Occupational Expert
17-2199.03Energy Engineers2.C.9.aTelecommunicationsLVLevel1.6422    N07/2016Occupational Expert
17-2199.03Energy Engineers2.C.9.bCommunications and MediaIMImportance2.6422     07/2016Occupational Expert
17-2199.03Energy Engineers2.C.9.bCommunications and MediaLVLevel2.6422    N07/2016Occupational Expert
17-2199.03Energy Engineers2.C.10TransportationIMImportance1.9522     07/2016Occupational Expert
17-2199.03Energy Engineers2.C.10TransportationLVLevel1.8222    N07/2016Occupational Expert