Table of Contents

Failure Cause

Table

Database Table Entity On Key 5 Conversions On Key 5 Tables Other Entities stored in same Table
Transaction ampc.failure_cause Failure Cause ConvertFailureCause
 astRootCauses

Columns

Property Db Table Db Column Db DataType Nullable Primary Key Joins
Code ampc.failure_cause code character varying(50) False
IsActive ampc.failure_cause is_active boolean False
CreatedByUserId ampc.failure_cause created_by_user_id bigint False
CreatedByUserCode uam.user code character varying(50) False ampc.failure_cause.created_by_user_id = uam.user.user_id
CreatedByUserFullName uam.user full_name character varying(200) False ampc.failure_cause.created_by_user_id = uam.user.user_id
CreatedOn ampc.failure_cause created_on timestamp without time zone False
ModifiedByUserId ampc.failure_cause modified_by_user_id bigint False
ModifiedByUserCode uam.user code character varying(50) False ampc.failure_cause.modified_by_user_id = uam.user.user_id
ModifiedByUserFullName uam.user full_name character varying(200) False ampc.failure_cause.modified_by_user_id = uam.user.user_id
ModifiedOn ampc.failure_cause modified_on timestamp without time zone False
Version ampc.failure_cause version integer False
PermissionTreeId ampc.failure_cause permission_tree_id bigint False
PermissionTreeCode uam.permission_tree code text False ampc.failure_cause.permission_tree_id = uam.permission_tree.permission_tree_id
PermissionTreeDescription uam.permission_tree description text True ampc.failure_cause.permission_tree_id = uam.permission_tree.permission_tree_id
Id ampc.failure_cause failure_cause_id bigint False True
FailureCauseTypeId ampc.failure_cause failure_cause_type_id bigint False
FailureCauseTypeCode ampc.failure_cause_type code character varying(50) False ampc.failure_cause.failure_cause_type_id = ampc.failure_cause_type.failure_cause_type_id
FailureCauseTypeDescription ampc.failure_cause_type description character varying(100) False ampc.failure_cause.failure_cause_type_id = ampc.failure_cause_type.failure_cause_type_id
Description ampc.failure_cause description character varying(100) False
Notes ampc.failure_cause notes text True
SequenceNumber ampc.failure_cause sequence_number integer True

Queries

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

Legend Description
Primary Table Alias The alias for the ampc.failure_cause 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
_fc False False 
SELECT
    _fc.code AS "Code",
    _fc.is_active AS "IsActive",
    _fc.created_by_user_id AS "CreatedByUserId",
    _fc.created_on AS "CreatedOn",
    _fc.modified_by_user_id AS "ModifiedByUserId",
    _fc.modified_on AS "ModifiedOn",
    _fc.version AS "Version",
    _fc.permission_tree_id AS "PermissionTreeId",
    _fc.failure_cause_id AS "Id",
    _fc.failure_cause_type_id AS "FailureCauseTypeId",
    _fc.description AS "Description",
    _fc.notes AS "Notes",
    _fc.sequence_number AS "SequenceNumber"
FROM
    ampc.failure_cause _fc

Query 2

Primary Table Alias Include References Include Permissions
_fc True False 
SELECT
    _fc.code AS "Code",
    _fc.is_active AS "IsActive",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _fc.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _fc.modified_on AS "ModifiedOn",
    _fc.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _fc.failure_cause_id AS "Id",
    _fct.failure_cause_type_id AS "FailureCauseTypeId",
    _fct.code AS "FailureCauseTypeCode",
    _fct.description AS "FailureCauseTypeDescription",
    _fc.description AS "Description",
    _fc.notes AS "Notes",
    _fc.sequence_number AS "SequenceNumber"
FROM
    ampc.failure_cause _fc
    JOIN uam.user _u ON _fc.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _fc.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _fc.permission_tree_id = _pt.permission_tree_id
    JOIN ampc.failure_cause_type _fct ON _fc.failure_cause_type_id = _fct.failure_cause_type_id

Query 3

Primary Table Alias Include References Include Permissions
_fc False True
Parameter Name Data Type Value
@permission_user_id Bigint 500000000000
@permission_id Bigint 118100 
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
    _fc.code AS "Code",
    _fc.is_active AS "IsActive",
    _fc.created_by_user_id AS "CreatedByUserId",
    _fc.created_on AS "CreatedOn",
    _fc.modified_by_user_id AS "ModifiedByUserId",
    _fc.modified_on AS "ModifiedOn",
    _fc.version AS "Version",
    _fc.permission_tree_id AS "PermissionTreeId",
    _fc.failure_cause_id AS "Id",
    _fc.failure_cause_type_id AS "FailureCauseTypeId",
    _fc.description AS "Description",
    _fc.notes AS "Notes",
    _fc.sequence_number AS "SequenceNumber",
    _fc.permission_tree_id AS "_fc_permission_tree_id"
FROM
    ampc.failure_cause _fc
    JOIN permission_tree_ids permission_join ON _fc.permission_tree_id = permission_join.permission_tree_id

Query 4

Primary Table Alias Include References Include Permissions
_fc True True
Parameter Name Data Type Value
@permission_user_id Bigint 500000000000
@permission_id Bigint 118100 
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
    _fc.code AS "Code",
    _fc.is_active AS "IsActive",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _fc.created_on AS "CreatedOn",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _fc.modified_on AS "ModifiedOn",
    _fc.version AS "Version",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _fc.failure_cause_id AS "Id",
    _fct.failure_cause_type_id AS "FailureCauseTypeId",
    _fct.code AS "FailureCauseTypeCode",
    _fct.description AS "FailureCauseTypeDescription",
    _fc.description AS "Description",
    _fc.notes AS "Notes",
    _fc.sequence_number AS "SequenceNumber",
    _fc.permission_tree_id AS "_fc_permission_tree_id",
    _u.permission_tree_id AS "_u_permission_tree_id",
    _u1.permission_tree_id AS "_u1_permission_tree_id",
    _fct.permission_tree_id AS "_fct_permission_tree_id"
FROM
    ampc.failure_cause _fc
    JOIN permission_tree_ids permission_join ON _fc.permission_tree_id = permission_join.permission_tree_id
    JOIN uam.user _u ON _fc.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _fc.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _fc.permission_tree_id = _pt.permission_tree_id
    JOIN ampc.failure_cause_type _fct ON _fc.failure_cause_type_id = _fct.failure_cause_type_id