Regular Asset
Table
Columns
| Property |
Db Table |
Db Column |
Db DataType |
Nullable |
Primary Key |
Joins |
CalendarId |
ampc.asset |
calendar_id |
bigint |
True |
|
|
CalendarCode |
gen.calendar |
code |
character varying(50) |
False |
|
ampc.asset.calendar_id = gen.calendar.calendar_id |
CalendarDescription |
gen.calendar |
description |
character varying(100) |
False |
|
ampc.asset.calendar_id = gen.calendar.calendar_id |
CostCentreId |
ampc.asset |
cost_centre_id |
bigint |
True |
|
|
CostCentreCode |
fin.cost_centre |
code |
character varying(50) |
False |
|
ampc.asset.cost_centre_id = fin.cost_centre.cost_centre_id |
CostCentreDescription |
fin.cost_centre |
description |
character varying(100) |
False |
|
ampc.asset.cost_centre_id = fin.cost_centre.cost_centre_id |
DevelopmentStatus |
ampc.asset |
development_status |
ampc.asset_development_status |
False |
|
|
GeneralLedgerId |
ampc.asset |
general_ledger_id |
bigint |
True |
|
|
GeneralLedgerCode |
fin.general_ledger |
code |
character varying(50) |
False |
|
ampc.asset.general_ledger_id = fin.general_ledger.general_ledger_id |
GeneralLedgerDescription |
fin.general_ledger |
description |
character varying(100) |
False |
|
ampc.asset.general_ledger_id = fin.general_ledger.general_ledger_id |
Id |
ampc.asset |
asset_id |
bigint |
False |
True |
|
IsActive |
ampc.asset |
is_active |
boolean |
False |
|
|
IsHistorical |
ampc.asset |
is_historical |
boolean |
False |
|
|
IsInherited |
ampc.asset |
is_inherited |
boolean |
False |
|
|
IsProposed |
ampc.asset |
is_proposed |
boolean |
False |
|
|
LastConfirmedChangeLogId |
ampc.asset |
last_confirmed_change_log_id |
bigint |
True |
|
|
LastConfirmedOn |
ampc.asset |
last_confirmed_on |
timestamp without time zone |
True |
|
|
LocationId |
ampc.asset |
location_id |
bigint |
True |
|
|
LocationCode |
gen.location |
code |
character varying(50) |
False |
|
ampc.asset.location_id = gen.location.location_id |
LocationDescription |
gen.location |
description |
character varying(500) |
False |
|
ampc.asset.location_id = gen.location.location_id |
NearestRegularAssetId |
ampc.asset |
nearest_regular_asset_id |
bigint |
False |
|
|
ParentAssetId |
ampc.asset |
parent_asset_id |
bigint |
True |
|
|
ParentAssetCode |
ampc.asset |
code |
character varying(50) |
False |
|
ampc.asset.parent_asset_id = ampc.asset.asset_id |
ParentAssetDescription |
ampc.asset |
description |
character varying(100) |
False |
|
ampc.asset.parent_asset_id = ampc.asset.asset_id |
ParentAssetRecordType |
ampc.asset |
record_type |
ampc.asset_record_type |
False |
|
ampc.asset.parent_asset_id = ampc.asset.asset_id |
SequenceNumber |
ampc.asset |
sequence_number |
integer |
True |
|
|
SiteId |
ampc.asset |
site_id |
bigint |
False |
|
|
SiteCode |
gen.site |
code |
character varying |
False |
|
ampc.asset.site_id = gen.site.site_id |
SiteDescription |
gen.site |
description |
character varying |
False |
|
ampc.asset.site_id = gen.site.site_id |
SynchronisedWithTypeObjectUpTo |
ampc.asset |
synchronised_with_type_object_up_to |
timestamp without time zone |
True |
|
|
Unsynchronised |
ampc.asset |
unsynchronised |
boolean |
True |
|
|
RuleEvaluationFailedReason |
ampc.asset |
rule_evaluation_failed_reason |
ampc.rule_evaluation_failed_reason |
True |
|
|
RuleEvaluationPassed |
ampc.asset |
rule_evaluation_passed |
boolean |
False |
|
|
RulesLastEvaluatedOn |
ampc.asset |
rules_last_evaluated_on |
timestamp without time zone |
True |
|
|
Unsubscribed |
ampc.asset |
unsubscribed |
boolean |
False |
|
|
Code |
ampc.asset |
code |
character varying(50) |
False |
|
|
GeographicId |
system.geographic_data |
geographic_data_id |
bigint |
False |
True |
ampc.asset.geographic_data_id = system.geographic_data.geographic_data_id |
GeographicEndPosition |
system.geographic_data |
end_position |
numeric(19,4) |
True |
|
ampc.asset.geographic_data_id = system.geographic_data.geographic_data_id |
GeographicEntityType |
system.geographic_data |
entity_type |
system.entity_type |
False |
|
ampc.asset.geographic_data_id = system.geographic_data.geographic_data_id |
GeographicLength |
system.geographic_data |
length |
numeric(19,4) |
True |
|
ampc.asset.geographic_data_id = system.geographic_data.geographic_data_id |
GeographicLocation |
system.geographic_data |
geog |
geography |
True |
|
ampc.asset.geographic_data_id = system.geographic_data.geographic_data_id |
GeographicNotes |
system.geographic_data |
notes |
text |
True |
|
ampc.asset.geographic_data_id = system.geographic_data.geographic_data_id |
GeographicReferenceEntityId |
system.geographic_data |
reference_entity_id |
bigint |
True |
|
ampc.asset.geographic_data_id = system.geographic_data.geographic_data_id |
GeographicReferenceEntityType |
system.geographic_data |
reference_entity_type |
system.entity_type |
True |
|
ampc.asset.geographic_data_id = system.geographic_data.geographic_data_id |
GeographicStartPosition |
system.geographic_data |
start_position |
numeric(19,4) |
True |
|
ampc.asset.geographic_data_id = system.geographic_data.geographic_data_id |
GeographicUnitOfMeasurementId |
system.geographic_data |
unit_of_measurement_id |
bigint |
True |
|
|
GeographicUnitOfMeasurementDescription |
gen.unit_of_measurement |
description |
character varying(100) |
False |
|
ampc.asset.geographic_data_id = system.geographic_data.geographic_data_id Then
system.geographic_data.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_id |
GeographicUnitOfMeasurementCode |
gen.unit_of_measurement |
code |
character varying(50) |
False |
|
ampc.asset.geographic_data_id = system.geographic_data.geographic_data_id Then
system.geographic_data.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_id |
CreatedByUserId |
ampc.asset |
created_by_user_id |
bigint |
False |
|
|
CreatedByUserCode |
uam.user |
code |
character varying(50) |
False |
|
ampc.asset.created_by_user_id = uam.user.user_id |
CreatedByUserFullName |
uam.user |
full_name |
character varying(200) |
False |
|
ampc.asset.created_by_user_id = uam.user.user_id |
CreatedOn |
ampc.asset |
created_on |
timestamp without time zone |
False |
|
|
ModifiedByUserId |
ampc.asset |
modified_by_user_id |
bigint |
False |
|
|
ModifiedByUserCode |
uam.user |
code |
character varying(50) |
False |
|
ampc.asset.modified_by_user_id = uam.user.user_id |
ModifiedByUserFullName |
uam.user |
full_name |
character varying(200) |
False |
|
ampc.asset.modified_by_user_id = uam.user.user_id |
ModifiedOn |
ampc.asset |
modified_on |
timestamp without time zone |
False |
|
|
Version |
ampc.asset |
version |
integer |
False |
|
|
PermissionTreeId |
ampc.asset |
permission_tree_id |
bigint |
False |
|
|
PermissionTreeCode |
uam.permission_tree |
code |
text |
False |
|
ampc.asset.permission_tree_id = uam.permission_tree.permission_tree_id |
PermissionTreeDescription |
uam.permission_tree |
description |
text |
True |
|
ampc.asset.permission_tree_id = uam.permission_tree.permission_tree_id |
AcquisitionStatusId |
ampc.asset |
acquisition_status_id |
bigint |
True |
|
|
AcquisitionStatusCode |
avm.acquisition_status |
code |
character varying(50) |
False |
|
ampc.asset.acquisition_status_id = avm.acquisition_status.acquisition_status_id |
AcquisitionStatusDescription |
avm.acquisition_status |
description |
character varying(100) |
False |
|
ampc.asset.acquisition_status_id = avm.acquisition_status.acquisition_status_id |
AcquisitionTypeId |
ampc.asset |
acquisition_type_id |
bigint |
True |
|
|
AcquisitionTypeCode |
avm.acquisition_type |
code |
character varying(50) |
False |
|
ampc.asset.acquisition_type_id = avm.acquisition_type.acquisition_type_id |
AcquisitionTypeDescription |
avm.acquisition_type |
description |
character varying(100) |
False |
|
ampc.asset.acquisition_type_id = avm.acquisition_type.acquisition_type_id |
AssetImportanceId |
ampc.asset |
asset_importance_id |
bigint |
True |
|
|
AssetImportanceCode |
risk.asset_importance |
code |
character varying(50) |
False |
|
ampc.asset.asset_importance_id = risk.asset_importance.asset_importance_id |
AssetImportanceDescription |
risk.asset_importance |
description |
character varying(100) |
False |
|
ampc.asset.asset_importance_id = risk.asset_importance.asset_importance_id |
AssetTypeId |
ampc.asset |
asset_type_id |
bigint |
True |
|
|
AssetTypeCode |
ampc.asset_type |
code |
character varying(50) |
False |
|
ampc.asset.asset_type_id = ampc.asset_type.asset_type_id |
AssetTypeDescription |
ampc.asset_type |
description |
character varying(100) |
False |
|
ampc.asset.asset_type_id = ampc.asset_type.asset_type_id |
Barcode |
ampc.asset |
barcode |
character varying(900) |
True |
|
|
BudgetedReplacementAmount |
ampc.asset |
budgeted_replacement_amount |
numeric(19,2) |
True |
|
|
CommissionedOn |
ampc.asset |
commissioned_on |
date |
True |
|
|
CommissioningWorkOrderId |
ampc.asset |
commissioning_work_order_id |
bigint |
True |
|
|
CommissioningWorkOrderCode |
wm.work_order |
code |
character varying(50) |
False |
|
ampc.asset.commissioning_work_order_id = wm.work_order.work_order_id |
CommissioningWorkOrderDescription |
wm.work_order |
description |
character varying(100) |
False |
|
ampc.asset.commissioning_work_order_id = wm.work_order.work_order_id |
CurrentValue |
ampc.asset |
current_value |
numeric(19,2) |
True |
|
|
DateOfCurrentValue |
ampc.asset |
date_of_current_value |
date |
True |
|
|
Description |
ampc.asset |
description |
character varying(100) |
False |
|
|
DowntimeCostPerHour |
ampc.asset |
downtime_cost_per_hour |
numeric(19,2) |
True |
|
|
ExpectedReplacementDate |
ampc.asset |
expected_replacement_date |
date |
True |
|
|
InheritedFromId |
ampc.asset |
inherited_from_id |
bigint |
True |
|
|
InheritedFromLastConfirmedOn |
ampc.asset_type |
last_confirmed_on |
timestamp without time zone |
True |
|
ampc.asset.inherited_from_id = ampc.asset_type.asset_type_id |
InsuredValue |
ampc.asset |
insured_value |
numeric(19,2) |
True |
|
|
IsForScheduledWorkOnly |
ampc.asset |
is_for_scheduled_work_only |
boolean |
False |
|
|
IsMsi |
ampc.asset |
is_msi |
boolean |
False |
|
|
IsOptionsUsed |
ampc.asset |
is_options_used |
boolean |
True |
|
|
IsPermitRequired |
ampc.asset |
is_permit_required |
boolean |
False |
|
|
IsRunning |
ampc.asset |
is_running |
boolean |
False |
|
|
Notes |
ampc.asset |
notes |
text |
True |
|
|
PurchaseAmount |
ampc.asset |
purchase_amount |
numeric(19,2) |
True |
|
|
QRCode |
ampc.asset |
qr_code |
character varying(200) |
True |
|
|
RecordType |
ampc.asset |
record_type |
ampc.asset_record_type |
False |
|
|
ReplacementAssetId |
ampc.asset |
replacement_asset_id |
bigint |
True |
|
|
ReplacementAssetCode |
ampc.asset |
code |
character varying(50) |
False |
|
ampc.asset.replacement_asset_id = ampc.asset.asset_id |
ReplacementAssetDescription |
ampc.asset |
description |
character varying(100) |
False |
|
ampc.asset.replacement_asset_id = ampc.asset.asset_id |
RFId |
ampc.asset |
rfid |
character varying(200) |
True |
|
|
SerialNumber |
ampc.asset |
serial_number |
character varying(50) |
True |
|
|
SupplierId |
ampc.asset |
supplier_id |
bigint |
True |
|
|
SupplierCode |
gen.supplier |
code |
character varying(50) |
False |
|
ampc.asset.supplier_id = gen.supplier.supplier_id |
SupplierDescription |
gen.supplier |
description |
character varying(100) |
False |
|
ampc.asset.supplier_id = gen.supplier.supplier_id |
TaskRollUpPointId |
ampc.asset |
task_roll_up_point_id |
bigint |
True |
|
|
TaskRollUpPointCode |
ampc.task_roll_up_point |
code |
character varying(50) |
False |
|
ampc.asset.task_roll_up_point_id = ampc.task_roll_up_point.task_roll_up_point_id |
TaskRollUpPointDescription |
ampc.task_roll_up_point |
description |
character varying(100) |
False |
|
ampc.asset.task_roll_up_point_id = ampc.task_roll_up_point.task_roll_up_point_id |
TreePathId |
system.tree_path |
tree_path_id |
bigint |
False |
True |
ampc.asset.tree_path_id = system.tree_path.tree_path_id |
TreePathItems |
system.tree_path |
path_items |
system.tree_path_item[] |
False |
|
ampc.asset.tree_path_id = system.tree_path.tree_path_id |
Warranty |
ampc.asset |
warranty |
ampc.warranty |
True |
|
|
Enumerations
Mapping 1
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| DevelopmentStatus |
AssetDevelopmentStatus |
development_status |
ampc.asset_development_status |
NewAwaitingConfirmation
ModifiedAwaitingConfirmation
DeletedAwaitingConfirmation
DeletedConfirmed
Confirmed
NewUnderDevelopment
ModifiedUnderDevelopment
|
Mapping 2
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| ParentAssetRecordType |
AssetRecordType |
record_type |
ampc.asset_record_type |
Regular
InPlace
EmptyPlaceholder
LinkedPlaceholder
|
Mapping 3
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| RuleEvaluationFailedReason |
RuleEvaluationFailedReason |
rule_evaluation_failed_reason |
ampc.rule_evaluation_failed_reason |
Unknown
ParentFailed
RuleFailed
ChildrenFailed
|
Mapping 4
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| GeographicEntityType |
EntityType |
entity_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
AssetWarranty
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
StandardTaskDocument
TaskImportance
TaskInterval
TaskIntervalType
TaskRollUpPoint
TypeOfWork
RegularAssetTypeTaskSpareRuleLink
InPlaceAssetTypeAttribute
RegularAssetTypeTaskResourceRuleLink
PlaceholderAssetSpare
RegularAssetMonitoringPointTriggerParameter
AssetSpare
AssetTypeSpare
AssetMeter
AssetConsumption
RegularAssetConsumption
PlaceholderAssetConsumption
InPlaceAssetConsumption
WarrantyType
RegularAssetTypeFileAttachment
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
WorkOrderTaskWarranty
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
WorkOrderWarranty
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
SystemOptionFileAttachmentCategory
SystemOptionFileAttachmentFileType
RecordChange
RecordChangeValue
RecordChangeUser
RecordChangeProperty
NotificationEventOutbox
NotificationEventAttachmentOutbox
NotificationOutbox
NotificationOutboxLog
ChangeDataTriggerCriteriaEvaluation
SystemOptionReportServerEntity
SystemOptionReportServerEntityDefaultReport
TemplateMigrationLog
TemplateMigrationLogIntent
ResourceActionMigrationLog
ImportSchema
ImportFile
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
|
Mapping 5
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| GeographicReferenceEntityType |
EntityType |
reference_entity_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
AssetWarranty
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
StandardTaskDocument
TaskImportance
TaskInterval
TaskIntervalType
TaskRollUpPoint
TypeOfWork
RegularAssetTypeTaskSpareRuleLink
InPlaceAssetTypeAttribute
RegularAssetTypeTaskResourceRuleLink
PlaceholderAssetSpare
RegularAssetMonitoringPointTriggerParameter
AssetSpare
AssetTypeSpare
AssetMeter
AssetConsumption
RegularAssetConsumption
PlaceholderAssetConsumption
InPlaceAssetConsumption
WarrantyType
RegularAssetTypeFileAttachment
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
WorkOrderTaskWarranty
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
WorkOrderWarranty
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
SystemOptionFileAttachmentCategory
SystemOptionFileAttachmentFileType
RecordChange
RecordChangeValue
RecordChangeUser
RecordChangeProperty
NotificationEventOutbox
NotificationEventAttachmentOutbox
NotificationOutbox
NotificationOutboxLog
ChangeDataTriggerCriteriaEvaluation
SystemOptionReportServerEntity
SystemOptionReportServerEntityDefaultReport
TemplateMigrationLog
TemplateMigrationLogIntent
ResourceActionMigrationLog
ImportSchema
ImportFile
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
|
Mapping 6
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| RecordType |
AssetRecordType |
record_type |
ampc.asset_record_type |
Regular
InPlace
EmptyPlaceholder
LinkedPlaceholder
|
Mapping 7
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| Warranty |
Warranty |
warranty |
ampc.warranty |
Strict
NonStrict
Expired
|
Queries
The list of example Regular Asset queries can be interpreted using the following legend:
| Legend |
Description |
| Primary Table Alias |
The alias for the ampc.asset 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 |
_a |
False |
False |
| Parameter Name |
Data Type |
Value |
@record_type |
Unknown |
Regular |
@asset_id |
Bigint |
0 |
SELECT
_a.calendar_id AS "CalendarId",
_a.cost_centre_id AS "CostCentreId",
_a.development_status AS "DevelopmentStatus",
_a.general_ledger_id AS "GeneralLedgerId",
_a.asset_id AS "Id",
_a.is_active AS "IsActive",
_a.is_historical AS "IsHistorical",
_a.is_inherited AS "IsInherited",
_a.is_proposed AS "IsProposed",
_a.last_confirmed_change_log_id AS "LastConfirmedChangeLogId",
_a.last_confirmed_on AS "LastConfirmedOn",
_a.location_id AS "LocationId",
_a.nearest_regular_asset_id AS "NearestRegularAssetId",
_a.parent_asset_id AS "ParentAssetId",
_a.sequence_number AS "SequenceNumber",
_a.site_id AS "SiteId",
_a.synchronised_with_type_object_up_to AS "SynchronisedWithTypeObjectUpTo",
_a.unsynchronised AS "Unsynchronised",
_a.rule_evaluation_failed_reason AS "RuleEvaluationFailedReason",
_a.rule_evaluation_passed AS "RuleEvaluationPassed",
_a.rules_last_evaluated_on AS "RulesLastEvaluatedOn",
_a.unsubscribed AS "Unsubscribed",
_a.code AS "Code",
_gd.geographic_data_id AS "GeographicId",
_gd.end_position AS "GeographicEndPosition",
_gd.entity_type AS "GeographicEntityType",
_gd.length AS "GeographicLength",
_gd.geog AS "GeographicLocation",
_gd.notes AS "GeographicNotes",
_gd.reference_entity_id AS "GeographicReferenceEntityId",
_gd.reference_entity_type AS "GeographicReferenceEntityType",
_gd.start_position AS "GeographicStartPosition",
_gd.unit_of_measurement_id AS "GeographicUnitOfMeasurementId",
_a.created_by_user_id AS "CreatedByUserId",
_a.created_on AS "CreatedOn",
_a.modified_by_user_id AS "ModifiedByUserId",
_a.modified_on AS "ModifiedOn",
_a.version AS "Version",
_a.permission_tree_id AS "PermissionTreeId",
_a.acquisition_status_id AS "AcquisitionStatusId",
_a.acquisition_type_id AS "AcquisitionTypeId",
_a.asset_importance_id AS "AssetImportanceId",
_a.asset_type_id AS "AssetTypeId",
_a.barcode AS "Barcode",
_a.budgeted_replacement_amount AS "BudgetedReplacementAmount",
_a.commissioned_on AS "CommissionedOn",
_a.commissioning_work_order_id AS "CommissioningWorkOrderId",
_a.current_value AS "CurrentValue",
_a.date_of_current_value AS "DateOfCurrentValue",
_a.description AS "Description",
_a.downtime_cost_per_hour AS "DowntimeCostPerHour",
_a.expected_replacement_date AS "ExpectedReplacementDate",
_a.inherited_from_id AS "InheritedFromId",
_a.insured_value AS "InsuredValue",
_a.is_for_scheduled_work_only AS "IsForScheduledWorkOnly",
_a.is_msi AS "IsMsi",
_a.is_options_used AS "IsOptionsUsed",
_a.is_permit_required AS "IsPermitRequired",
_a.is_running AS "IsRunning",
_a.notes AS "Notes",
_a.purchase_amount AS "PurchaseAmount",
_a.qr_code AS "QRCode",
_a.record_type AS "RecordType",
_a.replacement_asset_id AS "ReplacementAssetId",
_a.rfid AS "RFId",
_a.serial_number AS "SerialNumber",
_a.supplier_id AS "SupplierId",
_a.task_roll_up_point_id AS "TaskRollUpPointId",
_tp.tree_path_id AS "TreePathId",
_tp.path_items AS "TreePathItems",
_a.warranty AS "Warranty"
FROM
ampc.asset _a
LEFT JOIN system.geographic_data _gd ON _a.geographic_data_id = _gd.geographic_data_id
LEFT JOIN system.tree_path _tp ON _a.tree_path_id = _tp.tree_path_id
WHERE
(_a.record_type = @record_type AND
_a.asset_id >= @asset_id)
Query 2
| Primary Table Alias |
Include References |
Include Permissions |
_a |
True |
False |
| Parameter Name |
Data Type |
Value |
@record_type |
Unknown |
Regular |
@asset_id |
Bigint |
0 |
SELECT
_c.calendar_id AS "CalendarId",
_c.code AS "CalendarCode",
_c.description AS "CalendarDescription",
_cc.cost_centre_id AS "CostCentreId",
_cc.code AS "CostCentreCode",
_cc.description AS "CostCentreDescription",
_a.development_status AS "DevelopmentStatus",
_gl.general_ledger_id AS "GeneralLedgerId",
_gl.code AS "GeneralLedgerCode",
_gl.description AS "GeneralLedgerDescription",
_a.asset_id AS "Id",
_a.is_active AS "IsActive",
_a.is_historical AS "IsHistorical",
_a.is_inherited AS "IsInherited",
_a.is_proposed AS "IsProposed",
_a.last_confirmed_change_log_id AS "LastConfirmedChangeLogId",
_a.last_confirmed_on AS "LastConfirmedOn",
_l.location_id AS "LocationId",
_l.code AS "LocationCode",
_l.description AS "LocationDescription",
_a1.asset_id AS "NearestRegularAssetId",
_a2.asset_id AS "ParentAssetId",
_a2.code AS "ParentAssetCode",
_a2.description AS "ParentAssetDescription",
_a2.record_type AS "ParentAssetRecordType",
_a.sequence_number AS "SequenceNumber",
_s.site_id AS "SiteId",
_s.code AS "SiteCode",
_s.description AS "SiteDescription",
_a.synchronised_with_type_object_up_to AS "SynchronisedWithTypeObjectUpTo",
_a.unsynchronised AS "Unsynchronised",
_a.rule_evaluation_failed_reason AS "RuleEvaluationFailedReason",
_a.rule_evaluation_passed AS "RuleEvaluationPassed",
_a.rules_last_evaluated_on AS "RulesLastEvaluatedOn",
_a.unsubscribed AS "Unsubscribed",
_a.code AS "Code",
_gd.geographic_data_id AS "GeographicId",
_gd.end_position AS "GeographicEndPosition",
_gd.entity_type AS "GeographicEntityType",
_gd.length AS "GeographicLength",
_gd.geog AS "GeographicLocation",
_gd.notes AS "GeographicNotes",
_gd.reference_entity_id AS "GeographicReferenceEntityId",
_gd.reference_entity_type AS "GeographicReferenceEntityType",
_gd.start_position AS "GeographicStartPosition",
_uom.unit_of_measurement_id AS "GeographicUnitOfMeasurementId",
_uom.description AS "GeographicUnitOfMeasurementDescription",
_uom.code AS "GeographicUnitOfMeasurementCode",
_u.user_id AS "CreatedByUserId",
_u.code AS "CreatedByUserCode",
_u.full_name AS "CreatedByUserFullName",
_a.created_on AS "CreatedOn",
_u1.user_id AS "ModifiedByUserId",
_u1.code AS "ModifiedByUserCode",
_u1.full_name AS "ModifiedByUserFullName",
_a.modified_on AS "ModifiedOn",
_a.version AS "Version",
_pt.permission_tree_id AS "PermissionTreeId",
_pt.code AS "PermissionTreeCode",
_pt.description AS "PermissionTreeDescription",
_as.acquisition_status_id AS "AcquisitionStatusId",
_as.code AS "AcquisitionStatusCode",
_as.description AS "AcquisitionStatusDescription",
_at.acquisition_type_id AS "AcquisitionTypeId",
_at.code AS "AcquisitionTypeCode",
_at.description AS "AcquisitionTypeDescription",
_ai.asset_importance_id AS "AssetImportanceId",
_ai.code AS "AssetImportanceCode",
_ai.description AS "AssetImportanceDescription",
_at1.asset_type_id AS "AssetTypeId",
_at1.code AS "AssetTypeCode",
_at1.description AS "AssetTypeDescription",
_a.barcode AS "Barcode",
_a.budgeted_replacement_amount AS "BudgetedReplacementAmount",
_a.commissioned_on AS "CommissionedOn",
_wo.work_order_id AS "CommissioningWorkOrderId",
_wo.code AS "CommissioningWorkOrderCode",
_wo.description AS "CommissioningWorkOrderDescription",
_a.current_value AS "CurrentValue",
_a.date_of_current_value AS "DateOfCurrentValue",
_a.description AS "Description",
_a.downtime_cost_per_hour AS "DowntimeCostPerHour",
_a.expected_replacement_date AS "ExpectedReplacementDate",
_at2.asset_type_id AS "InheritedFromId",
_at2.last_confirmed_on AS "InheritedFromLastConfirmedOn",
_a.insured_value AS "InsuredValue",
_a.is_for_scheduled_work_only AS "IsForScheduledWorkOnly",
_a.is_msi AS "IsMsi",
_a.is_options_used AS "IsOptionsUsed",
_a.is_permit_required AS "IsPermitRequired",
_a.is_running AS "IsRunning",
_a.notes AS "Notes",
_a.purchase_amount AS "PurchaseAmount",
_a.qr_code AS "QRCode",
_a.record_type AS "RecordType",
_a3.asset_id AS "ReplacementAssetId",
_a3.code AS "ReplacementAssetCode",
_a3.description AS "ReplacementAssetDescription",
_a.rfid AS "RFId",
_a.serial_number AS "SerialNumber",
_s1.supplier_id AS "SupplierId",
_s1.code AS "SupplierCode",
_s1.description AS "SupplierDescription",
_trup.task_roll_up_point_id AS "TaskRollUpPointId",
_trup.code AS "TaskRollUpPointCode",
_trup.description AS "TaskRollUpPointDescription",
_tp.tree_path_id AS "TreePathId",
_tp.path_items AS "TreePathItems",
_a.warranty AS "Warranty"
FROM
ampc.asset _a
LEFT JOIN gen.calendar _c ON _a.calendar_id = _c.calendar_id
LEFT JOIN fin.cost_centre _cc ON _a.cost_centre_id = _cc.cost_centre_id
LEFT JOIN fin.general_ledger _gl ON _a.general_ledger_id = _gl.general_ledger_id
LEFT JOIN gen.location _l ON _a.location_id = _l.location_id
LEFT JOIN ampc.asset _a1 ON _a.nearest_regular_asset_id = _a1.asset_id
LEFT JOIN ampc.asset _a2 ON _a.parent_asset_id = _a2.asset_id
JOIN gen.site _s ON _a.site_id = _s.site_id
LEFT JOIN system.geographic_data _gd ON _a.geographic_data_id = _gd.geographic_data_id
LEFT JOIN gen.unit_of_measurement _uom ON _gd.unit_of_measurement_id = _uom.unit_of_measurement_id
JOIN uam.user _u ON _a.created_by_user_id = _u.user_id
JOIN uam.user _u1 ON _a.modified_by_user_id = _u1.user_id
JOIN uam.permission_tree _pt ON _a.permission_tree_id = _pt.permission_tree_id
LEFT JOIN avm.acquisition_status _as ON _a.acquisition_status_id = _as.acquisition_status_id
LEFT JOIN avm.acquisition_type _at ON _a.acquisition_type_id = _at.acquisition_type_id
LEFT JOIN risk.asset_importance _ai ON _a.asset_importance_id = _ai.asset_importance_id
LEFT JOIN ampc.asset_type _at1 ON _a.asset_type_id = _at1.asset_type_id
LEFT JOIN wm.work_order _wo ON _a.commissioning_work_order_id = _wo.work_order_id
LEFT JOIN ampc.asset_type _at2 ON _a.inherited_from_id = _at2.asset_type_id
LEFT JOIN ampc.asset _a3 ON _a.replacement_asset_id = _a3.asset_id
LEFT JOIN gen.supplier _s1 ON _a.supplier_id = _s1.supplier_id
LEFT JOIN ampc.task_roll_up_point _trup ON _a.task_roll_up_point_id = _trup.task_roll_up_point_id
LEFT JOIN system.tree_path _tp ON _a.tree_path_id = _tp.tree_path_id
WHERE
(_a.record_type = @record_type AND
_a.asset_id >= @asset_id)
Query 3
| Primary Table Alias |
Include References |
Include Permissions |
_a |
False |
True |
| Parameter Name |
Data Type |
Value |
@record_type |
Unknown |
Regular |
@asset_id |
Bigint |
0 |
@permission_user_id |
Bigint |
500000000000 |
@permission_id |
Bigint |
10000 |
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
_a.calendar_id AS "CalendarId",
_a.cost_centre_id AS "CostCentreId",
_a.development_status AS "DevelopmentStatus",
_a.general_ledger_id AS "GeneralLedgerId",
_a.asset_id AS "Id",
_a.is_active AS "IsActive",
_a.is_historical AS "IsHistorical",
_a.is_inherited AS "IsInherited",
_a.is_proposed AS "IsProposed",
_a.last_confirmed_change_log_id AS "LastConfirmedChangeLogId",
_a.last_confirmed_on AS "LastConfirmedOn",
_a.location_id AS "LocationId",
_a.nearest_regular_asset_id AS "NearestRegularAssetId",
_a.parent_asset_id AS "ParentAssetId",
_a.sequence_number AS "SequenceNumber",
_a.site_id AS "SiteId",
_a.synchronised_with_type_object_up_to AS "SynchronisedWithTypeObjectUpTo",
_a.unsynchronised AS "Unsynchronised",
_a.rule_evaluation_failed_reason AS "RuleEvaluationFailedReason",
_a.rule_evaluation_passed AS "RuleEvaluationPassed",
_a.rules_last_evaluated_on AS "RulesLastEvaluatedOn",
_a.unsubscribed AS "Unsubscribed",
_a.code AS "Code",
_gd.geographic_data_id AS "GeographicId",
_gd.end_position AS "GeographicEndPosition",
_gd.entity_type AS "GeographicEntityType",
_gd.length AS "GeographicLength",
_gd.geog AS "GeographicLocation",
_gd.notes AS "GeographicNotes",
_gd.reference_entity_id AS "GeographicReferenceEntityId",
_gd.reference_entity_type AS "GeographicReferenceEntityType",
_gd.start_position AS "GeographicStartPosition",
_gd.unit_of_measurement_id AS "GeographicUnitOfMeasurementId",
_a.created_by_user_id AS "CreatedByUserId",
_a.created_on AS "CreatedOn",
_a.modified_by_user_id AS "ModifiedByUserId",
_a.modified_on AS "ModifiedOn",
_a.version AS "Version",
_a.permission_tree_id AS "PermissionTreeId",
_a.acquisition_status_id AS "AcquisitionStatusId",
_a.acquisition_type_id AS "AcquisitionTypeId",
_a.asset_importance_id AS "AssetImportanceId",
_a.asset_type_id AS "AssetTypeId",
_a.barcode AS "Barcode",
_a.budgeted_replacement_amount AS "BudgetedReplacementAmount",
_a.commissioned_on AS "CommissionedOn",
_a.commissioning_work_order_id AS "CommissioningWorkOrderId",
_a.current_value AS "CurrentValue",
_a.date_of_current_value AS "DateOfCurrentValue",
_a.description AS "Description",
_a.downtime_cost_per_hour AS "DowntimeCostPerHour",
_a.expected_replacement_date AS "ExpectedReplacementDate",
_a.inherited_from_id AS "InheritedFromId",
_a.insured_value AS "InsuredValue",
_a.is_for_scheduled_work_only AS "IsForScheduledWorkOnly",
_a.is_msi AS "IsMsi",
_a.is_options_used AS "IsOptionsUsed",
_a.is_permit_required AS "IsPermitRequired",
_a.is_running AS "IsRunning",
_a.notes AS "Notes",
_a.purchase_amount AS "PurchaseAmount",
_a.qr_code AS "QRCode",
_a.record_type AS "RecordType",
_a.replacement_asset_id AS "ReplacementAssetId",
_a.rfid AS "RFId",
_a.serial_number AS "SerialNumber",
_a.supplier_id AS "SupplierId",
_a.task_roll_up_point_id AS "TaskRollUpPointId",
_tp.tree_path_id AS "TreePathId",
_tp.path_items AS "TreePathItems",
_a.warranty AS "Warranty",
_a.permission_tree_id AS "_a_permission_tree_id"
FROM
ampc.asset _a
JOIN permission_tree_ids permission_join ON _a.permission_tree_id = permission_join.permission_tree_id
LEFT JOIN system.geographic_data _gd ON _a.geographic_data_id = _gd.geographic_data_id
LEFT JOIN system.tree_path _tp ON _a.tree_path_id = _tp.tree_path_id
WHERE
(_a.record_type = @record_type AND
_a.asset_id >= @asset_id)
Query 4
| Primary Table Alias |
Include References |
Include Permissions |
_a |
True |
True |
| Parameter Name |
Data Type |
Value |
@record_type |
Unknown |
Regular |
@asset_id |
Bigint |
0 |
@permission_user_id |
Bigint |
500000000000 |
@permission_id |
Bigint |
10000 |
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
_c.calendar_id AS "CalendarId",
_c.code AS "CalendarCode",
_c.description AS "CalendarDescription",
_cc.cost_centre_id AS "CostCentreId",
_cc.code AS "CostCentreCode",
_cc.description AS "CostCentreDescription",
_a.development_status AS "DevelopmentStatus",
_gl.general_ledger_id AS "GeneralLedgerId",
_gl.code AS "GeneralLedgerCode",
_gl.description AS "GeneralLedgerDescription",
_a.asset_id AS "Id",
_a.is_active AS "IsActive",
_a.is_historical AS "IsHistorical",
_a.is_inherited AS "IsInherited",
_a.is_proposed AS "IsProposed",
_a.last_confirmed_change_log_id AS "LastConfirmedChangeLogId",
_a.last_confirmed_on AS "LastConfirmedOn",
_l.location_id AS "LocationId",
_l.code AS "LocationCode",
_l.description AS "LocationDescription",
_a1.asset_id AS "NearestRegularAssetId",
_a2.asset_id AS "ParentAssetId",
_a2.code AS "ParentAssetCode",
_a2.description AS "ParentAssetDescription",
_a2.record_type AS "ParentAssetRecordType",
_a.sequence_number AS "SequenceNumber",
_s.site_id AS "SiteId",
_s.code AS "SiteCode",
_s.description AS "SiteDescription",
_a.synchronised_with_type_object_up_to AS "SynchronisedWithTypeObjectUpTo",
_a.unsynchronised AS "Unsynchronised",
_a.rule_evaluation_failed_reason AS "RuleEvaluationFailedReason",
_a.rule_evaluation_passed AS "RuleEvaluationPassed",
_a.rules_last_evaluated_on AS "RulesLastEvaluatedOn",
_a.unsubscribed AS "Unsubscribed",
_a.code AS "Code",
_gd.geographic_data_id AS "GeographicId",
_gd.end_position AS "GeographicEndPosition",
_gd.entity_type AS "GeographicEntityType",
_gd.length AS "GeographicLength",
_gd.geog AS "GeographicLocation",
_gd.notes AS "GeographicNotes",
_gd.reference_entity_id AS "GeographicReferenceEntityId",
_gd.reference_entity_type AS "GeographicReferenceEntityType",
_gd.start_position AS "GeographicStartPosition",
_uom.unit_of_measurement_id AS "GeographicUnitOfMeasurementId",
_uom.description AS "GeographicUnitOfMeasurementDescription",
_uom.code AS "GeographicUnitOfMeasurementCode",
_u.user_id AS "CreatedByUserId",
_u.code AS "CreatedByUserCode",
_u.full_name AS "CreatedByUserFullName",
_a.created_on AS "CreatedOn",
_u1.user_id AS "ModifiedByUserId",
_u1.code AS "ModifiedByUserCode",
_u1.full_name AS "ModifiedByUserFullName",
_a.modified_on AS "ModifiedOn",
_a.version AS "Version",
_pt.permission_tree_id AS "PermissionTreeId",
_pt.code AS "PermissionTreeCode",
_pt.description AS "PermissionTreeDescription",
_as.acquisition_status_id AS "AcquisitionStatusId",
_as.code AS "AcquisitionStatusCode",
_as.description AS "AcquisitionStatusDescription",
_at.acquisition_type_id AS "AcquisitionTypeId",
_at.code AS "AcquisitionTypeCode",
_at.description AS "AcquisitionTypeDescription",
_ai.asset_importance_id AS "AssetImportanceId",
_ai.code AS "AssetImportanceCode",
_ai.description AS "AssetImportanceDescription",
_at1.asset_type_id AS "AssetTypeId",
_at1.code AS "AssetTypeCode",
_at1.description AS "AssetTypeDescription",
_a.barcode AS "Barcode",
_a.budgeted_replacement_amount AS "BudgetedReplacementAmount",
_a.commissioned_on AS "CommissionedOn",
_wo.work_order_id AS "CommissioningWorkOrderId",
_wo.code AS "CommissioningWorkOrderCode",
_wo.description AS "CommissioningWorkOrderDescription",
_a.current_value AS "CurrentValue",
_a.date_of_current_value AS "DateOfCurrentValue",
_a.description AS "Description",
_a.downtime_cost_per_hour AS "DowntimeCostPerHour",
_a.expected_replacement_date AS "ExpectedReplacementDate",
_at2.asset_type_id AS "InheritedFromId",
_at2.last_confirmed_on AS "InheritedFromLastConfirmedOn",
_a.insured_value AS "InsuredValue",
_a.is_for_scheduled_work_only AS "IsForScheduledWorkOnly",
_a.is_msi AS "IsMsi",
_a.is_options_used AS "IsOptionsUsed",
_a.is_permit_required AS "IsPermitRequired",
_a.is_running AS "IsRunning",
_a.notes AS "Notes",
_a.purchase_amount AS "PurchaseAmount",
_a.qr_code AS "QRCode",
_a.record_type AS "RecordType",
_a3.asset_id AS "ReplacementAssetId",
_a3.code AS "ReplacementAssetCode",
_a3.description AS "ReplacementAssetDescription",
_a.rfid AS "RFId",
_a.serial_number AS "SerialNumber",
_s1.supplier_id AS "SupplierId",
_s1.code AS "SupplierCode",
_s1.description AS "SupplierDescription",
_trup.task_roll_up_point_id AS "TaskRollUpPointId",
_trup.code AS "TaskRollUpPointCode",
_trup.description AS "TaskRollUpPointDescription",
_tp.tree_path_id AS "TreePathId",
_tp.path_items AS "TreePathItems",
_a.warranty AS "Warranty",
_a.permission_tree_id AS "_a_permission_tree_id",
_c.permission_tree_id AS "_c_permission_tree_id",
_cc.permission_tree_id AS "_cc_permission_tree_id",
_gl.permission_tree_id AS "_gl_permission_tree_id",
_l.permission_tree_id AS "_l_permission_tree_id",
_a1.permission_tree_id AS "_a1_permission_tree_id",
_a2.permission_tree_id AS "_a2_permission_tree_id",
_s.permission_tree_id AS "_s_permission_tree_id",
_uom.permission_tree_id AS "_uom_permission_tree_id",
_u.permission_tree_id AS "_u_permission_tree_id",
_u1.permission_tree_id AS "_u1_permission_tree_id",
_as.permission_tree_id AS "_as_permission_tree_id",
_at.permission_tree_id AS "_at_permission_tree_id",
_ai.permission_tree_id AS "_ai_permission_tree_id",
_at1.permission_tree_id AS "_at1_permission_tree_id",
_wo.permission_tree_id AS "_wo_permission_tree_id",
_at2.permission_tree_id AS "_at2_permission_tree_id",
_a3.permission_tree_id AS "_a3_permission_tree_id",
_s1.permission_tree_id AS "_s1_permission_tree_id",
_trup.permission_tree_id AS "_trup_permission_tree_id"
FROM
ampc.asset _a
JOIN permission_tree_ids permission_join ON _a.permission_tree_id = permission_join.permission_tree_id
LEFT JOIN gen.calendar _c ON _a.calendar_id = _c.calendar_id
LEFT JOIN fin.cost_centre _cc ON _a.cost_centre_id = _cc.cost_centre_id
LEFT JOIN fin.general_ledger _gl ON _a.general_ledger_id = _gl.general_ledger_id
LEFT JOIN gen.location _l ON _a.location_id = _l.location_id
LEFT JOIN ampc.asset _a1 ON _a.nearest_regular_asset_id = _a1.asset_id
LEFT JOIN ampc.asset _a2 ON _a.parent_asset_id = _a2.asset_id
JOIN gen.site _s ON _a.site_id = _s.site_id
LEFT JOIN system.geographic_data _gd ON _a.geographic_data_id = _gd.geographic_data_id
LEFT JOIN gen.unit_of_measurement _uom ON _gd.unit_of_measurement_id = _uom.unit_of_measurement_id
JOIN uam.user _u ON _a.created_by_user_id = _u.user_id
JOIN uam.user _u1 ON _a.modified_by_user_id = _u1.user_id
JOIN uam.permission_tree _pt ON _a.permission_tree_id = _pt.permission_tree_id
LEFT JOIN avm.acquisition_status _as ON _a.acquisition_status_id = _as.acquisition_status_id
LEFT JOIN avm.acquisition_type _at ON _a.acquisition_type_id = _at.acquisition_type_id
LEFT JOIN risk.asset_importance _ai ON _a.asset_importance_id = _ai.asset_importance_id
LEFT JOIN ampc.asset_type _at1 ON _a.asset_type_id = _at1.asset_type_id
LEFT JOIN wm.work_order _wo ON _a.commissioning_work_order_id = _wo.work_order_id
LEFT JOIN ampc.asset_type _at2 ON _a.inherited_from_id = _at2.asset_type_id
LEFT JOIN ampc.asset _a3 ON _a.replacement_asset_id = _a3.asset_id
LEFT JOIN gen.supplier _s1 ON _a.supplier_id = _s1.supplier_id
LEFT JOIN ampc.task_roll_up_point _trup ON _a.task_roll_up_point_id = _trup.task_roll_up_point_id
LEFT JOIN system.tree_path _tp ON _a.tree_path_id = _tp.tree_path_id
WHERE
(_a.record_type = @record_type AND
_a.asset_id >= @asset_id)