Regular Asset Type Task Spare

Table

Database	Table	Entity	On Key 5 Conversions	On Key 5 Tables	Other Entities stored in same Table
`Transaction`	`ampc.asset_type_task_spare`	Regular Asset Type Task Spare	ConvertAssetTypeTaskSpare	`astTaskSpares`	Standard Task Spare Auxiliary Asset Type Task Spare

Columns

Property	Db Table	Db Column	Db DataType	Nullable	Primary Key	Joins
`RulesLastChangedOn`	`ampc.asset_type_task_spare`	`rules_last_changed_on`	timestamp without time zone	True
`CreatedByUserId`	`ampc.asset_type_task_spare`	`created_by_user_id`	bigint	False
`CreatedByUserCode`	`uam.user`	`code`	character varying(50)	False		`ampc.asset_type_task_spare.created_by_user_id = uam.user.user_id`
`CreatedByUserFullName`	`uam.user`	`full_name`	character varying(200)	False		`ampc.asset_type_task_spare.created_by_user_id = uam.user.user_id`
`CreatedOn`	`ampc.asset_type_task_spare`	`created_on`	timestamp without time zone	False
`ModifiedByUserId`	`ampc.asset_type_task_spare`	`modified_by_user_id`	bigint	False
`ModifiedByUserCode`	`uam.user`	`code`	character varying(50)	False		`ampc.asset_type_task_spare.modified_by_user_id = uam.user.user_id`
`ModifiedByUserFullName`	`uam.user`	`full_name`	character varying(200)	False		`ampc.asset_type_task_spare.modified_by_user_id = uam.user.user_id`
`ModifiedOn`	`ampc.asset_type_task_spare`	`modified_on`	timestamp without time zone	False
`Version`	`ampc.asset_type_task_spare`	`version`	integer	False
`PermissionTreeId`	`ampc.asset_type_task_spare`	`permission_tree_id`	bigint	False
`PermissionTreeCode`	`uam.permission_tree`	`code`	text	False		`ampc.asset_type_task_spare.permission_tree_id = uam.permission_tree.permission_tree_id`
`PermissionTreeDescription`	`uam.permission_tree`	`description`	text	True		`ampc.asset_type_task_spare.permission_tree_id = uam.permission_tree.permission_tree_id`
`DevelopmentStatus`	`ampc.asset_type_task_spare`	`development_status`	ampc.asset_type_development_status	False
`Id`	`ampc.asset_type_task_spare`	`asset_type_task_spare_id`	bigint	False	True
`IsActive`	`ampc.asset_type_task_spare`	`is_active`	boolean	False
`IsBackup`	`ampc.asset_type_task_spare`	`is_backup`	boolean	False
`IsInherited`	`ampc.asset_type_task_spare`	`is_inherited`	boolean	True
`LastConfirmedOn`	`ampc.asset_type_task_spare`	`last_confirmed_on`	timestamp without time zone	True
`PreviousDevelopmentStatus`	`ampc.asset_type_task_spare`	`previous_development_status`	ampc.asset_type_development_status	True
`RegularAssetTypeTaskId`	`ampc.asset_type_task_spare`	`asset_type_task_id`	bigint	True
`RegularAssetTypeTaskCode`	`ampc.asset_type_task`	`code`	character varying(50)	False		`ampc.asset_type_task_spare.asset_type_task_id = ampc.asset_type_task.asset_type_task_id`
`RegularAssetTypeTaskDescription`	`ampc.asset_type_task`	`description`	character varying(255)	False		`ampc.asset_type_task_spare.asset_type_task_id = ampc.asset_type_task.asset_type_task_id`
`RegularAssetTypeTaskAssetTypeId`	`ampc.asset_type`	`asset_type_id`	bigint	False	True	`ampc.asset_type_task_spare.asset_type_task_id = ampc.asset_type_task.asset_type_task_id` Then `ampc.asset_type_task.asset_type_id = ampc.asset_type.asset_type_id`
`RegularAssetTypeTaskAssetTypeCode`	`ampc.asset_type`	`code`	character varying(50)	False		`ampc.asset_type_task_spare.asset_type_task_id = ampc.asset_type_task.asset_type_task_id` Then `ampc.asset_type_task.asset_type_id = ampc.asset_type.asset_type_id`
`SequenceNumber`	`ampc.asset_type_task_spare`	`sequence_number`	integer	True
`CostElementId`	`ampc.asset_type_task_spare`	`cost_element_id`	bigint	True
`CostElementCode`	`fin.cost_element`	`code`	character varying(50)	False		`ampc.asset_type_task_spare.cost_element_id = fin.cost_element.cost_element_id`
`CostElementDescription`	`fin.cost_element`	`description`	character varying(100)	False		`ampc.asset_type_task_spare.cost_element_id = fin.cost_element.cost_element_id`
`InheritedFromId`	`ampc.asset_type_task_spare`	`inherited_from_id`	bigint	True
`InheritedFromRegularAssetTypeTaskId`	`ampc.asset_type_task`	`asset_type_task_id`	bigint	False	True	`ampc.asset_type_task_spare.inherited_from_id = ampc.asset_type_task_spare.asset_type_task_spare_id` Then `ampc.asset_type_task_spare.asset_type_task_id = ampc.asset_type_task.asset_type_task_id`
`InheritedFromRegularAssetTypeTaskRecordType`	`ampc.asset_type_task`	`record_type`	ampc.asset_type_task_record_type	False		`ampc.asset_type_task_spare.inherited_from_id = ampc.asset_type_task_spare.asset_type_task_spare_id` Then `ampc.asset_type_task_spare.asset_type_task_id = ampc.asset_type_task.asset_type_task_id`
`IsHistorical`	`ampc.asset_type_task_spare`	`is_historical`	boolean	True
`MaterialMasterId`	`ampc.asset_type_task_spare`	`material_master_id`	bigint	False
`MaterialMasterCode`	`mm.material_master`	`code`	character varying(50)	False		`ampc.asset_type_task_spare.material_master_id = mm.material_master.material_master_id`
`MaterialMasterDescription`	`mm.material_master`	`description`	character varying(100)	False		`ampc.asset_type_task_spare.material_master_id = mm.material_master.material_master_id`
`MaterialMasterCommodityId`	`mm.commodity`	`commodity_id`	bigint	False	True	`ampc.asset_type_task_spare.material_master_id = mm.material_master.material_master_id` Then `mm.material_master.commodity_id = mm.commodity.commodity_id`
`MaterialMasterCommodityCode`	`mm.commodity`	`code`	character varying(50)	False		`ampc.asset_type_task_spare.material_master_id = mm.material_master.material_master_id` Then `mm.material_master.commodity_id = mm.commodity.commodity_id`
`MaterialMasterCommodityDescription`	`mm.commodity`	`description`	character varying(100)	False		`ampc.asset_type_task_spare.material_master_id = mm.material_master.material_master_id` Then `mm.material_master.commodity_id = mm.commodity.commodity_id`
`Notes`	`ampc.asset_type_task_spare`	`notes`	text	True
`PreferredMaterialMasterId`	`ampc.asset_type_task_spare`	`preferred_material_master_id`	bigint	True
`PreferredMaterialMasterCode`	`mm.material_master`	`code`	character varying(50)	False		`ampc.asset_type_task_spare.preferred_material_master_id = mm.material_master.material_master_id`
`PreferredMaterialMasterDescription`	`mm.material_master`	`description`	character varying(100)	False		`ampc.asset_type_task_spare.preferred_material_master_id = mm.material_master.material_master_id`
`Quantity`	`ampc.asset_type_task_spare`	`quantity`	numeric	False
`RecordType`	`ampc.asset_type_task_spare`	`record_type`	ampc.asset_type_task_record_type	False

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
InheritedFromRegularAssetTypeTaskRecordType	`AssetTypeTaskRecordType`	`record_type`	`ampc.asset_type_task_record_type`	`Regular` `StandardTask` `Auxiliary`

