KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - PERFYR09 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
PMISID varchar2(13) Yes
LRS_KEY varchar2(19) Yes
COUNTY number(5) Yes
RTTY number(5) Yes
RTNO number(5) Yes
CODE number(5) Yes
IMPBEG number(5) Yes
IMPEND number(5) Yes
LANE number(5) Yes
LANE_OFFSET number(5) Yes
MPBEG number(6, 3) Yes
SECLGT number(5, 3) Yes
MPEND number(6, 3) Yes
RDCAT number(5) Yes
AADT number(10) Yes
EAL number(5) Yes
DSTATE number(5) Yes
CSTATE number(5) Yes
PL number(5) Yes
FDATE date Yes
RUTVAL number(5, 3) Yes
FCR1 number(5) Yes
FCR2 number(5) Yes
FCR3 number(5) Yes
FCR4 number(5) Yes
TCR1 number(5) Yes
TCR2 number(5) Yes
TCR3 number(5) Yes
BCR number(5) Yes
RDATE date Yes
FAULT number(5) Yes
JD1 number(5) Yes
JD2 number(5) Yes
JD3 number(5) Yes
FSCORE number(5) Yes
F1PCT number(5) Yes
F2PCT number(5) Yes
F3PCT number(5) Yes
IRIDATE date Yes
IRIL number(5) Yes
IRIR number(5) Yes
MAYSL number(5) Yes
MAYSR number(5) Yes
LONGBEG number(12, 7) Yes
LATBEG number(10, 7) Yes
LONGEND number(12, 7) Yes
LATEND number(10, 7) Yes
LASTDATE date Yes
LASTACT number(5) Yes
LASTASP varchar2(7) Yes
DISTRICT number(5) Yes
HPMS number(5) Yes
HVYCOM number(10) Yes
CRACK number(5) Yes
COMBO number(5) Yes
DSDATE date Yes
PTYPE number(5) Yes
RUT number(5) Yes
PICK varchar2(1) Yes
CANLIST number(5) Yes
MSLINK number(10) Yes
MAPID number(10) Yes
JD4 number(2) Yes
TIE char(1) Yes

Columns Detail
Name Value
Name PMISID
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 LRS_KEY
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 19
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

Name Value
Name DSTATE
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 CSTATE
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 PL
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 FDATE
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 RUTVAL
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 FCR1
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 FCR2
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 FCR3
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 FCR4
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 TCR1
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 TCR2
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 TCR3
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 BCR
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 RDATE
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 FAULT
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 JD1
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 JD2
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 JD3
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 FSCORE
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 F1PCT
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 F2PCT
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 F3PCT
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 IRIDATE
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 IRIL
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 IRIR
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 MAYSL
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 MAYSR
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 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 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 5
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name LASTASP
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 7
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

Name Value
Name CRACK
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 COMBO
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 DSDATE
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 PTYPE
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 RUT
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 PICK
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 1
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

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

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

KDOT PMS Replacement Project