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 additional information on these items. The 12 fields are represented by one row. There are a total of 72,078 rows of data in this file.
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.1 | 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 |
