Visão geral

Este comando listará os mapeamentos dos requisitos e os resultados de aplicabilidade e implementação de toda a estrutura do requisito. Permitirá uma visão sintética do mapeamento de requisito.

Tabelas relacionadas

TABELA	Descrição	Chave primária (PK)	Tabelas de ligação
RQMAPPINGREVISION	Tabela que armazena dados da revisão do mapeamento de requisito	CDOBJECT CDREVISION	GNREVISION ADALLUSERS ADTEAM RQMAPPINGCONFIG GNTYPEROLE ADDEPARTMENT GNASSOC OBOBJECT GNSUPPLIER
RQREVISION	Tabela que armazena dados da revisão do requisito	CDREQUIREMENT CDREVISION	RQTYPE GNFAVORITE ADALLUSERS ADTEAM RQREQUIREMENT
RQMAPPINGCONFIG	Tabela de configuração do mapeamento do requisito	CDGENTYPE	GNGENTYPE RQTYPE GNEVAL ADDEPARTMENT
RQMAPPINGANALYSIS	Tabela que armazena os mapeamentos dos requisitos	CDMAPPINGANALYSIS	RQREQUIREMENT RQMAPPINGREVISION ADDEPARTMENT PMPROCESS ADDEPARTMENT GNASSOC GNEVALRESULTUSED
RQMAPPINGREQM	Tabela associativa entre o mapeamento de requisito e o requisito	CDMAPPING CDMAPPINGREVISION CDREQUIREMENT CDREQUIREMENTREV	RQMAPPINGREVISION RQREVISION
RQREQUIREMENT	Tabela de cadastro de requisitos	CDREQUIREMENT CDREVISION	GNREVISION GNASSOC DCDOCUMENT
RQMAPCOVERAGE	Armazena o nível de cobertura dos mapeamentos de requisito	CDMAPCOVERAGE	RQREQUIREMENT RQMAPPINGREVISION ADDEPARTMENT GNEVALRESULTUSED
RQMAPPINGDEPT	Tabela de associação de áreas com o mapeamento de requisito	CDMAPPING CDMAPPINGREVISION CDDEPARTMENT	RQMAPPINGREVISION ADDEPARTMENT
GNREVISION	Revisões	CDREVISION	GNASSOC GNACTIONASSOC GNREVCONFIG GNREASON GNREVISIONSTATUS ADALLUSERS
GNGENTYPE	Tipo genérico	CDGENTYPE	GNELETRONICFILECFG GNEVAL GNFAVORITE GNREVCONFIG GNMASK GNTYPEROLE ADCHECKLIST GNASSOC GNACTIVITYTIMECFG GNMASK GNTYPEROLE GNTRANSLATION GNSECURITY
GNSUPPLIER	Tabela para o cadastro genérico de fornecedores	CDSUPPLIER	CDCOMPANY CDASSOC CDSUPPLIERTYPE CDCOMPLEXFILECONT
GNEVALRESULTUSED	Resultados das avaliações utilizadas	CDEVALRESULTUSED	GNEVALRESULT
GNEVALRESULT	Resultados do método de avaliação	CDEVALRESULT	GNEVALREVISION
ADCOMPANY	Empresas cliente/fornecedores	CDCOMPANY	ADCOMPANYTYPE
ADDEPARTMENT	Cadastro de unidade de negócio e áreas	CDDEPARTMENT	GNFAVORITE ADALLUSERS COWORKSPACE ADTEAM ADDEPARTMENT GNASSOC GNMAPPING
OBOBJECT	Tabela base dos objetos	CDOBJECT CDREVISION	OBSUBREASON GNASSOC GNREVISION OBOBJECTGROUP ADTEAM

Oracle/Postgres/SQL Server

