with Name

KDOT PMS Replacement Project

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

MSLINK	number(10)		Yes	MGE Identifier of Element in Design File.
MAPID	number(10)		Yes	MGE Design File Identifier.
RIDER_KEY	varchar2(11)		Yes	LRS Key of Rider Route.
RIDER_PREFIX	varchar2(1)		Yes	Rider LRS Key Route Prefix.
RIDER_ROUTE_ID	varchar2(8)		Yes	Rider LRS Key Route Number.
RIDER_SEG_ID	varchar2(14)		Yes	Rider Route Segment Identifier.
RIDER_SUFFIX	varchar2(1)		Yes	Rider LRS Key Route Suffix.
RIDER_SUBCLASS	varchar2(1)		Yes	Rider LRS Key Route Subclass.
BEG_RIDER_CO_LOGMI	number(19)		Yes	Beginning County Logpoint of Rider Route in Miles.
END_RIDER_CO_LOGMI	number(19)		Yes	Ending County Logpoint of Rider Route in Miles.
BEG_RIDER_CO_LOGKL	number(19)		Yes	Beginning County Logpoint of Rider Route in Kilometers.
END_RIDER_CO_LOGKL	number(19)		Yes	Ending County Logpoint of Rider Route in Kilometers.
BEG_RIDER_ST_LOGMI	number(19)		Yes	Beginning State Logpoint of Rider Route in Miles.
END_RIDER_ST_LOGMI	number(19)		Yes	Ending State Logpoint of Rider Route in Miles.
BEG_RIDER_ST_LOGKL	number(19)		Yes	Beginning State Logpoint of Rider Route in Kilometers.
END_RIDER_ST_LOGKL	number(19)		Yes	Ending State Logpoint of Rider Route in Kilometers.
CARRY_KEY	varchar2(11)		Yes	Carrier Route LRS Key.
CARRY_PREFIX	varchar2(1)		Yes	Carrier LRS Key Route Prefix.
CARRY_ROUTE_ID	varchar2(8)		Yes	Carrier LRS Key Route Number.
CARRY_SEG_ID	varchar2(14)		Yes	Carrier Route Segment Identifier.
CARRY_SUFFIX	varchar2(1)		Yes	Carrier LRS Key Route Suffix.
CARRY_SUBCLASS	varchar2(1)		Yes	Carrier LRS Key Route Subclass.
BEG_CARRY_CO_LOGMI	number(19)		Yes	Beginning County Logpoint of Carrier Route in Miles.
END_CARRY_CO_LOGMI	number(19)		Yes	Ending County Logpoint of Carrier Route in Miles.
BEG_CARRY_CO_LOGKL	number(19)		Yes	Beginning County Logpoint of Carrier Route in Kilometers.
END_CARRY_CO_LOGKL	number(19)		Yes	Ending County Logpoint of Carrier Route in Kilometers.
BEG_CARRY_ST_LOGMI	number(19)		Yes	Beginning State Logpoint of Carrier Route in Miles.
END_CARRY_ST_LOGMI	number(19)		Yes	Ending State Logpoint of Carrier Route in Miles.
BEG_CARRY_ST_LOGKL	number(19)		Yes	Beginning State Logpoint of Carrier Route in Kilometers.
END_CARRY_ST_LOGKL	number(19)		Yes	Ending State Logpoint of Carrier Route in Kilometers.
COUNTY_NO	number(5)		Yes	County Number.
COUNTY_CODE	varchar2(3)		Yes	County Code.
DIRECTION	varchar2(1)		Yes	Travelway Direction.
STATUS_1	number(10)		Yes	Dummy Variable.
STATUS_2	number(10)		Yes	Dummy Variable.
STATUS_3	number(10)		Yes	Dummy Variable.

Columns Detail



	Name		Value

	Name		MSLINK
	Description		MGE Identifier of Element in Design File.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		MAPID
	Description		MGE Design File Identifier.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RIDER_KEY
	Description		LRS Key of Rider Route.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		11
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RIDER_PREFIX
	Description		Rider LRS Key Route Prefix.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RIDER_ROUTE_ID
	Description		Rider LRS Key Route Number.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		8
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RIDER_SEG_ID
	Description		Rider Route Segment Identifier.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		14
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RIDER_SUFFIX
	Description		Rider LRS Key Route Suffix.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RIDER_SUBCLASS
	Description		Rider LRS Key Route Subclass.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		BEG_RIDER_CO_LOGMI
	Description		Beginning County Logpoint of Rider Route in Miles.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		END_RIDER_CO_LOGMI
	Description		Ending County Logpoint of Rider Route in Miles.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		BEG_RIDER_CO_LOGKL
	Description		Beginning County Logpoint of Rider Route in Kilometers.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		END_RIDER_CO_LOGKL
	Description		Ending County Logpoint of Rider Route in Kilometers.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		BEG_RIDER_ST_LOGMI
	Description		Beginning State Logpoint of Rider Route in Miles.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		END_RIDER_ST_LOGMI
	Description		Ending State Logpoint of Rider Route in Miles.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		BEG_RIDER_ST_LOGKL
	Description		Beginning State Logpoint of Rider Route in Kilometers.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		END_RIDER_ST_LOGKL
	Description		Ending State Logpoint of Rider Route in Kilometers.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CARRY_KEY
	Description		Carrier Route LRS Key.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		11
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CARRY_PREFIX
	Description		Carrier LRS Key Route Prefix.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CARRY_ROUTE_ID
	Description		Carrier LRS Key Route Number.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		8
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CARRY_SEG_ID
	Description		Carrier Route Segment Identifier.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		14
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CARRY_SUFFIX
	Description		Carrier LRS Key Route Suffix.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CARRY_SUBCLASS
	Description		Carrier LRS Key Route Subclass.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		BEG_CARRY_CO_LOGMI
	Description		Beginning County Logpoint of Carrier Route in Miles.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		END_CARRY_CO_LOGMI
	Description		Ending County Logpoint of Carrier Route in Miles.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		BEG_CARRY_CO_LOGKL
	Description		Beginning County Logpoint of Carrier Route in Kilometers.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		END_CARRY_CO_LOGKL
	Description		Ending County Logpoint of Carrier Route in Kilometers.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		BEG_CARRY_ST_LOGMI
	Description		Beginning State Logpoint of Carrier Route in Miles.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		END_CARRY_ST_LOGMI
	Description		Ending State Logpoint of Carrier Route in Miles.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		BEG_CARRY_ST_LOGKL
	Description		Beginning State Logpoint of Carrier Route in Kilometers.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		END_CARRY_ST_LOGKL
	Description		Ending State Logpoint of Carrier Route in Kilometers.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

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



	Name		Value

	Name		COUNTY_CODE
	Description		County Code.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		3
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		DIRECTION
	Description		Travelway Direction.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		STATUS_1
	Description		Dummy Variable.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		STATUS_2
	Description		Dummy Variable.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		STATUS_3
	Description		Dummy Variable.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes

KDOT PMS Replacement Project