Tasks to Green DWAs
| Purpose: | Provide a mapping of task statements to Green Detailed Work Activities. |
| Table Name: | tasks_to_green_dwas |
Structure and Description:
| Column | Type | Column Content |
|---|
| onetsoc_code | Character(10) | O*NET-SOC Code (see Occupation Data) |
| task_id | Decimal(8,0) | Identifies each task (see Task Statements) |
| green_dwa_id | Character Varying(20) | Identifies each Green Detailed Work Activity (see Green DWA Reference) |
| date_updated | Date | Date when data was updated |
| domain_source | Character 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,311 rows of data in this file.
For more information, see:
File Structure Changes:
| Release Number | Description of Change |
|---|
| 18.1 | Added as a new file |
| 19.0 - 22.0 | No structure changes |
Data Example - tasks_to_green_dwas:
| onetsoc_code | task_id | green_dwa_id | date_updated | domain_source |
|---|
| 17-3029.09 | 18249 | 4.A.2.b.6.G01 | 2014-03-01 | Analyst |
| 17-3029.09 | 19737 | 4.A.3.a.2.G07 | 2014-03-01 | Analyst |
| 17-3029.09 | 19738 | 4.A.2.a.3.G03 | 2014-03-01 | Analyst |
