Purpose:Provide a mapping of O*NET-SOC codes (occupations) to Ability ratings.
Table Name:abilities
Download: oracle 11_abilities.sql
Structure and Description:
ColumnTypeColumn Content
onetsoc_codeCharacter(10)O*NET-SOC Code (see Occupation Data)
element_idCharacter Varying(20)Content Model Outline Position (see Content Model Reference)
scale_idCharacter Varying(3)Scale ID (see Scales Reference)
data_valueDecimal(5,2)Rating associated with the O*NET-SOC occupation

This file contains the Content Model Ability 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 1, Item Rating Level Statistics - Analyst for additional information on these items. The 12 fields are represented by one row. There are a total of 90,792 rows of data in this file.

For more information, see:

File Structure Changes:
Release NumberDescription of Change
5.0Date and Source columns added
5.1Columns added for N, Standard Error, Lower CI Bound, Upper CI Bound, Recommend Suppress, and Not Relevant
6.0 - 25.2No structure changes

Data Example - abilities:
29-2034.001.A.1.a.1IM4.00NULLNULLNULLNULLNNULL2020-11-01Analyst - Transition
29-2034.001.A.1.a.1LV4.00NULLNULLNULLNULLNN2020-11-01Analyst - Transition
29-2034.001.A.1.a.2IM3.75NULLNULLNULLNULLNNULL2020-11-01Analyst - Transition
29-2034.001.A.1.a.2LV3.88NULLNULLNULLNULLNN2020-11-01Analyst - Transition
29-2034.001.A.1.a.3IM4.00NULLNULLNULLNULLNNULL2020-11-01Analyst - Transition
29-2034.001.A.1.a.3LV4.00NULLNULLNULLNULLNN2020-11-01Analyst - Transition
29-2034.001.A.1.a.4IM3.44NULLNULLNULLNULLNNULL2020-11-01Analyst - Transition
29-2034.001.A.1.a.4LV3.37NULLNULLNULLNULLNN2020-11-01Analyst - Transition