TEST_DTE |
Base Object | CYCLE_ON |
Attribute Name | Test Dte |
ColumnName | TEST_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Test Date |
Note |
TEST_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
TEST_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
TEST_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
TEST_DTE Security Types |
Name | Current Value |
TEST_DTE Bound Attachments |
Name | Current Value |
TEST_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
TEST_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cycle On Test Dte |
NO | ||
Magnet (Oracle) CYCLE_ON TEST_DTE |
NO |
TEST_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TEST_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TEST_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TEST_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
POLE |
Base Object | CYCLE_ON |
Attribute Name | Pole |
ColumnName | POLE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Pole: Multiple of winding for measurement (use if more than one per magnet, n=1 is dipole) |
Note |
POLE Column Properties |
Datatype | NUMBER(2, 0) |
Nullable | NO |
POLE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 0 |
POLE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
POLE Security Types |
Name | Current Value |
POLE Bound Attachments |
Name | Current Value |
POLE Data Movement Rules |
Name | Type | Rule Text/Value |
POLE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cycle On Pole |
NO | ||
Magnet (Oracle) CYCLE_ON POLE |
NO |
POLE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
POLE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
POLE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
POLE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CYCLE_ON_TIME |
Base Object | CYCLE_ON |
Attribute Name | Cycle On Time |
ColumnName | CYCLE_ON_TIME |
Logical Rolename | |
RoleName | |
Domain | Magnet Default |
Physical Only | NO |
Definition | Time: Time from start of magnet turn on (sec) |
Note |
CYCLE_ON_TIME Column Properties |
Datatype | NUMBER(12, 6) |
Nullable | NO |
CYCLE_ON_TIME Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
CYCLE_ON_TIME Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CYCLE_ON_TIME Security Types |
Name | Current Value |
CYCLE_ON_TIME Bound Attachments |
Name | Current Value |
CYCLE_ON_TIME Data Movement Rules |
Name | Type | Rule Text/Value |
CYCLE_ON_TIME Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cycle On Cycle On Time |
NO | ||
Magnet (Oracle) CYCLE_ON CYCLE_ON_TIME |
NO |
CYCLE_ON_TIME Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CYCLE_ON_TIME Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CYCLE_ON_TIME Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CYCLE_ON_TIME Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CYCLE_ON_CUR |
Base Object | CYCLE_ON |
Attribute Name | Cycle On Cur |
ColumnName | CYCLE_ON_CUR |
Logical Rolename | |
RoleName | |
Domain | Magnet Default |
Physical Only | NO |
Definition | Current: Current at this time (A) |
Note |
CYCLE_ON_CUR Column Properties |
Datatype | NUMBER(12, 6) |
Nullable | NO |
CYCLE_ON_CUR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
CYCLE_ON_CUR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CYCLE_ON_CUR Security Types |
Name | Current Value |
CYCLE_ON_CUR Bound Attachments |
Name | Current Value |
CYCLE_ON_CUR Data Movement Rules |
Name | Type | Rule Text/Value |
CYCLE_ON_CUR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cycle On Cycle On Cur |
NO | ||
Magnet (Oracle) CYCLE_ON CYCLE_ON_CUR |
NO |
CYCLE_ON_CUR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CYCLE_ON_CUR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CYCLE_ON_CUR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CYCLE_ON_CUR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EQUIP_ID |
Base Object | CYCLE_ON |
Attribute Name | Equip Id |
ColumnName | EQUIP_ID |
Logical Rolename | |
RoleName | |
Domain | Asset Identifier |
Physical Only | NO |
Definition | Asset Identifier: The Datastream/Infor asset identifier also often referred to as the Barcode Id. |
Note |
EQUIP_ID Column Properties |
Datatype | VARCHAR2(30) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
EQUIP_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 11 |
Percent Null | 0 |
EQUIP_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EQUIP_ID Security Types |
Name | Current Value |
EQUIP_ID Bound Attachments |
Name | Current Value |
EQUIP_ID Data Movement Rules |
Name | Type | Rule Text/Value |
EQUIP_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cycle On Equip Id |
NO | ||
Magnet (Oracle) CYCLE_ON EQUIP_ID |
NO |
EQUIP_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EQUIP_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EQUIP_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EQUIP_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |