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