DVC_ID 
Base Object  DVC_SETTING 
Attribute Name  DVC_ID 
ColumnName  DVC_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Device Identifier: The unique identifier for the device.  It is represented in the form of a bar code.  The identifier consists of the concatenation of the following fields:  System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance.
 
Note 
 

DVC_ID Column Properties 
Datatype  VARCHAR2(40) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

DVC_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

DVC_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

DVC_ID Security Types 
Name  Current Value 

DVC_ID Bound Attachments 
Name  Current Value 

DVC_ID Data Movement Rules 
Name  Type  Rule Text/Value 

DVC_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Device Setting
Device Identifer 
NO     
EPICS (Oracle)
DVC_SETTING
DVC_ID 
NO     
XAL_OPTICS (Oracle)
DVC_SETTING
DVC_ID 
NO     

DVC_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DVC_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SCENARIO_ID 
Base Object  DVC_SETTING 
Attribute Name  SCENARIO_ID 
ColumnName  SCENARIO_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Scenario Identifier:  The unique identifier for a scenario type.
 
Note 
 

SCENARIO_ID Column Properties 
Datatype  VARCHAR2(50) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SCENARIO_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  17 
Percent Null 

SCENARIO_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SCENARIO_ID Security Types 
Name  Current Value 

SCENARIO_ID Bound Attachments 
Name  Current Value 

SCENARIO_ID Data Movement Rules 
Name  Type  Rule Text/Value 

SCENARIO_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Device Setting
SCENARIO_ID 
NO     
EPICS (Oracle)
DVC_SETTING
SCENARIO_ID 
NO     
XAL_OPTICS (Oracle)
DVC_SETTING
SCENARIO_ID 
NO     

SCENARIO_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SCENARIO_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SCENARIO_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SCENARIO_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SETTING_ID 
Base Object  DVC_SETTING 
Attribute Name  SETTING_ID 
ColumnName  SETTING_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Setting Identifier:  The unique identifier for a setting type.
 
Note 
 

SETTING_ID Column Properties 
Datatype  VARCHAR2(50) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SETTING_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

SETTING_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SETTING_ID Security Types 
Name  Current Value 

SETTING_ID Bound Attachments 
Name  Current Value 

SETTING_ID Data Movement Rules 
Name  Type  Rule Text/Value 

SETTING_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Device Setting
SETTING_ID 
NO     
EPICS (Oracle)
DVC_SETTING
SETTING_ID 
NO     
XAL_OPTICS (Oracle)
DVC_SETTING
SETTING_ID 
NO     

SETTING_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SETTING_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SETTING_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SETTING_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SETTING_VALUE 
Base Object  DVC_SETTING 
Attribute Name  SETTING_VALUE 
ColumnName  SETTING_VALUE 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Setting Value:  Contains the device settings for the beam line device.
 
Note 
 

SETTING_VALUE Column Properties 
Datatype  NUMBER(12, 6) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SETTING_VALUE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

SETTING_VALUE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SETTING_VALUE Security Types 
Name  Current Value 

SETTING_VALUE Bound Attachments 
Name  Current Value 

SETTING_VALUE Data Movement Rules 
Name  Type  Rule Text/Value 

SETTING_VALUE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Device Setting
SETTING_VALUE 
NO     
EPICS (Oracle)
DVC_SETTING
SETTING_VALUE 
NO     
XAL_OPTICS (Oracle)
DVC_SETTING
SETTING_VALUE 
NO     

SETTING_VALUE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SETTING_VALUE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SETTING_VALUE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SETTING_VALUE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description