Operation Group Identifier 
Base Entity  Process Variable Snapshot Signal 
Attribute Name  Operation Group Identifier 
Logical Rolename   
ColumnName  OPER_GRP_ID 
RoleName   
Domain  Operation Group 
Logical Only  NO 
Definition 
Equipment Category  Identifier: The unique identifier for a specific equipment category.
 
Note 
 

Operation Group Identifier Logical Attribute Properties 
Logical Attribute Name  Operation Group Identifier 
Datatype  VARCHAR(10) 
Nullable  NO 

Operation Group Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Operation Group Identifier Security Types 
Name  Current Value 

Operation Group Identifier Bound Attachments 
Name  Current Value 

Operation Group Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Operation Group Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Process Variable Snapshot Signal
Operation Group Identifier 
NO     
EPICS (Oracle)
PV_SNAPSHOT_SGNL
OPER_GRP_ID 
NO     

Operation Group Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Group Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Group Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Operation Group Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Mod Dte 
Base Entity  Process Variable Snapshot Signal 
Attribute Name  Mod Dte 
Logical Rolename   
ColumnName  MOD_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
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
Process Variable Snapshot Signal
Mod Dte 
NO     
EPICS (Oracle)
PV_SNAPSHOT_SGNL
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 


Sgnl Id 
Base Entity  Process Variable Snapshot Signal 
Attribute Name  Sgnl Id 
Logical Rolename   
ColumnName  SGNL_ID 
RoleName   
Domain  Signal Id 
Logical Only  NO 
Definition 
Signal Identifier:
 
Note 
 

Sgnl Id Logical Attribute Properties 
Logical Attribute Name  Sgnl Id 
Datatype  VARCHAR(75) 
Nullable  NO 

Sgnl Id Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Sgnl Id Security Types 
Name  Current Value 

Sgnl Id Bound Attachments 
Name  Current Value 

Sgnl Id Data Movement Rules 
Name  Type  Rule Text/Value 

Sgnl Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Process Variable Snapshot Signal
Sgnl Id 
NO     
EPICS (Oracle)
PV_SNAPSHOT_SGNL
SGNL_ID 
NO     

Sgnl Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sgnl Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sgnl Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sgnl Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Item Number 
Base Entity  Process Variable Snapshot Signal 
Attribute Name  Item Number 
Logical Rolename   
ColumnName  ITEM_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Item Number Logical Attribute Properties 
Logical Attribute Name  Item Number 
Datatype  INTEGER 
Nullable  NO 

Item Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Item Number Security Types 
Name  Current Value 

Item Number Bound Attachments 
Name  Current Value 

Item Number Data Movement Rules 
Name  Type  Rule Text/Value 

Item Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Process Variable Snapshot Signal
Item Number 
NO     
EPICS (Oracle)
PV_SNAPSHOT_SGNL
ITEM_NBR 
NO     

Item Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Item Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Item Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Item Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Rec Type ID 
Base Entity  Process Variable Snapshot Signal 
Attribute Name  Rec Type ID 
Logical Rolename   
ColumnName  Rec Type ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Epics Record Type:  A text field used to categories different EPICS records.
 
Note 
 

Rec Type ID Logical Attribute Properties 
Logical Attribute Name  Rec Type ID 
Datatype  VARCHAR(20) 
Nullable  YES 

Rec Type ID Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Rec Type ID Security Types 
Name  Current Value 

Rec Type ID Bound Attachments 
Name  Current Value 

Rec Type ID Data Movement Rules 
Name  Type  Rule Text/Value 

Rec Type ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Process Variable Snapshot Signal
Rec Type ID 
NO     
EPICS (Oracle)
PV_SNAPSHOT_SGNL
Rec Type ID 
NO     

Rec Type ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Rec Type ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Rec Type ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Rec Type ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Fld Id 
Base Entity  Process Variable Snapshot Signal 
Attribute Name  Fld Id 
Logical Rolename   
ColumnName  FLD_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Field Identifier:
 
Note 
 

Fld Id Logical Attribute Properties 
Logical Attribute Name  Fld Id 
Datatype  VARCHAR(50) 
Nullable  YES 

Fld Id Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Fld Id Security Types 
Name  Current Value 

Fld Id Bound Attachments 
Name  Current Value 

Fld Id Data Movement Rules 
Name  Type  Rule Text/Value 

Fld Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Process Variable Snapshot Signal
Fld Id 
NO     
EPICS (Oracle)
PV_SNAPSHOT_SGNL
FLD_ID 
NO     

Fld Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Fld Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Fld Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Fld Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sgnl Val 
Base Entity  Process Variable Snapshot Signal 
Attribute Name  Sgnl Val 
Logical Rolename   
ColumnName  SGNL_VAL 
RoleName   
Domain   
Logical Only  NO 
Definition 
Set Point Signal Value: The values for the signal at the given timestamp.  Implemented as an Oracle varray.
 
Note 
 

Sgnl Val Logical Attribute Properties 
Logical Attribute Name  Sgnl Val 
Datatype  VARCHAR(15) 
Nullable  YES 

Sgnl Val Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Sgnl Val Security Types 
Name  Current Value 

Sgnl Val Bound Attachments 
Name  Current Value 

Sgnl Val Data Movement Rules 
Name  Type  Rule Text/Value 

Sgnl Val Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Process Variable Snapshot Signal
Sgnl Val 
NO     
EPICS (Oracle)
PV_SNAPSHOT_SGNL
SGNL_VAL 
NO     

Sgnl Val Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sgnl Val Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sgnl Val Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sgnl Val Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description