WaDE2.0 [WaDE2.01.xml]
Water Allocations, also known as water rights or permits
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| 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.) | |||||
| 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 | ||||
| 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)