with Name

KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

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

	FNAME		varchar2(25)				Yes		Submitter
	LNAME		varchar2(25)				Yes		Submitter
	EMAIL		varchar2(25)				Yes		Submitter
	TELE		varchar2(25)				Yes		Submitter
	COUNTY		number(5)				Yes		PMIS county.
	RTTY		number(5)				Yes		PMIS route type(1,2 or 3).
	RTNO		number(5)				Yes		PMIS route number.
	CODE		number(5)				Yes		PMIS route code.
	LANE		number(5)				Yes		PMIS lane.
	PMPBEG		number(6, 3)				Yes		Project beginning milepost.
	PMPEND		number(6, 3)				Yes		Project ending milepost.
	QUANTITY		number(19)				Yes		Quantity of material.
	PREVSURF		varchar2(10)				Yes		Previous surface.
	ACTDESC		varchar2(2000)				Yes		Action description.
	OPENDATE		date				Yes		Date opened to traffic.
	TOP		varchar2(55)				Yes		Surface.
	PNUMBER		varchar2(10)				Yes		Project number.
	RECORDDATE		date				Yes		Date form submitted.
	RECORDNUMBER		number(19)				Yes		Record number.
	ACTNUM		number(19)				Yes		Action number: 1) Hand Patching 2) Crack Filling 3) 1/2 in. Overlay 4) 3/4 in. Overlay 5) Joint Repair 6) Slurry Seal 7) Spot Seals 8) Dilute Seal 100) Other
	DATECODE		date				Yes		Date code: 0101yr Preparation for future contract action. 0102yr Expected to last MORE than one year. 0103yr Expected to last LESS than one year. 0104yr Crack sealing.

Columns Detail



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

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



	Name		Value

	Name		COUNTY
	Description		PMIS county.
	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		PMIS route type(1,2 or 3).
	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		PMIS 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		PMIS route 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		LANE
	Description		PMIS lane.
	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		PMPBEG
	Description		Project 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		PMPEND
	Description		Project 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		QUANTITY
	Description		Quantity of material.
	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		PREVSURF
	Description		Previous surface.
	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		ACTDESC
	Description		Action description.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		2000
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		OPENDATE
	Description		Date opened to traffic.
	Type		date
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		DATE
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		TOP
	Description		Surface.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		55
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PNUMBER
	Description		Project number.
	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		RECORDDATE
	Description		Date form submitted.
	Type		date
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		DATE
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RECORDNUMBER
	Description		Record number.
	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		ACTNUM
	Description		Action number: 1) Hand Patching 2) Crack Filling 3) 1/2 in. Overlay 4) 3/4 in. Overlay 5) Joint Repair 6) Slurry Seal 7) Spot Seals 8) Dilute Seal 100) Other
	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		DATECODE
	Description		Date code: 0101yr Preparation for future contract action. 0102yr Expected to last MORE than one year. 0103yr Expected to last LESS than one year. 0104yr Crack sealing.
	Type		date
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		DATE
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes

Appears In



	Diagram

	KDOT_RPMS_PMISschema : Entity Relationship Diagram

KDOT PMS Replacement Project