Overview

This command will list all released reference requirements, with the number of applicable requirements and the implementation percentage of the requirement in the organization.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
RQREQUIREMENT	Requirement record table	CDREQUIREMENT CDREVISION	GNREVISION GNASSOC DCDOCUMENT
RQREVISION	Table that stores the requirement revision data	CDREQUIREMENT CDREVISION	RQTYPE GNFAVORITE ADALLUSERS ADTEAM RQREQUIREMENT
RQTYPE	Requirement type table	CDGENTYPE	GNGENTYPE GNTYPEROLE GNMASK
RQREQCOVERAGE	Stores the requirement coverage calculation results	CDREQCOVERAGE	RQREQUIREMENT ADDEPARTMENT GNEVALRESULTUSED
GNREVISION	Revisions	CDREVISION	GNASSOC GNACTIONASSOC GNREVCONFIG GNREASON GNREVISIONSTATUS ADALLUSERS
GNGENTYPE	Generic type	CDGENTYPE	GNELETRONICFILECFG GNEVAL GNFAVORITE GNREVCONFIG GNMASK GNTYPEROLE ADCHECKLIST GNASSOC GNACTIVITYTIMECFG GNMASK GNTYPEROLE GNTRANSLATION GNSECURITY

Oracle/Postgres/SQL Server

SELECT GNGENTYPE.IDGENTYPE,
   GNGENTYPE.NMGENTYPE,
   RQREQUIREMENT.IDREQUIREMENT,
   RQREQUIREMENT.NMREQUIREMENT,
   RQREQCOVERAGE.QTAPPLY,
   RQREQCOVERAGE.QTAPPLYTOTAL - RQREQCOVERAGE.QTAPPLY AS QTNOTAPPLY,
   RQREQCOVERAGE.VLIMPLEMENTED,
   GNREVISION.IDREVISION
FROM RQREQUIREMENT
     INNER JOIN RQREVISION ON RQREVISION.CDREQUIREMENT = RQREQUIREMENT.CDREQUIREMENTBASE AND RQREVISION.CDREVISION = RQREQUIREMENT.CDREVISION
     INNER JOIN GNREVISION ON GNREVISION.CDREVISION = RQREQUIREMENT.CDREVISION
     INNER JOIN RQTYPE ON RQTYPE.CDGENTYPE = RQREVISION.CDGENTYPE
     INNER JOIN GNGENTYPE ON GNGENTYPE.CDGENTYPE=RQTYPE.CDGENTYPE
     LEFT OUTER JOIN RQREQCOVERAGE ON RQREQCOVERAGE.CDREQUIREMENT = RQREQUIREMENT.CDREQUIREMENT AND RQREQCOVERAGE.CDREQUIREMENTREV = RQREQUIREMENT.CDREVISION
WHERE RQREQUIREMENT.CDREQUIREMENT = RQREQUIREMENT.CDREQUIREMENTBASE
  AND GNREVISION.FGSTATUS = 6 /* NOTE1 */
  AND RQREVISION.FGCURRENT = 1 /* NOTE2 */
  AND RQREQCOVERAGE.CDBUSINESSUNIT IS NULL /* NOTE3 */

Notes

▪1: 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.

▪2: The FGCURRENT field of the RQREVISION table is used to search for the current revision that is not obsolete.

▪3: This filter is used to search for the value of the calculation of all mappings performed for the requirement.

Fields used on the view screen

requirement-01

requirement-02