KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - GEOM_BKUP20200319 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
COUNTY number(3) Yes
RTTY number(1) Yes
RTNO number(3) Yes
CODE number(1) Yes
IMPBEG number(2) Yes
IMPEND number(2) Yes
LANE number(1) Yes
ID char(13) Yes
MPBEG number(6, 3) Yes
SECLGT number(5, 3) Yes
MPEND number(6, 3) Yes
RPBEG char(11) Yes
RPEND char(11) Yes
CHAIN number(3) Yes
CSEC number(3) Yes
CSCHAIN number(3) Yes
DIFF number(2) Yes
RDCAT number(2) Yes
SEAL number(2) Yes
SEALYR number(4) Yes
PERCENT number(3) Yes
TYPEP number(2) Yes
WDTP number(2) Yes
TYPE1 number(2) Yes
THICK1 number(2) Yes
YR1 number(4) Yes
TYPE2 number(2) Yes
THICK2 number(2) Yes
TYPE3 number(2) Yes
THICK3 number(2) Yes
TYPE4 number(2) Yes
THICK4 number(2) Yes
MGRAD number(4) Yes
SHTYPEL number(2) Yes
SHTYPER number(2) Yes
SHWDTL number(2) Yes
SHWDTR number(2) Yes
AADT number(6) Yes
EAL number(4) Yes
NATSYS number(2) Yes
FUNCLASS number(2) Yes
STCLASS number(2) Yes
STPSEG number(4) Yes
FRWY number(2) Yes
AXESS number(2) Yes
MAINT char(6) Yes
PROGRAM number(2) Yes
SCHYEAR number(4) Yes
SCHDATE date Yes
SCHACT number(3) Yes
SCHASP char(7) Yes
PVSR number(5, 3) Yes
PSI number(5, 3) Yes
PSIPAVE number(5, 3) Yes
NOSACT1 number(3) Yes
NOSACT2 number(3) Yes
NOSACT3 number(3) Yes
NOSACT4 number(3) Yes
PROBYR2 number(5, 3) Yes
PROBYR3 number(5, 3) Yes
PROBYR4 number(5, 3) Yes
MAXPROB2 number(5, 3) Yes
MAXPROB3 number(5, 3) Yes
MAXPROB4 number(5, 3) Yes
POSXREF number(2) Yes
LONGBEG number(12, 7) Yes
LATBEG number(10, 7) Yes
LONGEND number(12, 7) Yes
LATEND number(10, 7) Yes
SCHPNUM varchar2(10) Yes
GTYPEBEG varchar2(10) Yes
GTYPEEND varchar2(10) Yes
TRAFDATE date Yes
HVYCOMM number(6) Yes
LASTDATE date Yes
LASTACT number(3) Yes
LASTASP char(7) Yes
LASTPNUM char(10) Yes
LID char(19) Yes
LASTMIX varchar2(10) Yes
MIXYEAR number(4) Yes
D_ADL number(6) Yes

Columns Detail
Name Value
Name 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 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 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 IMPBEG
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 2
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

Name Value
Name LANE
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 ID
Type char
Nullable true
Unique false
Primary Key false
Index false
Type Name CHAR
Length 13
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name MPBEG
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
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 5
Scale 3
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name MPEND
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 RPBEG
Type char
Nullable true
Unique false
Primary Key false
Index false
Type Name CHAR
Length 11
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name RPEND
Type char
Nullable true
Unique false
Primary Key false
Index false
Type Name CHAR
Length 11
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name CHAIN
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 CSEC
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 CSCHAIN
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 DIFF
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 2
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

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

Name Value
Name SEALYR
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 PERCENT
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 TYPEP
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 2
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

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

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

Name Value
Name YR1
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 TYPE2
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 2
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

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

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

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

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

Name Value
Name MGRAD
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 SHTYPEL
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 2
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

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

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

Name Value
Name AADT
Type number
Nullable true
Unique false
Primary Key false
Index false
Length 6
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name EAL
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 NATSYS
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 2
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

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

Name Value
Name STPSEG
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 FRWY
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 2
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

Name Value
Name MAINT
Type char
Nullable true
Unique false
Primary Key false
Index false
Type Name CHAR
Length 6
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

Name Value
Name SCHYEAR
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 SCHDATE
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 SCHACT
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 SCHASP
Type char
Nullable true
Unique false
Primary Key false
Index false
Type Name CHAR
Length 7
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

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

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

Name Value
Name NOSACT1
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 NOSACT2
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 NOSACT3
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 NOSACT4
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 PROBYR2
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 5
Scale 3
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

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

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

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

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

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

Name Value
Name LONGBEG
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 LATBEG
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 10
Scale 7
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name LONGEND
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 LATEND
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 10
Scale 7
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SCHPNUM
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 GTYPEBEG
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 GTYPEEND
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 TRAFDATE
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 HVYCOMM
Type number
Nullable true
Unique false
Primary Key false
Index false
Length 6
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name LASTDATE
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 LASTACT
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 LASTASP
Type char
Nullable true
Unique false
Primary Key false
Index false
Type Name CHAR
Length 7
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name LASTPNUM
Type char
Nullable true
Unique false
Primary Key false
Index false
Type Name CHAR
Length 10
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name LID
Type char
Nullable true
Unique false
Primary Key false
Index false
Type Name CHAR
Length 19
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name LASTMIX
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 MIXYEAR
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 D_ADL
Type number
Nullable true
Unique false
Primary Key false
Index false
Length 6
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

KDOT PMS Replacement Project