link ERModel : Model . PMIS : Package
Entity - COSTCTP 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 | |||||
| ITEM | number(5) | Yes |
Bid Item Number-CTP. |
||||||
| IDESC | varchar2(30) | Yes |
Bid Item Description-CTP. |
||||||
| COSTWA1 | number(8, 3) | Yes |
Bid Item Cost in WageArea1-CTP. |
||||||
| COSTWA2 | number(8, 3) | Yes |
Bid Item Cost in WageArea2-CTP. |
||||||
| COSTWA3 | number(8, 3) | Yes |
Bid Item Cost in WageArea3-CTP. |
||||||
| COSTWA4 | number(8, 3) | Yes |
Bid Item Cost in WageArea4-CTP. |
||||||
| COSTWA5 | number(8, 3) | Yes |
Bid Item Cost in WageArea5-CTP. |
||||||
| Columns Detail |
| Name | Value | ||
| Name | ITEM | ||
| Description |
Bid Item Number-CTP. |
||
| 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 | IDESC | ||
| Description |
Bid Item Description-CTP. |
||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | VARCHAR2 | ||
| Length | 30 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | COSTWA1 | ||
| Description |
Bid Item Cost in WageArea1-CTP. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 8 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | COSTWA2 | ||
| Description |
Bid Item Cost in WageArea2-CTP. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 8 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | COSTWA3 | ||
| Description |
Bid Item Cost in WageArea3-CTP. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 8 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | COSTWA4 | ||
| Description |
Bid Item Cost in WageArea4-CTP. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 8 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | COSTWA5 | ||
| Description |
Bid Item Cost in WageArea5-CTP. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 8 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Appears In |
| Diagram | |||
|
|
|||