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