Training and Experience
| Purpose: | Provide a mapping of O*NET-SOC codes (occupations) to Training and Experience ratings. |
| Table Name: | training_and_experience |
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 Training and Experience Categories) |
| 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) |
| date_updated | Date | Date when data was updated |
| domain_source | Character Varying(30) | Source of the data |
This file contains the percent frequency data associated with Training and Experience Content Model elements. 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, 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 26,025 rows of data in this file.
File Structure Changes:
| Release Number | Description of Change |
|---|
| 30.3 | Added as a new file |
Data Example - training_and_experience:
| onetsoc_code | element_id | scale_id | category | data_value | n | standard_error | lower_ci_bound | upper_ci_bound | recommend_suppress | date_updated | domain_source |
|---|
| 33-9011.00 | 3.A.1 | RW | 1 | 15.38 | 26 | NULL | NULL | NULL | NULL | 2025-08-01 | Occupational Expert |
| 33-9011.00 | 3.A.1 | RW | 2 | 3.85 | 26 | NULL | NULL | NULL | NULL | 2025-08-01 | Occupational Expert |
| 33-9011.00 | 3.A.1 | RW | 3 | 0.00 | 26 | NULL | NULL | NULL | NULL | 2025-08-01 | Occupational Expert |
| 33-9011.00 | 3.A.1 | RW | 4 | 11.54 | 26 | NULL | NULL | NULL | NULL | 2025-08-01 | Occupational Expert |
| 33-9011.00 | 3.A.1 | RW | 5 | 11.54 | 26 | NULL | NULL | NULL | NULL | 2025-08-01 | Occupational Expert |
| 33-9011.00 | 3.A.1 | RW | 6 | 46.15 | 26 | NULL | NULL | NULL | NULL | 2025-08-01 | Occupational Expert |
| 33-9011.00 | 3.A.1 | RW | 7 | 11.54 | 26 | NULL | NULL | NULL | NULL | 2025-08-01 | Occupational Expert |
| 33-9011.00 | 3.A.1 | RW | 8 | 0.00 | 26 | NULL | NULL | NULL | NULL | 2025-08-01 | Occupational Expert |
| 33-9011.00 | 3.A.1 | RW | 9 | 0.00 | 26 | NULL | NULL | NULL | NULL | 2025-08-01 | Occupational Expert |
| 33-9011.00 | 3.A.1 | RW | 10 | 0.00 | 26 | NULL | NULL | NULL | NULL | 2025-08-01 | Occupational Expert |
| 33-9011.00 | 3.A.1 | RW | 11 | 0.00 | 26 | NULL | NULL | NULL | NULL | 2025-08-01 | Occupational Expert |