Mapping 4

Property	Property Type	Db Column	Db Column Type	Db Column Values
RecordType	`AssetTypeTaskRecordType`	`record_type`	`ampc.asset_type_task_record_type`	`Regular` `StandardTask` `Auxiliary`

Queries

The list of example Regular Asset Type Task Spare queries can be interpreted using the following legend:

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

Parameter Name	Data Type	Value
`@asset_type_task_spare_id`	Bigint	`0`
`@record_type`	Unknown	`Regular`

SELECT
    _atts.rules_last_changed_on AS "RulesLastChangedOn",
    _atts.created_by_user_id AS "CreatedByUserId",
    _atts.created_on AS "CreatedOn",
    _atts.modified_by_user_id AS "ModifiedByUserId",
    _atts.modified_on AS "ModifiedOn",
    _atts.version AS "Version",
    _atts.permission_tree_id AS "PermissionTreeId",
    _atts.development_status AS "DevelopmentStatus",
    _atts.asset_type_task_spare_id AS "Id",
    _atts.is_active AS "IsActive",
    _atts.is_backup AS "IsBackup",
    _atts.is_inherited AS "IsInherited",
    _atts.last_confirmed_on AS "LastConfirmedOn",
    _atts.previous_development_status AS "PreviousDevelopmentStatus",
    _atts.asset_type_task_id AS "RegularAssetTypeTaskId",
    _atts.sequence_number AS "SequenceNumber",
    _atts.cost_element_id AS "CostElementId",
    _atts.inherited_from_id AS "InheritedFromId",
    _atts.is_historical AS "IsHistorical",
    _atts.material_master_id AS "MaterialMasterId",
    _atts.notes AS "Notes",
    _atts.preferred_material_master_id AS "PreferredMaterialMasterId",
    _atts.quantity AS "Quantity",
    _atts.record_type AS "RecordType"
