| Component Identifier |
| Base Entity | Process Variable |
| Attribute Name | Component Identifier |
| Logical Rolename | |
| ColumnName | COMPONENT_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | Component Identifier: The id for identification of each component. |
| Note |
| Component Identifier Logical Attribute Properties |
| Logical Attribute Name | Component Identifier |
| Datatype | INTEGER |
| Nullable | NO |
| Component Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Component Identifier Security Types |
| Name | Current Value |
| Component Identifier Bound Attachments |
| Name | Current Value |
| Component Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Component Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Component Identifier |
NO | ||
| ALARM_MYSQL (MySQL) PV COMPONENT_ID |
NO | ||
| ALARM_ORACLE (Oracle) PV COMPONENT_ID |
NO |
| Component Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Component Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Description |
| Base Entity | Process Variable |
| Attribute Name | Description |
| Logical Rolename | |
| ColumnName | DESCR |
| RoleName | |
| Domain | Description |
| Logical Only | NO |
| Definition | Description: Description that might be more meaningful than PV name. |
| Note |
| Description Logical Attribute Properties |
| Logical Attribute Name | Description |
| Datatype | VARCHAR(100) |
| Nullable | YES |
| Description Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Description Security Types |
| Name | Current Value |
| Description Bound Attachments |
| Name | Current Value |
| Description Data Movement Rules |
| Name | Type | Rule Text/Value |
| Description Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Description |
NO | ||
| ALARM_MYSQL (MySQL) PV DESCR |
NO | ||
| ALARM_ORACLE (Oracle) PV DESCR |
NO |
| Description Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Description Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Description Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Description Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Enabled Indicator |
| Base Entity | Process Variable |
| Attribute Name | Enabled Indicator |
| Logical Rolename | |
| ColumnName | ENABLED_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Enabled Indicator: Indicates if alarms are enabled for a given PV. |
| Note |
| Enabled Indicator Logical Attribute Properties |
| Logical Attribute Name | Enabled Indicator |
| Datatype | NUMERIC(1, 0) |
| Nullable | NO |
| Enabled Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0 |
| Bound Default |
| Enabled Indicator Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Enabled Indicator Security Types |
| Name | Current Value |
| Enabled Indicator Bound Attachments |
| Name | Current Value |
| Enabled Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Enabled Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Enabled Indicator |
NO | ||
| ALARM_MYSQL (MySQL) PV ENABLED_IND |
NO | ||
| ALARM_ORACLE (Oracle) PV ENABLED_IND |
NO |
| Enabled Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Enabled Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Enabled Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Enabled Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Annunciate Indicator |
| Base Entity | Process Variable |
| Attribute Name | Annunciate Indicator |
| Logical Rolename | |
| ColumnName | ANNUNCIATE_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Annunciate Indicator: Indicates if alarm should be annunciated. |
| Note |
| Annunciate Indicator Logical Attribute Properties |
| Logical Attribute Name | Annunciate Indicator |
| Datatype | NUMERIC(1, 0) |
| Nullable | NO |
| Annunciate Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0 |
| Bound Default |
| Annunciate Indicator Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Annunciate Indicator Security Types |
| Name | Current Value |
| Annunciate Indicator Bound Attachments |
| Name | Current Value |
| Annunciate Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Annunciate Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Annunciate Indicator |
NO | ||
| ALARM_MYSQL (MySQL) PV ANNUNCIATE_IND |
NO | ||
| ALARM_ORACLE (Oracle) PV ANNUNCIATE_IND |
NO |
| Annunciate Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Annunciate Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Annunciate Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Annunciate Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Latch Indicator |
| Base Entity | Process Variable |
| Attribute Name | Latch Indicator |
| Logical Rolename | |
| ColumnName | LATCH_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Latch Indicator: Indicates that alarm should be latched for acknowledgement, even if PV recovers. |
| Note |
| Latch Indicator Logical Attribute Properties |
| Logical Attribute Name | Latch Indicator |
| Datatype | NUMERIC(1, 0) |
| Nullable | NO |
| Latch Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0 |
| Bound Default |
| Latch Indicator Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Latch Indicator Security Types |
| Name | Current Value |
| Latch Indicator Bound Attachments |
| Name | Current Value |
| Latch Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Latch Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Latch Indicator |
NO | ||
| ALARM_MYSQL (MySQL) PV LATCH_IND |
NO | ||
| ALARM_ORACLE (Oracle) PV LATCH_IND |
NO |
| Latch Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Latch Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Latch Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Latch Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Delay |
| Base Entity | Process Variable |
| Attribute Name | Delay |
| Logical Rolename | |
| ColumnName | DELAY |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Delay: Minimum time in seconds before raising the alarm. |
| Note |
| Delay Logical Attribute Properties |
| Logical Attribute Name | Delay |
| Datatype | INTEGER |
| Nullable | YES |
| Delay Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Delay Security Types |
| Name | Current Value |
| Delay Bound Attachments |
| Name | Current Value |
| Delay Data Movement Rules |
| Name | Type | Rule Text/Value |
| Delay Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Delay |
NO | ||
| ALARM_MYSQL (MySQL) PV DELAY |
NO | ||
| ALARM_ORACLE (Oracle) PV DELAY |
NO |
| Delay Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Delay Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Delay Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Delay Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Filter |
| Base Entity | Process Variable |
| Attribute Name | Filter |
| Logical Rolename | |
| ColumnName | FILTER |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Filter: Filter expression, may be used to compute \'enabled\' from expression. |
| Note |
| Filter Logical Attribute Properties |
| Logical Attribute Name | Filter |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Filter Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Filter Security Types |
| Name | Current Value |
| Filter Bound Attachments |
| Name | Current Value |
| Filter Data Movement Rules |
| Name | Type | Rule Text/Value |
| Filter Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Filter |
NO | ||
| ALARM_MYSQL (MySQL) PV FILTER |
NO | ||
| ALARM_ORACLE (Oracle) PV FILTER |
NO |
| Filter Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Filter Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Filter Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Filter Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Delay Count |
| Base Entity | Process Variable |
| Attribute Name | Delay Count |
| Logical Rolename | |
| ColumnName | DELAY_COUNT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Count: Alarm when PV != OK more often than this count within delay. |
| Note |
| Delay Count Logical Attribute Properties |
| Logical Attribute Name | Delay Count |
| Datatype | INTEGER |
| Nullable | YES |
| Delay Count Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Delay Count Security Types |
| Name | Current Value |
| Delay Count Bound Attachments |
| Name | Current Value |
| Delay Count Data Movement Rules |
| Name | Type | Rule Text/Value |
| Delay Count Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Delay Count |
NO | ||
| ALARM_MYSQL (MySQL) PV DELAY_COUNT |
NO | ||
| ALARM_ORACLE (Oracle) PV DELAY_COUNT |
NO |
| Delay Count Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Delay Count Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Delay Count Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Delay Count Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifer |
| Base Entity | Process Variable |
| Attribute Name | Status Identifer |
| Logical Rolename | |
| ColumnName | STATUS_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Status Identifier: Alarm system state for the severity identifier. |
| Note |
| Status Identifer Logical Attribute Properties |
| Logical Attribute Name | Status Identifer |
| Datatype | INTEGER |
| Nullable | YES |
| Status Identifer Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Status Identifer Security Types |
| Name | Current Value |
| Status Identifer Bound Attachments |
| Name | Current Value |
| Status Identifer Data Movement Rules |
| Name | Type | Rule Text/Value |
| Status Identifer Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Status Identifer |
NO | ||
| ALARM_MYSQL (MySQL) PV STATUS_ID |
NO | ||
| ALARM_ORACLE (Oracle) PV STATUS_ID |
NO |
| Status Identifer Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifer Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifer Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifer Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Severity Identifier |
| Base Entity | Process Variable |
| Attribute Name | Severity Identifier |
| Logical Rolename | |
| ColumnName | SEVERITY_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Severity Identifier: Alarm system severity. |
| Note |
| Severity Identifier Logical Attribute Properties |
| Logical Attribute Name | Severity Identifier |
| Datatype | INTEGER |
| Nullable | YES |
| Severity Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Severity Identifier Security Types |
| Name | Current Value |
| Severity Identifier Bound Attachments |
| Name | Current Value |
| Severity Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Severity Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Severity Identifier |
NO | ||
| ALARM_MYSQL (MySQL) PV SEVERITY_ID |
NO | ||
| ALARM_ORACLE (Oracle) PV SEVERITY_ID |
NO |
| Severity Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Severity Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Severity Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Severity Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Current Severity Identifier |
| Base Entity | Process Variable |
| Attribute Name | Severity Identifier |
| Logical Rolename | Current Severity Identifier |
| ColumnName | CUR_SEVERITY_ID |
| RoleName | CUR_SEVERITY_ID |
| Domain | |
| Logical Only | NO |
| Definition | Current Severity Identifier: Current severity of PV. |
| Note |
| Current Severity Identifier Logical Attribute Properties |
| Logical Attribute Name | Severity Identifier |
| Datatype | INTEGER |
| Nullable | YES |
| Current Severity Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Current Severity Identifier Security Types |
| Name | Current Value |
| Current Severity Identifier Bound Attachments |
| Name | Current Value |
| Current Severity Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Current Severity Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Severity Identifier |
NO | ||
| ALARM_MYSQL (MySQL) PV CUR_SEVERITY_ID |
NO | ||
| ALARM_ORACLE (Oracle) PV CUR_SEVERITY_ID |
NO |
| Current Severity Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Current Severity Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Current Severity Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Current Severity Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Process Variable Value |
| Base Entity | Process Variable |
| Attribute Name | Process Variable Value |
| Logical Rolename | |
| ColumnName | PV_VALUE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Process Variable Value: PV value that caused severity/status. |
| Note |
| Process Variable Value Logical Attribute Properties |
| Logical Attribute Name | Process Variable Value |
| Datatype | VARCHAR(100) |
| Nullable | YES |
| Process Variable Value Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Process Variable Value Security Types |
| Name | Current Value |
| Process Variable Value Bound Attachments |
| Name | Current Value |
| Process Variable Value Data Movement Rules |
| Name | Type | Rule Text/Value |
| Process Variable Value Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Process Variable Value |
NO | ||
| ALARM_MYSQL (MySQL) PV PV_VALUE |
NO | ||
| ALARM_ORACLE (Oracle) PV PV_VALUE |
NO |
| Process Variable Value Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Process Variable Value Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Process Variable Value Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Process Variable Value Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Alarm Time |
| Base Entity | Process Variable |
| Attribute Name | Alarm Time |
| Logical Rolename | |
| ColumnName | ALARM_TIME |
| RoleName | |
| Domain | TimeStamp |
| Logical Only | NO |
| Definition | Alarm Time: The time of the most recent alarm. |
| Note |
| Alarm Time Logical Attribute Properties |
| Logical Attribute Name | Alarm Time |
| Datatype | TIMESTAMP/DATE |
| Nullable | YES |
| Alarm Time Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | systime |
| Bound Default |
| Alarm Time Security Types |
| Name | Current Value |
| Alarm Time Bound Attachments |
| Name | Current Value |
| Alarm Time Data Movement Rules |
| Name | Type | Rule Text/Value |
| Alarm Time Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Alarm Time |
NO | ||
| ALARM_MYSQL (MySQL) PV ALARM_TIME |
NO | ||
| ALARM_ORACLE (Oracle) PV ALARM_TIME |
NO |
| Alarm Time Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Alarm Time Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Alarm Time Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Alarm Time Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Current Status Identifier |
| Base Entity | Process Variable |
| Attribute Name | Current Status Identifier |
| Logical Rolename | |
| ColumnName | CUR_STATUS_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Current Status Identifier Logical Attribute Properties |
| Logical Attribute Name | Current Status Identifier |
| Datatype | INTEGER |
| Nullable | YES |
| Current Status Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Current Status Identifier Security Types |
| Name | Current Value |
| Current Status Identifier Bound Attachments |
| Name | Current Value |
| Current Status Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Current Status Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Current Status Identifier |
NO | ||
| ALARM_MYSQL (MySQL) PV CUR_STATUS_ID |
NO | ||
| ALARM_ORACLE (Oracle) PV CUR_STATUS_ID |
NO |
| Current Status Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Current Status Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Current Status Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Current Status Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Active Global Alarm Indicator |
| Base Entity | Process Variable |
| Attribute Name | Active Global Alarm Indicator |
| Logical Rolename | |
| ColumnName | ACT_GLOBAL_ALARM_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Active Global Alarm Indicator Logical Attribute Properties |
| Logical Attribute Name | Active Global Alarm Indicator |
| Datatype | NUMERIC(1, 0) |
| Nullable | NO |
| Active Global Alarm Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 0 |
| Bound Default |
| Active Global Alarm Indicator Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Active Global Alarm Indicator Security Types |
| Name | Current Value |
| Active Global Alarm Indicator Bound Attachments |
| Name | Current Value |
| Active Global Alarm Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Active Global Alarm Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Process Variable Active Global Alarm Indicator |
NO | ||
| ALARM_MYSQL (MySQL) PV ACT_GLOBAL_ALARM_IND |
NO | ||
| ALARM_ORACLE (Oracle) PV ACT_GLOBAL_ALARM_IND |
NO |
| Active Global Alarm Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Active Global Alarm Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Active Global Alarm Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Active Global Alarm Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |