with Name

KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - RUTTING_TENTHS 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

	REV_SESSION_NAME		char(30)				Yes		Session Name During Collection with slight revisions.
	COUNTY		number(3)				Yes		County Number 1-105.
	RTTY		number(1)				Yes		Route Class 1-3 (1=I,2=U,3=K).
	RTNO		number(3)				Yes		Route Number.
	CODE		number(1)				Yes		Route Suffix 0-8.
	IMPBEG		number(2)				Yes		Integer Beginning MILEpost.
	IMPEND		number(2)				Yes		Integer Ending MILEpost.
	LANE		number(1)				Yes		Lane Designation 0-4.
	ID		char(13)				Yes		PMS ID (based on first seven fields).
	MPBEG		number(6, 3)				Yes		Beginning MILEpost.
	MPEND		number(6, 3)				Yes		Ending MILEpost.
	SECLGT		number(5, 3)				Yes		Length of segment in miles.
	RUTDATE		date				Yes		Profile Survey DATE.
	AVGRUT		number(7, 5)				Yes		Avg Left and Right Wheelpath Rut Depth in per length - Divide by SECLGT to get inches.
	MAXRUT		number(8, 5)				Yes		Max Rut Depths maybe in inches.
	RUTTIME		number(4)				Yes		Time rutting data collected.

Columns Detail



	Name		Value

	Name		REV_SESSION_NAME
	Description		Session Name During Collection with slight revisions.
	Type		char
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		CHAR
	Length		30
	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		RTTY
	Description		Route Class 1-3 (1=I,2=U,3=K).
	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		RTNO
	Description		Route Number.
	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		CODE
	Description		Route Suffix 0-8.
	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		IMPBEG
	Description		Integer Beginning MILEpost.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		2
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		IMPEND
	Description		Integer Ending MILEpost.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		2
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LANE
	Description		Lane Designation 0-4.
	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		ID
	Description		PMS ID (based on first seven fields).
	Type		char
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		CHAR
	Length		13
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		MPBEG
	Description		Beginning MILEpost.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		MPEND
	Description		Ending MILEpost.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SECLGT
	Description		Length of segment in miles.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		5
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RUTDATE
	Description		Profile Survey DATE.
	Type		date
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		DATE
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		AVGRUT
	Description		Avg Left and Right Wheelpath Rut Depth in per length - Divide by SECLGT to get inches.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		7
	Scale		5
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		MAXRUT
	Description		Max Rut Depths maybe in inches.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		8
	Scale		5
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RUTTIME
	Description		Time rutting data collected.
	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

Appears In



	Diagram

	KDOT_RPMS_PMISschema : Entity Relationship Diagram

KDOT PMS Replacement Project