CAB_ID |
Base Object | PART_CAB_DR |
Attribute Name | Cab Id |
ColumnName | CAB_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Cabinet Identifer: A unique identiefer for the cabinet made up of the equipment category and a number. |
Note |
CAB_ID Column Properties |
Datatype | VARCHAR2(12) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CAB_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 12 |
Percent Null | 0 |
CAB_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CAB_ID Security Types |
Name | Current Value |
CAB_ID Bound Attachments |
Name | Current Value |
CAB_ID Data Movement Rules |
Name | Type | Rule Text/Value |
CAB_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Part Cab Dr Cab Id |
NO | ||
PART (Oracle) PART_CAB_DR CAB_ID |
NO |
CAB_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CAB_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CAB_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CAB_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DR_ID |
Base Object | PART_CAB_DR |
Attribute Name | Dr Id |
ColumnName | DR_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Drawer Identifier: A unique identifier for a drawer or tray in a cabinet. |
Note |
DR_ID Column Properties |
Datatype | VARCHAR2(5) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DR_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 5 |
Percent Null | 0 |
DR_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DR_ID Security Types |
Name | Current Value |
DR_ID Bound Attachments |
Name | Current Value |
DR_ID Data Movement Rules |
Name | Type | Rule Text/Value |
DR_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Part Cab Dr Dr Id |
NO | ||
PART (Oracle) PART_CAB_DR DR_ID |
NO |
DR_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DR_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DR_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DR_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PART_ID |
Base Object | PART_CAB_DR |
Attribute Name | Part Id |
ColumnName | PART_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Part Identifier: Abbreviated identifer for a part. |
Note |
PART_ID Column Properties |
Datatype | VARCHAR2(25) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PART_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
PART_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PART_ID Security Types |
Name | Current Value |
PART_ID Bound Attachments |
Name | Current Value |
PART_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PART_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Part Cab Dr Part Id |
NO | ||
PART (Oracle) PART_CAB_DR PART_ID |
NO |
PART_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PART_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PART_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PART_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |