Tasks to DWAs

Purpose:Provide a mapping of task statements to Detailed Work Activities.
Table Name:tasks_to_dwas
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)
dwa_idCharacter Varying(20)Identifies each Detailed Work Activity (see DWA Reference)

This file maps each Detailed Work Activity (DWA) to the task statements, and consequently to the O*NET-SOC occupations, requiring that activity. Each DWA is mapped to multiple task statements, and each referenced task statement is mapped to one or more DWAs.

The file is displayed in five tab delimited fields with the columns named O*NET-SOC Code, Task ID, DWA ID, Date, and Domain Source. The five fields are represented by one row. There are a total of 23,014 rows of data in this file.

For more information, see:

File Structure Changes:
Release NumberDescription of Change
18.1Added as a new file
19.0 - 25.1No structure changes

Data Example - tasks_to_dwas:
onetsoc_​codetask_​iddwa_​iddate_​updateddomain_​source
53-6051.00238504.A.3.b.6.I08.D012020-11-01Analyst
53-6051.00238514.A.1.a.2.I02.D142020-11-01Analyst
53-6051.00238524.A.3.b.6.I08.D032020-11-01Analyst
53-6051.00238534.A.4.a.1.I02.D042020-11-01Analyst
53-6051.00238544.A.1.a.2.I02.D122020-11-01Analyst