AggregatedAmounts_fact - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: AggregatedAmounts_fact

Columns

PKNameData TypeNULLAutoDefaultCommentFK

AggregatedAmountIDBigInt

Primary internal key unique identifier for aggregated amount records.
MethodIDBigInt Primary internal key unique identifier for method records.

OrganizationIDBigInt Primary internal key unique identifier for organization records.

ReportingUnitIDBigInt Primary internal key unique identifier for reporting units records.

VariableSpecificIDBigInt Primary internal key unique identifier for variable records.

WaterSourceIDBigInt Primary internal key unique identifier for water source records.

AllocationCropDutyAmountFloat

Crop Duty amount. The number of acres of land that is irrigated for the complete growth of a crop by supplying 1-meter cubes per second of water continuously throughout the crop.
AmountFloat The aggregated amount of water in the area.
CommunityWaterSupplySystemNVarChar(250)

Name of the community water system the water right serves (if available).
CropTypeCVNVarChar(100)

The type of crop watered by the water right (if available) (e.g., wheat, alfalfa, corn, hay, etc.) (applies mostly to irrigation uses).

CustomerTypeCVNVarChar(100)

Description of the type of customer the water right services (e.g., Residential, Commercial, Industrial, Institutional, Combined, Unspecified, etc).

DataPublicationDateIDBigInt

Date that this data was published by the data provider to the public.

DataPublicationDOINVarChar(100)

A unique digital object identifier into the original dataset.
InterbasinTransferFromIDNVarChar(100)

Identifier name / ID of the basin if the water supply type for the reporting unit is designated as an interbasin transfer and from another basin.
InterbasinTransferToIDNVarChar(100)

Identifier name / ID of the basin if the water supply type for the reporting unit is designated as an interbasin transfer and used in another basin.
IrrigatedAcreageFloat

Number of acres irrigated by the water right (if available).
IrrigationMethodCVNVarChar(100)

A term to describe the method used for the place of use (if available) (applies mostly to irrigation beneficial uses).

PopulationServedFloat

The amount of population served by the water right (if available).
PowerGeneratedGWhFloat

The power (GWh) to be generated by the water right record (if available) (mostly applies to power generating beneficial uses).
PowerTypeNVarChar(50)

Description of the type of power generated.
PrimaryUseCategoryCVNVarChar(250)

The primary stated purpose by the water allocation (if available).

ReportYearCVBigInt

Year corresponding to the annual reporting period for the aggregated data in the reporting unit.

SDWISIdentifierCVNVarChar(250)

If the use is municipal, the data provider can add the SDWIS identifier for the CWS.

TimeframeEndIDBigInt

Primary internal key unique identifier for end date when the water right no longer can legally access the assigned water. Format of MM/DD.

TimeframeStartIDBigInt

Primary internal key unique identifier for start date when the water right can legally access the assigned water. Format of MM/DD.


Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_AggregatedAmounts_Date_dim_endCore.Date_dimCore.AggregatedAmounts_factDateIDTimeframeEndID
fk_AggregatedAmounts_Date_dim_end_pubCore.Date_dimCore.AggregatedAmounts_factDateIDDataPublicationDateID
fk_AggregatedAmounts_Date_dim_startCore.Date_dimCore.AggregatedAmounts_factDateIDTimeframeStartID
fk_AggregatedAmounts_fact_BeneficialUseCategoryCVs.BeneficialUseCore.AggregatedAmounts_factNamePrimaryUseCategoryCV
fk_AggregatedAmounts_fact_CropTypeCVs.CropTypeCore.AggregatedAmounts_factNameCropTypeCV
fk_AggregatedAmounts_fact_CustomerTypeCVCVs.CustomerTypeCVCore.AggregatedAmounts_factNameCustomerTypeCV
fk_AggregatedAmounts_fact_IrrigationMethodCVs.IrrigationMethodCore.AggregatedAmounts_factNameIrrigationMethodCV
fk_AggregatedAmounts_fact_Methods_dimCore.Methods_dimCore.AggregatedAmounts_factMethodIDMethodID
fk_AggregatedAmounts_fact_Organizations_dimCore.Organizations_dimCore.AggregatedAmounts_factOrganizationIDOrganizationID
fk_AggregatedAmounts_fact_ReportingUnits_dimCore.ReportingUnits_dimCore.AggregatedAmounts_factReportingUnitIDReportingUnitID
fk_AggregatedAmounts_fact_ReportYearCVCVs.ReportYearCVCore.AggregatedAmounts_factNameReportYearCV
fk_AggregatedAmounts_fact_SDWISIdentifierCVs.SDWISIdentifierCore.AggregatedAmounts_factNameSDWISIdentifierCV
fk_AggregatedAmounts_fact_Variables_dimCore.Variables_dimCore.AggregatedAmounts_factVariableSpecificIDVariableSpecificID
fk_AggregatedAmounts_fact_WaterSources_dimCore.WaterSources_dimCore.AggregatedAmounts_factWaterSourceIDWaterSourceID

Triggers

(none)


Used in Diagrams

Diagram Name
3_AggregatedAmounts