with Name

KDOT PMS Replacement Project

ERModel : Model . Modeling : Package

Entity - TAMP2022GFPFLT 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		varchar2(16)				Yes
	LRS_KEY		varchar2(13)				Yes
	PAVEMENTTYPE		varchar2(20)				Yes
	LW_DIST		number(8, 3)				Yes
	FLT18GFP		varchar2(1)				Yes
	FLT19GFP		varchar2(1)				Yes
	FLT20GFP		varchar2(1)				Yes
	FLT21GFP		varchar2(1)				Yes
	FLT22GFP		varchar2(1)				Yes
	FLT23GFP		varchar2(1)				Yes
	FLT24GFP		varchar2(1)				Yes
	FLT25GFP		varchar2(1)				Yes
	FLT26GFP		varchar2(1)				Yes
	FLT27GFP		varchar2(1)				Yes
	FLT28GFP		varchar2(1)				Yes
	FLT29GFP		varchar2(1)				Yes
	FLT30GFP		varchar2(1)				Yes
	FLT31GFP		varchar2(1)				Yes
	FLT32GFP		varchar2(1)				Yes

Columns Detail



	Name		Value

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



	Name		Value

	Name		PAVEMENTTYPE
	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		LW_DIST
	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		FLT18GFP
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

	Name		FLT32GFP
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		1
	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