Section

Table

Database	Table	Entity	On Key 5 Conversions	On Key 5 Tables	Other Entities stored in same Table
`Transaction`	`res.section`	Section	ConvertSection ConvertSectionGeographicData	`stdGeographicData` `stfSections`

Columns

Property	Db Table	Db Column	Db DataType	Nullable	Primary Key	Joins
`Code`	`res.section`	`code`	character varying(50)	False
`IsActive`	`res.section`	`is_active`	boolean	False
`GeographicId`	`system.geographic_data`	`geographic_data_id`	bigint	False	True	`res.section.geographic_data_id = system.geographic_data.geographic_data_id`
`GeographicEndPosition`	`system.geographic_data`	`end_position`	numeric(19,4)	True		`res.section.geographic_data_id = system.geographic_data.geographic_data_id`
`GeographicEntityType`	`system.geographic_data`	`entity_type`	system.entity_type	False		`res.section.geographic_data_id = system.geographic_data.geographic_data_id`
`GeographicLength`	`system.geographic_data`	`length`	numeric(19,4)	True		`res.section.geographic_data_id = system.geographic_data.geographic_data_id`
`GeographicLocation`	`system.geographic_data`	`geog`	geography	True		`res.section.geographic_data_id = system.geographic_data.geographic_data_id`
`GeographicNotes`	`system.geographic_data`	`notes`	text	True		`res.section.geographic_data_id = system.geographic_data.geographic_data_id`
`GeographicReferenceEntityId`	`system.geographic_data`	`reference_entity_id`	bigint	True		`res.section.geographic_data_id = system.geographic_data.geographic_data_id`
`GeographicReferenceEntityType`	`system.geographic_data`	`reference_entity_type`	system.entity_type	True		`res.section.geographic_data_id = system.geographic_data.geographic_data_id`
`GeographicStartPosition`	`system.geographic_data`	`start_position`	numeric(19,4)	True		`res.section.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		`res.section.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		`res.section.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`	`res.section`	`created_by_user_id`	bigint	False
`CreatedByUserCode`	`uam.user`	`code`	character varying(50)	False		`res.section.created_by_user_id = uam.user.user_id`
`CreatedByUserFullName`	`uam.user`	`full_name`	character varying(200)	False		`res.section.created_by_user_id = uam.user.user_id`
`CreatedOn`	`res.section`	`created_on`	timestamp without time zone	False
`ModifiedByUserId`	`res.section`	`modified_by_user_id`	bigint	False
`ModifiedByUserCode`	`uam.user`	`code`	character varying(50)	False		`res.section.modified_by_user_id = uam.user.user_id`
`ModifiedByUserFullName`	`uam.user`	`full_name`	character varying(200)	False		`res.section.modified_by_user_id = uam.user.user_id`
`ModifiedOn`	`res.section`	`modified_on`	timestamp without time zone	False
`Version`	`res.section`	`version`	integer	False
`PermissionTreeId`	`res.section`	`permission_tree_id`	bigint	False
`PermissionTreeCode`	`uam.permission_tree`	`code`	text	False		`res.section.permission_tree_id = uam.permission_tree.permission_tree_id`
`PermissionTreeDescription`	`uam.permission_tree`	`description`	text	True		`res.section.permission_tree_id = uam.permission_tree.permission_tree_id`
`SiteId`	`res.section`	`site_id`	bigint	True
`SiteCode`	`gen.site`	`code`	character varying	False		`res.section.site_id = gen.site.site_id`
`SiteDescription`	`gen.site`	`description`	character varying	False		`res.section.site_id = gen.site.site_id`
`Id`	`res.section`	`section_id`	bigint	False	True
`Description`	`res.section`	`description`	character varying(100)	False
`Notes`	`res.section`	`notes`	text	True
`SequenceNumber`	`res.section`	`sequence_number`	integer	True
`SupplierId`	`res.section`	`supplier_id`	bigint	True
`SupplierCode`	`gen.supplier`	`code`	character varying(50)	False		`res.section.supplier_id = gen.supplier.supplier_id`
`SupplierDescription`	`gen.supplier`	`description`	character varying(100)	False		`res.section.supplier_id = gen.supplier.supplier_id`

Enumerations

Mapping 1

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

Mapping 2

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

Queries

The list of example Section queries can be interpreted using the following legend:

Legend	Description
Primary Table Alias	The alias for the `res.section` 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
`_s`	False	False

