EQUIP_ID |
Base Object | INSTR |
Attribute Name | Equip Id |
ColumnName | EQUIP_ID |
Logical Rolename | |
RoleName | |
Domain | Asset Identifier |
Physical Only | NO |
Definition | Equipment Identifier: The unique identifier for the equipment. |
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 Inst Equip Id |
NO | ||
Logical Instrument Equip Id |
NO | ||
Logical Instrument Equip Id |
NO | ||
CNMS_PRPSL (Oracle) INSTR EQUIP_ID |
NO | ||
EQUIP (Oracle) INSTR EQUIP_ID |
NO | ||
EXPRESS (Oracle) INSTR EQUIP_ID |
NO | ||
INSTR (Oracle) INSTR EQUIP_ID |
NO | ||
Instrument Logbook (Oracle) INSTR EQUIP_ID |
NO | ||
IPTSv5 (Oracle) INSTR EQUIP_ID |
NO | ||
PROC (Oracle) INSTR EQUIP_ID |
NO | ||
PRPSL (Oracle) INSTR EQUIP_ID |
NO | ||
PUBL (Oracle) INSTR EQUIP_ID |
NO | ||
SMPL (Oracle) INSTR EQUIP_ID |
NO | ||
XF_ADMIN (Oracle) INSTR 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 |
INSTR_NM |
Base Object | INSTR |
Attribute Name | Instr Nm |
ColumnName | INSTR_NM |
Logical Rolename | |
RoleName | |
Domain | Description |
Physical Only | NO |
Definition | Instrument Name: The name associated with the instrument. |
Note |
INSTR_NM Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
INSTR_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
INSTR_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
INSTR_NM Security Types |
Name | Current Value |
INSTR_NM Bound Attachments |
Name | Current Value |
INSTR_NM Data Movement Rules |
Name | Type | Rule Text/Value |
INSTR_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Inst Instr Nm |
NO | ||
Logical Instrument Instrument Name |
NO | ||
Logical Instrument Instr Nm |
NO | ||
CNMS_PRPSL (Oracle) INSTR INSTR_NM |
NO | ||
EQUIP (Oracle) INSTR INSTR_NM |
NO | ||
EXPRESS (Oracle) INSTR INSTR_NM |
NO | ||
INSTR (Oracle) INSTR INSTR_NM |
NO | ||
Instrument Logbook (Oracle) INSTR INSTR_NM |
NO | ||
IPTSv5 (Oracle) INSTR INSTR_NM |
NO | ||
PROC (Oracle) INSTR INSTR_NM |
NO | ||
PRPSL (Oracle) INSTR INSTR_NM |
NO | ||
PUBL (Oracle) INSTR INSTR_NM |
NO | ||
SMPL (Oracle) INSTR INSTR_NM |
NO | ||
XF_ADMIN (Oracle) INSTR INSTR_NM |
NO |
INSTR_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTR_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTR_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTR_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_DTE |
Base Object | INSTR |
Attribute Name | Modify Date |
ColumnName | MOD_DTE |
Logical Rolename | |
RoleName | |
Domain | Modify Date |
Physical Only | NO |
Definition | Modify Date: The day the instrument information was modified. |
Note |
MOD_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
MOD_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
MOD_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MOD_DTE Security Types |
Name | Current Value |
MOD_DTE Bound Attachments |
Name | Current Value |
MOD_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
MOD_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Inst Modify Date |
NO | ||
Logical Instrument Modify Date |
NO | ||
Logical Instrument Modify Date |
NO | ||
CNMS_PRPSL (Oracle) INSTR MOD_DTE |
NO | ||
EQUIP (Oracle) INSTR MOD_DTE |
NO | ||
EXPRESS (Oracle) INSTR MOD_DTE |
NO | ||
INSTR (Oracle) INSTR MOD_DTE |
NO | ||
Instrument Logbook (Oracle) INSTR MOD_DTE |
NO | ||
IPTSv5 (Oracle) INSTR MOD_DTE |
NO | ||
PROC (Oracle) INSTR MOD_DTE |
NO | ||
PRPSL (Oracle) INSTR MOD_DTE |
NO | ||
PUBL (Oracle) INSTR MOD_DTE |
NO | ||
SMPL (Oracle) INSTR MOD_DTE |
NO | ||
XF_ADMIN (Oracle) INSTR MOD_DTE |
NO |
MOD_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_UID |
Base Object | INSTR |
Attribute Name | Mod By Uid |
ColumnName | MOD_BY_UID |
Logical Rolename | |
RoleName | |
Domain | Userid |
Physical Only | NO |
Definition | Modify By: The userid of the person who last modified the instrument record. |
Note |
MOD_BY_UID Column Properties |
Datatype | VARCHAR2(64) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
MOD_BY_UID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 64 |
Percent Null | 0 |
MOD_BY_UID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MOD_BY_UID Security Types |
Name | Current Value |
MOD_BY_UID Bound Attachments |
Name | Current Value |
MOD_BY_UID Data Movement Rules |
Name | Type | Rule Text/Value |
MOD_BY_UID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Inst Mod By Uid |
NO | ||
Logical Instrument Mod By Uid |
NO | ||
Logical Instrument Mod By Uid |
NO | ||
CNMS_PRPSL (Oracle) INSTR MOD_BY_UID |
NO | ||
EQUIP (Oracle) INSTR MOD_BY_UID |
NO | ||
EXPRESS (Oracle) INSTR MOD_BY_UID |
NO | ||
INSTR (Oracle) INSTR MOD_BY_UID |
NO | ||
Instrument Logbook (Oracle) INSTR MOD_BY_UID |
NO | ||
IPTSv5 (Oracle) INSTR MOD_BY_UID |
NO | ||
PROC (Oracle) INSTR MOD_BY_UID |
NO | ||
PRPSL (Oracle) INSTR MOD_BY_UID |
NO | ||
PUBL (Oracle) INSTR MOD_BY_UID |
NO | ||
SMPL (Oracle) INSTR MOD_BY_UID |
NO | ||
XF_ADMIN (Oracle) INSTR MOD_BY_UID |
NO |
MOD_BY_UID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_UID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_UID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_UID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |