Task Ratings

Purpose:Provide a mapping of O*NET-SOC codes (occupations) to the ratings for tasks associated with the occupation.
Table Name:task_ratings
Structure and Description:
ColumnTypeColumn Content
onetsoc_codeCharacter(10)O*NET-SOC Code (see Occupation Data)
task_idDecimal(8,0)Identifies each task (see Task Statements)
scale_idCharacter Varying(3)Scale ID (see Scales Reference)
categoryDecimal(3,0)Percent frequency category (see Task Categories)
data_valueDecimal(5,2)Rating associated with the O*NET-SOC occupation

This file contains the task ratings 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, 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 158,751 rows of data in this file.

File Structure Changes:
Release NumberDescription of Change
13.0Added as a new file
14.0 - 28.1No structure changes
28.2Standard Error, Lower CI Bound, Upper CI Bound expanded from 2 decimal places to 4
28.3 - 29.0No structure changes

Data Example - task_ratings:
onetsoc_​codetask_​idscale_​idcategorydata_​valuenstandard_​errorlower_​ci_​boundupper_​ci_​boundrecommend_​suppressdate_​updateddomain_​source
17-2081.0015210FT110.0020NULLNULLNULLNULL2024-08-01Occupational Expert
17-2081.0015210FT215.0020NULLNULLNULLNULL2024-08-01Occupational Expert
17-2081.0015210FT325.0020NULLNULLNULLNULL2024-08-01Occupational Expert
17-2081.0015210FT420.0020NULLNULLNULLNULL2024-08-01Occupational Expert
17-2081.0015210FT515.0020NULLNULLNULLNULL2024-08-01Occupational Expert
17-2081.0015210FT65.0020NULLNULLNULLNULL2024-08-01Occupational Expert
17-2081.0015210FT710.0020NULLNULLNULLNULL2024-08-01Occupational Expert
17-2081.0015210IMNULL4.2921NULLNULLNULLNULL2024-08-01Occupational Expert
17-2081.0015210RTNULL100.0021NULLNULLNULLNULL2024-08-01Occupational Expert