Work Activities

Purpose:Provide a mapping of O*NET-SOC codes (occupations) to Work Activity ratings.
Table Name:work_activities
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 Activity data associated with each O*NET-SOC occupation. It is displayed in 12 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_updated, and domain_source. Refer to Appendix 2, Item Rating Level Statistics - Incumbent for additional information on these items. The 12 fields are represented by one row. There are a total of 78,228 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 - 20.2No structure changes

Data Example - work_activities:
onetsoc_​codeelement_​idscale_​iddata_​valuenstandard_​errorlower_​ci_​boundupper_​ci_​boundrecommend_​suppressnot_​relevantdate_​updateddomain_​source
17-2071.004.A.1.a.1IM4.43460.084.264.60NNULL2015-07-01Incumbent
17-2071.004.A.1.a.1LV4.78460.274.235.33NN2015-07-01Incumbent
17-2071.004.A.1.a.2IM3.54460.302.944.15NNULL2015-07-01Incumbent
17-2071.004.A.1.a.2LV4.43460.223.994.87NN2015-07-01Incumbent
17-2071.004.A.1.b.1IM3.93460.163.624.25NNULL2015-07-01Incumbent
17-2071.004.A.1.b.1LV4.62460.284.065.18NN2015-07-01Incumbent
17-2071.004.A.1.b.2IM3.42460.193.033.80NNULL2015-07-01Incumbent
17-2071.004.A.1.b.2LV3.77460.223.324.22NN2015-07-01Incumbent
17-2071.004.A.1.b.3IM3.55460.183.193.92NNULL2015-07-01Incumbent
17-2071.004.A.1.b.3LV3.65460.193.264.04NN2015-07-01Incumbent
17-2071.004.A.2.a.1IM3.23450.142.943.52NNULL2015-07-01Incumbent
17-2071.004.A.2.a.1LV3.91460.203.504.31NN2015-07-01Incumbent