SELECT
    _s.code AS "Code",
    _s.is_active AS "IsActive",
    _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",
    _s.created_by_user_id AS "CreatedByUserId",
    _s.created_on AS "CreatedOn",
    _s.modified_by_user_id AS "ModifiedByUserId",
    _s.modified_on AS "ModifiedOn",
    _s.version AS "Version",
    _s.permission_tree_id AS "PermissionTreeId",
    _s.site_id AS "SiteId",
    _s.section_id AS "Id",
    _s.description AS "Description",
    _s.notes AS "Notes",
    _s.sequence_number AS "SequenceNumber",
    _s.supplier_id AS "SupplierId"
FROM
    res.section _s
    LEFT JOIN system.geographic_data _gd ON _s.geographic_data_id = _gd.geographic_data_id

Query 2

Primary Table Alias	Include References	Include Permissions
`_s`	True	False

SELECT
    _s.code AS "Code",
    _s.is_active AS "IsActive",
    _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",
    _s.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _s.modified_on AS "ModifiedOn",
    _s.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _s1.site_id AS "SiteId",
    _s1.code AS "SiteCode",
    _s1.description AS "SiteDescription",
    _s.section_id AS "Id",
    _s.description AS "Description",
    _s.notes AS "Notes",
    _s.sequence_number AS "SequenceNumber",
    _s2.supplier_id AS "SupplierId",
    _s2.code AS "SupplierCode",
    _s2.description AS "SupplierDescription"
FROM
    res.section _s
    LEFT JOIN system.geographic_data _gd ON _s.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 _s.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _s.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _s.permission_tree_id = _pt.permission_tree_id
    LEFT JOIN gen.site _s1 ON _s.site_id = _s1.site_id
    LEFT JOIN gen.supplier _s2 ON _s.supplier_id = _s2.supplier_id

Query 3

Primary Table Alias	Include References	Include Permissions
`_s`	False	True

Parameter Name	Data Type	Value
`@permission_user_id`	Bigint	`500000000000`
`@permission_id`	Bigint	`70000`

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
    _s.code AS "Code",
    _s.is_active AS "IsActive",
    _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",
    _s.created_by_user_id AS "CreatedByUserId",
    _s.created_on AS "CreatedOn",
    _s.modified_by_user_id AS "ModifiedByUserId",
    _s.modified_on AS "ModifiedOn",
    _s.version AS "Version",
    _s.permission_tree_id AS "PermissionTreeId",
    _s.site_id AS "SiteId",
    _s.section_id AS "Id",
    _s.description AS "Description",
    _s.notes AS "Notes",
    _s.sequence_number AS "SequenceNumber",
    _s.supplier_id AS "SupplierId",
    _s.permission_tree_id AS "_s_permission_tree_id"
FROM
    res.section _s
    JOIN permission_tree_ids permission_join ON _s.permission_tree_id = permission_join.permission_tree_id
    LEFT JOIN system.geographic_data _gd ON _s.geographic_data_id = _gd.geographic_data_id

Query 4

Primary Table Alias	Include References	Include Permissions
`_s`	True	True

Parameter Name	Data Type	Value
`@permission_user_id`	Bigint	`500000000000`
`@permission_id`	Bigint	`70000`

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
    _s.code AS "Code",
    _s.is_active AS "IsActive",
    _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",
    _s.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _s.modified_on AS "ModifiedOn",
    _s.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _s1.site_id AS "SiteId",
    _s1.code AS "SiteCode",
    _s1.description AS "SiteDescription",
    _s.section_id AS "Id",
    _s.description AS "Description",
    _s.notes AS "Notes",
    _s.sequence_number AS "SequenceNumber",
    _s2.supplier_id AS "SupplierId",
    _s2.code AS "SupplierCode",
    _s2.description AS "SupplierDescription",
    _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",
    _s1.permission_tree_id AS "_s1_permission_tree_id",
    _s2.permission_tree_id AS "_s2_permission_tree_id"
FROM
    res.section _s
    JOIN permission_tree_ids permission_join ON _s.permission_tree_id = permission_join.permission_tree_id
    LEFT JOIN system.geographic_data _gd ON _s.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 _s.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _s.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _s.permission_tree_id = _pt.permission_tree_id
    LEFT JOIN gen.site _s1 ON _s.site_id = _s1.site_id
    LEFT JOIN gen.supplier _s2 ON _s.supplier_id = _s2.supplier_id

Table of Contents

Section

Table

Columns

Enumerations

Mapping 1

Mapping 2

Queries

Query 1

Query 2

Query 3

Query 4