Education, Training, and Experience
| Purpose: | Provide a mapping of O*NET-SOC codes (occupations) to Education, Training, and Experience ratings. |
Structure and Description:
| Column | Type | Column Content |
|---|
| O*NET-SOC Code | Character(10) | O*NET-SOC Code (see Occupation Data) |
| Element ID | Character Varying(20) | Content Model Outline Position (see Content Model Reference) |
| Element Name | Character Varying(150) | Content Model Element Name (see Content Model Reference) |
| Scale ID | Character Varying(3) | Scale ID (see Scales Reference) |
| Category | Integer(3) | Percent frequency category (see Education, Training, and Experience Categories) |
| Data Value | Float(5,2) | Rating associated with the O*NET-SOC occupation |
| N | Integer(4) | Sample size |
| Standard Error | Float(5,2) | Standard Error |
| Lower CI Bound | Float(5,2) | Lower 95% confidence interval bound |
| Upper CI Bound | Float(5,2) | Upper 95% confidence interval bound |
| Recommend Suppress | Character(1) | Low precision indicator (Y=yes, N=no) |
| Date | Character(7) | Date when data was updated |
| Domain Source | Character Varying(30) | Source of the data |
This file contains the percent frequency data associated with Education, Training, and Experience Content Model elements. 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, Date, 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 38,991 rows of data in this file.
File Structure Changes:
| Release Number | Description of Change |
|---|
| 5.0 | Added as a new file |
| 5.1 | Columns added for N, Standard Error, Lower CI Bound, Upper CI Bound, and Recommend Suppress |
| 6.0 - 20.1 | No structure changes |
Data Example - Education, Training, and Experience:
| O*NET-SOC Code | Element ID | Element Name | Scale ID | Category | Data Value | N | Standard Error | Lower CI Bound | Upper CI Bound | Recommend Suppress | Date | Domain Source |
|---|
| 17-2071.00 | 2.D.1 | Required Level of Education | RL | 1 | 0.00 | 49 | 0.00 | n/a | n/a | N | 07/2015 | Incumbent |
| 17-2071.00 | 2.D.1 | Required Level of Education | RL | 2 | 2.58 | 49 | 2.60 | 0.33 | 17.51 | N | 07/2015 | Incumbent |
| 17-2071.00 | 2.D.1 | Required Level of Education | RL | 3 | 0.00 | 49 | 0.00 | n/a | n/a | N | 07/2015 | Incumbent |
| 17-2071.00 | 2.D.1 | Required Level of Education | RL | 4 | 0.44 | 49 | 0.45 | 0.06 | 3.38 | N | 07/2015 | Incumbent |
| 17-2071.00 | 2.D.1 | Required Level of Education | RL | 5 | 1.83 | 49 | 1.49 | 0.35 | 9.00 | N | 07/2015 | Incumbent |
| 17-2071.00 | 2.D.1 | Required Level of Education | RL | 6 | 70.15 | 49 | 10.90 | 45.20 | 87.00 | N | 07/2015 | Incumbent |
| 17-2071.00 | 2.D.1 | Required Level of Education | RL | 7 | 1.25 | 49 | 1.27 | 0.16 | 9.16 | N | 07/2015 | Incumbent |
| 17-2071.00 | 2.D.1 | Required Level of Education | RL | 8 | 23.33 | 49 | 11.13 | 8.01 | 51.54 | N | 07/2015 | Incumbent |
| 17-2071.00 | 2.D.1 | Required Level of Education | RL | 9 | 0.00 | 49 | 0.00 | n/a | n/a | N | 07/2015 | Incumbent |
| 17-2071.00 | 2.D.1 | Required Level of Education | RL | 10 | 0.44 | 49 | 0.45 | 0.06 | 3.38 | N | 07/2015 | Incumbent |
| 17-2071.00 | 2.D.1 | Required Level of Education | RL | 11 | 0.00 | 49 | 0.00 | n/a | n/a | N | 07/2015 | Incumbent |
| 17-2071.00 | 2.D.1 | Required Level of Education | RL | 12 | 0.00 | 49 | 0.00 | n/a | n/a | N | 07/2015 | Incumbent |
