Overview
This command will list all risks and their risk types and created attributes. Such information refers to the File Risk menu. All types of the SoftExpert Risk component are recorded in the GNGENTYPE table.
Related tables
Table
|
Description
|
Primary key (PK)
|
Connection tables
|
RIRISK
|
Risk record
|
CDRISK
|
RIRISKTYPE
GNTYPEROLE
INOCCURRENCETYPE
ADTEAM
ADUSER
GNASSOC
GNTOOLSANALISYS
|
RIRISKTYPE
|
Risk type record
|
CDRISKTYPE
|
GNGENTYPE
GNTYPEROLE
|
GNGENTYPE
|
Generic type
|
CDGENTYPE
|
GNELETRONICFILECFG
GNEVAL
GNFAVORITE
GNREVCONFIG
GNMASK
GNTYPEROLE
ADCHECKLIST
GNASSOC
GNACTIVITYTIMECFG
GNMASK
GNTYPEROLE
GNTRANSLATION
GNSECURITY
|
GNASSOCATTRIB
|
Attribute association table
|
CDASSOC
CDATTRIBUTE
|
GNASSOC
ADATTRIBUTE
ADATTRIBVALUE
ADATTRIBUTEOBJECT
|
ADATTRIBUTE
|
Attribute record
|
CDATTRIBUTE
|
GNDATASOURCE
GNFORMATFIELD
GNPERMISSION
GNTRANSLATION
|
ADATTRIBVALUE
|
Attribute value
|
CDATTRIBUTE
CDVALUE
|
ADATTRIBUTE
GNTRANSLATION
|
Oracle/Postgres/SQL Server
SELECT RIRISK.IDRISK,
RIRISK.NMRISK,
RIRISK.DSRISK,
RIRISK.FGVALUE,
GNGENTYPE.IDGENTYPE,
GNGENTYPE.NMGENTYPE AS NMTYPERISK,
(SELECT ADATTRIBVALUE.NMATTRIBUTE
FROM GNASSOCATTRIB
INNER JOIN ADATTRIBUTE ON GNASSOCATTRIB.CDATTRIBUTE = ADATTRIBUTE.CDATTRIBUTE
INNER JOIN ADATTRIBVALUE ON ADATTRIBVALUE.CDATTRIBUTE = GNASSOCATTRIB.CDATTRIBUTE AND ADATTRIBVALUE.CDVALUE = GNASSOCATTRIB.CDVALUE
WHERE GNASSOCATTRIB.CDASSOC = RIRISK.CDASSOC
AND ADATTRIBUTE.NMATTRIBUTE = 'A01' /* NOTE1 */
) AS Atributo01,
(SELECT ADATTRIBVALUE.VLATTRIBUTE
FROM GNASSOCATTRIB
INNER JOIN ADATTRIBUTE ON GNASSOCATTRIB.CDATTRIBUTE = ADATTRIBUTE.CDATTRIBUTE
INNER JOIN ADATTRIBVALUE ON ADATTRIBVALUE.CDATTRIBUTE = GNASSOCATTRIB.CDATTRIBUTE AND ADATTRIBVALUE.CDVALUE = GNASSOCATTRIB.CDVALUE
WHERE GNASSOCATTRIB.CDASSOC = RIRISK.CDASSOC
AND ADATTRIBUTE.NMATTRIBUTE = 'A02'
) AS Atributo02,
(SELECT GNASSOCATTRIB.NMVALUE
FROM GNASSOCATTRIB
INNER JOIN ADATTRIBUTE ON GNASSOCATTRIB.CDATTRIBUTE = ADATTRIBUTE.CDATTRIBUTE
WHERE GNASSOCATTRIB.CDASSOC = RIRISK.CDASSOC
AND ADATTRIBUTE.NMATTRIBUTE = 'A03'
) AS Atributo03,
(SELECT GNASSOCATTRIB.VLVALUE
FROM GNASSOCATTRIB
INNER JOIN ADATTRIBUTE ON GNASSOCATTRIB.CDATTRIBUTE = ADATTRIBUTE.CDATTRIBUTE
WHERE GNASSOCATTRIB.CDASSOC = RIRISK.CDASSOC
AND ADATTRIBUTE.NMATTRIBUTE = 'A04'
) AS Atributo04
FROM RIRISK
INNER JOIN RIRISKTYPE ON RIRISKTYPE.CDRISKTYPE = RIRISK.CDRISKTYPE
INNER JOIN GNGENTYPE ON GNGENTYPE.CDGENTYPE= RIRISKTYPE.CDRISKTYPE
WHERE RIRISK.FGENABLED = 1 /* NOTE2 */
AND GNGENTYPE.FGACTIVE = 1 /* NOTE3 */
AND GNGENTYPE.IDGENTYPE = 'TP01' /* NOTE4 */
|
Notes
▪1: The NMATTRIBUTE field of the ADATTRIBUTE table has the name of the attribute created in Configuration Attribute. ▪2: The FGENABLED field of the RIRISK table determines whether the risk is enabled (value = 1) or disabled (value = 2). ▪3: The FGACTIVE field of the GNGENTYPE table determines whether the risk type is enabled (value = 1) or disabled (value = 2). ▪4: The IDGENTYPE field of the GNGENTYPE table is used to filter the risks of a certain risk type, using the risk type ID # as a filter.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
IDRISK
|
VARCHAR(50)
|
Risk ID #
|
2
|
NMRISK
|
VARCHAR(255)
|
Risk name
|
3
|
DSRISK
|
TEXT
|
Risk description
|
4
|
FGVALUE
|
NUMERIC(2)
|
Risk classification:
1 – Loss
2 – Opportunity
|
5
|
IDGENTYPE
|
VARCHAR(50)
|
Risk type ID #
|
6
|
NMGENTYPE
|
VARCHAR(255)
|
Risk type name
|
7
|
Atributo01
|
VARCHAR(255)
|
Result of attribute 'A01'
Attribute type = List of values
|
8
|
Atributo02
|
NUMERIC(28,12)
|
Result of attribute 'A02'
Attribute type = List of values
|
9
|
Atributo03
|
VARCHAR(255)
|
Result of attribute 'A03'
Attribute type = Indeterminate
|
10
|
Atributo04
|
NUMERIC(28,12)
|
Result of attribute 'A04'
Attribute type = Indeterminate
|
|