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).

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.

For more information, see:

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

Data Example - work_values:
onetsoc_​codeelement_​idscale_​iddata_​valuedate_​updateddomain_​source
15-1143.011.B.2.aEX5.002012-07-01Analyst
15-1143.011.B.2.bEX4.672012-07-01Analyst
15-1143.011.B.2.cEX4.002012-07-01Analyst
15-1143.011.B.2.dEX3.332012-07-01Analyst
15-1143.011.B.2.eEX5.002012-07-01Analyst
15-1143.011.B.2.fEX3.672012-07-01Analyst
15-1143.011.B.2.gVH1.002012-07-01Analyst
15-1143.011.B.2.hVH5.002012-07-01Analyst
15-1143.011.B.2.iVH2.002012-07-01Analyst