Purpose:Provide a mapping of O*NET-SOC codes (occupations) to Interest ratings.
Table Name:interests
Download: 13_interests.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 Interest data associated with each O*NET-SOC occupation.

Interest ratings are presented as two scales: OI reports the RIASEC level of each interest and IH presents “high-point codes”, the numbers of the RIASEC scales for the first, second and/or third highest ratings.

The high-point values represent the following elements:

 0.00 = No high point available 
 1.00 = Realistic 
 2.00 = Investigative 
 3.00 = Artistic 
 4.00 = Social 
 5.00 = Enterprising 
 6.00 = Conventional 

The file is displayed in six tab delimited fields with the columns named O*NET-SOC Code, Element ID, Scale ID, Data Value, Date, and Domain Source. The six fields are represented by one row. There are a total of 7,866 rows of data in this file.

For more information, see:

File Structure Changes:
Release NumberDescription of Change
5.0Date and Source columns added
5.1 - 26.0No structure changes

Data Example - interests:
43-4041.001.B.1.aOI1.832020-11-01Analyst - Transition
43-4041.001.B.1.bOI2.002020-11-01Analyst - Transition
43-4041.001.B.1.cOI1.002020-11-01Analyst - Transition
43-4041.001.B.1.dOI2.672020-11-01Analyst - Transition
43-4041.001.B.1.eOI5.172020-11-01Analyst - Transition
43-4041.001.B.1.fOI6.502020-11-01Analyst - Transition
43-4041.001.B.1.gIH6.002020-11-01Analyst - Transition
43-4041.001.B.1.hIH5.002020-11-01Analyst - Transition
43-4041.001.B.1.iIH4.002020-11-01Analyst - Transition
29-2034.001.B.1.aOI6.502020-11-01Analyst - Transition
29-2034.001.B.1.bOI3.332020-11-01Analyst - Transition
29-2034.001.B.1.cOI1.332020-11-01Analyst - Transition
29-2034.001.B.1.dOI4.332020-11-01Analyst - Transition
29-2034.001.B.1.eOI3.002020-11-01Analyst - Transition
29-2034.001.B.1.fOI3.502020-11-01Analyst - Transition
29-2034.001.B.1.gIH1.002020-11-01Analyst - Transition
29-2034.001.B.1.hIH4.002020-11-01Analyst - Transition
29-2034.001.B.1.iIH6.002020-11-01Analyst - Transition