Device Identifer 
Base Entity  Diag Elex Dvc 
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
Diag Elex Dvc
Device Identifer 
NO     
EPICS (Oracle)
DIAG_ELEX_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 


IP Addr 
Base Entity  Diag Elex Dvc 
Attribute Name  IP Addr 
Logical Rolename   
ColumnName  IP_ADDR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

IP Addr Logical Attribute Properties 
Logical Attribute Name  IP Addr 
Datatype  VARCHAR(50) 
Nullable  YES 

IP Addr Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
IP Addr Security Types 
Name  Current Value 

IP Addr Bound Attachments 
Name  Current Value 

IP Addr Data Movement Rules 
Name  Type  Rule Text/Value 

IP Addr Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diag Elex Dvc
IP Addr 
NO     
EPICS (Oracle)
DIAG_ELEX_DVC
IP_ADDR 
NO     

IP Addr Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

IP Addr Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

IP Addr Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

IP Addr Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Dsgn Cab Slot Bgn 
Base Entity  Diag Elex Dvc 
Attribute Name  Dsgn Cab Slot Bgn 
Logical Rolename   
ColumnName  DSGN_CAB_SLOT_BGN 
RoleName   
Domain   
Logical Only  NO 
Definition 
Design Cabinet Beginning Slot Number:  The first slot the equipment occupies in the cabinet.
 
Note 
 

Dsgn Cab Slot Bgn Logical Attribute Properties 
Logical Attribute Name  Dsgn Cab Slot Bgn 
Datatype  NUMERIC(3, 0) 
Nullable  YES 

Dsgn Cab Slot Bgn Domain Restrictions 

CheckConstraint  dsgn_cab_slot_end < 46 
Check Constraint Name  SYS_C0014288_1 
Bound Rule   
Declared Default   
Bound Default   
Dsgn Cab Slot Bgn Security Types 
Name  Current Value 

Dsgn Cab Slot Bgn Bound Attachments 
Name  Current Value 

Dsgn Cab Slot Bgn Data Movement Rules 
Name  Type  Rule Text/Value 

Dsgn Cab Slot Bgn Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diag Elex Dvc
Dsgn Cab Slot Bgn 
NO     
EPICS (Oracle)
DIAG_ELEX_DVC
DSGN_CAB_SLOT_BGN 
NO     

Dsgn Cab Slot Bgn Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Dsgn Cab Slot Bgn Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Dsgn Cab Slot Bgn Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Dsgn Cab Slot Bgn Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Dsgn Cab Slot End 
Base Entity  Diag Elex Dvc 
Attribute Name  Dsgn Cab Slot End 
Logical Rolename   
ColumnName  DSGN_CAB_SLOT_END 
RoleName   
Domain   
Logical Only  NO 
Definition 
Design Cabinet Ending Slot Number:  If more than one slot is required for equipment, this field indicates the last slot number used.
 
Note 
 

Dsgn Cab Slot End Logical Attribute Properties 
Logical Attribute Name  Dsgn Cab Slot End 
Datatype  NUMERIC(3, 0) 
Nullable  YES 

Dsgn Cab Slot End Domain Restrictions 

CheckConstraint  dsgn_cab_slot_bgn > 0 
Check Constraint Name  SYS_C0014287_1 
Bound Rule   
Declared Default   
Bound Default   
Dsgn Cab Slot End Security Types 
Name  Current Value 

Dsgn Cab Slot End Bound Attachments 
Name  Current Value 

Dsgn Cab Slot End Data Movement Rules 
Name  Type  Rule Text/Value 

Dsgn Cab Slot End Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diag Elex Dvc
Dsgn Cab Slot End 
NO     
EPICS (Oracle)
DIAG_ELEX_DVC
DSGN_CAB_SLOT_END 
NO     

Dsgn Cab Slot End Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Dsgn Cab Slot End Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Dsgn Cab Slot End Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Dsgn Cab Slot End Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Dsgn Cab Slot Pos Ind 
Base Entity  Diag Elex Dvc 
Attribute Name  Dsgn Cab Slot Pos Ind 
Logical Rolename   
ColumnName  DSGN_CAB_SLOT_POS_IND 
RoleName   
Domain   
Logical Only  NO 
Definition 
Design Cabinet Slot Position Indicator:  Used to indicate how the device is installed into the cabinet.  Valid values include "F - Front" or "B-Back".
 
Note 
 

Dsgn Cab Slot Pos Ind Logical Attribute Properties 
Logical Attribute Name  Dsgn Cab Slot Pos Ind 
Datatype  CHAR(1) 
Nullable  NO 

Dsgn Cab Slot Pos Ind Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'F' 
Bound Default   
Dsgn Cab Slot Pos Ind Security Types 
Name  Current Value 

Dsgn Cab Slot Pos Ind Bound Attachments 
Name  Current Value 

Dsgn Cab Slot Pos Ind Data Movement Rules 
Name  Type  Rule Text/Value 

Dsgn Cab Slot Pos Ind Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diag Elex Dvc
Dsgn Cab Slot Pos Ind 
NO     
EPICS (Oracle)
DIAG_ELEX_DVC
DSGN_CAB_SLOT_POS_IND 
NO     

Dsgn Cab Slot Pos Ind Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Dsgn Cab Slot Pos Ind Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Dsgn Cab Slot Pos Ind Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Dsgn Cab Slot Pos Ind Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Pos Within Slots 
Base Entity  Diag Elex Dvc 
Attribute Name  Pos Within Slots 
Logical Rolename   
ColumnName  POS_WITHIN_SLOTS 
RoleName   
Domain   
Logical Only  NO 
Definition 
Position Within Slots:  Indicates the relative position of the device in a slot where more than one device is used.
 
Note 
 

Pos Within Slots Logical Attribute Properties 
Logical Attribute Name  Pos Within Slots 
Datatype  NUMERIC(3, 0) 
Nullable  YES 

Pos Within Slots Domain Restrictions 

CheckConstraint  dsgn_cab_slot_pos_ind in ('F','B') 
Check Constraint Name  SYS_C0014289_1 
Bound Rule   
Declared Default   
Bound Default   
Pos Within Slots Security Types 
Name  Current Value 

Pos Within Slots Bound Attachments 
Name  Current Value 

Pos Within Slots Data Movement Rules 
Name  Type  Rule Text/Value 

Pos Within Slots Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Diag Elex Dvc
Pos Within Slots 
NO     
EPICS (Oracle)
DIAG_ELEX_DVC
POS_WITHIN_SLOTS 
NO     

Pos Within Slots Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Pos Within Slots Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Pos Within Slots Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Pos Within Slots Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description