WaDE2.0 [WaDE2.01.xml]
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| RegulatoryOverlayID | BigInt |
| Primary key unique identifier to RegulatoryOverlay_dim table. | |||
| 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(100) |
| 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)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_RegulatoryOverlay_dim_RegulatoryOverlayTypeCV | CVs.RegulatoryOverlayTypeCV | Core.RegulatoryOverlay_dim | Name | RegulatoryOverlayTypeCV |
(none)
| Diagram Name |
| 1_WaterAllocations |
| 4_RegulatoryInfo |