IOC Dvc Id 
Base Entity  IOC Device Assignment 
Attribute Name  IOC Dvc Id 
Logical Rolename   
ColumnName  IOC 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 
 

IOC Dvc Id Logical Attribute Properties 
Logical Attribute Name  IOC Dvc Id 
Datatype  VARCHAR(50) 
Nullable  NO 

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

IOC Dvc Id Security Types 
Name  Current Value 

IOC Dvc Id Bound Attachments 
Name  Current Value 

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

IOC Dvc Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
IOC Device Assignment
IOC Dvc Id 
NO     
EPICS (Oracle)
IOC_DVC_ASGN
IOC Dvc Id 
NO     

IOC Dvc Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

IOC Dvc Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

IOC Dvc Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

IOC Dvc Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Device Identifer 
Base Entity  IOC Device Assignment 
Attribute Name  Device Identifer 
Logical Rolename  Device Identifer 
ColumnName  IOC_DVC_ID 
RoleName  IOC_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 
 

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
IOC Device Assignment
Device Identifer 
NO     
EPICS (Oracle)
IOC_DVC_ASGN
IOC_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 


Device Identifer 
Base Entity  IOC Device Assignment 
Attribute Name  Device Identifer 
Logical Rolename  Device Identifer 
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
IOC Device Assignment
Device Identifer 
NO     
EPICS (Oracle)
IOC_DVC_ASGN
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 


Mod By Uid 
Base Entity  IOC Device Assignment 
Attribute Name  Mod By Uid 
Logical Rolename   
ColumnName  Mod By Uid 
RoleName   
Domain  Mod By Uid 
Logical Only  NO 
Definition 
Modified by Userid:  The database userid of the person who inserted or update a record in the table.
 
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
IOC Device Assignment
Mod By Uid 
NO     
EPICS (Oracle)
IOC_DVC_ASGN
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 


Mod Dte 
Base Entity  IOC Device Assignment 
Attribute Name  Mod Dte 
Logical Rolename   
ColumnName  Mod Dte 
RoleName   
Domain   
Logical Only  NO 
Definition 
Modify Date: The date the record was created or modified.
 
Note 
 

Mod Dte Logical Attribute Properties 
Logical Attribute Name  Mod Dte 
Datatype  DATE 
Nullable  NO 

Mod Dte Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  SYSDATE 
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
IOC Device Assignment
Mod Dte 
NO     
EPICS (Oracle)
IOC_DVC_ASGN
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