link 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 | |||
|
|
|||