WaDE2.0 [WaDE2.01.xml]
Water Allocations, also known as water rights or permits
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| AllocationID | BigInt |
| Internal unique identifier integer for allocations | |||
| AllocationUUID | NVarChar(50) | Unique universal identifier for the allocation across all the member states, can be alphanumeric | |||||
| AllocationNativeID | NVarChar(250) | Unique identifier for the allocation as-is in the member states, can be alphanumeric | |||||
| AllocationOwner | NVarChar(255) | Name of the owner, entity with the allocation. If multiple owners, truncate after five. | |||||
| AllocationBasisCV | NVarChar(250) |
| Specify whether this water right is based on water withdrawals/diversion or consumptive use/depletion amount | ||||
| AllocationLegalStatusCV | NVarChar(50) | The legal status of the water right (e.g., proven, approved, perfected, adjudicated, etc.) | |||||
| WaterRightTypeCV | NVarChar(10) |
| This field contains the Type of Application or Water Right of this database entry. examples: Underground Water Claim, Federal Reserved Water Right | ||||
| AllocationApplicationDate | BigInt |
| Date of the original filing on the allocation | ||||
| AllocationPriorityDate | BigInt | Priority Date given to the allocation | |||||
| AllocationExpirationDate | BigInt |
| If the allocation is temporary, add the expiration date | ||||
| AllocationTimeframeEnd | BigInt |
| End date when the water right no longer can legally access the assigned water. Format of MM/DD. | ||||
| AllocationTimeframeStart | BigInt |
| Start date when the water right can legally access the assigned water. Format of MM/DD. | ||||
| AllocationChangeApplicationIndicator | NVarChar(100) |
| Indicate if this allocation was the result of a change application | ||||
| LegacyAllocationIDs | NVarChar(100) |
| If this allocation was the result of a change application, add the legacy allocation IDs as a comma separated list |
(none)
(none)
(none)
(none)