Regular Asset Type Rule

Table

Database	Table	Entity	On Key 5 Conversions	On Key 5 Tables	Other Entities stored in same Table
Transaction	ampc.asset_type_rule	Regular Asset Type Rule	ConvertAssetTypeRuleTypes	astRuleLinks

Columns

Property	Db Table	Db Column	Db DataType	Nullable	Primary Key	Joins
IsActive	ampc.asset_type_rule	is_active	boolean	False
CreatedByUserId	ampc.asset_type_rule	created_by_user_id	bigint	False
CreatedByUserCode	uam.user	code	character varying(50)	False		ampc.asset_type_rule.created_by_user_id = uam.user.user_id
CreatedByUserFullName	uam.user	full_name	character varying(200)	False		ampc.asset_type_rule.created_by_user_id = uam.user.user_id
CreatedOn	ampc.asset_type_rule	created_on	timestamp without time zone	False
ModifiedByUserId	ampc.asset_type_rule	modified_by_user_id	bigint	False
ModifiedByUserCode	uam.user	code	character varying(50)	False		ampc.asset_type_rule.modified_by_user_id = uam.user.user_id
ModifiedByUserFullName	uam.user	full_name	character varying(200)	False		ampc.asset_type_rule.modified_by_user_id = uam.user.user_id
ModifiedOn	ampc.asset_type_rule	modified_on	timestamp without time zone	False
Version	ampc.asset_type_rule	version	integer	False
Id	ampc.asset_type_rule	asset_type_rule_id	bigint	False	True
RegularAssetTypeId	ampc.asset_type_rule	asset_type_id	bigint	False
RegularAssetTypeCode	ampc.asset_type	code	character varying(50)	False		ampc.asset_type_rule.asset_type_id = ampc.asset_type.asset_type_id
RegularAssetTypeDescription	ampc.asset_type	description	character varying(100)	False		ampc.asset_type_rule.asset_type_id = ampc.asset_type.asset_type_id
RuleId	ampc.asset_type_rule	rule_id	bigint	True
RuleCode	ampc.rule	code	character varying(50)	False		ampc.asset_type_rule.rule_id = ampc.rule.rule_id
RuleDescription	ampc.rule	description	character varying(100)	False		ampc.asset_type_rule.rule_id = ampc.rule.rule_id
RuleRuleText	ampc.rule	rule_text	text	True		ampc.asset_type_rule.rule_id = ampc.rule.rule_id
RuleRuleCategoryId	ampc.rule_category	rule_category_id	bigint	False	True	ampc.asset_type_rule.rule_id = ampc.rule.rule_id Then ampc.rule.rule_category_id = ampc.rule_category.rule_category_id
RuleRuleCategoryCode	ampc.rule_category	code	character varying(50)	False		ampc.asset_type_rule.rule_id = ampc.rule.rule_id Then ampc.rule.rule_category_id = ampc.rule_category.rule_category_id
RuleRuleCategoryDescription	ampc.rule_category	description	character varying(100)	False		ampc.asset_type_rule.rule_id = ampc.rule.rule_id Then ampc.rule.rule_category_id = ampc.rule_category.rule_category_id
SequenceNumber	ampc.asset_type_rule	sequence_number	integer	True

Queries

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

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

SELECT
    _atr.is_active AS "IsActive",
    _atr.created_by_user_id AS "CreatedByUserId",
    _atr.created_on AS "CreatedOn",
    _atr.modified_by_user_id AS "ModifiedByUserId",
    _atr.modified_on AS "ModifiedOn",
    _atr.version AS "Version",
    _atr.asset_type_rule_id AS "Id",
    _atr.asset_type_id AS "RegularAssetTypeId",
    _atr.rule_id AS "RuleId",
    _atr.sequence_number AS "SequenceNumber"
FROM
    ampc.asset_type_rule _atr

Query 2

Primary Table Alias	Include References	Include Permissions
_atr	True	False

SELECT
    _atr.is_active AS "IsActive",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _atr.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _atr.modified_on AS "ModifiedOn",
    _atr.version AS "Version",
    _atr.asset_type_rule_id AS "Id",
    _at.asset_type_id AS "RegularAssetTypeId",
    _at.code AS "RegularAssetTypeCode",
    _at.description AS "RegularAssetTypeDescription",
    _r.rule_id AS "RuleId",
    _r.code AS "RuleCode",
    _r.description AS "RuleDescription",
    _r.rule_text AS "RuleRuleText",
    _r.rule_category_id AS "RuleRuleCategory",
    _rc.rule_category_id AS "RuleRuleCategoryId",
    _rc.code AS "RuleRuleCategoryCode",
    _rc.description AS "RuleRuleCategoryDescription",
    _atr.sequence_number AS "SequenceNumber"
FROM
    ampc.asset_type_rule _atr
    JOIN uam.user _u ON _atr.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _atr.modified_by_user_id = _u1.user_id
    JOIN ampc.asset_type _at ON _atr.asset_type_id = _at.asset_type_id
    JOIN ampc.rule _r ON _atr.rule_id = _r.rule_id
    LEFT JOIN ampc.rule_category _rc ON _r.rule_category_id = _rc.rule_category_id