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 - 26.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 11-3051.00 4.A.1.a.1 IM 4.46 37 0.12 4.21 4.71 N NULL 2021-08-01 Incumbent 11-3051.00 4.A.1.a.1 LV 4.28 37 0.24 3.78 4.78 N N 2021-08-01 Incumbent 11-3051.00 4.A.1.a.2 IM 4.19 37 0.16 3.87 4.52 N NULL 2021-08-01 Incumbent 11-3051.00 4.A.1.a.2 LV 4.82 37 0.32 4.17 5.47 N N 2021-08-01 Incumbent 11-3051.00 4.A.1.b.1 IM 3.95 37 0.15 3.66 4.25 N NULL 2021-08-01 Incumbent 11-3051.00 4.A.1.b.1 LV 3.97 36 0.35 3.26 4.67 N N 2021-08-01 Incumbent 11-3051.00 4.A.1.b.2 IM 4.02 36 0.16 3.70 4.33 N NULL 2021-08-01 Incumbent 11-3051.00 4.A.1.b.2 LV 3.95 35 0.26 3.43 4.47 N N 2021-08-01 Incumbent 11-3051.00 4.A.1.b.3 IM 3.52 37 0.16 3.19 3.84 N NULL 2021-08-01 Incumbent 11-3051.00 4.A.1.b.3 LV 3.27 37 0.20 2.87 3.67 N N 2021-08-01 Incumbent 11-3051.00 4.A.2.a.1 IM 3.67 37 0.19 3.29 4.06 N NULL 2021-08-01 Incumbent 11-3051.00 4.A.2.a.1 LV 3.72 37 0.27 3.17 4.26 N N 2021-08-01 Incumbent
