link ERModel : Model . PMIS : Package
Entity - SCHEDACT 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 | |||||
| ID | char(13) | Yes |
PMS id |
||||||
| SCHYEAR | number(4) | Yes |
Scheduled fiscal year action completed |
||||||
| PROGRAM | number(2) | Yes |
Fiscal program (MM,SM,RM...) |
||||||
| PA_EQTCR | number(4, 2) | Yes |
Post action equiv. transverse cracking |
||||||
| PA_RUTVAL | number(4, 2) | Yes |
Post action rutting value |
||||||
| PA_EQJD | number(4, 2) | Yes |
Post action equivalent joint distress |
||||||
| PA_EQFLT | number(5, 2) | Yes |
Post action equivalent faulting |
||||||
| ACTION | number(4) | Yes |
Action number e.g. 12=1.5" Overlay |
||||||
| PA_DLIFE | number(6, 3) | Yes |
Post action design life |
||||||
| Columns Detail |
| Name | Value | ||
| Name | ID | ||
| Description |
PMS 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 | SCHYEAR | ||
| Description |
Scheduled fiscal year action completed |
||
| 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 | PROGRAM | ||
| Description |
Fiscal program (MM,SM,RM...) |
||
| 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 | PA_EQTCR | ||
| Description |
Post action equiv. transverse cracking |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 4 | ||
| Scale | 2 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | PA_RUTVAL | ||
| Description |
Post action rutting value |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 4 | ||
| Scale | 2 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | PA_EQJD | ||
| Description |
Post action equivalent joint distress |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 4 | ||
| Scale | 2 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | PA_EQFLT | ||
| Description |
Post action equivalent faulting |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 5 | ||
| Scale | 2 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | ACTION | ||
| Description |
Action number e.g. 12=1.5" Overlay |
||
| 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 | PA_DLIFE | ||
| Description |
Post action design life |
||
| 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 | ||
| Appears In |
| Diagram | |||
|
|
|||