link R-PMS Subsystem - AECOM : Package . AECOM-EPMS System : Package
Entity - LOGPROJ link
| Properties |
| Name | Value | ||
| Description |
Practical boundaries for future pavement maintenance and rehabilitation projects |
||
| 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 | |||||
| CODE | number(0) | Yes |
Code that uniquely identifies the route suffix. A value of 9 indicates turnpike. |
||||||
| COUNTY | number(0) | Yes |
Code that uniquely identifies the county. |
||||||
| LANE | number(0) | Yes |
Code that uniquely identifies the lane designation. Null values indicate that the project spans all lane designations |
||||||
| LID | varchar2(255) | Yes |
Code that uniquely identifies the logical project. |
||||||
| MPBEG | float(0) | Yes |
Start log point of the logical project (miles) |
||||||
| MPEND | float(0) | Yes |
End log point of the logical project (miles) |
||||||
| RECORDDATE | timestamp(0) | Yes |
Date of the set of logical projects to which this logical project belongs. |
||||||
| RTNO | varchar2(255) | Yes |
Code that uniquely identifies the route. |
||||||
| RTTY | number(0) | Yes |
Code that uniquely identifies the route classification. |
||||||
| Columns Detail |
| Name | Value | ||
| Name | CODE | ||
| Description |
Code that uniquely identifies the route suffix. A value of 9 indicates turnpike. |
||
| 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 | COUNTY | ||
| Description |
Code that uniquely identifies the county. |
||
| 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 | LANE | ||
| Description |
Code that uniquely identifies the lane designation. Null values indicate that the project spans all lane designations |
||
| 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 | LID | ||
| Description |
Code that uniquely identifies the logical project. |
||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Length | 255 | ||
| Scale | 0 | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | MPBEG | ||
| Description |
Start log point of the logical project (miles) |
||
| Type | float | ||
| 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 | MPEND | ||
| Description |
End log point of the logical project (miles) |
||
| Type | float | ||
| 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 | RECORDDATE | ||
| Description |
Date of the set of logical projects to which this logical project belongs. |
||
| Type | timestamp | ||
| 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 | RTNO | ||
| Description |
Code that uniquely identifies the route. |
||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Length | 255 | ||
| Scale | 0 | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | RTTY | ||
| Description |
Code that uniquely identifies the route classification. |
||
| 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 | |||
|
|
|||