with Name

KDOT PMS Replacement Project

ERModel : Model . Modeling : Package

Entity - pmis link

Properties



	Name		Value

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

Columns Summary



	Column Name		Data Type		PK / FK		Nullable		Description

	ID		varchar2(20)				Yes
	Start_Od		float(10)				Yes
	Stop_Od		float(10)				Yes
	Odometer_Dist		float(10)				Yes
	Route_Unique_ID		varchar2(255)				Yes
	Session_Name		varchar2(255)				Yes
	Rutting_Average_Left_and_Right		float(10)				Yes
	ColDate		timestamp(0)				Yes
	Pav_Type		varchar2(255)				Yes
	Joint_Average_Faulting		float(10)				Yes
	Total_Cracking_Length		float(10)				Yes
	Affected_Wheelpath_Area		float(10)				Yes
	Total_Wheelpath_Area		float(10)				Yes
	Affected_Slab_Count		varchar2(10)				Yes
	Total_Slab_Count		varchar2(10)				Yes
	Lane_Area		float(10)				Yes
	Cracking_Percent		float(10)				Yes
	Average_IRI		float(10)				Yes
	VALID		float(10)				Yes
	FEATURE		varchar2(255)				Yes
	HPMS_Average_IRI		float(10)				Yes
	HPMS_VALID		float(10)				Yes
	FEA2		varchar2(255)				Yes
	COU		varchar2(10)				Yes
	RTTY		varchar2(10)				Yes
	RTNO		varchar2(10)				Yes
	CODE		varchar2(10)				Yes
	DIRBnd		varchar2(255)				Yes
	ColTime		timestamp(0)				Yes

Columns Detail



	Name		Value

	Name		ID
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		20
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Start_Od
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Stop_Od
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Odometer_Dist
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Route_Unique_ID
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		255
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Session_Name
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		255
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Rutting_Average_Left_and_Right
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		ColDate
	Type		timestamp
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		datetime
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Pav_Type
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		255
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Joint_Average_Faulting
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Total_Cracking_Length
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Affected_Wheelpath_Area
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Total_Wheelpath_Area
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Affected_Slab_Count
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Total_Slab_Count
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Lane_Area
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Cracking_Percent
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		Average_IRI
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		VALID
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		FEATURE
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		255
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		HPMS_Average_IRI
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		HPMS_VALID
	Type		float
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		float
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		FEA2
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		255
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		COU
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RTTY
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RTNO
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CODE
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		DIRBnd
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		255
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		ColTime
	Type		timestamp
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		datetime
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes

Appears In



	Diagram

	KDOT_RPMS_Modeling(Reduced) : Entity Relationship Diagram

KDOT PMS Replacement Project