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