KDOT PMS Replacement Project

R-PMS Subsystem - AECOM : Package . AECOM-EPMS System : Package

Entity - PAVEMENT link

Properties
Name Value
Data Model Physical
Stereotypes AECOMSystem
Schema AECOMSchema
Primary Key Clustered Unspecified
Unlogged false
Temporal false

Columns Summary
Column Name Data Type PK / FK Nullable Description
PVMTGRP number(0) Yes

Code defined in EPMS that uniquely identifies the pavement type.

PVMTNO number(0) Yes

Number that uniquely identifies each pavement type as classified in the PMIS database.

Columns Detail
Name Value
Name PVMTGRP
Description

Code defined in EPMS that uniquely identifies the pavement type.

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name PVMTNO
Description

Number that uniquely identifies each pavement type as classified in the PMIS database.

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 0
Scale 0
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Appears In
Diagram
 KDOT_RPMS_EPMS(AECOM) : Entity Relationship Diagram
KDOT PMS Replacement Project