Table of Contents

Alarm Expression Task

Table

Database Table Entity On Key 5 Conversions On Key 5 Tables Other Entities stored in same Table
Transaction ahm.alarm_expression_task Alarm Expression Task

Columns

Property Db Table Db Column Db DataType Nullable Primary Key Joins
CreatedByUserId ahm.alarm_expression_task created_by_user_id bigint False
CreatedByUserCode uam.user code character varying(50) False ahm.alarm_expression_task.created_by_user_id = uam.user.user_id
CreatedByUserFullName uam.user full_name character varying(200) False ahm.alarm_expression_task.created_by_user_id = uam.user.user_id
CreatedOn ahm.alarm_expression_task created_on timestamp without time zone False
ModifiedByUserId ahm.alarm_expression_task modified_by_user_id bigint False
ModifiedByUserCode uam.user code character varying(50) False ahm.alarm_expression_task.modified_by_user_id = uam.user.user_id
ModifiedByUserFullName uam.user full_name character varying(200) False ahm.alarm_expression_task.modified_by_user_id = uam.user.user_id
ModifiedOn ahm.alarm_expression_task modified_on timestamp without time zone False
Version ahm.alarm_expression_task version integer False
Id ahm.alarm_expression_task alarm_expression_task_id bigint False True
AlarmExpressionId ahm.alarm_expression_task alarm_expression_id bigint False
AlarmExpressionAlarmId ahm.alarm alarm_id bigint False True ahm.alarm_expression_task.alarm_expression_id = ahm.alarm_expression.alarm_expression_id Then
ahm.alarm_expression.alarm_id = ahm.alarm.alarm_id
AlarmExpressionAlarmDescription ahm.alarm description character varying(500) False ahm.alarm_expression_task.alarm_expression_id = ahm.alarm_expression.alarm_expression_id Then
ahm.alarm_expression.alarm_id = ahm.alarm.alarm_id
AlarmExpressionMonitoringPointTriggerExpressionId ahm.monitoring_point_trigger_expression monitoring_point_trigger_expression_id bigint False True ahm.alarm_expression_task.alarm_expression_id = ahm.alarm_expression.alarm_expression_id Then
ahm.alarm_expression.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id
AlarmExpressionMonitoringPointTriggerExpressionDescription ahm.monitoring_point_trigger_expression description character varying(100) False ahm.alarm_expression_task.alarm_expression_id = ahm.alarm_expression.alarm_expression_id Then
ahm.alarm_expression.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id
AlarmExpressionMonitoringPointTriggerExpressionExpression ahm.monitoring_point_trigger_expression expression text True ahm.alarm_expression_task.alarm_expression_id = ahm.alarm_expression.alarm_expression_id Then
ahm.alarm_expression.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id
RegularAssetTaskId ahm.alarm_expression_task asset_task_id bigint False
RegularAssetTaskCode ampc.asset_task code character varying(50) False ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id
RegularAssetTaskDescription ampc.asset_task description character varying(255) False ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id
RegularAssetTaskRecordType ampc.asset_task record_type ampc.asset_task_record_type False ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id
RegularAssetTaskAssetId ampc.asset asset_id bigint False True ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id Then
ampc.asset_task.asset_id = ampc.asset.asset_id
RegularAssetTaskAssetCode ampc.asset code character varying(50) False ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id Then
ampc.asset_task.asset_id = ampc.asset.asset_id
RegularAssetTaskAssetDescription ampc.asset description character varying(100) False ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id Then
ampc.asset_task.asset_id = ampc.asset.asset_id
RegularAssetTaskAssetRecordType ampc.asset record_type ampc.asset_record_type False ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id Then
ampc.asset_task.asset_id = ampc.asset.asset_id
RegularAssetTaskComponentId ampc.asset_component asset_component_id bigint False True ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id Then
ampc.asset_task.asset_component_id = ampc.asset_component.asset_component_id
RegularAssetTaskComponentCode ampc.asset_component code character varying(50) False ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id Then
ampc.asset_task.asset_component_id = ampc.asset_component.asset_component_id
RegularAssetTaskComponentDescription ampc.asset_component description character varying(100) False ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id Then
ampc.asset_task.asset_component_id = ampc.asset_component.asset_component_id
RegularAssetTaskComponentRecordType ampc.asset_component record_type ampc.asset_component_record_type False ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id Then
ampc.asset_task.asset_component_id = ampc.asset_component.asset_component_id
RegularAssetTaskSiteId gen.site site_id bigint False True ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id Then
ampc.asset_task.site_id = gen.site.site_id
RegularAssetTaskSiteCode gen.site code character varying False ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id Then
ampc.asset_task.site_id = gen.site.site_id
RegularAssetTaskSiteDescription gen.site description character varying False ahm.alarm_expression_task.asset_task_id = ampc.asset_task.asset_task_id Then
ampc.asset_task.site_id = gen.site.site_id
Status ahm.alarm_expression_task status ahm.alarm_detail_status False

