Work Context
| Purpose: | Provide a mapping of O*NET-SOC codes (occupations) to Work Context ratings. |
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) |
| category | Decimal(3,0) | Percent frequency category (see Work Context Categories) |
| 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 Context data associated with each O*NET-SOC occupation. It is displayed in 13 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 13 fields are represented by one row. There are a total of 326,546 rows of data in this file.
The column named Data Value provides both the mean rating (indicated by the value CX in the Scale ID column) and the percent of respondents endorsing each category (indicated by CXP in the Scale ID column).
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.3 | No structure changes |
Data Example - work_context:
| onetsoc_code | element_id | scale_id | category | data_value | n | standard_error | lower_ci_bound | upper_ci_bound | recommend_suppress | not_relevant | date_updated | domain_source |
|---|
| 39-9011.01 | 4.C.3.d.8 | CT | NULL | 2.77 | 22 | NULL | NULL | NULL | NULL | NULL | 2018-08-01 | Occupational Expert |
| 39-9011.01 | 4.C.3.d.8 | CTP | 1 | 0.00 | 22 | NULL | NULL | NULL | NULL | NULL | 2018-08-01 | Occupational Expert |
| 39-9011.01 | 4.C.3.d.8 | CTP | 2 | 22.73 | 22 | NULL | NULL | NULL | NULL | NULL | 2018-08-01 | Occupational Expert |
| 39-9011.01 | 4.C.3.d.8 | CTP | 3 | 77.27 | 22 | NULL | NULL | NULL | NULL | NULL | 2018-08-01 | Occupational Expert |
