Table of Contents

In-Place Asset Meter

Table

Database Table Entity On Key 5 Conversions On Key 5 Tables Other Entities stored in same Table
Transaction ampc.asset_meter In-Place Asset Meter ConvertAssetMeter
astAssetMeters
Regular Asset Meter
Placeholder Asset Meter
Asset Meter

Columns

Property Db Table Db Column Db DataType Nullable Primary Key Joins
IsActive ampc.asset_meter is_active boolean False
CreatedByUserId ampc.asset_meter created_by_user_id bigint False
CreatedByUserCode uam.user code character varying(50) False ampc.asset_meter.created_by_user_id = uam.user.user_id
CreatedByUserFullName uam.user full_name character varying(200) False ampc.asset_meter.created_by_user_id = uam.user.user_id
CreatedOn ampc.asset_meter created_on timestamp without time zone False
ModifiedByUserId ampc.asset_meter modified_by_user_id bigint False
ModifiedByUserCode uam.user code character varying(50) False ampc.asset_meter.modified_by_user_id = uam.user.user_id
ModifiedByUserFullName uam.user full_name character varying(200) False ampc.asset_meter.modified_by_user_id = uam.user.user_id
ModifiedOn ampc.asset_meter modified_on timestamp without time zone False
Version ampc.asset_meter version integer False
PermissionTreeId ampc.asset_meter permission_tree_id bigint False
PermissionTreeCode uam.permission_tree code text False ampc.asset_meter.permission_tree_id = uam.permission_tree.permission_tree_id
PermissionTreeDescription uam.permission_tree description text True ampc.asset_meter.permission_tree_id = uam.permission_tree.permission_tree_id
Id ampc.asset_meter asset_meter_id bigint False True
AssetMeterType ampc.asset_meter asset_meter_type system.entity_type False
InPlaceAssetId ampc.asset_meter asset_id bigint False
InPlaceAssetCode ampc.asset code character varying(50) False ampc.asset_meter.asset_id = ampc.asset.asset_id
InPlaceAssetDescription ampc.asset description character varying(100) False ampc.asset_meter.asset_id = ampc.asset.asset_id
IsMainMeter ampc.asset_meter is_main_meter boolean False
MeterId ampc.asset_meter meter_id bigint False
MeterCode aom.meter code character varying(50) False ampc.asset_meter.meter_id = aom.meter.meter_id
MeterDescription aom.meter description character varying(100) False ampc.asset_meter.meter_id = aom.meter.meter_id
Notes ampc.asset_meter notes text True
SequenceNumber ampc.asset_meter sequence_number integer False

Enumerations

Mapping 1