Enumerations

Mapping 1

Property Property Type Db Column Db Column Type Db Column Values
RegularAssetTaskRecordType AssetTaskRecordType record_type ampc.asset_task_record_type Regular
Auxiliary

Mapping 2

Property Property Type Db Column Db Column Type Db Column Values
RegularAssetTaskAssetRecordType AssetRecordType record_type ampc.asset_record_type Regular
InPlace
EmptyPlaceholder
LinkedPlaceholder

Mapping 3

Property Property Type Db Column Db Column Type Db Column Values
RegularAssetTaskComponentRecordType AssetComponentRecordType record_type ampc.asset_component_record_type Regular
EmptyPlaceholder
LinkedPlaceholder

Mapping 4

Property Property Type Db Column Db Column Type Db Column Values
Status AlarmDetailStatus status ahm.alarm_detail_status Active
Handled
Cancelled

Queries

The list of example Alarm Expression Task queries can be interpreted using the following legend:

Legend Description
Primary Table Alias The alias for the ahm.alarm_expression_task table in the query
Include References Include (true) or exclude (false) all lookup table joins in the query
Include Permissions Include (true) or exclude (false) the permission table join in the query to enforce or skip row-level security based on the permissions for the user

Query 1

Primary Table Alias Include References Include Permissions
_aet False False 
SELECT
    _aet.created_by_user_id AS "CreatedByUserId",
    _aet.created_on AS "CreatedOn",
    _aet.modified_by_user_id AS "ModifiedByUserId",
    _aet.modified_on AS "ModifiedOn",
    _aet.version AS "Version",
    _aet.alarm_expression_task_id AS "Id",
    _aet.alarm_expression_id AS "AlarmExpressionId",
    _aet.asset_task_id AS "RegularAssetTaskId",
    _aet.status AS "Status"
FROM
    ahm.alarm_expression_task _aet

Query 2

Primary Table Alias Include References Include Permissions
_aet True False 
SELECT
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _aet.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _aet.modified_on AS "ModifiedOn",
    _aet.version AS "Version",
    _aet.alarm_expression_task_id AS "Id",
    _ae.alarm_expression_id AS "AlarmExpressionId",
    _ae.alarm_id AS "AlarmExpressionAlarm",
    _a.alarm_id AS "AlarmExpressionAlarmId",
    _a.description AS "AlarmExpressionAlarmDescription",
    _ae.monitoring_point_trigger_expression_id AS "AlarmExpressionMonitoringPointTriggerExpression",
    _mpte.monitoring_point_trigger_expression_id AS "AlarmExpressionMonitoringPointTriggerExpressionId",
    _mpte.description AS "AlarmExpressionMonitoringPointTriggerExpressionDescription",
    _mpte.expression AS "AlarmExpressionMonitoringPointTriggerExpressionExpression",
    _at.asset_task_id AS "RegularAssetTaskId",
    _at.code AS "RegularAssetTaskCode",
    _at.description AS "RegularAssetTaskDescription",
    _at.record_type AS "RegularAssetTaskRecordType",
    _at.asset_id AS "RegularAssetTaskAsset",
    _a1.asset_id AS "RegularAssetTaskAssetId",
    _a1.code AS "RegularAssetTaskAssetCode",
    _a1.description AS "RegularAssetTaskAssetDescription",
    _a1.record_type AS "RegularAssetTaskAssetRecordType",
    _at.asset_component_id AS "RegularAssetTaskComponent",
    _ac.asset_component_id AS "RegularAssetTaskComponentId",
    _ac.code AS "RegularAssetTaskComponentCode",
    _ac.description AS "RegularAssetTaskComponentDescription",
    _ac.record_type AS "RegularAssetTaskComponentRecordType",
    _at.site_id AS "RegularAssetTaskSite",
    _s.site_id AS "RegularAssetTaskSiteId",
    _s.code AS "RegularAssetTaskSiteCode",
    _s.description AS "RegularAssetTaskSiteDescription",
    _aet.status AS "Status"
FROM
    ahm.alarm_expression_task _aet
    JOIN uam.user _u ON _aet.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _aet.modified_by_user_id = _u1.user_id
    JOIN ahm.alarm_expression _ae ON _aet.alarm_expression_id = _ae.alarm_expression_id
    JOIN ahm.alarm _a ON _ae.alarm_id = _a.alarm_id
    JOIN ahm.monitoring_point_trigger_expression _mpte ON _ae.monitoring_point_trigger_expression_id = _mpte.monitoring_point_trigger_expression_id
    JOIN ampc.asset_task _at ON _aet.asset_task_id = _at.asset_task_id
    JOIN ampc.asset _a1 ON _at.asset_id = _a1.asset_id
    LEFT JOIN ampc.asset_component _ac ON _at.asset_component_id = _ac.asset_component_id
    JOIN gen.site _s ON _at.site_id = _s.site_id