with Name

KDOT PMS Replacement Project

ERModel : Model . Modeling : Package

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

	LRS_TENTH_LANE		varchar2(17)				Yes
	PMSID		varchar2(13)				Yes
	LW_DIST18		number(8, 3)				Yes
	LW_DIST19		number(8, 3)				Yes
	LW_DIST20		number(8, 3)				Yes
	LW_DIST21		number(8, 3)				Yes
	LW_DIST22PT		number(8, 3)				Yes
	CRK18		number(7, 1)				Yes
	CRK19		number(7, 1)				Yes
	CRK20		number(7, 1)				Yes
	CRK21		number(7, 1)				Yes
	CRK22PT		number(7, 1)				Yes

Columns Detail



	Name		Value

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



	Name		Value

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



	Name		Value

	Name		LW_DIST18
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		8
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LW_DIST19
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		8
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LW_DIST20
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		8
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LW_DIST21
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		8
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LW_DIST22PT
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		8
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CRK18
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		7
	Scale		1
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CRK19
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		7
	Scale		1
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CRK20
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		7
	Scale		1
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CRK21
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		7
	Scale		1
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		CRK22PT
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		decimal
	Length		7
	Scale		1
	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