FROM
    ampc.asset_type_task_spare _atts
WHERE
    (_atts.asset_type_task_spare_id > @asset_type_task_spare_id AND 
    _atts.record_type = @record_type)

Query 2

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

Parameter Name	Data Type	Value
`@asset_type_task_spare_id`	Bigint	`0`
`@record_type`	Unknown	`Regular`

SELECT
    _atts.rules_last_changed_on AS "RulesLastChangedOn",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _atts.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _atts.modified_on AS "ModifiedOn",
    _atts.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _atts.development_status AS "DevelopmentStatus",
    _atts.asset_type_task_spare_id AS "Id",
    _atts.is_active AS "IsActive",
    _atts.is_backup AS "IsBackup",
    _atts.is_inherited AS "IsInherited",
    _atts.last_confirmed_on AS "LastConfirmedOn",
    _atts.previous_development_status AS "PreviousDevelopmentStatus",
    _att.asset_type_task_id AS "RegularAssetTypeTaskId",
    _att.code AS "RegularAssetTypeTaskCode",
    _att.description AS "RegularAssetTypeTaskDescription",
    _att.asset_type_id AS "RegularAssetTypeTaskAssetType",
    _at.asset_type_id AS "RegularAssetTypeTaskAssetTypeId",
    _at.code AS "RegularAssetTypeTaskAssetTypeCode",
    _atts.sequence_number AS "SequenceNumber",
    _ce.cost_element_id AS "CostElementId",
    _ce.code AS "CostElementCode",
    _ce.description AS "CostElementDescription",
    _atts1.asset_type_task_spare_id AS "InheritedFromId",
    _atts1.asset_type_task_id AS "InheritedFromRegularAssetTypeTask",
    _att1.asset_type_task_id AS "InheritedFromRegularAssetTypeTaskId",
    _att1.record_type AS "InheritedFromRegularAssetTypeTaskRecordType",
    _atts.is_historical AS "IsHistorical",
    _mm.material_master_id AS "MaterialMasterId",
    _mm.code AS "MaterialMasterCode",
    _mm.description AS "MaterialMasterDescription",
    _mm.commodity_id AS "MaterialMasterCommodity",
    _c.commodity_id AS "MaterialMasterCommodityId",
    _c.code AS "MaterialMasterCommodityCode",
    _c.description AS "MaterialMasterCommodityDescription",
    _atts.notes AS "Notes",
    _mm1.material_master_id AS "PreferredMaterialMasterId",
    _mm1.code AS "PreferredMaterialMasterCode",
    _mm1.description AS "PreferredMaterialMasterDescription",
    _atts.quantity AS "Quantity",
    _atts.record_type AS "RecordType"
