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(7,4) Standard Error lower_ci_bound Decimal(7,4) Lower 95% confidence interval bound upper_ci_bound Decimal(7,4) 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 - 28.1 No structure changes 28.2 Standard Error, Lower CI Bound, Upper CI Bound expanded from 2 decimal places to 4 28.3 - 29.2 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 33-1012.00 4.A.1.a.1 IM 4.70 30 0.0860 4.5271 4.8787 N NULL 2024-08-01 Incumbent 33-1012.00 4.A.1.a.1 LV 4.27 31 0.2561 3.7491 4.7950 N N 2024-08-01 Incumbent 33-1012.00 4.A.1.a.2 IM 3.54 29 0.2707 2.9846 4.0934 N NULL 2024-08-01 Incumbent 33-1012.00 4.A.1.a.2 LV 4.25 30 0.3551 3.5258 4.9782 N N 2024-08-01 Incumbent 33-1012.00 4.A.1.b.1 IM 4.20 31 0.3129 3.5583 4.8364 N NULL 2024-08-01 Incumbent 33-1012.00 4.A.1.b.1 LV 4.47 31 0.3696 3.7141 5.2238 N N 2024-08-01 Incumbent 33-1012.00 4.A.1.b.2 IM 3.20 30 0.2640 2.6599 3.7397 N NULL 2024-08-01 Incumbent 33-1012.00 4.A.1.b.2 LV 3.14 31 0.3814 2.3636 3.9214 N N 2024-08-01 Incumbent 33-1012.00 4.A.1.b.3 IM 3.17 31 0.2706 2.6222 3.7273 N NULL 2024-08-01 Incumbent 33-1012.00 4.A.1.b.3 LV 3.55 31 0.3936 2.7509 4.3585 N N 2024-08-01 Incumbent 33-1012.00 4.A.2.a.1 IM 3.39 30 0.2405 2.8998 3.8834 N NULL 2024-08-01 Incumbent 33-1012.00 4.A.2.a.1 LV 4.38 30 0.5038 3.3479 5.4085 N N 2024-08-01 Incumbent
