KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - REHAB 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
ACTION number(3) Yes

Action Number 0-900.

ACODE char(3) Yes

Historical (no longer used).

RECYCLE number(1) Yes

Recycled Materials Used (1=yes).

SDESC char(16) Yes

Rehab. Description (short).

SDESCKM char(16) Yes

Rehab. Description SI (short).

LDESC char(40) Yes

Rehab. Description (long).

LDESCKM char(40) Yes

Rehab. Description SI (long).

PCCP number(3) Yes

MPS action number 1-12

COMP number(3) Yes

MPS action number 1-18

FDBIT number(3) Yes

MPS action number 1-28

PDBIT number(3) Yes

MPS action number 1-26

EQUTHICK number(6, 3) Yes

Equivalent Thickness

ACTTYPE varchar2(2) Yes

[H]eavy,[L]ight or [N]onstructural

CRF number(1) Yes

Flag for Completed Rehab Form:

1 = ON FORM

0 = NOT ON FORM

Columns Detail
Name Value
Name ACTION
Description

Action Number 0-900.

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 ACODE
Description

Historical (no longer used).

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

Name Value
Name RECYCLE
Description

Recycled Materials Used (1=yes).

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 SDESC
Description

Rehab. Description (short).

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

Name Value
Name SDESCKM
Description

Rehab. Description SI (short).

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

Name Value
Name LDESC
Description

Rehab. Description (long).

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

Name Value
Name LDESCKM
Description

Rehab. Description SI (long).

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

Name Value
Name PCCP
Description

MPS action number 1-12

Default Value -1
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 COMP
Description

MPS action number 1-18

Default Value -1
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 FDBIT
Description

MPS action number 1-28

Default Value -1
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 PDBIT
Description

MPS action number 1-26

Default Value -1
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 EQUTHICK
Description

Equivalent Thickness

Default Value -1
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 ACTTYPE
Description

[H]eavy,[L]ight or [N]onstructural

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

Name Value
Name CRF
Description

Flag for Completed Rehab Form:

1 = ON FORM

0 = NOT ON FORM

Default Value 0
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

Appears In
Diagram
 KDOT_RPMS_PMISschema : Entity Relationship Diagram
KDOT PMS Replacement Project