Allocations_dim_Input - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: Allocations_dim_Input

Water Allocations, also known as water rights or permits

Columns

PKNameData TypeNULLAutoDefaultCommentFK

AllocationNativeIDNVarChar(250) Unique identifier for the allocation as-is in the member states, can be alphanumeric
AllocationOwnerNVarChar(255) Name of the owner, entity with the allocation. If multiple owners, truncate after five.
AllocationBasisCVNVarChar(250)

Specify whether this water right is based on water withdrawals/diversion or consumptive use/depletion amount
AllocationLegalStatusCVNVarChar(50) The legal status of the water right (e.g., proven, approved, perfected, adjudicated, etc.)
AllocationApplicationDateBigInt

Date of the original filing on the allocation
AllocationPriorityDateBigInt Priority Date given to the allocation
AllocationExpirationDateBigInt

If the allocation is temporary, add the expiration date
AllocationChangeApplicationIndicatorNVarChar(100)

Indicate if this allocation was the result of a change application
LegacyAllocationIDsNVarChar(100)

If this allocation was the result of a change application, add the legacy allocation IDs as a comma separated list

Indexes

(none)


Foreign Keys

(none)


Triggers

(none)


Used in Diagrams

(none)