Green DWA Reference
| Purpose: | Provide each Green Detailed Work Activity. |
| Table Name: | green_dwa_reference |
Structure and Description:
| Column | Type | Column Content |
|---|
| element_id | Character Varying(20) | Content Model Outline Position (see Content Model Reference) |
| green_dwa_id | Character Varying(20) | Identifies each Green Detailed Work Activity |
| green_dwa_title | Character Varying(150) | Green Detailed Work Activity statement |
This file contains each Green Detailed Work Activity and the element ID of its corresponding generalized Work Activity. Each Green DWA is linked to exactly one Work Activity from the O*NET Content Model. Each Green DWA is linked to multiple task statements; see Tasks to Green DWAs for these links.
The file is displayed in three tab delimited fields with the columns named Element ID, Green DWA ID, and Green DWA Title. The three fields are represented by one row. There are a total of 174 rows of data in this file.
File Structure Changes:
| Release Number | Description of Change |
|---|
| 18.1 | Added as a new file |
| 19.0 - 20.3 | No structure changes |
Data Example - green_dwa_reference:
| element_id | green_dwa_id | green_dwa_title |
|---|
| 4.A.1.a.1 | 4.A.1.a.1.G01 | Collect geographic information systems (GIS) data. |
| 4.A.1.a.1 | 4.A.1.a.1.G02 | Collect geological data. |
| 4.A.2.b.2 | 4.A.2.b.2.G09 | Design systems for water management, distribution or conservation. |
| 4.A.4.b.6 | 4.A.4.b.6.G07 | Advise others on environmental remediation or restoration procedures. |
