Purpose:Provide a mapping of O*NET-SOC codes (occupations) to Knowledge ratings.
Download: 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,822 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 - 23.0No structure changes

Data Example - Knowledge:
O*NET-SOC CodeTitleElement IDElement NameScale IDScale NameData ValueNStandard ErrorLower CI BoundUpper CI BoundRecommend SuppressNot RelevantDateDomain Source
15-1199.03Web Administrators2.C.8.bLaw and GovernmentIMImportance2.4719     08/2018Occupational Expert
15-1199.03Web Administrators2.C.8.bLaw and GovernmentLVLevel2.5020    N08/2018Occupational Expert
15-1199.03Web Administrators2.C.9.aTelecommunicationsIMImportance2.7020     08/2018Occupational Expert
15-1199.03Web Administrators2.C.9.aTelecommunicationsLVLevel2.8020    N08/2018Occupational Expert
15-1199.03Web Administrators2.C.9.bCommunications and MediaIMImportance4.1020     08/2018Occupational Expert
15-1199.03Web Administrators2.C.9.bCommunications and MediaLVLevel4.2020    N08/2018Occupational Expert
15-1199.03Web Administrators2.C.10TransportationIMImportance1.4020     08/2018Occupational Expert
15-1199.03Web Administrators2.C.10TransportationLVLevel0.9020    N08/2018Occupational Expert