Property Property Type Db Column Db Column Type Db Column Values
AssetMeterType EntityType asset_meter_type system.entity_type Alarm
NewAlarm
AlarmExpression
AlarmExpressionTask
AlarmAttribute
AlarmDocument
AlarmType
MonitoringPoint
MonitoringPointBoundEvaluationLog
MonitoringPointParameter
MonitoringPointReading
MonitoringPointTrigger
MonitoringPointTriggerExpression
MonitoringPointTriggerExpressionAlarmType
MonitoringPointTriggerExpressionParameter
MonitoringPointTriggerExpressionEvaluation
MonitoringPointTriggerExpressionEvaluationLog
MonitoringPointType
MonitoringPointTypeParameter
MonitoringPointAttribute
MonitoringPointDocument
AuxiliaryAssetTask
AuxiliaryAssetTaskResource
AuxiliaryAssetTaskSpare
AuxiliaryAssetTaskSubTask
RegularAssetComponent
RegularAssetComponentAttribute
RegularAssetComponentDocument
RegularAssetComponentRuleEvaluationFailure
AssetComponent
PlaceholderAssetComponent
PlaceholderAssetComponentOptionValue
PlaceholderAssetComponentCondition
PlaceholderAssetMeter
PlaceholderAssetComponentRuleEvaluationFailure
RegularAssetCondition
RegularAssetActiveCondition
AssetFmeca
RegularAssetOptionValue
Asset
RegularAssetAttribute
RegularAssetDocument
RegularAssetFileAttachment
PlaceholderAsset
PlaceholderAssetAttribute
PlaceholderAssetDocument
PlaceholderAssetFileAttachment
PlaceholderAssetRuleEvaluationFailure
PlaceholderAssetResponsibility
PlaceholderAssetCondition
PlaceholderAssetActiveCondition
AssetTask
SetAssetTaskSpareWarehouseEntity
RegularAssetTask
RegularAssetTaskRuleEvaluationFailure
RegularAssetTaskAttribute
RegularAssetTaskAuxiliaryTask
RegularAssetTaskFollowUpTask
RegularAssetTaskFollowUpTaskExpression
RegularAssetTaskSuppressedTask
RegularAssetTaskResource
RegularAssetTaskResourceRuleEvaluationFailure
RegularAssetTaskSpare
RegularAssetTaskSpareRuleEvaluationFailure
RegularAssetTaskSubTask
RegularAssetTaskFileAttachment
AuxiliaryAssetTypeTask
AuxiliaryAssetTypeTaskResource
AuxiliaryAssetTypeTaskSpare
AuxiliaryAssetTypeTaskSubTask
RegularAssetTypeComponent
RegularAssetTypeComponentAttribute
RegularAssetTypeComponentDocument
AssetTypeComponent
PlaceholderAssetTypeComponent
PlaceholderAssetTypeComponentCondition
PlaceholderAssetTypeComponentAttribute
PlaceholderAssetTypeComponentDocument
PlaceholderAssetTypeComponentRuleLink
RegularAssetTypeComponentRuleLink
PlaceholderAssetComponentAttribute
PlaceholderAssetComponentDocument
PlaceholderAssetComponentActiveCondition
AssetTypeFmeca
AssetTypeFunction
AssetFunction
AssetFmecaTask
AssetTypeFmecaTask
AssetTypeFolder
RegularAssetTypeOption
AssetType
PlaceholderAssetType
PlaceholderAssetTypeSpare
PlaceholderAssetTypeAttribute
PlaceholderAssetTypeDocument
PlaceholderAssetTypeResponsibility
PlaceholderAssetTypeRuleLink
RegularAssetTypeTask
RegularAssetTypeTaskAttribute
RegularAssetTypeTaskAuxiliaryTask
RegularAssetTypeTaskCondition
RegularAssetTypeTaskDocument
RegularAssetTypeTaskFollowUpTask
RegularAssetTypeTaskFollowUpTaskExpression
AssetTypeTask
AssetTypeTaskResource
AssetTaskResource
AssetTaskSpare
AssetTypeTaskSpare
RegularAssetTypeTaskResource
RegularAssetTypeTaskRuleLink
RegularAssetTypeTaskSpare
RegularAssetTypeTaskSubTask
RegularAssetTypeTaskSuppressedTask
Condition
ConditionType
Event
FailureCause
FailureCauseType
FailureMechanism
FailureMechanismType
FailureMode
FailureModeType
InPlaceAssetMeter
InPlaceAssetAttribute
InPlaceAssetFileAttachment
InPlaceAssetRuleEvaluationFailure
InPlaceAssetResponsibility
InPlaceAssetSpare
InPlaceAssetType
InPlaceAssetTypeResponsibility
InPlaceAssetTypeRuleLink
InPlaceAssetTypeSpare
InPlaceAsset
Option
OptionCategory
RegularAsset
RegularAssetTaskDocument
RegularAssetMeter
RegularAssetResponsibility
RegularAssetMonitoringPointTrigger
RegularAssetSpare
RegularAssetTaskCondition
RegularAssetType
RegularAssetTypeAttribute
RegularAssetTypeDocument
RegularAssetTypeCondition
PlaceholderAssetTypeCondition
RegularAssetTypeRule
RegularAssetTypeResponsibility
RegularAssetTypeMonitoringPointTrigger
RegularAssetTypeSpare
RepairType
Rule
RuleCategory
RuleOption
StandardTask
StandardTaskSpare
StandardTaskSubTask
StandardTaskResource
StandardTaskAttribute
TaskImportance
TaskInterval
TaskIntervalType
TaskRollUpPoint
TypeOfWork
RegularAssetTypeTaskSpareRuleLink
InPlaceAssetTypeAttribute
RegularAssetTypeTaskResourceRuleLink
PlaceholderAssetSpare
RegularAssetMonitoringPointTriggerParameter
AssetSpare
AssetTypeSpare
AssetMeter
AssetConsumption
RegularAssetConsumption
PlaceholderAssetConsumption
InPlaceAssetConsumption
Meter
MeterAttribute
MeterDocument
MeterReading
PredictedMeterReading
TimeLossCategory
TimeLossReason
TimeLossType
Consumable
AcquisitionStatus
AcquisitionType
DocumentFolder
DocumentRecord
DocumentRecordAttribute
FileAttachment
FileAttachmentCategory
FileAttachmentContentHistory
DocumentRecordFileHistory
Costing
CostingBudget
CostCentre
CostCentreAttribute
CostCentreDocument
CostCentreType
CostElement
CostElementAttribute
CostElementDocument
Currency
BudgetTemplate
BudgetTemplateParameter
FinancialYear
FinancialYearPeriod
GeneralLedger
GeneralLedgerAttribute
GeneralLedgerDocument
CurrencyRate
Budget
BudgetParameter
AddressType
Approval
Attribute
AttributeAllowedValue
Calendar
CalendarDay
CalendarException
CalendarDayHour
Classification
ClassificationAllowedValue
EmailType
Language
OperationalRole
OperationalRoleTemplate
OperationalRoleResource
PhoneNumberType
UserOperationalRole
UserOperationalRoleTemplate
UserOperationalRoleResource
TermsAndCondition
TermsAndConditionVersion
TermsAndConditionOperationalRole
UserTermsAndConditionVersion
Location
LocationAttribute
LocationDocument
LocalisationSet
LocalisationKey
LocalisationTranslation
Phrase
PhraseTranslation
PreconfiguredReason
Site
SiteAttribute
SiteDocument
SiteType
Supplier
SupplierFileAttachment
SupplierAttribute
SupplierDocument
SupplierContactAddress
SupplierContactEmail
SupplierContactPhoneNumber
SupplierResource
SupplierTaxRate
UnitOfMeasurement
SiteResource
SiteContactAddress
SiteContactEmail
SiteContactPhoneNumber
ChangeDataTrigger
ChangeDataTriggerOccurrenceLog
ChangeDataTriggerCriteria
NotificationTemplate
ChangeDataTriggerCriteriaParameter
ChangeDataTriggerNotificationEvent
NotificationTemplateParameter
ChangeDataTriggerNotificationEventAttachment
ChangeDataTriggerNotificationEventAttachmentParameter
RequestType
Category
Commodity
MaterialMaster
MaterialMasterAttribute
MaterialMasterDocument
MaterialMasterBin
MaterialMasterSupplier
MaterialMasterLinkWarehouse
StockItem
StockItemFileAttachment
StockItemAttribute
StockItemDocument
StockItemBin
StockItemSupplier
WarehouseAttribute
Warehouse
WarehouseDocument
Requisition
RequisitionFileAttachment
RequisitionStatus
RequisitionStatusChange
RequisitionStatusAttribute
RequisitionStatusDocument
RequisitionStatusChangeHistory
RequisitionItemTransaction
ApprovalRole
RequisitionAttribute
RequisitionDocument
RequisitionTransaction
RequisitionItem
RequisitionItemFileAttachment
UserSiteApprovalRole
ApprovalWorkflow
ApprovalWorkflowExpression
ApprovalWorkflowExpressionApprovalRole
Competency
Resource
ResourceAttribute
ResourceAddress
ResourceClassification
ResourceCompetency
ResourceDocument
ResourceEmail
ResourcePhoneNumber
ResourceTrade
ResourceTradeCompetency
ResourceTradeFinancialRate
Section
SectionAttribute
SectionDocument
SectionTrade
TradeAttribute
TradeDocument
Trade
TradeCompetency
TradeFinancialRate
ResourceContext
ResourceFileAttachment
AssetImportance
RiskConsequence
RiskConsequenceCategory
RiskModel
RiskModelConsequenceCategory
RiskModelImportance
RiskModelProbability
RiskProbability
WorkOrderImportance
WorkOrderStatus
WorkOrderStatusAttribute
WorkOrderStatusDocument
WorkOrderStatusAllowedChange
WorkOrder
WorkOrderStatusChangeHistory
WorkOrderStatusChange
WorkOrderMerge
WorkOrderSplit
WorkOrderMeter
WorkOrderAttribute
WorkOrderDocument
WorkOrderFileAttachment
WorkOrderTaskFileAttachment
WorkOrderTaskSpareFileAttachment
WorkOrderTask
WorkOrderTaskDocument
WorkOrderTaskAdHocCost
WorkOrderMonitoringPoint
WorkOrderTaskMonitoringPoint
WorkOrderTaskSpare
WorkOrderTaskSubTask
WorkOrderTaskResource
WorkOrderTaskResourceUsage
DueTask
DueTaskSuppressor
ProposedWorkOrderBatch
ProposedWorkOrder
ProposedWorkOrderTask
ProposedWorkOrderMeter
WorkOrderMovement
WorkOrderTaskMovement
WorkOrderTaskResourceMovement
WorkOrderTaskSpareMovement
WorkOrderTaskSubTaskMovement
WorkOrderCompleteAllTasksLog
WorkRequest
WorkRequestAttribute
WorkRequestDocument
WorkRequestStatus
WorkRequestStatusChange
WorkRequestStatusChangeHistory
WorkRequestFileAttachment
WorkOrderDowntimeLoss
WorkOrderProgressEvent
WorkOrderProgressEventAllowedChange
WorkOrderProgressLog
ServiceLevelAgreementClassification
ServiceLevelAgreement
ServiceLevelAgreementMeasure
WorkOrderServiceLevelAgreement
WorkOrderServiceLevelAgreementMeasure
ServiceLevelAgreementMeasureTrigger
ServiceLevelAgreementMeasureFieldAssignment
PermissionTree
User
UserAttribute
UserDocument
UserAuthentication
SecurityRole
SecurityRolePermission
UserSecurityRole
UserCustomPermission
UserOption
BackgroundTask
BackgroundTaskStep
ScheduledBackgroundTask
ScheduledJob
UserDefinedField
UserDefinedFieldPredefinedValue
SystemOption
SystemOptionPageLimit
SystemOptionWorkOrderStatus
SystemOptionDefaultStandardTask
SystemOptionWorkOrderStatusTypeOfWork
SystemOptionReferenceDataViewPermission
RecordChange
RecordChangeValue
RecordChangeUser
RecordChangeProperty
NotificationEventOutbox
NotificationEventAttachmentOutbox
NotificationOutbox
NotificationOutboxLog
ChangeDataTriggerCriteriaEvaluation
SystemOptionReportServerEntity
SystemOptionReportServerEntityDefaultReport
TemplateMigrationLog
TemplateMigrationLogIntent
ResourceActionMigrationLog
UserDefinedQuery
ResourceActionCustomisation
TemplateCustomisation
TemplateResource
ClusterSettings
ClusterIdentityProviderSettings
MessageBrokerHost
MessageBrokerTopic
MessageBrokerTopicConsumer
TenantSettings
TenantChangeDataSubscriptionSettings
TenantIdentityProviderSettings
TenantJobSettings
TenantFileContentStoreLocationSettings
TenantFileContentStoreFileTypeGroupSettings
TenantFileContentStoreFileTypeSettings
ClusterFeatureToggle
TenantFeatureToggle
TenantHealthCheck
TenantMachineHealthCheck
ClusterHealthCheck
ClusterMachineHealthCheck
ClusterCapacitySlot
TenantChangeLogCleanupExpressionSettings
ClusterJobSettings

