with Name

KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - LRS_CP_0202 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
	MAPID		number(10)				Yes
	LRS_KEY		varchar2(19)				Yes
	DIRECTION		varchar2(1)				Yes
	LANE_ID		varchar2(2)				Yes
	COUNTY_NO		number(5)				Yes
	CITY_NO		number(5)				Yes
	LRS_PREFIX		varchar2(1)				Yes
	ROUTE_ID		varchar2(10)				Yes
	SEGMENT_ID		varchar2(16)				Yes
	LRS_SUFFIX		varchar2(1)				Yes
	UNIQUE_ID		varchar2(1)				Yes
	ADMIN_OWNER		varchar2(1)				Yes
	LRS_SUBCLASS		varchar2(1)				Yes
	COUNTY_LOGMILE		number(19)				Yes
	STATE_LOGMILE		number(19)				Yes
	COUNTY_LOGKILO		number(19)				Yes
	STATE_LOGKILO		number(19)				Yes
	REFPOST		varchar2(3)				Yes
	REFPOST_OFFSET		number(10)				Yes
	LATITUDE		varchar2(10)				Yes
	LONGITUDE		varchar2(11)				Yes
	CONTROL_POINT_CODE		number(5)				Yes
	INVENTORY_CODE		number(5)				Yes
	INTERSECTION_TYPE		varchar2(2)				Yes
	INTERSECTION_ID		varchar2(15)				Yes
	CONTROL_POINT_DESC		varchar2(50)				Yes
	COUNTY_CODE		varchar2(3)				Yes
	CNTY_ABBREVIATION		varchar2(2)				Yes
	DISTRICT_NO		number(5)				Yes
	INTCHG_CODE		varchar2(1)				Yes
	INTCHG_NO		varchar2(3)				Yes
	INTCHG_ONOFF		varchar2(1)				Yes
	STATUS_1		number(10)				Yes
	STATUS_2		number(10)				Yes
	STATUS_3		number(10)				Yes

Columns Detail



	Name		Value

	Name		MSLINK
	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
	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		LRS_KEY
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		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		LANE_ID
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		2
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		COUNTY_NO
	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		CITY_NO
	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		LRS_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		ROUTE_ID
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SEGMENT_ID
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		16
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LRS_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		UNIQUE_ID
	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		ADMIN_OWNER
	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		LRS_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		COUNTY_LOGMILE
	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		STATE_LOGMILE
	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_LOGKILO
	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		STATE_LOGKILO
	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		REFPOST
	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		REFPOST_OFFSET
	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		LATITUDE
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		10
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LONGITUDE
	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		CONTROL_POINT_CODE
	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		INVENTORY_CODE
	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		INTERSECTION_TYPE
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		2
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		INTERSECTION_ID
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		15
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CONTROL_POINT_DESC
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		50
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		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		CNTY_ABBREVIATION
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		2
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		DISTRICT_NO
	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		INTCHG_CODE
	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		INTCHG_NO
	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		INTCHG_ONOFF
	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
	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
	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
	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