Asset Type FMECA
Table
| Database |
Table |
Entity |
On Key 5 Conversions |
On Key 5 Tables |
Other Entities stored in same Table |
Transaction |
ampc.asset_type_fmeca |
Asset Type FMECA |
ConvertAssetTypeFmeca
|
astComponentFailureAnalysis
|
|
Columns
| Property |
Db Table |
Db Column |
Db DataType |
Nullable |
Primary Key |
Joins |
DevelopmentStatus |
ampc.asset_type_fmeca |
development_status |
ampc.asset_type_development_status |
True |
|
|
Id |
ampc.asset_type_fmeca |
asset_type_fmeca_id |
bigint |
False |
True |
|
IsActive |
ampc.asset_type_fmeca |
is_active |
boolean |
False |
|
|
IsBackup |
ampc.asset_type_fmeca |
is_backup |
boolean |
False |
|
|
IsInherited |
ampc.asset_type_fmeca |
is_inherited |
boolean |
False |
|
|
LastConfirmedOn |
ampc.asset_type_fmeca |
last_confirmed_on |
timestamp without time zone |
True |
|
|
PreviousDevelopmentStatus |
ampc.asset_type_fmeca |
previous_development_status |
ampc.asset_type_development_status |
True |
|
|
SequenceNumber |
ampc.asset_type_fmeca |
sequence_number |
integer |
True |
|
|
CreatedByUserId |
ampc.asset_type_fmeca |
created_by_user_id |
bigint |
False |
|
|
CreatedByUserCode |
uam.user |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.created_by_user_id = uam.user.user_id |
CreatedByUserFullName |
uam.user |
full_name |
character varying(200) |
False |
|
ampc.asset_type_fmeca.created_by_user_id = uam.user.user_id |
CreatedOn |
ampc.asset_type_fmeca |
created_on |
timestamp without time zone |
False |
|
|
ModifiedByUserId |
ampc.asset_type_fmeca |
modified_by_user_id |
bigint |
False |
|
|
ModifiedByUserCode |
uam.user |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.modified_by_user_id = uam.user.user_id |
ModifiedByUserFullName |
uam.user |
full_name |
character varying(200) |
False |
|
ampc.asset_type_fmeca.modified_by_user_id = uam.user.user_id |
ModifiedOn |
ampc.asset_type_fmeca |
modified_on |
timestamp without time zone |
False |
|
|
Version |
ampc.asset_type_fmeca |
version |
integer |
False |
|
|
PermissionTreeId |
ampc.asset_type_fmeca |
permission_tree_id |
bigint |
False |
|
|
PermissionTreeCode |
uam.permission_tree |
code |
text |
False |
|
ampc.asset_type_fmeca.permission_tree_id = uam.permission_tree.permission_tree_id |
PermissionTreeDescription |
uam.permission_tree |
description |
text |
True |
|
ampc.asset_type_fmeca.permission_tree_id = uam.permission_tree.permission_tree_id |
AssetTypeId |
ampc.asset_type_fmeca |
asset_type_id |
bigint |
False |
|
|
AssetTypeCode |
ampc.asset_type |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.asset_type_id = ampc.asset_type.asset_type_id |
AssetTypeDescription |
ampc.asset_type |
description |
character varying(100) |
False |
|
ampc.asset_type_fmeca.asset_type_id = ampc.asset_type.asset_type_id |
AssetTypeRecordType |
ampc.asset_type |
record_type |
ampc.asset_type_record_type |
False |
|
ampc.asset_type_fmeca.asset_type_id = ampc.asset_type.asset_type_id |
AssetTypeNearestRegularAssetTypeId |
ampc.asset_type |
asset_type_id |
bigint |
False |
True |
ampc.asset_type_fmeca.asset_type_id = ampc.asset_type.asset_type_id Then
ampc.asset_type.nearest_regular_asset_type_id = ampc.asset_type.asset_type_id |
AssetTypeNearestRegularAssetTypeCode |
ampc.asset_type |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.asset_type_id = ampc.asset_type.asset_type_id Then
ampc.asset_type.nearest_regular_asset_type_id = ampc.asset_type.asset_type_id |
AssetTypeNearestRegularAssetTypeDescription |
ampc.asset_type |
description |
character varying(100) |
False |
|
ampc.asset_type_fmeca.asset_type_id = ampc.asset_type.asset_type_id Then
ampc.asset_type.nearest_regular_asset_type_id = ampc.asset_type.asset_type_id |
AssetTypeFunctionId |
ampc.asset_type_fmeca |
asset_type_function_id |
bigint |
True |
|
|
AssetTypeFunctionCode |
ampc.asset_type_function |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.asset_type_function_id = ampc.asset_type_function.asset_type_function_id |
AssetTypeFunctionDescription |
ampc.asset_type_function |
description |
character varying(100) |
True |
|
ampc.asset_type_fmeca.asset_type_function_id = ampc.asset_type_function.asset_type_function_id |
ComponentId |
ampc.asset_type_fmeca |
asset_type_component_id |
bigint |
True |
|
|
ComponentCode |
ampc.asset_type_component |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.asset_type_component_id = ampc.asset_type_component.asset_type_component_id |
ComponentDescription |
ampc.asset_type_component |
description |
character varying(100) |
False |
|
ampc.asset_type_fmeca.asset_type_component_id = ampc.asset_type_component.asset_type_component_id |
ComponentRecordType |
ampc.asset_type_component |
record_type |
ampc.asset_type_component_record_type |
False |
|
ampc.asset_type_fmeca.asset_type_component_id = ampc.asset_type_component.asset_type_component_id |
ComponentAssetTypeId |
ampc.asset_type |
asset_type_id |
bigint |
False |
True |
ampc.asset_type_fmeca.asset_type_component_id = ampc.asset_type_component.asset_type_component_id Then
ampc.asset_type_component.asset_type_id = ampc.asset_type.asset_type_id |
ComponentAssetTypeCode |
ampc.asset_type |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.asset_type_component_id = ampc.asset_type_component.asset_type_component_id Then
ampc.asset_type_component.asset_type_id = ampc.asset_type.asset_type_id |
ComponentAssetTypeDescription |
ampc.asset_type |
description |
character varying(100) |
False |
|
ampc.asset_type_fmeca.asset_type_component_id = ampc.asset_type_component.asset_type_component_id Then
ampc.asset_type_component.asset_type_id = ampc.asset_type.asset_type_id |
ComponentAssetTypeRecordType |
ampc.asset_type |
record_type |
ampc.asset_type_record_type |
False |
|
ampc.asset_type_fmeca.asset_type_component_id = ampc.asset_type_component.asset_type_component_id Then
ampc.asset_type_component.asset_type_id = ampc.asset_type.asset_type_id |
ComponentAssetTypeNearestRegularAssetTypeId |
ampc.asset_type |
asset_type_id |
bigint |
False |
True |
ampc.asset_type_fmeca.asset_type_component_id = ampc.asset_type_component.asset_type_component_id Then
ampc.asset_type_component.asset_type_id = ampc.asset_type.asset_type_id Then
ampc.asset_type.nearest_regular_asset_type_id = ampc.asset_type.asset_type_id |
ComponentAssetTypeNearestRegularAssetTypeCode |
ampc.asset_type |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.asset_type_component_id = ampc.asset_type_component.asset_type_component_id Then
ampc.asset_type_component.asset_type_id = ampc.asset_type.asset_type_id Then
ampc.asset_type.nearest_regular_asset_type_id = ampc.asset_type.asset_type_id |
ComponentAssetTypeNearestRegularAssetTypeDescription |
ampc.asset_type |
description |
character varying(100) |
False |
|
ampc.asset_type_fmeca.asset_type_component_id = ampc.asset_type_component.asset_type_component_id Then
ampc.asset_type_component.asset_type_id = ampc.asset_type.asset_type_id Then
ampc.asset_type.nearest_regular_asset_type_id = ampc.asset_type.asset_type_id |
FailureCauseId |
ampc.asset_type_fmeca |
failure_cause_id |
bigint |
True |
|
|
FailureCauseCode |
ampc.failure_cause |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.failure_cause_id = ampc.failure_cause.failure_cause_id |
FailureCauseDescription |
ampc.failure_cause |
description |
character varying(100) |
False |
|
ampc.asset_type_fmeca.failure_cause_id = ampc.failure_cause.failure_cause_id |
FailureCauseAdditionalInformation |
ampc.asset_type_fmeca |
failure_cause_additional_information |
character varying(255) |
True |
|
|
FailureCauseTypeId |
ampc.asset_type_fmeca |
failure_cause_type_id |
bigint |
True |
|
|
FailureCauseTypeCode |
ampc.failure_cause_type |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.failure_cause_type_id = ampc.failure_cause_type.failure_cause_type_id |
FailureCauseTypeDescription |
ampc.failure_cause_type |
description |
character varying(100) |
False |
|
ampc.asset_type_fmeca.failure_cause_type_id = ampc.failure_cause_type.failure_cause_type_id |
FailureMechanismId |
ampc.asset_type_fmeca |
failure_mechanism_id |
bigint |
True |
|
|
FailureMechanismCode |
ampc.failure_mechanism |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.failure_mechanism_id = ampc.failure_mechanism.failure_mechanism_id |
FailureMechanismDescription |
ampc.failure_mechanism |
description |
character varying(100) |
False |
|
ampc.asset_type_fmeca.failure_mechanism_id = ampc.failure_mechanism.failure_mechanism_id |
FailureMechanismAdditionalInformation |
ampc.asset_type_fmeca |
failure_mechanism_additional_information |
character varying(255) |
True |
|
|
FailureMechanismTypeId |
ampc.asset_type_fmeca |
failure_mechanism_type_id |
bigint |
True |
|
|
FailureMechanismTypeCode |
ampc.failure_mechanism_type |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.failure_mechanism_type_id = ampc.failure_mechanism_type.failure_mechanism_type_id |
FailureMechanismTypeDescription |
ampc.failure_mechanism_type |
description |
character varying(100) |
False |
|
ampc.asset_type_fmeca.failure_mechanism_type_id = ampc.failure_mechanism_type.failure_mechanism_type_id |
FailureModeId |
ampc.asset_type_fmeca |
failure_mode_id |
bigint |
True |
|
|
FailureModeCode |
ampc.failure_mode |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.failure_mode_id = ampc.failure_mode.failure_mode_id |
FailureModeDescription |
ampc.failure_mode |
description |
character varying(100) |
False |
|
ampc.asset_type_fmeca.failure_mode_id = ampc.failure_mode.failure_mode_id |
FailureModeAdditionalInformation |
ampc.asset_type_fmeca |
failure_mode_additional_information |
character varying(255) |
True |
|
|
FailureModeTypeId |
ampc.asset_type_fmeca |
failure_mode_type_id |
bigint |
True |
|
|
FailureModeTypeCode |
ampc.failure_mode_type |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.failure_mode_type_id = ampc.failure_mode_type.failure_mode_type_id |
FailureModeTypeDescription |
ampc.failure_mode_type |
description |
character varying(100) |
False |
|
ampc.asset_type_fmeca.failure_mode_type_id = ampc.failure_mode_type.failure_mode_type_id |
InheritedFromId |
ampc.asset_type_fmeca |
inherited_from_id |
bigint |
True |
|
|
IsFailureEvident |
ampc.asset_type_fmeca |
is_failure_evident |
boolean |
True |
|
|
IsLegacy |
ampc.asset_type_fmeca |
is_legacy |
boolean |
True |
|
|
LinkedToEntityType |
ampc.asset_type_fmeca |
linked_to_entity_type |
system.entity_type |
False |
|
|
Notes |
ampc.asset_type_fmeca |
notes |
text |
True |
|
|
RepairTypeId |
ampc.asset_type_fmeca |
repair_type_id |
bigint |
True |
|
|
RepairTypeCode |
ampc.repair_type |
code |
character varying(50) |
False |
|
ampc.asset_type_fmeca.repair_type_id = ampc.repair_type.repair_type_id |
RepairTypeDescription |
ampc.repair_type |
description |
character varying(100) |
False |
|
ampc.asset_type_fmeca.repair_type_id = ampc.repair_type.repair_type_id |
RepairTypeAdditionalInformation |
ampc.asset_type_fmeca |
repair_type_additional_information |
character varying(255) |
True |
|
|
WarningEffects |
ampc.asset_type_fmeca |
warning_effects |
character varying(255) |
True |
|
|
Enumerations
Mapping 1
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| DevelopmentStatus |
AssetTypeDevelopmentStatus |
development_status |
ampc.asset_type_development_status |
NewUnderDevelopment
NewAwaitingConfirmation
ModifiedUnderDevelopment
ModifiedAwaitingConfirmation
DeletedAwaitingConfirmation
DeletedConfirmed
Confirmed
|
Mapping 2
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| PreviousDevelopmentStatus |
AssetTypeDevelopmentStatus |
previous_development_status |
ampc.asset_type_development_status |
NewUnderDevelopment
NewAwaitingConfirmation
ModifiedUnderDevelopment
ModifiedAwaitingConfirmation
DeletedAwaitingConfirmation
DeletedConfirmed
Confirmed
|
Mapping 3
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| AssetTypeRecordType |
AssetTypeRecordType |
record_type |
ampc.asset_type_record_type |
Folder
Regular
InPlace
EmptyPlaceholder
LinkedPlaceholder
|
Mapping 4
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| ComponentRecordType |
AssetTypeComponentRecordType |
record_type |
ampc.asset_type_component_record_type |
Regular
EmptyPlaceholder
LinkedPlaceholder
|
Mapping 5
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| ComponentAssetTypeRecordType |
AssetTypeRecordType |
record_type |
ampc.asset_type_record_type |
Folder
Regular
InPlace
EmptyPlaceholder
LinkedPlaceholder
|
Mapping 6
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| LinkedToEntityType |
EntityType |
linked_to_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
|
Queries
The list of example Asset Type FMECA queries can be interpreted using the following legend:
| Legend |
Description |
| Primary Table Alias |
The alias for the ampc.asset_type_fmeca 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 |
_atf |
False |
False |
| Parameter Name |
Data Type |
Value |
@asset_type_fmeca_id |
Bigint |
0 |
SELECT
_atf.development_status AS "DevelopmentStatus",
_atf.asset_type_fmeca_id AS "Id",
_atf.is_active AS "IsActive",
_atf.is_backup AS "IsBackup",
_atf.is_inherited AS "IsInherited",
_atf.last_confirmed_on AS "LastConfirmedOn",
_atf.previous_development_status AS "PreviousDevelopmentStatus",
_atf.sequence_number AS "SequenceNumber",
_atf.created_by_user_id AS "CreatedByUserId",
_atf.created_on AS "CreatedOn",
_atf.modified_by_user_id AS "ModifiedByUserId",
_atf.modified_on AS "ModifiedOn",
_atf.version AS "Version",
_atf.permission_tree_id AS "PermissionTreeId",
_atf.asset_type_id AS "AssetTypeId",
_atf.asset_type_function_id AS "AssetTypeFunctionId",
_atf.asset_type_component_id AS "ComponentId",
_atf.failure_cause_id AS "FailureCauseId",
_atf.failure_cause_additional_information AS "FailureCauseAdditionalInformation",
_atf.failure_cause_type_id AS "FailureCauseTypeId",
_atf.failure_mechanism_id AS "FailureMechanismId",
_atf.failure_mechanism_additional_information AS "FailureMechanismAdditionalInformation",
_atf.failure_mechanism_type_id AS "FailureMechanismTypeId",
_atf.failure_mode_id AS "FailureModeId",
_atf.failure_mode_additional_information AS "FailureModeAdditionalInformation",
_atf.failure_mode_type_id AS "FailureModeTypeId",
_atf.inherited_from_id AS "InheritedFromId",
_atf.is_failure_evident AS "IsFailureEvident",
_atf.is_legacy AS "IsLegacy",
_atf.linked_to_entity_type AS "LinkedToEntityType",
_atf.notes AS "Notes",
_atf.repair_type_id AS "RepairTypeId",
_atf.repair_type_additional_information AS "RepairTypeAdditionalInformation",
_atf.warning_effects AS "WarningEffects"
FROM
ampc.asset_type_fmeca _atf
WHERE
(_atf.asset_type_fmeca_id > @asset_type_fmeca_id)
Query 2
| Primary Table Alias |
Include References |
Include Permissions |
_atf |
True |
False |
| Parameter Name |
Data Type |
Value |
@asset_type_fmeca_id |
Bigint |
0 |
SELECT
_atf.development_status AS "DevelopmentStatus",
_atf.asset_type_fmeca_id AS "Id",
_atf.is_active AS "IsActive",
_atf.is_backup AS "IsBackup",
_atf.is_inherited AS "IsInherited",
_atf.last_confirmed_on AS "LastConfirmedOn",
_atf.previous_development_status AS "PreviousDevelopmentStatus",
_atf.sequence_number AS "SequenceNumber",
_u.user_id AS "CreatedByUserId",
_u.code AS "CreatedByUserCode",
_u.full_name AS "CreatedByUserFullName",
_atf.created_on AS "CreatedOn",
_u1.user_id AS "ModifiedByUserId",
_u1.code AS "ModifiedByUserCode",
_u1.full_name AS "ModifiedByUserFullName",
_atf.modified_on AS "ModifiedOn",
_atf.version AS "Version",
_pt.permission_tree_id AS "PermissionTreeId",
_pt.code AS "PermissionTreeCode",
_pt.description AS "PermissionTreeDescription",
_at.asset_type_id AS "AssetTypeId",
_at.code AS "AssetTypeCode",
_at.description AS "AssetTypeDescription",
_at.record_type AS "AssetTypeRecordType",
_at.nearest_regular_asset_type_id AS "AssetTypeNearestRegularAssetType",
_at1.asset_type_id AS "AssetTypeNearestRegularAssetTypeId",
_at1.code AS "AssetTypeNearestRegularAssetTypeCode",
_at1.description AS "AssetTypeNearestRegularAssetTypeDescription",
_atf1.asset_type_function_id AS "AssetTypeFunctionId",
_atf1.code AS "AssetTypeFunctionCode",
_atf1.description AS "AssetTypeFunctionDescription",
_atc.asset_type_component_id AS "ComponentId",
_atc.code AS "ComponentCode",
_atc.description AS "ComponentDescription",
_atc.record_type AS "ComponentRecordType",
_atc.asset_type_id AS "ComponentAssetType",
_at2.asset_type_id AS "ComponentAssetTypeId",
_at2.code AS "ComponentAssetTypeCode",
_at2.description AS "ComponentAssetTypeDescription",
_at2.record_type AS "ComponentAssetTypeRecordType",
_at2.nearest_regular_asset_type_id AS "ComponentAssetTypeNearestRegularAssetType",
_at3.asset_type_id AS "ComponentAssetTypeNearestRegularAssetTypeId",
_at3.code AS "ComponentAssetTypeNearestRegularAssetTypeCode",
_at3.description AS "ComponentAssetTypeNearestRegularAssetTypeDescription",
_fc.failure_cause_id AS "FailureCauseId",
_fc.code AS "FailureCauseCode",
_fc.description AS "FailureCauseDescription",
_atf.failure_cause_additional_information AS "FailureCauseAdditionalInformation",
_fct.failure_cause_type_id AS "FailureCauseTypeId",
_fct.code AS "FailureCauseTypeCode",
_fct.description AS "FailureCauseTypeDescription",
_fm.failure_mechanism_id AS "FailureMechanismId",
_fm.code AS "FailureMechanismCode",
_fm.description AS "FailureMechanismDescription",
_atf.failure_mechanism_additional_information AS "FailureMechanismAdditionalInformation",
_fmt.failure_mechanism_type_id AS "FailureMechanismTypeId",
_fmt.code AS "FailureMechanismTypeCode",
_fmt.description AS "FailureMechanismTypeDescription",
_fm1.failure_mode_id AS "FailureModeId",
_fm1.code AS "FailureModeCode",
_fm1.description AS "FailureModeDescription",
_atf.failure_mode_additional_information AS "FailureModeAdditionalInformation",
_fmt1.failure_mode_type_id AS "FailureModeTypeId",
_fmt1.code AS "FailureModeTypeCode",
_fmt1.description AS "FailureModeTypeDescription",
_atf2.asset_type_fmeca_id AS "InheritedFromId",
_atf.is_failure_evident AS "IsFailureEvident",
_atf.is_legacy AS "IsLegacy",
_atf.linked_to_entity_type AS "LinkedToEntityType",
_atf.notes AS "Notes",
_rt.repair_type_id AS "RepairTypeId",
_rt.code AS "RepairTypeCode",
_rt.description AS "RepairTypeDescription",
_atf.repair_type_additional_information AS "RepairTypeAdditionalInformation",
_atf.warning_effects AS "WarningEffects"
FROM
ampc.asset_type_fmeca _atf
JOIN uam.user _u ON _atf.created_by_user_id = _u.user_id
JOIN uam.user _u1 ON _atf.modified_by_user_id = _u1.user_id
JOIN uam.permission_tree _pt ON _atf.permission_tree_id = _pt.permission_tree_id
JOIN ampc.asset_type _at ON _atf.asset_type_id = _at.asset_type_id
LEFT JOIN ampc.asset_type _at1 ON _at.nearest_regular_asset_type_id = _at1.asset_type_id
LEFT JOIN ampc.asset_type_function _atf1 ON _atf.asset_type_function_id = _atf1.asset_type_function_id
LEFT JOIN ampc.asset_type_component _atc ON _atf.asset_type_component_id = _atc.asset_type_component_id
LEFT JOIN ampc.asset_type _at2 ON _atc.asset_type_id = _at2.asset_type_id
LEFT JOIN ampc.asset_type _at3 ON _at2.nearest_regular_asset_type_id = _at3.asset_type_id
LEFT JOIN ampc.failure_cause _fc ON _atf.failure_cause_id = _fc.failure_cause_id
LEFT JOIN ampc.failure_cause_type _fct ON _atf.failure_cause_type_id = _fct.failure_cause_type_id
LEFT JOIN ampc.failure_mechanism _fm ON _atf.failure_mechanism_id = _fm.failure_mechanism_id
LEFT JOIN ampc.failure_mechanism_type _fmt ON _atf.failure_mechanism_type_id = _fmt.failure_mechanism_type_id
LEFT JOIN ampc.failure_mode _fm1 ON _atf.failure_mode_id = _fm1.failure_mode_id
LEFT JOIN ampc.failure_mode_type _fmt1 ON _atf.failure_mode_type_id = _fmt1.failure_mode_type_id
LEFT JOIN ampc.asset_type_fmeca _atf2 ON _atf.inherited_from_id = _atf2.asset_type_fmeca_id
LEFT JOIN ampc.repair_type _rt ON _atf.repair_type_id = _rt.repair_type_id
WHERE
(_atf.asset_type_fmeca_id > @asset_type_fmeca_id)
Query 3
| Primary Table Alias |
Include References |
Include Permissions |
_atf |
False |
True |
| Parameter Name |
Data Type |
Value |
@asset_type_fmeca_id |
Bigint |
0 |
@permission_user_id |
Bigint |
500000000000 |
@permission_id |
Bigint |
119400 |
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
_atf.development_status AS "DevelopmentStatus",
_atf.asset_type_fmeca_id AS "Id",
_atf.is_active AS "IsActive",
_atf.is_backup AS "IsBackup",
_atf.is_inherited AS "IsInherited",
_atf.last_confirmed_on AS "LastConfirmedOn",
_atf.previous_development_status AS "PreviousDevelopmentStatus",
_atf.sequence_number AS "SequenceNumber",
_atf.created_by_user_id AS "CreatedByUserId",
_atf.created_on AS "CreatedOn",
_atf.modified_by_user_id AS "ModifiedByUserId",
_atf.modified_on AS "ModifiedOn",
_atf.version AS "Version",
_atf.permission_tree_id AS "PermissionTreeId",
_atf.asset_type_id AS "AssetTypeId",
_atf.asset_type_function_id AS "AssetTypeFunctionId",
_atf.asset_type_component_id AS "ComponentId",
_atf.failure_cause_id AS "FailureCauseId",
_atf.failure_cause_additional_information AS "FailureCauseAdditionalInformation",
_atf.failure_cause_type_id AS "FailureCauseTypeId",
_atf.failure_mechanism_id AS "FailureMechanismId",
_atf.failure_mechanism_additional_information AS "FailureMechanismAdditionalInformation",
_atf.failure_mechanism_type_id AS "FailureMechanismTypeId",
_atf.failure_mode_id AS "FailureModeId",
_atf.failure_mode_additional_information AS "FailureModeAdditionalInformation",
_atf.failure_mode_type_id AS "FailureModeTypeId",
_atf.inherited_from_id AS "InheritedFromId",
_atf.is_failure_evident AS "IsFailureEvident",
_atf.is_legacy AS "IsLegacy",
_atf.linked_to_entity_type AS "LinkedToEntityType",
_atf.notes AS "Notes",
_atf.repair_type_id AS "RepairTypeId",
_atf.repair_type_additional_information AS "RepairTypeAdditionalInformation",
_atf.warning_effects AS "WarningEffects",
_atf.permission_tree_id AS "_atf_permission_tree_id"
FROM
ampc.asset_type_fmeca _atf
JOIN permission_tree_ids permission_join ON _atf.permission_tree_id = permission_join.permission_tree_id
WHERE
(_atf.asset_type_fmeca_id > @asset_type_fmeca_id)
Query 4
| Primary Table Alias |
Include References |
Include Permissions |
_atf |
True |
True |
| Parameter Name |
Data Type |
Value |
@asset_type_fmeca_id |
Bigint |
0 |
@permission_user_id |
Bigint |
500000000000 |
@permission_id |
Bigint |
119400 |
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
_atf.development_status AS "DevelopmentStatus",
_atf.asset_type_fmeca_id AS "Id",
_atf.is_active AS "IsActive",
_atf.is_backup AS "IsBackup",
_atf.is_inherited AS "IsInherited",
_atf.last_confirmed_on AS "LastConfirmedOn",
_atf.previous_development_status AS "PreviousDevelopmentStatus",
_atf.sequence_number AS "SequenceNumber",
_u.user_id AS "CreatedByUserId",
_u.code AS "CreatedByUserCode",
_u.full_name AS "CreatedByUserFullName",
_atf.created_on AS "CreatedOn",
_u1.user_id AS "ModifiedByUserId",
_u1.code AS "ModifiedByUserCode",
_u1.full_name AS "ModifiedByUserFullName",
_atf.modified_on AS "ModifiedOn",
_atf.version AS "Version",
_pt.permission_tree_id AS "PermissionTreeId",
_pt.code AS "PermissionTreeCode",
_pt.description AS "PermissionTreeDescription",
_at.asset_type_id AS "AssetTypeId",
_at.code AS "AssetTypeCode",
_at.description AS "AssetTypeDescription",
_at.record_type AS "AssetTypeRecordType",
_at.nearest_regular_asset_type_id AS "AssetTypeNearestRegularAssetType",
_at1.asset_type_id AS "AssetTypeNearestRegularAssetTypeId",
_at1.code AS "AssetTypeNearestRegularAssetTypeCode",
_at1.description AS "AssetTypeNearestRegularAssetTypeDescription",
_atf1.asset_type_function_id AS "AssetTypeFunctionId",
_atf1.code AS "AssetTypeFunctionCode",
_atf1.description AS "AssetTypeFunctionDescription",
_atc.asset_type_component_id AS "ComponentId",
_atc.code AS "ComponentCode",
_atc.description AS "ComponentDescription",
_atc.record_type AS "ComponentRecordType",
_atc.asset_type_id AS "ComponentAssetType",
_at2.asset_type_id AS "ComponentAssetTypeId",
_at2.code AS "ComponentAssetTypeCode",
_at2.description AS "ComponentAssetTypeDescription",
_at2.record_type AS "ComponentAssetTypeRecordType",
_at2.nearest_regular_asset_type_id AS "ComponentAssetTypeNearestRegularAssetType",
_at3.asset_type_id AS "ComponentAssetTypeNearestRegularAssetTypeId",
_at3.code AS "ComponentAssetTypeNearestRegularAssetTypeCode",
_at3.description AS "ComponentAssetTypeNearestRegularAssetTypeDescription",
_fc.failure_cause_id AS "FailureCauseId",
_fc.code AS "FailureCauseCode",
_fc.description AS "FailureCauseDescription",
_atf.failure_cause_additional_information AS "FailureCauseAdditionalInformation",
_fct.failure_cause_type_id AS "FailureCauseTypeId",
_fct.code AS "FailureCauseTypeCode",
_fct.description AS "FailureCauseTypeDescription",
_fm.failure_mechanism_id AS "FailureMechanismId",
_fm.code AS "FailureMechanismCode",
_fm.description AS "FailureMechanismDescription",
_atf.failure_mechanism_additional_information AS "FailureMechanismAdditionalInformation",
_fmt.failure_mechanism_type_id AS "FailureMechanismTypeId",
_fmt.code AS "FailureMechanismTypeCode",
_fmt.description AS "FailureMechanismTypeDescription",
_fm1.failure_mode_id AS "FailureModeId",
_fm1.code AS "FailureModeCode",
_fm1.description AS "FailureModeDescription",
_atf.failure_mode_additional_information AS "FailureModeAdditionalInformation",
_fmt1.failure_mode_type_id AS "FailureModeTypeId",
_fmt1.code AS "FailureModeTypeCode",
_fmt1.description AS "FailureModeTypeDescription",
_atf2.asset_type_fmeca_id AS "InheritedFromId",
_atf.is_failure_evident AS "IsFailureEvident",
_atf.is_legacy AS "IsLegacy",
_atf.linked_to_entity_type AS "LinkedToEntityType",
_atf.notes AS "Notes",
_rt.repair_type_id AS "RepairTypeId",
_rt.code AS "RepairTypeCode",
_rt.description AS "RepairTypeDescription",
_atf.repair_type_additional_information AS "RepairTypeAdditionalInformation",
_atf.warning_effects AS "WarningEffects",
_atf.permission_tree_id AS "_atf_permission_tree_id",
_u.permission_tree_id AS "_u_permission_tree_id",
_u1.permission_tree_id AS "_u1_permission_tree_id",
_at.permission_tree_id AS "_at_permission_tree_id",
_at1.permission_tree_id AS "_at1_permission_tree_id",
_atf1.permission_tree_id AS "_atf1_permission_tree_id",
_atc.permission_tree_id AS "_atc_permission_tree_id",
_at2.permission_tree_id AS "_at2_permission_tree_id",
_at3.permission_tree_id AS "_at3_permission_tree_id",
_fc.permission_tree_id AS "_fc_permission_tree_id",
_fct.permission_tree_id AS "_fct_permission_tree_id",
_fm.permission_tree_id AS "_fm_permission_tree_id",
_fmt.permission_tree_id AS "_fmt_permission_tree_id",
_fm1.permission_tree_id AS "_fm1_permission_tree_id",
_fmt1.permission_tree_id AS "_fmt1_permission_tree_id",
_atf2.permission_tree_id AS "_atf2_permission_tree_id",
_rt.permission_tree_id AS "_rt_permission_tree_id"
FROM
ampc.asset_type_fmeca _atf
JOIN permission_tree_ids permission_join ON _atf.permission_tree_id = permission_join.permission_tree_id
JOIN uam.user _u ON _atf.created_by_user_id = _u.user_id
JOIN uam.user _u1 ON _atf.modified_by_user_id = _u1.user_id
JOIN uam.permission_tree _pt ON _atf.permission_tree_id = _pt.permission_tree_id
JOIN ampc.asset_type _at ON _atf.asset_type_id = _at.asset_type_id
LEFT JOIN ampc.asset_type _at1 ON _at.nearest_regular_asset_type_id = _at1.asset_type_id
LEFT JOIN ampc.asset_type_function _atf1 ON _atf.asset_type_function_id = _atf1.asset_type_function_id
LEFT JOIN ampc.asset_type_component _atc ON _atf.asset_type_component_id = _atc.asset_type_component_id
LEFT JOIN ampc.asset_type _at2 ON _atc.asset_type_id = _at2.asset_type_id
LEFT JOIN ampc.asset_type _at3 ON _at2.nearest_regular_asset_type_id = _at3.asset_type_id
LEFT JOIN ampc.failure_cause _fc ON _atf.failure_cause_id = _fc.failure_cause_id
LEFT JOIN ampc.failure_cause_type _fct ON _atf.failure_cause_type_id = _fct.failure_cause_type_id
LEFT JOIN ampc.failure_mechanism _fm ON _atf.failure_mechanism_id = _fm.failure_mechanism_id
LEFT JOIN ampc.failure_mechanism_type _fmt ON _atf.failure_mechanism_type_id = _fmt.failure_mechanism_type_id
LEFT JOIN ampc.failure_mode _fm1 ON _atf.failure_mode_id = _fm1.failure_mode_id
LEFT JOIN ampc.failure_mode_type _fmt1 ON _atf.failure_mode_type_id = _fmt1.failure_mode_type_id
LEFT JOIN ampc.asset_type_fmeca _atf2 ON _atf.inherited_from_id = _atf2.asset_type_fmeca_id
LEFT JOIN ampc.repair_type _rt ON _atf.repair_type_id = _rt.repair_type_id
WHERE
(_atf.asset_type_fmeca_id > @asset_type_fmeca_id)