WaDE2.0 [WaDE2.01.xml]
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
| RegulatoryOverlayUUID | NVarChar(250) | Foreign key unique identifier to RegulatoryOverlay_dim table. | |||||
| OversightAgency | NVarChar(250) | The name of the agency / governing body providing oversight for the regulation. | |||||
| RegulatoryDescription | BigInt | A description of the regulation. | |||||
| RegulatoryName | NVarChar(50) | The name of the regulation | |||||
| RegulatoryOverlayNativeID | NVarChar(250) | Unique identifier code / ID used by the data provider to distinguish the regulatory overlay area in the source data. | |||||
| RegulatoryOverlayTypeCV | NVarChar(250) |
| The high level description of the regulatory overlaytype recognized by the data provider. | ||||
| RegulatoryStatusCV | NVarChar(50) | Status of the regulation (e.g., initiated, in effect, efc.). | |||||
| RegulatoryStatute | NVarChar(500) |
| Legal statute(s) ID / name related to the regulation (e.g., 56-78134). | ||||
| RegulatoryStatuteLink | NVarChar(500) |
| A link to the legal statute(s) related to the regulation (e.g., https://le.utah.gov/xcode/code.html). | ||||
| StatutoryEffectiveDate | Date | The start date of the legal statute(s) began. Format of MM/DD/YYYY. | |||||
| StatutoryEndDate | Date |
| The end date of the legal statute(s) ends. Format of MM/DD/YYYY. | ||||
| WaterSourceTypeCV | NVarChar(100) |
| The high level description of the water source type (e.g., surface water, groundwater, mixed, reuse, etc.) |
(none)
(none)
(none)
| Diagram Name |
| 6_InputTables |