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 - 23.0 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 27-2032.00 4.A.1.a.1 IM 4.10 21 NULL NULL NULL NULL NULL 2018-08-01 Occupational Expert 27-2032.00 4.A.1.a.1 LV 4.48 21 NULL NULL NULL NULL N 2018-08-01 Occupational Expert 27-2032.00 4.A.1.a.2 IM 2.95 21 NULL NULL NULL NULL NULL 2018-08-01 Occupational Expert 27-2032.00 4.A.1.a.2 LV 3.25 20 NULL NULL NULL NULL N 2018-08-01 Occupational Expert 27-2032.00 4.A.1.b.1 IM 3.67 21 NULL NULL NULL NULL NULL 2018-08-01 Occupational Expert 27-2032.00 4.A.1.b.1 LV 4.19 21 NULL NULL NULL NULL N 2018-08-01 Occupational Expert 27-2032.00 4.A.1.b.2 IM 2.43 21 NULL NULL NULL NULL NULL 2018-08-01 Occupational Expert 27-2032.00 4.A.1.b.2 LV 2.38 21 NULL NULL NULL NULL N 2018-08-01 Occupational Expert 27-2032.00 4.A.1.b.3 IM 2.95 20 NULL NULL NULL NULL NULL 2018-08-01 Occupational Expert 27-2032.00 4.A.1.b.3 LV 2.95 20 NULL NULL NULL NULL N 2018-08-01 Occupational Expert 27-2032.00 4.A.2.a.1 IM 3.95 20 NULL NULL NULL NULL NULL 2018-08-01 Occupational Expert 27-2032.00 4.A.2.a.1 LV 4.89 19 NULL NULL NULL NULL N 2018-08-01 Occupational Expert
