Table of Contents

Risk Probability

Table

Database Table Entity On Key 5 Conversions On Key 5 Tables Other Entities stored in same Table
Transaction risk.risk_probability Risk Probability ConvertRiskProbability
 astProbabilities

Columns

Property Db Table Db Column Db DataType Nullable Primary Key Joins
Code risk.risk_probability code character varying(50) False
CreatedByUserId risk.risk_probability created_by_user_id bigint False
CreatedByUserCode uam.user code character varying(50) False risk.risk_probability.created_by_user_id = uam.user.user_id
CreatedByUserFullName uam.user full_name character varying(200) False risk.risk_probability.created_by_user_id = uam.user.user_id
CreatedOn risk.risk_probability created_on timestamp without time zone False
IsActive risk.risk_probability is_active boolean False
ModifiedByUserId risk.risk_probability modified_by_user_id bigint False
ModifiedByUserCode uam.user code character varying(50) False risk.risk_probability.modified_by_user_id = uam.user.user_id
ModifiedByUserFullName uam.user full_name character varying(200) False risk.risk_probability.modified_by_user_id = uam.user.user_id
ModifiedOn risk.risk_probability modified_on timestamp without time zone False
PermissionTreeId risk.risk_probability permission_tree_id bigint False
PermissionTreeCode uam.permission_tree code text False risk.risk_probability.permission_tree_id = uam.permission_tree.permission_tree_id
PermissionTreeDescription uam.permission_tree description text True risk.risk_probability.permission_tree_id = uam.permission_tree.permission_tree_id
Version risk.risk_probability version integer False
Id risk.risk_probability risk_probability_id bigint False True
Description risk.risk_probability description character varying(100) False
Notes risk.risk_probability notes text True
SequenceNumber risk.risk_probability sequence_number integer True
Value risk.risk_probability value numeric(19,3) False

Queries

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

Legend Description
Primary Table Alias The alias for the risk.risk_probability 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
_rp False False 
SELECT
    _rp.code AS "Code",
    _rp.created_by_user_id AS "CreatedByUserId",
    _rp.created_on AS "CreatedOn",
    _rp.is_active AS "IsActive",
    _rp.modified_by_user_id AS "ModifiedByUserId",
    _rp.modified_on AS "ModifiedOn",
    _rp.permission_tree_id AS "PermissionTreeId",
    _rp.version AS "Version",
    _rp.risk_probability_id AS "Id",
    _rp.description AS "Description",
    _rp.notes AS "Notes",
    _rp.sequence_number AS "SequenceNumber",
    _rp.value AS "Value"
FROM
    risk.risk_probability _rp

Query 2

Primary Table Alias Include References Include Permissions
_rp True False 
SELECT
    _rp.code AS "Code",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _rp.created_on AS "CreatedOn",
    _rp.is_active AS "IsActive",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _rp.modified_on AS "ModifiedOn",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _rp.version AS "Version",
    _rp.risk_probability_id AS "Id",
    _rp.description AS "Description",
    _rp.notes AS "Notes",
    _rp.sequence_number AS "SequenceNumber",
    _rp.value AS "Value"
FROM
    risk.risk_probability _rp
    JOIN uam.user _u ON _rp.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _rp.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _rp.permission_tree_id = _pt.permission_tree_id

Query 3

Primary Table Alias Include References Include Permissions
_rp False True
Parameter Name Data Type Value
@permission_user_id Bigint 500000000000
@permission_id Bigint 119900 
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
    _rp.code AS "Code",
    _rp.created_by_user_id AS "CreatedByUserId",
    _rp.created_on AS "CreatedOn",
    _rp.is_active AS "IsActive",
    _rp.modified_by_user_id AS "ModifiedByUserId",
    _rp.modified_on AS "ModifiedOn",
    _rp.permission_tree_id AS "PermissionTreeId",
    _rp.version AS "Version",
    _rp.risk_probability_id AS "Id",
    _rp.description AS "Description",
    _rp.notes AS "Notes",
    _rp.sequence_number AS "SequenceNumber",
    _rp.value AS "Value",
    _rp.permission_tree_id AS "_rp_permission_tree_id"
FROM
    risk.risk_probability _rp
    JOIN permission_tree_ids permission_join ON _rp.permission_tree_id = permission_join.permission_tree_id

Query 4

Primary Table Alias Include References Include Permissions
_rp True True
Parameter Name Data Type Value
@permission_user_id Bigint 500000000000
@permission_id Bigint 119900 
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
    _rp.code AS "Code",
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _rp.created_on AS "CreatedOn",
    _rp.is_active AS "IsActive",
    _u1.user_id AS "ModifiedByUserId",
    _u1.code AS "ModifiedByUserCode",
    _u1.full_name AS "ModifiedByUserFullName",
    _rp.modified_on AS "ModifiedOn",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _rp.version AS "Version",
    _rp.risk_probability_id AS "Id",
    _rp.description AS "Description",
    _rp.notes AS "Notes",
    _rp.sequence_number AS "SequenceNumber",
    _rp.value AS "Value",
    _rp.permission_tree_id AS "_rp_permission_tree_id",
    _u.permission_tree_id AS "_u_permission_tree_id",
    _u1.permission_tree_id AS "_u1_permission_tree_id"
FROM
    risk.risk_probability _rp
    JOIN permission_tree_ids permission_join ON _rp.permission_tree_id = permission_join.permission_tree_id
    JOIN uam.user _u ON _rp.created_by_user_id = _u.user_id
    JOIN uam.user _u1 ON _rp.modified_by_user_id = _u1.user_id
    JOIN uam.permission_tree _pt ON _rp.permission_tree_id = _pt.permission_tree_id