Interests

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. To better understand the scales, refer to the report: The Second Generation Occupational Interest Profiles for the O*NET System: Summary, on the O*NET Resource Center site (http://www.onetcenter.org/reports/SecondOIP_Summary.html).

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

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

Data Example - interests:
onetsoc_​codeelement_​idscale_​iddata_​valuedate_​updateddomain_​source
11-1011.031.B.1.aOI1.002013-07-01Analyst
11-1011.031.B.1.bOI4.332013-07-01Analyst
11-1011.031.B.1.cOI2.672013-07-01Analyst
11-1011.031.B.1.dOI2.332013-07-01Analyst
11-1011.031.B.1.eOI7.002013-07-01Analyst
11-1011.031.B.1.fOI4.332013-07-01Analyst
11-1011.031.B.1.gIH5.002013-07-01Analyst
11-1011.031.B.1.hIH6.002013-07-01Analyst
11-1011.031.B.1.iIH2.002013-07-01Analyst
15-1143.001.B.1.aOI4.002013-07-01Analyst
15-1143.001.B.1.bOI6.002013-07-01Analyst
15-1143.001.B.1.cOI2.332013-07-01Analyst
15-1143.001.B.1.dOI2.002013-07-01Analyst
15-1143.001.B.1.eOI5.332013-07-01Analyst
15-1143.001.B.1.fOI6.002013-07-01Analyst
15-1143.001.B.1.gIH2.002013-07-01Analyst
15-1143.001.B.1.hIH6.002013-07-01Analyst
15-1143.001.B.1.iIH5.002013-07-01Analyst