FROM
    ampc.asset_type_task_spare _atts
    JOIN uam.user _u ON _atts.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _atts.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _atts.permission_tree_id = _pt.permission_tree_id
    JOIN ampc.asset_type_task _att ON _atts.asset_type_task_id = _att.asset_type_task_id
    LEFT JOIN ampc.asset_type _at ON _att.asset_type_id = _at.asset_type_id
    LEFT JOIN fin.cost_element _ce ON _atts.cost_element_id = _ce.cost_element_id
    LEFT JOIN ampc.asset_type_task_spare _atts1 ON _atts.inherited_from_id = _atts1.asset_type_task_spare_id
    LEFT JOIN ampc.asset_type_task _att1 ON _atts1.asset_type_task_id = _att1.asset_type_task_id
    JOIN mm.material_master _mm ON _atts.material_master_id = _mm.material_master_id
    JOIN mm.commodity _c ON _mm.commodity_id = _c.commodity_id
    LEFT JOIN mm.material_master _mm1 ON _atts.preferred_material_master_id = _mm1.material_master_id
WHERE
    (_atts.asset_type_task_spare_id > @asset_type_task_spare_id AND 
    _atts.record_type = @record_type)

Query 3

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

Parameter Name	Data Type	Value
`@asset_type_task_spare_id`	Bigint	`0`
`@record_type`	Unknown	`Regular`
`@permission_user_id`	Bigint	`500000000000`
`@permission_id`	Bigint	`11700`

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
    _atts.rules_last_changed_on AS "RulesLastChangedOn",
    _atts.created_by_user_id AS "CreatedByUserId",
    _atts.created_on AS "CreatedOn",
    _atts.modified_by_user_id AS "ModifiedByUserId",
    _atts.modified_on AS "ModifiedOn",
    _atts.version AS "Version",
    _atts.permission_tree_id AS "PermissionTreeId",
    _atts.development_status AS "DevelopmentStatus",
    _atts.asset_type_task_spare_id AS "Id",
    _atts.is_active AS "IsActive",
    _atts.is_backup AS "IsBackup",
    _atts.is_inherited AS "IsInherited",
    _atts.last_confirmed_on AS "LastConfirmedOn",
    _atts.previous_development_status AS "PreviousDevelopmentStatus",
    _atts.asset_type_task_id AS "RegularAssetTypeTaskId",
    _atts.sequence_number AS "SequenceNumber",
    _atts.cost_element_id AS "CostElementId",
    _atts.inherited_from_id AS "InheritedFromId",
    _atts.is_historical AS "IsHistorical",
    _atts.material_master_id AS "MaterialMasterId",
    _atts.notes AS "Notes",
    _atts.preferred_material_master_id AS "PreferredMaterialMasterId",
    _atts.quantity AS "Quantity",
    _atts.record_type AS "RecordType",
    _atts.permission_tree_id AS "_atts_permission_tree_id"
FROM
    ampc.asset_type_task_spare _atts
    JOIN permission_tree_ids permission_join ON _atts.permission_tree_id = permission_join.permission_tree_id
WHERE
    (_atts.asset_type_task_spare_id > @asset_type_task_spare_id AND 
    _atts.record_type = @record_type)

Query 4

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

