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