SELECT RQMAPPINGREVISION.FGOBJECTMAP,
   GNGENTYPE.IDGENTYPE,
   GNGENTYPE.NMGENTYPE,
   RQMAPPINGREVISION.IDMAPPING,
   RQMAPPINGREVISION.NMMAPPING,
   FATHER.IDREQUIREMENT AS IDREQREFERENCE,
   FATHER.NMREQUIREMENT AS NMREQREFERENCE,
   REQUIREMENTS.FGREQMODEL,
   REQUIREMENTS.IDREQUIREMENT,
   REQUIREMENTS.NMREQUIREMENT,
   GNEVALRESULT.NMEVALRESULT,
   RQMAPCOVERAGE.QTAPPLY,
   RQMAPCOVERAGE.QTAPPLYTOTAL - RQMAPCOVERAGE.QTAPPLY AS QTNOTAPPLY,
   RQMAPCOVERAGE.VLIMPLEMENTED,
   RQMAPPINGANALYSIS.DSJUSTIFY,
   ADBU.IDDEPARTMENT AS IDBUSINESSUNIT,
   ADBU.NMDEPARTMENT AS NMBUSINESSUNIT,
   ADAREA.IDDEPARTMENT AS IDAREA,
   ADAREA.NMDEPARTMENT AS NMAREA,
   OBOBJECT.IDOBJECT,
   OBOBJECT.NMOBJECT,
   ADCOMPANY.IDCOMMERCIAL,
   ADCOMPANY.NMCOMPANY
