CAB_ID |
Base Object | PART_CAB_DR_BIN_SEC |
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 Bin Sec Cab Id |
NO | ||
PART (Oracle) PART_CAB_DR_BIN_SEC 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_BIN_SEC |
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 Bin Sec Dr Id |
NO | ||
PART (Oracle) PART_CAB_DR_BIN_SEC 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 |
BIN_ID |
Base Object | PART_CAB_DR_BIN_SEC |
Attribute Name | Bin Id |
ColumnName | BIN_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Bin Identifer: Identifer for a unique bin within a drawer. |
Note |
BIN_ID Column Properties |
Datatype | VARCHAR2(5) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BIN_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 5 |
Percent Null | 0 |
BIN_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BIN_ID Security Types |
Name | Current Value |
BIN_ID Bound Attachments |
Name | Current Value |
BIN_ID Data Movement Rules |
Name | Type | Rule Text/Value |
BIN_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Part Cab Dr Bin Sec Bin Id |
NO | ||
PART (Oracle) PART_CAB_DR_BIN_SEC BIN_ID |
NO |
BIN_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BIN_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BIN_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BIN_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SEC_ID |
Base Object | PART_CAB_DR_BIN_SEC |
Attribute Name | Sec Id |
ColumnName | SEC_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Section Identifer: Defines the sections in a bin. |
Note |
SEC_ID Column Properties |
Datatype | VARCHAR2(5) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SEC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 5 |
Percent Null | 0 |
SEC_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SEC_ID Security Types |
Name | Current Value |
SEC_ID Bound Attachments |
Name | Current Value |
SEC_ID Data Movement Rules |
Name | Type | Rule Text/Value |
SEC_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Part Cab Dr Bin Sec Sec Id |
NO | ||
PART (Oracle) PART_CAB_DR_BIN_SEC SEC_ID |
NO |
SEC_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SEC_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SEC_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SEC_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PART_ID |
Base Object | PART_CAB_DR_BIN_SEC |
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 Bin Sec Part Id |
NO | ||
PART (Oracle) PART_CAB_DR_BIN_SEC 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 |