Tasks to Green DWAs

Purpose:Provide a mapping of task statements to Green Detailed Work Activities.
Table Name:tasks_to_green_dwas
Download: 29_tasks_to_green_dwas.sql
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)
green_dwa_idCharacter Varying(20)Identifies each Green Detailed Work Activity (see Green DWA Reference)
date_updatedDateDate when data was updated
domain_sourceCharacter Varying(30)Source of the data

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

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

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

Data Example - tasks_to_green_dwas:
onetsoc_​codetask_​idgreen_​dwa_​iddate_​updateddomain_​source
17-2011.00207244.A.2.b.1.G102015-07-01Analyst
17-2011.00207254.A.2.a.4.G122015-07-01Analyst
17-2011.00207264.A.2.b.1.G102015-07-01Analyst