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 | 0 |
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 | 0 |
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 | 7 |
Percent Null | 0 |
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 | 0 |
MPS_INP_TRIPS Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 0 |
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 | 0 |
MPS_TRIPS Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 0 |
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 | 0 |
MPS_FIRST_HIT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 0 |
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 |