Queries

The list of example In-Place Asset Meter queries can be interpreted using the following legend:

Legend Description
Primary Table Alias The alias for the ampc.asset_meter 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
_am False False
Parameter Name Data Type Value
@asset_meter_type Unknown InPlaceAssetMeter
SELECT
    _am.is_active AS "IsActive",
    _am.created_by_user_id AS "CreatedByUserId",
    _am.created_on AS "CreatedOn",
    _am.modified_by_user_id AS "ModifiedByUserId",
    _am.modified_on AS "ModifiedOn",
    _am.version AS "Version",
    _am.permission_tree_id AS "PermissionTreeId",
    _am.asset_meter_id AS "Id",
    _am.asset_meter_type AS "AssetMeterType",
    _am.asset_id AS "InPlaceAssetId",
    _am.is_main_meter AS "IsMainMeter",
    _am.meter_id AS "MeterId",
    _am.notes AS "Notes",
    _am.sequence_number AS "SequenceNumber"
FROM
    ampc.asset_meter _am
WHERE
    (_am.asset_meter_type = @asset_meter_type)


Query 2

Primary Table Alias Include References Include Permissions
_am True False
Parameter Name Data Type Value
@asset_meter_type Unknown InPlaceAssetMeter
SELECT
    _am.is_active AS "IsActive",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _am.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _am.modified_on AS "ModifiedOn",
    _am.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _am.asset_meter_id AS "Id",
    _am.asset_meter_type AS "AssetMeterType",
    _a.asset_id AS "InPlaceAssetId",
    _a.code AS "InPlaceAssetCode",
    _a.description AS "InPlaceAssetDescription",
    _am.is_main_meter AS "IsMainMeter",
    _m.meter_id AS "MeterId",
    _m.code AS "MeterCode",
    _m.description AS "MeterDescription",
    _am.notes AS "Notes",
    _am.sequence_number AS "SequenceNumber"
