Placeholder Asset Component Condition

Table

Database	Table	Entity	On Key 5 Conversions	On Key 5 Tables	Other Entities stored in same Table
`Transaction`	`ampc.asset_component_condition`	Placeholder Asset Component Condition

Columns

Property	Db Table	Db Column	Db DataType	Nullable	Primary Key	Joins
`DevelopmentStatus`	`ampc.asset_component_condition`	`development_status`	ampc.asset_development_status	False
`Id`	`ampc.asset_component_condition`	`asset_component_condition_id`	bigint	False	True
`IsActive`	`ampc.asset_component_condition`	`is_active`	boolean	False
`IsHistorical`	`ampc.asset_component_condition`	`is_historical`	boolean	False
`IsInherited`	`ampc.asset_component_condition`	`is_inherited`	boolean	False
`IsProposed`	`ampc.asset_component_condition`	`is_proposed`	boolean	False
`LastConfirmedChangeLogId`	`ampc.asset_component_condition`	`last_confirmed_change_log_id`	bigint	True
`LastConfirmedOn`	`ampc.asset_component_condition`	`last_confirmed_on`	timestamp without time zone	True
`SequenceNumber`	`ampc.asset_component_condition`	`sequence_number`	integer	True
`SynchronisedWithTypeObjectUpTo`	`ampc.asset_component_condition`	`synchronised_with_type_object_up_to`	timestamp without time zone	True
`Unsynchronised`	`ampc.asset_component_condition`	`unsynchronised`	boolean	False
`CreatedByUserId`	`ampc.asset_component_condition`	`created_by_user_id`	bigint	False
`CreatedByUserCode`	`uam.user`	`code`	character varying(50)	False		`ampc.asset_component_condition.created_by_user_id = uam.user.user_id`
`CreatedByUserFullName`	`uam.user`	`full_name`	character varying(200)	False		`ampc.asset_component_condition.created_by_user_id = uam.user.user_id`
`CreatedOn`	`ampc.asset_component_condition`	`created_on`	timestamp without time zone	False
`ModifiedByUserId`	`ampc.asset_component_condition`	`modified_by_user_id`	bigint	False
`ModifiedByUserCode`	`uam.user`	`code`	character varying(50)	False		`ampc.asset_component_condition.modified_by_user_id = uam.user.user_id`
`ModifiedByUserFullName`	`uam.user`	`full_name`	character varying(200)	False		`ampc.asset_component_condition.modified_by_user_id = uam.user.user_id`
`ModifiedOn`	`ampc.asset_component_condition`	`modified_on`	timestamp without time zone	False
`Version`	`ampc.asset_component_condition`	`version`	integer	False
`PermissionTreeId`	`ampc.asset_component_condition`	`permission_tree_id`	bigint	False
`PermissionTreeCode`	`uam.permission_tree`	`code`	text	False		`ampc.asset_component_condition.permission_tree_id = uam.permission_tree.permission_tree_id`
`PermissionTreeDescription`	`uam.permission_tree`	`description`	text	True		`ampc.asset_component_condition.permission_tree_id = uam.permission_tree.permission_tree_id`
`AdjustmentFactor`	`ampc.asset_component_condition`	`adjustment_factor`	numeric	True
`ConditionId`	`ampc.asset_component_condition`	`condition_id`	bigint	False
`ConditionAdjustmentFactor`	`ampc.condition`	`adjustment_factor`	numeric	True		`ampc.asset_component_condition.condition_id = ampc.condition.condition_id`
`ConditionCode`	`ampc.condition`	`code`	character varying(50)	False		`ampc.asset_component_condition.condition_id = ampc.condition.condition_id`
`ConditionDescription`	`ampc.condition`	`description`	character varying(100)	False		`ampc.asset_component_condition.condition_id = ampc.condition.condition_id`
`ConditionConditionTypeId`	`ampc.condition_type`	`condition_type_id`	bigint	False	True	`ampc.asset_component_condition.condition_id = ampc.condition.condition_id` Then `ampc.condition.condition_type_id = ampc.condition_type.condition_type_id`
`ConditionConditionTypeCode`	`ampc.condition_type`	`code`	character varying(50)	False		`ampc.asset_component_condition.condition_id = ampc.condition.condition_id` Then `ampc.condition.condition_type_id = ampc.condition_type.condition_type_id`
`ConditionConditionTypeDescription`	`ampc.condition_type`	`description`	character varying(100)	False		`ampc.asset_component_condition.condition_id = ampc.condition.condition_id` Then `ampc.condition.condition_type_id = ampc.condition_type.condition_type_id`
`InheritedFrom`	`ampc.asset_component_condition`	`inherited_from_id`	bigint	True
`InheritedFromRegularAssetTypeCondition`	`ampc.asset_component_condition`	`inherited_from_regular_asset_type_condition`	boolean	False
`Notes`	`ampc.asset_component_condition`	`notes`	text	True
`PlaceholderAssetComponentId`	`ampc.asset_component_condition`	`asset_component_id`	bigint	False
`PlaceholderAssetComponentCode`	`ampc.asset_component`	`code`	character varying(50)	False		`ampc.asset_component_condition.asset_component_id = ampc.asset_component.asset_component_id`
`PlaceholderAssetComponentDescription`	`ampc.asset_component`	`description`	character varying(100)	False		`ampc.asset_component_condition.asset_component_id = ampc.asset_component.asset_component_id`
`PlaceholderAssetComponentIsActive`	`ampc.asset_component`	`is_active`	boolean	False		`ampc.asset_component_condition.asset_component_id = ampc.asset_component.asset_component_id`
`PlaceholderAssetComponentAssetId`	`ampc.asset`	`asset_id`	bigint	False	True	`ampc.asset_component_condition.asset_component_id = ampc.asset_component.asset_component_id` Then `ampc.asset_component.asset_id = ampc.asset.asset_id`
`PlaceholderAssetComponentAssetNearestRegularAssetId`	`ampc.asset`	`asset_id`	bigint	False	True	`ampc.asset_component_condition.asset_component_id = ampc.asset_component.asset_component_id` Then `ampc.asset_component.asset_id = ampc.asset.asset_id` Then `ampc.asset.nearest_regular_asset_id = ampc.asset.asset_id`
`PlaceholderAssetComponentAssetNearestRegularAssetCode`	`ampc.asset`	`code`	character varying(50)	False		`ampc.asset_component_condition.asset_component_id = ampc.asset_component.asset_component_id` Then `ampc.asset_component.asset_id = ampc.asset.asset_id` Then `ampc.asset.nearest_regular_asset_id = ampc.asset.asset_id`
`PlaceholderAssetComponentAssetNearestRegularAssetDescription`	`ampc.asset`	`description`	character varying(100)	False		`ampc.asset_component_condition.asset_component_id = ampc.asset_component.asset_component_id` Then `ampc.asset_component.asset_id = ampc.asset.asset_id` Then `ampc.asset.nearest_regular_asset_id = ampc.asset.asset_id`
`State`	`ampc.asset_component_condition`	`state`	ampc.condition_state	False

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
State	`ConditionState`	`state`	`ampc.condition_state`	`Apply` `Unaffected` `Disabled`

