with Name

KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

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

	SITE		varchar2(15)				Yes		Site of test: rt-refpost e.g. k4-305
	CNTY_MP		number(6, 3)				Yes
	MP_TYPE		varchar2(4)				Yes		Real or Fake.(Spanned county.)
	LANE_NUM		number(1)				Yes
	SDATE		date				Yes		Date of test.
	STIME		varchar2(5)				Yes		Time of test.
	SITE_COUNTY		number(3)				Yes
	RTTY		number(1)				Yes
	SITE_RTNO		number(3)				Yes
	SITE_CODE		number(1)				Yes
	LANE		varchar2(10)				Yes		Lane of test: e.g. wl or eb etc.
	DISTANCE		number(7, 3)				Yes		Ref post of test. (akin to milepost)
	SURFACE_YEAR		number(4)				Yes
	SURFACE_TYPE		varchar2(10)				Yes
	FN		number(4, 1)				Yes		Friction number.
	SPEED		number(4, 1)				Yes		Speed at which test taken.
	ATEMP		number(3)				Yes		Ambient temperature at test site.
	PCT_SLIP		number(5, 1)				Yes
	PEAK_FN		number(5, 1)				Yes
	LAT		number(11, 7)				Yes		Latitude at test site.
	LON		number(12, 7)				Yes		Longitude at test site.
	HDOP		number(4, 1)				Yes		Horizontal dilution of precision.
	SURFACE		varchar2(13)				Yes		Year and surface type.
	OPR		varchar2(10)				Yes		Operator number.
	DRVR		varchar2(10)				Yes		Driver number.
	COMMENTS		varchar2(15)				Yes		Operator entered comments.
	SURCOND		varchar2(15)				Yes		Surface condition entered by operator.

Columns Detail



	Name		Value

	Name		SITE
	Description		Site of test: rt-refpost e.g. k4-305
	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		CNTY_MP
	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		MP_TYPE
	Description		Real or Fake.(Spanned county.)
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		4
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LANE_NUM
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SDATE
	Description		Date of test.
	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		STIME
	Description		Time of test.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		5
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SITE_COUNTY
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		3
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		RTTY
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SITE_RTNO
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		3
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SITE_CODE
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		1
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LANE
	Description		Lane of test: e.g. wl or eb etc.
	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		DISTANCE
	Description		Ref post of test. (akin to milepost)
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		7
	Scale		3
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SURFACE_YEAR
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		4
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SURFACE_TYPE
	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		FN
	Description		Friction number.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		4
	Scale		1
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SPEED
	Description		Speed at which test taken.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		4
	Scale		1
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		ATEMP
	Description		Ambient temperature at test site.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		3
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PCT_SLIP
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		5
	Scale		1
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		PEAK_FN
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		5
	Scale		1
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LAT
	Description		Latitude at test site.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		11
	Scale		7
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		LON
	Description		Longitude at test site.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		12
	Scale		7
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		HDOP
	Description		Horizontal dilution of precision.
	Type		number
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		NUMBER
	Length		4
	Scale		1
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		SURFACE
	Description		Year and surface type.
	Type		varchar2
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		VARCHAR2
	Length		13
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		OPR
	Description		Operator 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		DRVR
	Description		Driver 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		COMMENTS
	Description		Operator entered comments.
	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		SURCOND
	Description		Surface condition entered by operator.
	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

Appears In



	Diagram

	KDOT_RPMS_PMISschema : Entity Relationship Diagram

KDOT PMS Replacement Project