FROM
    ampc.asset_meter _am
    JOIN uam.user _u ON _am.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _am.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _am.permission_tree_id = _pt.permission_tree_id
    JOIN ampc.asset _a ON _am.asset_id = _a.asset_id
    JOIN aom.meter _m ON _am.meter_id = _m.meter_id
WHERE
    (_am.asset_meter_type = @asset_meter_type)


Query 3

Primary Table Alias Include References Include Permissions
_am False True
Parameter Name Data Type Value
@asset_meter_type Unknown InPlaceAssetMeter
@permission_user_id Bigint 500000000000
@permission_id Bigint 117800
WITH permission_tree_ids AS
(
    SELECT DISTINCT unnest(psd.permission_tree_ids) AS permission_tree_id FROM uam.user_permission up JOIN uam.permission_set_data psd ON up.permission_set_id = psd.permission_set_id WHERE up.user_id = @permission_user_id AND up.permission_id = @permission_id
)
SELECT
    _am.is_active AS "IsActive",
    _am.created_by_user_id AS "CreatedByUserId",
    _am.created_on AS "CreatedOn",
    _am.modified_by_user_id AS "ModifiedByUserId",
    _am.modified_on AS "ModifiedOn",
    _am.version AS "Version",
    _am.permission_tree_id AS "PermissionTreeId",
    _am.asset_meter_id AS "Id",
    _am.asset_meter_type AS "AssetMeterType",
    _am.asset_id AS "InPlaceAssetId",
    _am.is_main_meter AS "IsMainMeter",
    _am.meter_id AS "MeterId",
    _am.notes AS "Notes",
    _am.sequence_number AS "SequenceNumber",
    _am.permission_tree_id AS "_am_permission_tree_id"