Queries

The list of example Placeholder Asset Component Condition queries can be interpreted using the following legend:

Legend	Description
Primary Table Alias	The alias for the `ampc.asset_component_condition` 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
`_acc`	False	False

SELECT
    _acc.development_status AS "DevelopmentStatus",
    _acc.asset_component_condition_id AS "Id",
    _acc.is_active AS "IsActive",
    _acc.is_historical AS "IsHistorical",
    _acc.is_inherited AS "IsInherited",
    _acc.is_proposed AS "IsProposed",
    _acc.last_confirmed_change_log_id AS "LastConfirmedChangeLogId",
    _acc.last_confirmed_on AS "LastConfirmedOn",
    _acc.sequence_number AS "SequenceNumber",
    _acc.synchronised_with_type_object_up_to AS "SynchronisedWithTypeObjectUpTo",
    _acc.unsynchronised AS "Unsynchronised",
    _acc.created_by_user_id AS "CreatedByUserId",
    _acc.created_on AS "CreatedOn",
    _acc.modified_by_user_id AS "ModifiedByUserId",
    _acc.modified_on AS "ModifiedOn",
    _acc.version AS "Version",
    _acc.permission_tree_id AS "PermissionTreeId",
    _acc.adjustment_factor AS "AdjustmentFactor",
    _acc.condition_id AS "ConditionId",
    _acc.inherited_from_id AS "InheritedFrom",
    _acc.inherited_from_regular_asset_type_condition AS "InheritedFromRegularAssetTypeCondition",
    _acc.notes AS "Notes",
    _acc.asset_component_id AS "PlaceholderAssetComponentId",
    _acc.state AS "State"
