Overview
This command will list all risk analyses of current plans whose revision is released. It also displays the inherent and residual result of the current evaluation and the risk analysis and risk evaluation attributes.
Related tables
TABLE
|
Description
|
Primary key (PK)
|
Connection tables
|
RIPLAN
|
Plan record
|
PCDPLAN
CDREVISION
|
RIPLANTYPE
GNMASK
GNASSOC
GNEVALREVISION
GNFAVORITE
GNTYPEROLE
GNTOOLSANALISYS
GNREVISION
ADALLUSERS
ADTEAM
RIPROFILE
ADDEPARTMENT
ADAPPROVALROUTE
RIFORMULARESIDEVAL
|
RIRISK
|
Risk record
|
CDRISK
|
RIRISKTYPE
GNTYPEROLE
INOCCURRENCETYPE
ADTEAM
ADUSER
GNASSOC
GNTOOLSANALISYS
|
RIRISKANALYSIS
|
Risk analysis record
|
CDRISKANALYSIS
|
GNASSOC
ADALLUSERS
ADTEAM
ADMEASUNITY
RIRISK
GNEVALREVISION
GNTOOLSANALISYS
GNFORMULA
|
RIRISKANAEVAL
|
Risk evaluation record
|
CDRISKANAEVAL
|
RIRISKANALYSIS
GNEVALRESULTUSED
GNASSOC
GNAPPROV
RIFORMULARESIDEVAL
|
GNASSOCATTRIB
|
Attribute association table
|
CDASSOC
CDATTRIBUTE
|
GNASSOC
ADATTRIBUTE
ADATTRIBVALUE
ADATTRIBUTEOBJECT
|
GNASSOCRISKANA
|
Risk analysis association table
|
CDASSOCRISKANA
|
GNASSOC
RIRISKANALYSIS
RIPLAN
|
GNREVISION
|
Revisions
|
CDREVISION
|
GNASSOC
GNACTIONASSOC
GNREVCONFIG
GNREASON
GNREVISIONSTATUS
ADALLUSERS
|
GNEVALRESULTUSED
|
Result of used evaluations
|
CDEVALRESULTUSED
|
GNEVALRESULT
|
GNEVALRESULT
|
Evaluation method results
|
CDEVALRESULT
|
GNEVALREVISION
|
Oracle/Postgres/SQL Server
SELECT RIPLAN.IDPLAN,
RIPLAN.NMPLAN,
RIRISKANALYSIS.IDRISKANALYSIS,
RIRISK.NMRISK,
RIRISKANALYSIS.DSRISKANALYSIS,
GERU_IN.VLEVALRESULT AS VLEVALRESULTREAL,
GER_IN.NMEVALRESULT AS NMEVALRESULT_REAL,
GERU_RES.VLEVALRESULT AS VLEVALRESULTRESID,
GER_RESID.NMEVALRESULT AS NMEVALRESULT_RESID,
RIRISKANAEVAL.IDPERIOD,
RIRISKANAEVAL.DTEVAL,
(SELECT NMVALUE FROM GNASSOCATTRIB
WHERE CDASSOC = RIRISKANALYSIS.CDASSOC
AND CDATTRIBUTE = 515 /* NOTE1 */) AS ATRIBUTO_ANALISE,
(SELECT NMVALUE FROM GNASSOCATTRIB
WHERE CDASSOC = RIRISKANAEVAL.CDASSOC
AND CDATTRIBUTE = 515) AS ATRIBUTO_AVALIACAO
FROM GNASSOCRISKANA
INNER JOIN RIRISKANALYSIS ON RIRISKANALYSIS.CDRISKANALYSIS = GNASSOCRISKANA.CDRISKANALYSIS
INNER JOIN RIRISK ON RIRISK.CDRISK = RIRISKANALYSIS.CDRISK
INNER JOIN RIPLAN ON RIPLAN.CDPLAN = GNASSOCRISKANA.CDPLAN AND RIPLAN.CDREVISION = GNASSOCRISKANA.CDREVISION
INNER JOIN GNREVISION ON GNREVISION.CDREVISION = RIPLAN.CDREVISION
LEFT OUTER JOIN RIRISKANAEVAL ON RIRISKANAEVAL.CDRISKANALYSIS = RIRISKANALYSIS.CDRISKANALYSIS
LEFT OUTER JOIN GNEVALRESULTUSED GERU_IN ON GERU_IN.CDEVALRESULTUSED = RIRISKANAEVAL.CDEVALRESULTREAL
LEFT OUTER JOIN GNEVALRESULTUSED GERU_RES ON GERU_RES.CDEVALRESULTUSED = RIRISKANAEVAL.CDEVALRESULTRESID
LEFT OUTER JOIN GNEVALRESULT GER_IN ON GERU_IN.CDEVALRESULT=GER_IN.CDEVALRESULT
LEFT OUTER JOIN GNEVALRESULT GER_RESID ON GERU_RES.CDEVALRESULT=GER_RESID.CDEVALRESULT
WHERE RIPLAN.FGTEMPLATE = 2 /* NOTE2 */
AND RIPLAN.FGSTATUS = 1 /* NOTE3 */
AND RIPLAN.FGCURRENT = 1 /* NOTE4 */
AND GNREVISION.FGSTATUS = 6 /* NOTE5 */
AND RIRISKANAEVAL.FGCURRENT = 1 /* NOTE6 */
|
Notes
▪1: The NMVALUE field of the ADATTRIBUTE table has the name of the attribute created in Configuration Attribute. ▪2: The FGTEMPLATE field of the RIPLAN table informs whether the plan is a template. If it is, the value will be equal to 1; if it is not, it will be equal to 2. ▪3: The FGSTATUS field of the RIPLAN table determines whether the plan is enabled (value = 1) or disabled (value = 3). ▪4: The FGCURRENT field of the RIPLAN table determines whether the risk plan is enabled and is a revision of the current plan. Current and released plans have a value equal to 1; plans that are in the draft step or are obsolete have a value equal to 2. ▪5: The FGSTATUS field of the GNREVISION table indicates the revision status, defined as: 1 = Draft; 2 = Review; 3 = Approval; 4 = Release; 5 = Released; 6 = Closed. ▪6: The FGCURRENT field of the RIRISKANAEVAL table is used to search for the current risk analysis evaluation. The risk analysis has only one current evaluation.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
IDPLAN
|
VARCHAR (255)
|
Position ID #
|
2
|
NMPLAN
|
VARCHAR(255)
|
Plan name
|
3
|
IDRISKANALYSIS
|
VARCHAR(50)
|
Risk analysis ID #
|
4
|
NMRISK
|
VARCHAR(255)
|
Risk name
|
5
|
DSRISKANALYSIS
|
TEXT
|
Risk analysis comment
|
6
|
VLEVALRESULTREAL
|
NUMERIC(28,12)
|
Value of the "actual" risk evaluation
|
7
|
NMEVALRESULT_REAL
|
VARCHAR(255)
|
Result of the "actual" risk evaluation
|
8
|
VLEVALRESULTRESID
|
NUMERIC(28,12)
|
Value of the "residual" risk evaluation
|
9
|
NMEVALRESULT_RESID
|
VARCHAR(255)
|
Result of the "residual" risk evaluation
|
10
|
IDPERIOD
|
VARCHAR(50)
|
Risk evaluation ID #
|
11
|
DTEVAL
|
DATETIME
|
Evaluation date
|
12
|
ATRIBUTO_ANALISE
|
VARCHAR(255)
|
Result of the '515' attribute associated with the risk analysis
Attribute type = Indeterminate
|
13
|
ATRIBUTO_AVALIACAO
|
VARCHAR(255)
|
Result of the '515' attribute associated with the risk evaluation
Attribute type = Indeterminate
|
|