FROM
    ampc.asset_meter _am
    JOIN permission_tree_ids permission_join ON _am.permission_tree_id = permission_join.permission_tree_id
WHERE
    (_am.asset_meter_type = @asset_meter_type)


Query 4

Primary Table Alias Include References Include Permissions
_am True True
Parameter Name Data Type Value
@asset_meter_type Unknown InPlaceAssetMeter
@permission_user_id Bigint 500000000000
@permission_id Bigint 117800
WITH permission_tree_ids AS
(
    SELECT DISTINCT unnest(psd.permission_tree_ids) AS permission_tree_id FROM uam.user_permission up JOIN uam.permission_set_data psd ON up.permission_set_id = psd.permission_set_id WHERE up.user_id = @permission_user_id AND up.permission_id = @permission_id
)
SELECT
    _am.is_active AS "IsActive",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _am.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _am.modified_on AS "ModifiedOn",
    _am.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _am.asset_meter_id AS "Id",
    _am.asset_meter_type AS "AssetMeterType",
    _a.asset_id AS "InPlaceAssetId",
    _a.code AS "InPlaceAssetCode",
    _a.description AS "InPlaceAssetDescription",
    _am.is_main_meter AS "IsMainMeter",
    _m.meter_id AS "MeterId",
    _m.code AS "MeterCode",
    _m.description AS "MeterDescription",
    _am.notes AS "Notes",
    _am.sequence_number AS "SequenceNumber",
    _am.permission_tree_id AS "_am_permission_tree_id",
    _u.permission_tree_id AS "_u_permission_tree_id",
    _u1.permission_tree_id AS "_u1_permission_tree_id",
    _a.permission_tree_id AS "_a_permission_tree_id",
    _m.permission_tree_id AS "_m_permission_tree_id"
FROM
    ampc.asset_meter _am
    JOIN permission_tree_ids permission_join ON _am.permission_tree_id = permission_join.permission_tree_id
    JOIN uam.user _u ON _am.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _am.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _am.permission_tree_id = _pt.permission_tree_id
    JOIN ampc.asset _a ON _am.asset_id = _a.asset_id
    JOIN aom.meter _m ON _am.meter_id = _m.meter_id
WHERE
    (_am.asset_meter_type = @asset_meter_type)