FROM RQMAPPINGREVISION
     INNER JOIN GNREVISION ON GNREVISION.CDREVISION = RQMAPPINGREVISION.CDREVISION
     INNER JOIN RQMAPPINGCONFIG ON RQMAPPINGCONFIG.CDGENTYPE = RQMAPPINGREVISION.CDGENTYPE
     INNER JOIN GNGENTYPE ON GNGENTYPE.CDGENTYPE=RQMAPPINGCONFIG.CDGENTYPE
     INNER JOIN RQMAPPINGREQM ON RQMAPPINGREQM.CDMAPPING=RQMAPPINGREVISION.CDMAPPING
   AND RQMAPPINGREQM.CDMAPPINGREVISION=RQMAPPINGREVISION.CDREVISION
     INNER JOIN (
   SELECT
   1 AS FGREQMODEL,
   GUIDE.CDREQUIREMENT,
   GUIDE.CDREVISION,
   GUIDE.IDREQUIREMENT,
   GUIDE.NMREQUIREMENT,
   GUIDE.CDREQUIREMENTOWNER,
   GUIDE.CDREQUIREMENTBASE,
   REFG.IDREQUIREMENT AS NMREF
   FROM RQREQUIREMENT GUIDE
   INNER JOIN RQREQUIREMENT REFG ON GUIDE.CDREQUIREMENT=REFG.CDREQUIREMENT
   AND GUIDE.CDREVISION=REFG.CDREVISION
   WHERE GUIDE.CDREQUIREMENTOWNER IS NOT NULL
   AND EXISTS (SELECT 1 FROM RQREQUIREMENT WHERE RQREQUIREMENT.CDREQUIREMENTOWNER = GUIDE.CDREQUIREMENT)
   UNION ALL
   SELECT
   2 AS FGREQMODEL,
   LEAF.CDREQUIREMENT,
   LEAF.CDREVISION,
   LEAF.IDREQUIREMENT,
   LEAF.NMREQUIREMENT,
   LEAF.CDREQUIREMENTOWNER,
   LEAF.CDREQUIREMENTBASE,
   REFL.IDREQUIREMENT AS NMREF
   FROM RQREQUIREMENT LEAF
   INNER JOIN RQREQUIREMENT REFL ON REFL.CDREQUIREMENT=LEAF.CDREQUIREMENT
   AND LEAF.CDREVISION=REFL.CDREVISION
   WHERE LEAF.CDREQUIREMENTOWNER IS NOT NULL
   AND NOT EXISTS (SELECT 1 FROM RQREQUIREMENT WHERE RQREQUIREMENT.CDREQUIREMENTOWNER=LEAF.CDREQUIREMENT)
   ) REQUIREMENTS ON REQUIREMENTS.CDREQUIREMENTBASE = RQMAPPINGREQM.CDREQUIREMENT AND REQUIREMENTS.CDREVISION = RQMAPPINGREQM.CDREQUIREMENTREV
     INNER JOIN RQREVISION ON REQUIREMENTS.CDREVISION = RQREVISION.CDREVISION
     INNER JOIN ADDEPARTMENT ADBU ON RQMAPPINGREVISION.CDBUSINESSUNIT=ADBU.CDDEPARTMENT
     INNER JOIN RQMAPPINGANALYSIS ON RQMAPPINGANALYSIS.CDBUSINESSUNIT IS NOT NULL
   AND RQMAPPINGANALYSIS.CDREQUIREMENT=REQUIREMENTS.CDREQUIREMENT
   AND RQMAPPINGANALYSIS.CDREQUIREMENTREV=REQUIREMENTS.CDREVISION
   AND RQMAPPINGANALYSIS.CDMAPPING=RQMAPPINGREQM.CDMAPPING
   AND RQMAPPINGANALYSIS.CDMAPPINGREVISION=RQMAPPINGREQM.CDMAPPINGREVISION
     LEFT OUTER JOIN RQMAPCOVERAGE ON RQMAPCOVERAGE.CDREQUIREMENT=REQUIREMENTS.CDREQUIREMENT
   AND RQMAPCOVERAGE.CDREQUIREMENTREV=REQUIREMENTS.CDREVISION
   AND RQMAPCOVERAGE.CDMAPPING=RQMAPPINGREQM.CDMAPPING
   AND RQMAPCOVERAGE.CDMAPPINGREVISION=RQMAPPINGREQM.CDMAPPINGREVISION
     LEFT OUTER JOIN RQREQUIREMENT FATHER ON FATHER.CDREQUIREMENT=REQUIREMENTS.CDREQUIREMENTBASE
   AND FATHER.CDREVISION=REQUIREMENTS.CDREVISION
     LEFT OUTER JOIN GNEVALRESULTUSED ON GNEVALRESULTUSED.CDEVALRESULTUSED=RQMAPCOVERAGE.CDEVALRESULTUSED
     LEFT OUTER JOIN GNEVALRESULT ON GNEVALRESULT.CDEVALRESULT = GNEVALRESULTUSED.CDEVALRESULT
     LEFT OUTER JOIN RQMAPPINGDEPT ON RQMAPPINGDEPT.CDMAPPING=RQMAPPINGREVISION.CDMAPPING
   AND RQMAPPINGDEPT.CDMAPPINGREVISION=RQMAPPINGREVISION.CDREVISION
     LEFT OUTER JOIN ADDEPARTMENT ADAREA ON ADAREA.CDDEPARTMENT = RQMAPPINGDEPT.CDDEPARTMENT
     LEFT OUTER JOIN OBOBJECT ON OBOBJECT.CDOBJECT=RQMAPPINGREVISION.CDOBJECT
   AND OBOBJECT.CDREVISION=RQMAPPINGREVISION.CDOBJECTREV
     LEFT OUTER JOIN GNSUPPLIER ON GNSUPPLIER.CDSUPPLIER = RQMAPPINGREVISION.CDSUPPLIER
     LEFT OUTER JOIN ADCOMPANY ON ADCOMPANY.CDCOMPANY = GNSUPPLIER.CDSUPPLIER
WHERE RQMAPPINGREVISION.FGCURRENT = 1 /* OBS1*/
  AND GNREVISION.FGSTATUS = 6 /* OBS2*/

Observações

▪1: O campo FGCURRENT da tabela RQMAPPINGREVISION é utilizado para buscar a revisão atual que não é obsoleta.

▪2: O campo FGSTATUS da tabela GNREVISION utilizado para informar a situação da revisão, definido desta maneira: 1 = Elaboração; 2 = Consenso; 3 = Aprovação; 4 = Homologação; 5 = Liberação; 6 = Encerrada.

Campos utilizados na consulta

requirement-05

requirement-06

requirement-07