with Name

KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - NOAANORM link

Properties



	Name		Value

	Data Model		Physical
	Schema		PMIS
	Primary Key Clustered		Unspecified
	Unlogged		false
	Temporal		false

Columns Summary



	Column Name		Data Type		PK / FK		Nullable		Description

	STANO		number(4)				Yes		NOAA Station Number.
	RAINYEAR		number(4)				Yes		Rainfall Year.
	COUNTY		number(3)				Yes		County Number 1-105.
	DIV		number(1)				Yes		NOAA Division 1-9.
	RAIN01		number(6, 2)				Yes		Normal Rainfall in JAN.
	RAIN02		number(6, 2)				Yes		Normal Rainfall in FEB.
	RAIN03		number(6, 2)				Yes		Normal Rainfall in MAR.
	RAIN04		number(6, 2)				Yes		Normal Rainfall in APR.
	RAIN05		number(6, 2)				Yes		Normal Rainfall in MAY.
	RAIN06		number(6, 2)				Yes		Normal Rainfall in JUN.
	RAIN07		number(6, 2)				Yes		Normal Rainfall in JUL.
	RAIN08		number(6, 2)				Yes		Normal Rainfall in AUG.
	RAIN09		number(6, 2)				Yes		Normal Rainfall in SEP.
	RAIN10		number(6, 2)				Yes		Normal Rainfall in OCT.
	RAIN11		number(6, 2)				Yes		Normal Rainfall in NOV.
	RAIN12		number(6, 2)				Yes		Normal Rainfall in DEC.
	ANNUAL		number(6, 2)				Yes		Normal Annual Total Rainfall.

Columns Detail



	Name		Value

	Name		STANO
	Description		NOAA Station Number.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		4
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RAINYEAR
	Description		Rainfall Year.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		4
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		COUNTY
	Description		County Number 1-105.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		3
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		DIV
	Description		NOAA Division 1-9.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RAIN01
	Description		Normal Rainfall in JAN.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		2
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RAIN02
	Description		Normal Rainfall in FEB.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		2
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RAIN03
	Description		Normal Rainfall in MAR.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		2
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RAIN04
	Description		Normal Rainfall in APR.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		2
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RAIN05
	Description		Normal Rainfall in MAY.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		2
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RAIN06
	Description		Normal Rainfall in JUN.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		2
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RAIN07
	Description		Normal Rainfall in JUL.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		2
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RAIN08
	Description		Normal Rainfall in AUG.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		2
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RAIN09
	Description		Normal Rainfall in SEP.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		2
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RAIN10
	Description		Normal Rainfall in OCT.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		2
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RAIN11
	Description		Normal Rainfall in NOV.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		2
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RAIN12
	Description		Normal Rainfall in DEC.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		2
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		ANNUAL
	Description		Normal Annual Total Rainfall.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		2
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes

KDOT PMS Replacement Project