Device Identifer 
Base Entity  MPS Interface Device 
Attribute Name  Device Identifer 
Logical Rolename   
ColumnName  DVC_ID 
RoleName   
Domain  Device Id 
Logical Only  NO 
Definition 
Device Identifier: The unique identifier for the device. The identifier consists of the concatenation of the following fields:  System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance.
 
Note 
 

Device Identifer Logical Attribute Properties 
Logical Attribute Name  Device Identifer 
Datatype  VARCHAR(50) 
Nullable  NO 

Device Identifer Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Device Identifer Security Types 
Name  Current Value 

Device Identifer Bound Attachments 
Name  Current Value 

Device Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Device Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
MPS Interface Device
Device Identifer 
NO     
DIAG_MPS (Oracle)
MPS_INTFC_DVC
DVC_ID 
NO     

Device Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Device Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Device Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Device Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DAC Dvc Id 
Base Entity  MPS Interface Device 
Attribute Name  Device Identifer 
Logical Rolename  DAC Dvc Id 
ColumnName  DAC_DVC_ID 
RoleName  DAC_DVC_ID 
Domain  Device Id 
Logical Only  NO 
Definition 
Device Identifier: The unique identifier for the device. The identifier consists of the concatenation of the following fields:  System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance.
 
Note 
 

DAC Dvc Id Logical Attribute Properties 
Logical Attribute Name  Device Identifer 
Datatype  VARCHAR(50) 
Nullable  NO 

DAC Dvc Id Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

DAC Dvc Id Security Types 
Name  Current Value 

DAC Dvc Id Bound Attachments 
Name  Current Value 

DAC Dvc Id Data Movement Rules 
Name  Type  Rule Text/Value 

DAC Dvc Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
MPS Interface Device
Device Identifer 
NO     
DIAG_MPS (Oracle)
MPS_INTFC_DVC
DVC_ID 
NO     

DAC Dvc Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DAC Dvc Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DAC Dvc Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DAC Dvc Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description