FROM
    ampc.asset_component_condition _acc

Query 2

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

SELECT
    _acc.development_status AS "DevelopmentStatus",
    _acc.asset_component_condition_id AS "Id",
    _acc.is_active AS "IsActive",
    _acc.is_historical AS "IsHistorical",
    _acc.is_inherited AS "IsInherited",
    _acc.is_proposed AS "IsProposed",
    _acc.last_confirmed_change_log_id AS "LastConfirmedChangeLogId",
    _acc.last_confirmed_on AS "LastConfirmedOn",
    _acc.sequence_number AS "SequenceNumber",
    _acc.synchronised_with_type_object_up_to AS "SynchronisedWithTypeObjectUpTo",
    _acc.unsynchronised AS "Unsynchronised",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _acc.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _acc.modified_on AS "ModifiedOn",
    _acc.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _acc.adjustment_factor AS "AdjustmentFactor",
    _c.condition_id AS "ConditionId",
    _c.adjustment_factor AS "ConditionAdjustmentFactor",
    _c.code AS "ConditionCode",
    _c.description AS "ConditionDescription",
    _c.condition_type_id AS "ConditionConditionType",
    _ct.condition_type_id AS "ConditionConditionTypeId",
    _ct.code AS "ConditionConditionTypeCode",
    _ct.description AS "ConditionConditionTypeDescription",
    _acc.inherited_from_id AS "InheritedFrom",
    _acc.inherited_from_regular_asset_type_condition AS "InheritedFromRegularAssetTypeCondition",
    _acc.notes AS "Notes",
    _ac.asset_component_id AS "PlaceholderAssetComponentId",
    _ac.code AS "PlaceholderAssetComponentCode",
    _ac.description AS "PlaceholderAssetComponentDescription",
    _ac.is_active AS "PlaceholderAssetComponentIsActive",
    _ac.asset_id AS "PlaceholderAssetComponentAsset",
    _a.asset_id AS "PlaceholderAssetComponentAssetId",
    _a.nearest_regular_asset_id AS "PlaceholderAssetComponentAssetNearestRegularAsset",
    _a1.asset_id AS "PlaceholderAssetComponentAssetNearestRegularAssetId",
    _a1.code AS "PlaceholderAssetComponentAssetNearestRegularAssetCode",
    _a1.description AS "PlaceholderAssetComponentAssetNearestRegularAssetDescription",
    _acc.state AS "State"
FROM
    ampc.asset_component_condition _acc
    JOIN uam.user _u ON _acc.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _acc.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _acc.permission_tree_id = _pt.permission_tree_id
    JOIN ampc.condition _c ON _acc.condition_id = _c.condition_id
    JOIN ampc.condition_type _ct ON _c.condition_type_id = _ct.condition_type_id
    JOIN ampc.asset_component _ac ON _acc.asset_component_id = _ac.asset_component_id
    LEFT JOIN ampc.asset _a ON _ac.asset_id = _a.asset_id
    LEFT JOIN ampc.asset _a1 ON _a.nearest_regular_asset_id = _a1.asset_id

Query 3

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

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

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
    _acc.development_status AS "DevelopmentStatus",
    _acc.asset_component_condition_id AS "Id",
    _acc.is_active AS "IsActive",
    _acc.is_historical AS "IsHistorical",
    _acc.is_inherited AS "IsInherited",
    _acc.is_proposed AS "IsProposed",
    _acc.last_confirmed_change_log_id AS "LastConfirmedChangeLogId",
    _acc.last_confirmed_on AS "LastConfirmedOn",
    _acc.sequence_number AS "SequenceNumber",
    _acc.synchronised_with_type_object_up_to AS "SynchronisedWithTypeObjectUpTo",
    _acc.unsynchronised AS "Unsynchronised",
    _acc.created_by_user_id AS "CreatedByUserId",
    _acc.created_on AS "CreatedOn",
    _acc.modified_by_user_id AS "ModifiedByUserId",
    _acc.modified_on AS "ModifiedOn",
    _acc.version AS "Version",
    _acc.permission_tree_id AS "PermissionTreeId",
    _acc.adjustment_factor AS "AdjustmentFactor",
    _acc.condition_id AS "ConditionId",
    _acc.inherited_from_id AS "InheritedFrom",
    _acc.inherited_from_regular_asset_type_condition AS "InheritedFromRegularAssetTypeCondition",
    _acc.notes AS "Notes",
    _acc.asset_component_id AS "PlaceholderAssetComponentId",
    _acc.state AS "State",
    _acc.permission_tree_id AS "_acc_permission_tree_id"
