Work Values

Purpose:Provide a mapping of O*NET-SOC codes (occupations) to Work Values ratings.
Table Name:work_values
Download: 22_work_values.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 Work Values data associated with each O*NET- SOC occupation.

The column named Data Value provides both the mean extent rating (indicated by the value EX in the Scale ID column) and the top three high-point values for respondents endorsing each occupation (indicated by VH in the Scale ID Column). To better understand the scales, refer to the report: The Second Generation Occupational Value Profiles for the O*NET System: Summary, on the O*NET Resource Center site (http://www.onetcenter.org/reports/SecondOVP_Summary.html).

The high-point values represent the following elements:

 0.00 = No high point available 
 1.00 = Achievement 
 2.00 = Working Conditions 
 3.00 = Recognition 
 4.00 = Relationships 
 5.00 = Support 
 6.00 = Independence 

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.2No structure changes

Data Example - work_values:
onetsoc_​codeelement_​idscale_​iddata_​valuedate_​updateddomain_​source
17-2071.001.B.2.aEX5.672008-06-01Analyst
17-2071.001.B.2.bEX5.502008-06-01Analyst
17-2071.001.B.2.cEX5.332008-06-01Analyst
17-2071.001.B.2.dEX4.332008-06-01Analyst
17-2071.001.B.2.eEX4.332008-06-01Analyst
17-2071.001.B.2.fEX5.332008-06-01Analyst
17-2071.001.B.2.gVH1.002008-06-01Analyst
17-2071.001.B.2.hVH2.002008-06-01Analyst
17-2071.001.B.2.iVH6.002008-06-01Analyst