Green DWA Reference

Purpose:Provide each Green Detailed Work Activity.
Table Name:green_dwa_reference
Structure and Description:
ColumnTypeColumn Content
element_idCharacter Varying(20)Content Model Outline Position (see Content Model Reference)
green_dwa_idCharacter Varying(20)Identifies each Green Detailed Work Activity
green_dwa_titleCharacter 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 NumberDescription of Change
18.1Added as a new file
19.0 - 20.1No structure changes

Data Example - green_dwa_reference:
element_​idgreen_​dwa_​idgreen_​dwa_​title
4.A.1.a.14.A.1.a.1.G01Collect geographic information systems (GIS) data.
4.A.1.a.14.A.1.a.1.G02Collect geological data.
4.A.2.b.24.A.2.b.2.G09Design systems for water management, distribution or conservation.
4.A.4.b.64.A.4.b.6.G07Advise others on environmental remediation or restoration procedures.