Experiment Resource Type Identifier |
Base Entity | Can Substrate Cell |
Attribute Name | Experiment Resource Type Identifier |
Logical Rolename | |
ColumnName | EXPT_RSRC_TYPE_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Experiment Resource Type Identifier Logical Attribute Properties |
Logical Attribute Name | Experiment Resource Type Identifier |
Datatype | VARCHAR(50) |
Nullable | NO |
Experiment Resource Type Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Experiment Resource Type Identifier Security Types |
Name | Current Value |
Experiment Resource Type Identifier Bound Attachments |
Name | Current Value |
Experiment Resource Type Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Experiment Resource Type Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Experiment Resource Type Identifier |
NO | ||
EXPRESS (Oracle) CASC EXPT_RSRC_TYPE_ID |
NO |
Experiment Resource Type Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Experiment Resource Type Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Experiment Resource Type Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Experiment Resource Type Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Facility Identifier |
Base Entity | Can Substrate Cell |
Attribute Name | Facility Identifier |
Logical Rolename | |
ColumnName | FACIL_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Facility Identifer: A unique abbreviated identifier for the facilty in which the proposed experiment is to take place. |
Note |
Facility Identifier Logical Attribute Properties |
Logical Attribute Name | Facility Identifier |
Datatype | VARCHAR(10) |
Nullable | NO |
Facility Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Facility Identifier Security Types |
Name | Current Value |
Facility Identifier Bound Attachments |
Name | Current Value |
Facility Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Facility Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Facility Identifier |
NO | ||
EXPRESS (Oracle) CASC FACIL_ID |
NO |
Facility Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Facility Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Facility Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Facility Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier |
Base Entity | Can Substrate Cell |
Attribute Name | Status Identifier |
Logical Rolename | |
ColumnName | STAT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Status Identifier Logical Attribute Properties |
Logical Attribute Name | Status Identifier |
Datatype | VARCHAR(20) |
Nullable | NO |
Status Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Status Identifier Security Types |
Name | Current Value |
Status Identifier Bound Attachments |
Name | Current Value |
Status Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Status Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Status Identifier |
NO | ||
EXPRESS (Oracle) CASC STAT_ID |
NO |
Status Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Total Quantity |
Base Entity | Can Substrate Cell |
Attribute Name | Total Quantity |
Logical Rolename | |
ColumnName | TOT_QTY |
RoleName | |
Domain | Quantity |
Logical Only | NO |
Definition | |
Note |
Total Quantity Logical Attribute Properties |
Logical Attribute Name | Total Quantity |
Datatype | INTEGER |
Nullable | NO |
Total Quantity Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 1 |
Bound Default |
Total Quantity Security Types |
Name | Current Value |
Total Quantity Bound Attachments |
Name | Current Value |
Total Quantity Data Movement Rules |
Name | Type | Rule Text/Value |
Total Quantity Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Total Quantity |
NO | ||
EXPRESS (Oracle) CASC TOT_QTY |
NO |
Total Quantity Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Total Quantity Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Total Quantity Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Total Quantity Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Quantity in Use |
Base Entity | Can Substrate Cell |
Attribute Name | Quantity in Use |
Logical Rolename | |
ColumnName | QTY_USE |
RoleName | |
Domain | Quantity |
Logical Only | NO |
Definition | |
Note |
Quantity in Use Logical Attribute Properties |
Logical Attribute Name | Quantity in Use |
Datatype | INTEGER |
Nullable | YES |
Quantity in Use Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 1 |
Bound Default |
Quantity in Use Security Types |
Name | Current Value |
Quantity in Use Bound Attachments |
Name | Current Value |
Quantity in Use Data Movement Rules |
Name | Type | Rule Text/Value |
Quantity in Use Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Quantity in Use |
NO | ||
EXPRESS (Oracle) CASC QTY_USE |
NO |
Quantity in Use Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Quantity in Use Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Quantity in Use Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Quantity in Use Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Reorder Threshold |
Base Entity | Can Substrate Cell |
Attribute Name | Reorder Threshold |
Logical Rolename | |
ColumnName | REORD_THR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Reorder Threshold Logical Attribute Properties |
Logical Attribute Name | Reorder Threshold |
Datatype | INTEGER |
Nullable | NO |
Reorder Threshold Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Reorder Threshold Security Types |
Name | Current Value |
Reorder Threshold Bound Attachments |
Name | Current Value |
Reorder Threshold Data Movement Rules |
Name | Type | Rule Text/Value |
Reorder Threshold Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Reorder Threshold |
NO | ||
EXPRESS (Oracle) CASC REORD_THR |
NO |
Reorder Threshold Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Reorder Threshold Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Reorder Threshold Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Reorder Threshold Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Minimum |
Base Entity | Can Substrate Cell |
Attribute Name | Temperature Minimum |
Logical Rolename | |
ColumnName | TEMP_MIN |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Temperature Minimum Logical Attribute Properties |
Logical Attribute Name | Temperature Minimum |
Datatype | VARCHAR(5) |
Nullable | YES |
Temperature Minimum Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Temperature Minimum Security Types |
Name | Current Value |
Temperature Minimum Bound Attachments |
Name | Current Value |
Temperature Minimum Data Movement Rules |
Name | Type | Rule Text/Value |
Temperature Minimum Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Temperature Minimum |
NO | ||
EXPRESS (Oracle) CASC TEMP_MIN |
NO |
Temperature Minimum Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Minimum Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Minimum Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Minimum Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Maximum |
Base Entity | Can Substrate Cell |
Attribute Name | Temperature Maximum |
Logical Rolename | |
ColumnName | TEMP_MAX |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Temperature Maximum Logical Attribute Properties |
Logical Attribute Name | Temperature Maximum |
Datatype | VARCHAR(5) |
Nullable | YES |
Temperature Maximum Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Temperature Maximum Security Types |
Name | Current Value |
Temperature Maximum Bound Attachments |
Name | Current Value |
Temperature Maximum Data Movement Rules |
Name | Type | Rule Text/Value |
Temperature Maximum Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Temperature Maximum |
NO | ||
EXPRESS (Oracle) CASC TEMP_MAX |
NO |
Temperature Maximum Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Maximum Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Maximum Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Maximum Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Unit of Measure Identifier |
Base Entity | Can Substrate Cell |
Attribute Name | Unit Identifier |
Logical Rolename | Temperature Unit of Measure Identifier |
ColumnName | TEMP_UOM_ID |
RoleName | TEMP_UOM_ID |
Domain | |
Logical Only | NO |
Definition | Length Unit Identifier: Abbreviated unit of length. |
Note |
Temperature Unit of Measure Identifier Logical Attribute Properties |
Logical Attribute Name | Unit Identifier |
Datatype | VARCHAR(3) |
Nullable | YES |
Temperature Unit of Measure Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Temperature Unit of Measure Identifier Security Types |
Name | Current Value |
Temperature Unit of Measure Identifier Bound Attachments |
Name | Current Value |
Temperature Unit of Measure Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Temperature Unit of Measure Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Unit Identifier |
NO | ||
EXPRESS (Oracle) CASC TEMP_UOM_ID |
NO |
Temperature Unit of Measure Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Unit of Measure Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Unit of Measure Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Temperature Unit of Measure Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Minimum |
Base Entity | Can Substrate Cell |
Attribute Name | Pressure Minimum |
Logical Rolename | |
ColumnName | PRESS_MIN |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Pressure Minimum Logical Attribute Properties |
Logical Attribute Name | Pressure Minimum |
Datatype | VARCHAR(5) |
Nullable | YES |
Pressure Minimum Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Pressure Minimum Security Types |
Name | Current Value |
Pressure Minimum Bound Attachments |
Name | Current Value |
Pressure Minimum Data Movement Rules |
Name | Type | Rule Text/Value |
Pressure Minimum Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Pressure Minimum |
NO | ||
EXPRESS (Oracle) CASC PRESS_MIN |
NO |
Pressure Minimum Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Minimum Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Minimum Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Minimum Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Maximum |
Base Entity | Can Substrate Cell |
Attribute Name | Pressure Maximum |
Logical Rolename | |
ColumnName | PRESS_MAX |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Pressure Maximum Logical Attribute Properties |
Logical Attribute Name | Pressure Maximum |
Datatype | VARCHAR(5) |
Nullable | YES |
Pressure Maximum Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Pressure Maximum Security Types |
Name | Current Value |
Pressure Maximum Bound Attachments |
Name | Current Value |
Pressure Maximum Data Movement Rules |
Name | Type | Rule Text/Value |
Pressure Maximum Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Pressure Maximum |
NO | ||
EXPRESS (Oracle) CASC PRESS_MAX |
NO |
Pressure Maximum Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Maximum Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Maximum Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Maximum Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Unit of Measure Identifier |
Base Entity | Can Substrate Cell |
Attribute Name | Unit Identifier |
Logical Rolename | Pressure Unit of Measure Identifier |
ColumnName | PRESS_UOM_ID |
RoleName | PRESS_UOM_ID |
Domain | |
Logical Only | NO |
Definition | Length Unit Identifier: Abbreviated unit of length. |
Note |
Pressure Unit of Measure Identifier Logical Attribute Properties |
Logical Attribute Name | Unit Identifier |
Datatype | VARCHAR(3) |
Nullable | YES |
Pressure Unit of Measure Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Pressure Unit of Measure Identifier Security Types |
Name | Current Value |
Pressure Unit of Measure Identifier Bound Attachments |
Name | Current Value |
Pressure Unit of Measure Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Pressure Unit of Measure Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Unit Identifier |
NO | ||
EXPRESS (Oracle) CASC PRESS_UOM_ID |
NO |
Pressure Unit of Measure Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Unit of Measure Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Unit of Measure Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Pressure Unit of Measure Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Height |
Base Entity | Can Substrate Cell |
Attribute Name | Inner Dimension Height |
Logical Rolename | |
ColumnName | IN_DIM_HT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Inner Dimension Height Logical Attribute Properties |
Logical Attribute Name | Inner Dimension Height |
Datatype | NUMERIC(10, 2) |
Nullable | YES |
Inner Dimension Height Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Inner Dimension Height Security Types |
Name | Current Value |
Inner Dimension Height Bound Attachments |
Name | Current Value |
Inner Dimension Height Data Movement Rules |
Name | Type | Rule Text/Value |
Inner Dimension Height Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Inner Dimension Height |
NO | ||
EXPRESS (Oracle) CASC IN_DIM_HT |
NO |
Inner Dimension Height Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Height Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Height Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Height Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Width |
Base Entity | Can Substrate Cell |
Attribute Name | Inner Dimension Width |
Logical Rolename | |
ColumnName | IN_DIM_WD |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Inner Dimension Width Logical Attribute Properties |
Logical Attribute Name | Inner Dimension Width |
Datatype | NUMERIC(10, 2) |
Nullable | YES |
Inner Dimension Width Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Inner Dimension Width Security Types |
Name | Current Value |
Inner Dimension Width Bound Attachments |
Name | Current Value |
Inner Dimension Width Data Movement Rules |
Name | Type | Rule Text/Value |
Inner Dimension Width Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Inner Dimension Width |
NO | ||
EXPRESS (Oracle) CASC IN_DIM_WD |
NO |
Inner Dimension Width Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Width Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Width Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Width Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Depth |
Base Entity | Can Substrate Cell |
Attribute Name | Inner Dimension Depth |
Logical Rolename | |
ColumnName | IN_DIM_DP |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Inner Dimension Depth Logical Attribute Properties |
Logical Attribute Name | Inner Dimension Depth |
Datatype | NUMERIC(10, 2) |
Nullable | YES |
Inner Dimension Depth Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Inner Dimension Depth Security Types |
Name | Current Value |
Inner Dimension Depth Bound Attachments |
Name | Current Value |
Inner Dimension Depth Data Movement Rules |
Name | Type | Rule Text/Value |
Inner Dimension Depth Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Inner Dimension Depth |
NO | ||
EXPRESS (Oracle) CASC IN_DIM_DP |
NO |
Inner Dimension Depth Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Depth Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Depth Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Depth Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Diameter |
Base Entity | Can Substrate Cell |
Attribute Name | Inner Dimension Diameter |
Logical Rolename | |
ColumnName | IN_DIM_DIA |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Inner Dimension Diameter Logical Attribute Properties |
Logical Attribute Name | Inner Dimension Diameter |
Datatype | NUMERIC(10, 2) |
Nullable | YES |
Inner Dimension Diameter Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Inner Dimension Diameter Security Types |
Name | Current Value |
Inner Dimension Diameter Bound Attachments |
Name | Current Value |
Inner Dimension Diameter Data Movement Rules |
Name | Type | Rule Text/Value |
Inner Dimension Diameter Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Inner Dimension Diameter |
NO | ||
EXPRESS (Oracle) CASC IN_DIM_DIA |
NO |
Inner Dimension Diameter Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Diameter Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Diameter Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Diameter Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Unit of Measure Identifer |
Base Entity | Can Substrate Cell |
Attribute Name | Unit Identifier |
Logical Rolename | Inner Dimension Unit of Measure Identifer |
ColumnName | IN_DIM_UOM_ID |
RoleName | IN_DIM_UOM_ID |
Domain | |
Logical Only | NO |
Definition | Length Unit Identifier: Abbreviated unit of length. |
Note |
Inner Dimension Unit of Measure Identifer Logical Attribute Properties |
Logical Attribute Name | Unit Identifier |
Datatype | VARCHAR(3) |
Nullable | YES |
Inner Dimension Unit of Measure Identifer Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Inner Dimension Unit of Measure Identifer Security Types |
Name | Current Value |
Inner Dimension Unit of Measure Identifer Bound Attachments |
Name | Current Value |
Inner Dimension Unit of Measure Identifer Data Movement Rules |
Name | Type | Rule Text/Value |
Inner Dimension Unit of Measure Identifer Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Unit Identifier |
NO | ||
EXPRESS (Oracle) CASC IN_DIM_UOM_ID |
NO |
Inner Dimension Unit of Measure Identifer Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Unit of Measure Identifer Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Unit of Measure Identifer Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Inner Dimension Unit of Measure Identifer Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Height |
Base Entity | Can Substrate Cell |
Attribute Name | Outer Dimension Height |
Logical Rolename | |
ColumnName | OUT_DIM_HT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Outer Dimension Height Logical Attribute Properties |
Logical Attribute Name | Outer Dimension Height |
Datatype | NUMERIC(10, 2) |
Nullable | YES |
Outer Dimension Height Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Outer Dimension Height Security Types |
Name | Current Value |
Outer Dimension Height Bound Attachments |
Name | Current Value |
Outer Dimension Height Data Movement Rules |
Name | Type | Rule Text/Value |
Outer Dimension Height Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Outer Dimension Height |
NO | ||
EXPRESS (Oracle) CASC OUT_DIM_HT |
NO |
Outer Dimension Height Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Height Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Height Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Height Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Width |
Base Entity | Can Substrate Cell |
Attribute Name | Outer Dimension Width |
Logical Rolename | |
ColumnName | OUT_DIM_WD |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Outer Dimension Width Logical Attribute Properties |
Logical Attribute Name | Outer Dimension Width |
Datatype | NUMERIC(10, 2) |
Nullable | YES |
Outer Dimension Width Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Outer Dimension Width Security Types |
Name | Current Value |
Outer Dimension Width Bound Attachments |
Name | Current Value |
Outer Dimension Width Data Movement Rules |
Name | Type | Rule Text/Value |
Outer Dimension Width Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Outer Dimension Width |
NO | ||
EXPRESS (Oracle) CASC OUT_DIM_WD |
NO |
Outer Dimension Width Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Width Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Width Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Width Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Depth |
Base Entity | Can Substrate Cell |
Attribute Name | Outer Dimension Depth |
Logical Rolename | |
ColumnName | OUT_DIM_DP |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Outer Dimension Depth Logical Attribute Properties |
Logical Attribute Name | Outer Dimension Depth |
Datatype | NUMERIC(10, 2) |
Nullable | YES |
Outer Dimension Depth Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Outer Dimension Depth Security Types |
Name | Current Value |
Outer Dimension Depth Bound Attachments |
Name | Current Value |
Outer Dimension Depth Data Movement Rules |
Name | Type | Rule Text/Value |
Outer Dimension Depth Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Outer Dimension Depth |
NO | ||
EXPRESS (Oracle) CASC OUT_DIM_DP |
NO |
Outer Dimension Depth Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Depth Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Depth Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Depth Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Diameter |
Base Entity | Can Substrate Cell |
Attribute Name | Outer Dimension Diameter |
Logical Rolename | |
ColumnName | OUT_DIM_DIA |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Outer Dimension Diameter Logical Attribute Properties |
Logical Attribute Name | Outer Dimension Diameter |
Datatype | NUMERIC(10, 2) |
Nullable | YES |
Outer Dimension Diameter Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Outer Dimension Diameter Security Types |
Name | Current Value |
Outer Dimension Diameter Bound Attachments |
Name | Current Value |
Outer Dimension Diameter Data Movement Rules |
Name | Type | Rule Text/Value |
Outer Dimension Diameter Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Outer Dimension Diameter |
NO | ||
EXPRESS (Oracle) CASC OUT_DIM_DIA |
NO |
Outer Dimension Diameter Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Diameter Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Diameter Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Diameter Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Unit of Measure Identifier |
Base Entity | Can Substrate Cell |
Attribute Name | Unit Identifier |
Logical Rolename | Outer Dimension Unit of Measure Identifier |
ColumnName | OUT_DIM_UOM_ID |
RoleName | OUT_DIM_UOM_ID |
Domain | |
Logical Only | NO |
Definition | Length Unit Identifier: Abbreviated unit of length. |
Note |
Outer Dimension Unit of Measure Identifier Logical Attribute Properties |
Logical Attribute Name | Unit Identifier |
Datatype | VARCHAR(3) |
Nullable | YES |
Outer Dimension Unit of Measure Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Outer Dimension Unit of Measure Identifier Security Types |
Name | Current Value |
Outer Dimension Unit of Measure Identifier Bound Attachments |
Name | Current Value |
Outer Dimension Unit of Measure Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Outer Dimension Unit of Measure Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Unit Identifier |
NO | ||
EXPRESS (Oracle) CASC OUT_DIM_UOM_ID |
NO |
Outer Dimension Unit of Measure Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Unit of Measure Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Unit of Measure Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Outer Dimension Unit of Measure Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Volume |
Base Entity | Can Substrate Cell |
Attribute Name | Volume |
Logical Rolename | |
ColumnName | VOL |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Volume Logical Attribute Properties |
Logical Attribute Name | Volume |
Datatype | NUMERIC(10, 2) |
Nullable | YES |
Volume Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Volume Security Types |
Name | Current Value |
Volume Bound Attachments |
Name | Current Value |
Volume Data Movement Rules |
Name | Type | Rule Text/Value |
Volume Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Volume |
NO | ||
EXPRESS (Oracle) CASC VOL |
NO |
Volume Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Volume Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Volume Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Volume Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Volume Unit of Measure Identifier |
Base Entity | Can Substrate Cell |
Attribute Name | Unit Identifier |
Logical Rolename | Volume Unit of Measure Identifier |
ColumnName | VOL_UOM |
RoleName | VOL_UOM |
Domain | |
Logical Only | NO |
Definition | Length Unit Identifier: Abbreviated unit of length. |
Note |
Volume Unit of Measure Identifier Logical Attribute Properties |
Logical Attribute Name | Unit Identifier |
Datatype | VARCHAR(3) |
Nullable | YES |
Volume Unit of Measure Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Volume Unit of Measure Identifier Security Types |
Name | Current Value |
Volume Unit of Measure Identifier Bound Attachments |
Name | Current Value |
Volume Unit of Measure Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Volume Unit of Measure Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Unit Identifier |
NO | ||
EXPRESS (Oracle) CASC VOL_UOM |
NO |
Volume Unit of Measure Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Volume Unit of Measure Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Volume Unit of Measure Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Volume Unit of Measure Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Identifier |
Base Entity | Can Substrate Cell |
Attribute Name | Manufacturer Identifier |
Logical Rolename | |
ColumnName | MANUF_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Manufacturer Identifier Logical Attribute Properties |
Logical Attribute Name | Manufacturer Identifier |
Datatype | VARCHAR(30) |
Nullable | YES |
Manufacturer Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Manufacturer Identifier Security Types |
Name | Current Value |
Manufacturer Identifier Bound Attachments |
Name | Current Value |
Manufacturer Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Manufacturer Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Manufacturer Identifier |
NO | ||
EXPRESS (Oracle) CASC MANUF_ID |
NO |
Manufacturer Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Part Number |
Base Entity | Can Substrate Cell |
Attribute Name | Manufacturer Part Number |
Logical Rolename | |
ColumnName | MANFU_PART_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Manufacturer Part Number Logical Attribute Properties |
Logical Attribute Name | Manufacturer Part Number |
Datatype | VARCHAR(50) |
Nullable | YES |
Manufacturer Part Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Manufacturer Part Number Security Types |
Name | Current Value |
Manufacturer Part Number Bound Attachments |
Name | Current Value |
Manufacturer Part Number Data Movement Rules |
Name | Type | Rule Text/Value |
Manufacturer Part Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Manufacturer Part Number |
NO | ||
EXPRESS (Oracle) CASC MANFU_PART_NBR |
NO |
Manufacturer Part Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Part Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Part Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Manufacturer Part Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Location Identifier |
Base Entity | Can Substrate Cell |
Attribute Name | Location Identifier |
Logical Rolename | |
ColumnName | LOC_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Location Identifier Logical Attribute Properties |
Logical Attribute Name | Location Identifier |
Datatype | VARCHAR(50) |
Nullable | YES |
Location Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Location Identifier Security Types |
Name | Current Value |
Location Identifier Bound Attachments |
Name | Current Value |
Location Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Location Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Location Identifier |
NO | ||
EXPRESS (Oracle) CASC LOC_ID |
NO |
Location Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Location Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Location Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Location Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Material |
Base Entity | Can Substrate Cell |
Attribute Name | Material |
Logical Rolename | |
ColumnName | MTL |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Material Logical Attribute Properties |
Logical Attribute Name | Material |
Datatype | VARCHAR(100) |
Nullable | YES |
Material Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Material Security Types |
Name | Current Value |
Material Bound Attachments |
Name | Current Value |
Material Data Movement Rules |
Name | Type | Rule Text/Value |
Material Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Material |
NO | ||
EXPRESS (Oracle) CASC MTL |
NO |
Material Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Material Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Material Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Material Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mount or Connector |
Base Entity | Can Substrate Cell |
Attribute Name | Mount or Connector |
Logical Rolename | |
ColumnName | MNT_CON |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Mount or Connector Logical Attribute Properties |
Logical Attribute Name | Mount or Connector |
Datatype | VARCHAR(100) |
Nullable | YES |
Mount or Connector Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Mount or Connector Security Types |
Name | Current Value |
Mount or Connector Bound Attachments |
Name | Current Value |
Mount or Connector Data Movement Rules |
Name | Type | Rule Text/Value |
Mount or Connector Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Mount or Connector |
NO | ||
EXPRESS (Oracle) CASC MNT_CON |
NO |
Mount or Connector Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mount or Connector Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mount or Connector Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mount or Connector Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Hardware or Option |
Base Entity | Can Substrate Cell |
Attribute Name | Hardware or Option |
Logical Rolename | |
ColumnName | HARD_OPT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Hardware or Option Logical Attribute Properties |
Logical Attribute Name | Hardware or Option |
Datatype | VARCHAR(100) |
Nullable | YES |
Hardware or Option Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Hardware or Option Security Types |
Name | Current Value |
Hardware or Option Bound Attachments |
Name | Current Value |
Hardware or Option Data Movement Rules |
Name | Type | Rule Text/Value |
Hardware or Option Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Hardware or Option |
NO | ||
EXPRESS (Oracle) CASC HARD_OPT |
NO |
Hardware or Option Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Hardware or Option Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Hardware or Option Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Hardware or Option Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Drawing Number |
Base Entity | Can Substrate Cell |
Attribute Name | Drawing Number |
Logical Rolename | |
ColumnName | DRAW_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Drawing Number: NScD drawing number. |
Note |
Drawing Number Logical Attribute Properties |
Logical Attribute Name | Drawing Number |
Datatype | VARCHAR(50) |
Nullable | YES |
Drawing Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Drawing Number Security Types |
Name | Current Value |
Drawing Number Bound Attachments |
Name | Current Value |
Drawing Number Data Movement Rules |
Name | Type | Rule Text/Value |
Drawing Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Drawing Number |
NO | ||
EXPRESS (Oracle) CASC DRAW_NBR |
NO |
Drawing Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Drawing Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Drawing Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Drawing Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Comment |
Base Entity | Can Substrate Cell |
Attribute Name | Comment |
Logical Rolename | |
ColumnName | CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
Comment Logical Attribute Properties |
Logical Attribute Name | Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Comment Security Types |
Name | Current Value |
Comment Bound Attachments |
Name | Current Value |
Comment Data Movement Rules |
Name | Type | Rule Text/Value |
Comment Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Comment |
NO | ||
EXPRESS (Oracle) CASC CMNT |
NO |
Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Show in Dashboard Indicator |
Base Entity | Can Substrate Cell |
Attribute Name | Show in Dashboard Indicator |
Logical Rolename | |
ColumnName | DASH_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Show in Dashboard Indicator Logical Attribute Properties |
Logical Attribute Name | Show in Dashboard Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Show in Dashboard Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Show in Dashboard Indicator Reference Value (Bound to Domain) |
Name | Standard Indicator |
Description | These are the standard values for the Indicator domain. |
Type | By List |
Value | Value Description |
Y | Yes |
N | No |
Show in Dashboard Indicator Security Types |
Name | Current Value |
Show in Dashboard Indicator Bound Attachments |
Name | Current Value |
Show in Dashboard Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Show in Dashboard Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Can Substrate Cell Show in Dashboard Indicator |
NO | ||
EXPRESS (Oracle) CASC DASH_IND |
NO |
Show in Dashboard Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Show in Dashboard Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Show in Dashboard Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Show in Dashboard Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |