with Name

KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

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

	DIST		number(5)				Yes		District Number 1-6.
	COUNTY		number(5)				Yes		County Number 1-105.
	RTTY		number(5)				Yes		Route Class 1-3 (1=I,2=U,3=K).
	RTNO		number(5)				Yes		Route Number.
	CODE		number(5)				Yes		Route Suffix 0-8.
	IMPBEG		number(5)				Yes		Integer Beginning MILEpost.
	IMPEND		number(5)				Yes		Integer Ending MILEpost.
	LANE		number(5)				Yes		Lane Designation 0-4.
	MPBEG		number(6, 3)				Yes		Beginning MILEpost.
	SECLGT		number(6, 3)				Yes		Section Length.
	MPEND		number(6, 3)				Yes		Ending MILEpost.
	REFBEG		varchar2(16)				Yes		Beginning Reference Description.
	REFEND		varchar2(16)				Yes		Ending Reference Description.
	CANLIST		number(5)				Yes		Candidate List Number 2-4.
	MOSTPACT		number(5)				Yes		Most Probable Action.
	PLANYEAR		number(5)				Yes		Planned Action Program Year.
	PLANACT		number(5)				Yes		Planned Action.
	MAINYR		number(5)				Yes		ContMaint.Overlay Year.
	MAINACT		number(5)				Yes		ContMaint.Overlay Action Impact. 1- Preparation for project. 2- Do NOT expect to return in 1 year. 3- EXPECT to return in 1 year.
	MAINYR1		number(5)				Yes		Previous ContMaint.Overlay Year.
	MAINACT1		number(5)				Yes		Previous CM.OL Action Impact. (See above)
	LASTYR		number(5)				Yes		Last Major Action Year.
	LASTACT		number(5)				Yes		Last Major Action.
	LASTYR1		number(5)				Yes		Previous Major Action Year.
	LASTACT1		number(5)				Yes		Previous Major Action.
	LASTYR2		number(5)				Yes		Previous Major Action Year.
	LASTYR3		number(5)				Yes		Previous Major Action Year.
	LASTACT2		number(5)				Yes		Previous Major Action.
	LASTACT3		number(5)				Yes		Previous Major Action.

Columns Detail



	Name		Value

	Name		DIST
	Description		District Number 1-6.
	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
	Description		County Number 1-105.
	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		RTTY
	Description		Route Class 1-3 (1=I,2=U,3=K).
	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		RTNO
	Description		Route 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		CODE
	Description		Route Suffix 0-8.
	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		IMPBEG
	Description		Integer Beginning MILEpost.
	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		IMPEND
	Description		Integer Ending MILEpost.
	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		LANE
	Description		Lane Designation 0-4.
	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		MPBEG
	Description		Beginning MILEpost.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SECLGT
	Description		Section Length.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		MPEND
	Description		Ending MILEpost.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		6
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		REFBEG
	Description		Beginning Reference Description.
	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		REFEND
	Description		Ending Reference Description.
	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		CANLIST
	Description		Candidate List Number 2-4.
	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		MOSTPACT
	Description		Most Probable Action.
	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		PLANYEAR
	Description		Planned Action Program Year.
	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		PLANACT
	Description		Planned Action.
	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		MAINYR
	Description		ContMaint.Overlay Year.
	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		MAINACT
	Description		ContMaint.Overlay Action Impact. 1- Preparation for project. 2- Do NOT expect to return in 1 year. 3- EXPECT to return in 1 year.
	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		MAINYR1
	Description		Previous ContMaint.Overlay Year.
	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		MAINACT1
	Description		Previous CM.OL Action Impact. (See above)
	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		LASTYR
	Description		Last Major Action Year.
	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		LASTACT
	Description		Last Major Action.
	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		LASTYR1
	Description		Previous Major Action Year.
	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		LASTACT1
	Description		Previous Major Action.
	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		LASTYR2
	Description		Previous Major Action Year.
	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		LASTYR3
	Description		Previous Major Action Year.
	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		LASTACT2
	Description		Previous Major Action.
	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		LASTACT3
	Description		Previous Major Action.
	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

KDOT PMS Replacement Project