ReportYearCV - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: ReportYearCV

A term to indicate the annual reporting period that this data are valid. There is a need to ensure the annual reporting period year matches the type of year used by the data provider. For example, if the data are valid for November 2018, the annual reporting period could be 2018 or 2019 depending on whether the data provider uses a calendar or water year.

Columns

PKNameData TypeNULLAutoDefaultCommentFK

NameBigInt Internal unique identifier string used for term name. Name / listing of the term as noted from the data provider from the source data.
TermNVarChar(250) Unique string of the term. Name / listing of the term as noted from the data provider from the source data.
DefinitionNVarChar(4000)

Definition of the term as noted from the data provider from the source data.
StateNVarChar(250)

Two digit state abbreviation where the term was provided from. If multiple, use comma separated list.
SourceVocabularyURI NVarChar(250)

Web link to source glossary / index of where the data provider provides the term and it's definition.
WaDENameNVarChar(150)

WaDE specific term used to group and categorize similar beneficial uses and facilitate data visualizations and queries across state boundaries.

Indexes

(none)


Foreign Keys

(none)


Triggers

(none)


Used in Diagrams

Diagram Name
5_ContreolledVocabulary