FROM
    ampc.asset_component_condition _acc
    JOIN permission_tree_ids permission_join ON _acc.permission_tree_id = permission_join.permission_tree_id

Query 4

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

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

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
    _acc.development_status AS "DevelopmentStatus",
    _acc.asset_component_condition_id AS "Id",
    _acc.is_active AS "IsActive",
    _acc.is_historical AS "IsHistorical",
    _acc.is_inherited AS "IsInherited",
    _acc.is_proposed AS "IsProposed",
    _acc.last_confirmed_change_log_id AS "LastConfirmedChangeLogId",
    _acc.last_confirmed_on AS "LastConfirmedOn",
    _acc.sequence_number AS "SequenceNumber",
    _acc.synchronised_with_type_object_up_to AS "SynchronisedWithTypeObjectUpTo",
    _acc.unsynchronised AS "Unsynchronised",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _acc.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _acc.modified_on AS "ModifiedOn",
    _acc.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _acc.adjustment_factor AS "AdjustmentFactor",
    _c.condition_id AS "ConditionId",
    _c.adjustment_factor AS "ConditionAdjustmentFactor",
    _c.code AS "ConditionCode",
    _c.description AS "ConditionDescription",
    _c.condition_type_id AS "ConditionConditionType",
    _ct.condition_type_id AS "ConditionConditionTypeId",
    _ct.code AS "ConditionConditionTypeCode",
    _ct.description AS "ConditionConditionTypeDescription",
    _acc.inherited_from_id AS "InheritedFrom",
    _acc.inherited_from_regular_asset_type_condition AS "InheritedFromRegularAssetTypeCondition",
    _acc.notes AS "Notes",
    _ac.asset_component_id AS "PlaceholderAssetComponentId",
    _ac.code AS "PlaceholderAssetComponentCode",
    _ac.description AS "PlaceholderAssetComponentDescription",
    _ac.is_active AS "PlaceholderAssetComponentIsActive",
    _ac.asset_id AS "PlaceholderAssetComponentAsset",
    _a.asset_id AS "PlaceholderAssetComponentAssetId",
    _a.nearest_regular_asset_id AS "PlaceholderAssetComponentAssetNearestRegularAsset",
    _a1.asset_id AS "PlaceholderAssetComponentAssetNearestRegularAssetId",
    _a1.code AS "PlaceholderAssetComponentAssetNearestRegularAssetCode",
    _a1.description AS "PlaceholderAssetComponentAssetNearestRegularAssetDescription",
    _acc.state AS "State",
    _acc.permission_tree_id AS "_acc_permission_tree_id",
    _u.permission_tree_id AS "_u_permission_tree_id",
    _u1.permission_tree_id AS "_u1_permission_tree_id",
    _c.permission_tree_id AS "_c_permission_tree_id",
    _ct.permission_tree_id AS "_ct_permission_tree_id",
    _ac.permission_tree_id AS "_ac_permission_tree_id",
    _a.permission_tree_id AS "_a_permission_tree_id",
    _a1.permission_tree_id AS "_a1_permission_tree_id"
FROM
    ampc.asset_component_condition _acc
    JOIN permission_tree_ids permission_join ON _acc.permission_tree_id = permission_join.permission_tree_id
    JOIN uam.user _u ON _acc.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _acc.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _acc.permission_tree_id = _pt.permission_tree_id
    JOIN ampc.condition _c ON _acc.condition_id = _c.condition_id
    JOIN ampc.condition_type _ct ON _c.condition_type_id = _ct.condition_type_id
    JOIN ampc.asset_component _ac ON _acc.asset_component_id = _ac.asset_component_id
    LEFT JOIN ampc.asset _a ON _ac.asset_id = _a.asset_id
    LEFT JOIN ampc.asset _a1 ON _a.nearest_regular_asset_id = _a1.asset_id

Table of Contents

Placeholder Asset Component Condition

Table

Columns

Enumerations

Mapping 1

Mapping 2

Queries

Query 1

Query 2

Query 3

Query 4