This table contains information about the defined purposes of the dam. There is a many to one relationship with the Dam table via the DamXDamPurpose table.
| Field Name | Field Description | Data Type | Field Size* | DamID | The DamID number for the dam. | int | 4 | DamPurposeID | The uses or purposes of the project (hydropower, water supply, recreation, etc.) | tinyint | 1 | RefID | The primary reference number describing the source of the Dam information | int | 4 | UpdDate | The date and time the record was created or updated by agency compiler. | smalldatetime | 4 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.