SGNL_ID 
Base Object  MPS_DAILY_STAT 
Attribute Name  Sgnl Id 
ColumnName  SGNL_ID 
Logical Rolename   
RoleName   
Domain  Signal Id 
Physical Only  NO 
Definition 
Signal Identifier:
 
Note 
 

SGNL_ID Column Properties 
Datatype  VARCHAR2(75) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 

SGNL_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  75 
Percent Null 

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 
EPICS (Oracle)
MPS_DAILY_STAT
SGNL_ID 
NO     
MPS (Oracle)
MPS_DAILY_STAT
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 


MPS_INP_SGNL_ID 
Base Object  MPS_DAILY_STAT 
Attribute Name  Sgnl Id 
ColumnName  MPS_INP_SGNL_ID 
Logical Rolename   
RoleName  MPS_INP_SGNL_ID 
Domain  Signal Id 
Physical Only  NO 
Definition 
Machine Protection System Input Signal Identifier: The signal id which carries the trip signal to MPS from the monitoring device.
 
Note 
 

MPS_INP_SGNL_ID Column Properties 
Datatype  VARCHAR2(75) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 

MPS_INP_SGNL_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  75 
Percent Null 

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

MPS_INP_SGNL_ID Security Types 
Name  Current Value 

MPS_INP_SGNL_ID Bound Attachments 
Name  Current Value 

MPS_INP_SGNL_ID Data Movement Rules 
Name  Type  Rule Text/Value 

MPS_INP_SGNL_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EPICS (Oracle)
MPS_DAILY_STAT
MPS_INP_SGNL_ID 
NO     
MPS (Oracle)
MPS_DAILY_STAT
MPS_INP_SGNL_ID 
NO     

MPS_INP_SGNL_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MPS_INP_SGNL_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MPS_INP_SGNL_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MPS_INP_SGNL_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CUR_DTE 
Base Object  MPS_DAILY_STAT 
Attribute Name  Cur Dte 
ColumnName  CUR_DTE 
Logical Rolename   
RoleName   
Domain  Date 
Physical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

CUR_DTE Column Properties 
Datatype  DATE 
Nullable  NO 

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

CUR_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

CUR_DTE Security Types 
Name  Current Value 

CUR_DTE Bound Attachments 
Name  Current Value 

CUR_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

CUR_DTE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EPICS (Oracle)
MPS_DAILY_STAT
CUR_DTE 
NO     
MPS (Oracle)
MPS_DAILY_STAT
CUR_DTE 
NO     

CUR_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CUR_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CUR_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CUR_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MPS_INP_TRIPS 
Base Object  MPS_DAILY_STAT 
Attribute Name  MPS Inp Trips 
ColumnName  MPS_INP_TRIPS 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Machine Protection System Input Trips: The number of times the input device tripped for specified day.
 
Note 
 

MPS_INP_TRIPS Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  YES 

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

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

MPS_INP_TRIPS Security Types 
Name  Current Value 

MPS_INP_TRIPS Bound Attachments 
Name  Current Value 

MPS_INP_TRIPS Data Movement Rules 
Name  Type  Rule Text/Value 

MPS_INP_TRIPS Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EPICS (Oracle)
MPS_DAILY_STAT
MPS_INP_TRIPS 
NO     
MPS (Oracle)
MPS_DAILY_STAT
MPS_INP_TRIPS 
NO     

MPS_INP_TRIPS Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MPS_INP_TRIPS Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MPS_INP_TRIPS Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MPS_INP_TRIPS Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MPS_TRIPS 
Base Object  MPS_DAILY_STAT 
Attribute Name  MPS Trips 
ColumnName  MPS_TRIPS 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Machine Protection System Trips: The number of times the MPS signal tripped for specified day.
 
Note 
 

MPS_TRIPS Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  YES 

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

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

MPS_TRIPS Security Types 
Name  Current Value 

MPS_TRIPS Bound Attachments 
Name  Current Value 

MPS_TRIPS Data Movement Rules 
Name  Type  Rule Text/Value 

MPS_TRIPS Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EPICS (Oracle)
MPS_DAILY_STAT
MPS_TRIPS 
NO     
MPS (Oracle)
MPS_DAILY_STAT
MPS_TRIPS 
NO     

MPS_TRIPS Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MPS_TRIPS Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MPS_TRIPS Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MPS_TRIPS Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MPS_FIRST_HIT 
Base Object  MPS_DAILY_STAT 
Attribute Name  MPS First Hit 
ColumnName  MPS_FIRST_HIT 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Machine Protection System First Hit: The number of times the signal was the first signal to trip in a correlated cascade of trips (Hence the suspected cause of the cascade) for a specific day.
 
Note 
 

MPS_FIRST_HIT Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  YES 

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

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

MPS_FIRST_HIT Security Types 
Name  Current Value 

MPS_FIRST_HIT Bound Attachments 
Name  Current Value 

MPS_FIRST_HIT Data Movement Rules 
Name  Type  Rule Text/Value 

MPS_FIRST_HIT Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EPICS (Oracle)
MPS_DAILY_STAT
MPS_FIRST_HIT 
NO     
MPS (Oracle)
MPS_DAILY_STAT
MPS_FIRST_HIT 
NO     

MPS_FIRST_HIT Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MPS_FIRST_HIT Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MPS_FIRST_HIT Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MPS_FIRST_HIT Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description