Work Activities
Purpose: Provide a mapping of O*NET-SOC codes (occupations) to Work Activity ratings.
Table Name: work_activities
Structure and Description:
Column Type Column Content onetsoc_code Character(10) O*NET-SOC Code (see Occupation Data element_id Character Varying(20) Content Model Outline Position (see Content Model Reference scale_id Character Varying(3) Scale ID (see Scales Reference data_value Decimal(5,2) Rating associated with the O*NET-SOC occupation n Decimal(4,0) Sample size standard_error Decimal(5,2) Standard Error lower_ci_bound Decimal(5,2) Lower 95% confidence interval bound upper_ci_bound Decimal(5,2) Upper 95% confidence interval bound recommend_suppress Character(1) Low precision indicator (Y=yes, N=no) not_relevant Character(1) Not relevant for the occupation (Y=yes, N=no) date_updated Date Date when data was updated domain_source Character Varying(30) Source of the data
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 more information, see:
File Structure Changes:
Release Number Description of Change 5.0 Date and Source columns added 5.1 Columns added for N, Standard Error, Lower CI Bound, Upper CI Bound, Recommend Suppress, and Not Relevant 6.0 - 22.3 No structure changes
Data Example - work_activities:
onetsoc_code element_id scale_id data_value n standard_error lower_ci_bound upper_ci_bound recommend_suppress not_relevant date_updated domain_source 43-6011.00 4.A.1.a.1 IM 4.50 46 0.11 4.28 4.72 N NULL 2017-07-01 Incumbent 43-6011.00 4.A.1.a.1 LV 4.33 45 0.34 3.65 5.00 N N 2017-07-01 Incumbent 43-6011.00 4.A.1.a.2 IM 3.42 45 0.16 3.10 3.74 N NULL 2017-07-01 Incumbent 43-6011.00 4.A.1.a.2 LV 3.88 45 0.40 3.07 4.69 N N 2017-07-01 Incumbent 43-6011.00 4.A.1.b.1 IM 3.92 46 0.18 3.55 4.28 N NULL 2017-07-01 Incumbent 43-6011.00 4.A.1.b.1 LV 3.97 46 0.39 3.18 4.76 N N 2017-07-01 Incumbent 43-6011.00 4.A.1.b.2 IM 2.28 45 0.21 1.86 2.69 N NULL 2017-07-01 Incumbent 43-6011.00 4.A.1.b.2 LV 1.85 46 0.33 1.19 2.51 N N 2017-07-01 Incumbent 43-6011.00 4.A.1.b.3 IM 2.51 46 0.21 2.08 2.93 N NULL 2017-07-01 Incumbent 43-6011.00 4.A.1.b.3 LV 2.41 46 0.36 1.69 3.13 N N 2017-07-01 Incumbent 43-6011.00 4.A.2.a.1 IM 2.93 45 0.26 2.40 3.45 N NULL 2017-07-01 Incumbent 43-6011.00 4.A.2.a.1 LV 3.20 45 0.44 2.31 4.09 N N 2017-07-01 Incumbent