Parameter Name	Data Type	Value
`@asset_type_task_spare_id`	Bigint	`0`
`@record_type`	Unknown	`Regular`
`@permission_user_id`	Bigint	`500000000000`
`@permission_id`	Bigint	`11700`

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
    _atts.rules_last_changed_on AS "RulesLastChangedOn",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _atts.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _atts.modified_on AS "ModifiedOn",
    _atts.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _atts.development_status AS "DevelopmentStatus",
    _atts.asset_type_task_spare_id AS "Id",
    _atts.is_active AS "IsActive",
    _atts.is_backup AS "IsBackup",
    _atts.is_inherited AS "IsInherited",
    _atts.last_confirmed_on AS "LastConfirmedOn",
    _atts.previous_development_status AS "PreviousDevelopmentStatus",
    _att.asset_type_task_id AS "RegularAssetTypeTaskId",
    _att.code AS "RegularAssetTypeTaskCode",
    _att.description AS "RegularAssetTypeTaskDescription",
    _att.asset_type_id AS "RegularAssetTypeTaskAssetType",
    _at.asset_type_id AS "RegularAssetTypeTaskAssetTypeId",
    _at.code AS "RegularAssetTypeTaskAssetTypeCode",
    _atts.sequence_number AS "SequenceNumber",
    _ce.cost_element_id AS "CostElementId",
    _ce.code AS "CostElementCode",
    _ce.description AS "CostElementDescription",
    _atts1.asset_type_task_spare_id AS "InheritedFromId",
    _atts1.asset_type_task_id AS "InheritedFromRegularAssetTypeTask",
    _att1.asset_type_task_id AS "InheritedFromRegularAssetTypeTaskId",
    _att1.record_type AS "InheritedFromRegularAssetTypeTaskRecordType",
    _atts.is_historical AS "IsHistorical",
    _mm.material_master_id AS "MaterialMasterId",
    _mm.code AS "MaterialMasterCode",
    _mm.description AS "MaterialMasterDescription",
    _mm.commodity_id AS "MaterialMasterCommodity",
    _c.commodity_id AS "MaterialMasterCommodityId",
    _c.code AS "MaterialMasterCommodityCode",
    _c.description AS "MaterialMasterCommodityDescription",
    _atts.notes AS "Notes",
    _mm1.material_master_id AS "PreferredMaterialMasterId",
    _mm1.code AS "PreferredMaterialMasterCode",
    _mm1.description AS "PreferredMaterialMasterDescription",
    _atts.quantity AS "Quantity",
    _atts.record_type AS "RecordType",
    _atts.permission_tree_id AS "_atts_permission_tree_id",
    _u.permission_tree_id AS "_u_permission_tree_id",
    _u1.permission_tree_id AS "_u1_permission_tree_id",
    _att.permission_tree_id AS "_att_permission_tree_id",
    _at.permission_tree_id AS "_at_permission_tree_id",
    _ce.permission_tree_id AS "_ce_permission_tree_id",
    _atts1.permission_tree_id AS "_atts1_permission_tree_id",
    _att1.permission_tree_id AS "_att1_permission_tree_id",
    _mm.permission_tree_id AS "_mm_permission_tree_id",
    _c.permission_tree_id AS "_c_permission_tree_id",
    _mm1.permission_tree_id AS "_mm1_permission_tree_id"
FROM
    ampc.asset_type_task_spare _atts
    JOIN permission_tree_ids permission_join ON _atts.permission_tree_id = permission_join.permission_tree_id
    JOIN uam.user _u ON _atts.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _atts.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _atts.permission_tree_id = _pt.permission_tree_id
    JOIN ampc.asset_type_task _att ON _atts.asset_type_task_id = _att.asset_type_task_id
    LEFT JOIN ampc.asset_type _at ON _att.asset_type_id = _at.asset_type_id
    LEFT JOIN fin.cost_element _ce ON _atts.cost_element_id = _ce.cost_element_id
    LEFT JOIN ampc.asset_type_task_spare _atts1 ON _atts.inherited_from_id = _atts1.asset_type_task_spare_id
    LEFT JOIN ampc.asset_type_task _att1 ON _atts1.asset_type_task_id = _att1.asset_type_task_id
    JOIN mm.material_master _mm ON _atts.material_master_id = _mm.material_master_id
    JOIN mm.commodity _c ON _mm.commodity_id = _c.commodity_id
    LEFT JOIN mm.material_master _mm1 ON _atts.preferred_material_master_id = _mm1.material_master_id
WHERE
    (_atts.asset_type_task_spare_id > @asset_type_task_spare_id AND 
    _atts.record_type = @record_type)

Table of Contents

Regular Asset Type Task Spare

Table

Columns

Enumerations

Mapping 1

Mapping 2

Mapping 3

Mapping 4

Queries

Query 1

Query 2

Query 3

Query 4