Visão geral

Este comando listará os mapeamentos do requisito e os escopos associados com os resultados de aplicabilidade e implementação. Permite uma visão analí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	CDMAPPING CDREVISION	GNREVISION ADALLUSERS ADTEAM RQMAPPINGCONFIG GNTYPEROLE ADDEPARTMENT GNASSOC OBOBJECT GNSUPPLIER
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
GNSUPPLIER	Tabela para o cadastro genérico de fornecedores	CDSUPPLIER	CDCOMPANY CDASSOC CDSUPPLIERTYPE CDCOMPLEXFILECONT
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,
   RQMAPPINGREVISION.IDMAPPING,
   RQMAPPINGREVISION.NMMAPPING,
   RQREQUIREMENT.IDREQUIREMENT,
   RQREQUIREMENT.NMREQUIREMENT,
   RQMAPCOVERAGE.QTAPPLY,
   RQMAPCOVERAGE.QTAPPLYTOTAL - RQMAPCOVERAGE.QTAPPLY AS QTNOTAPPLY,
   RQMAPCOVERAGE.VLIMPLEMENTED,
   ADDEPARTMENT.IDDEPARTMENT AS IDBUSINESSUNIT,
   ADDEPARTMENT.NMDEPARTMENT AS NMBUSINESSUNIT,
   ADAREA.IDDEPARTMENT AS IDAREA,
   ADAREA.NMDEPARTMENT AS NMAREA,
   OBOBJECT.IDOBJECT,
   OBOBJECT.NMOBJECT,
   ADCOMPANY.IDCOMMERCIAL,
   ADCOMPANY.NMCOMPANY,
   GNREVISION.IDREVISION
FROM RQMAPPINGREVISION
   INNER JOIN GNREVISION ON GNREVISION.CDREVISION = RQMAPPINGREVISION.CDREVISION
   INNER JOIN RQMAPPINGREQM ON RQMAPPINGREQM.CDMAPPING = RQMAPPINGREVISION.CDMAPPING
   AND RQMAPPINGREQM.CDMAPPINGREVISION = RQMAPPINGREVISION.CDREVISION
   INNER JOIN RQREQUIREMENT ON RQREQUIREMENT.CDREQUIREMENT = RQMAPPINGREQM.CDREQUIREMENT
   AND RQREQUIREMENT.CDREVISION = RQMAPPINGREQM.CDREQUIREMENTREV
   INNER JOIN RQMAPCOVERAGE ON RQMAPCOVERAGE.CDREQUIREMENT = RQMAPPINGREQM.CDREQUIREMENT
   AND RQMAPCOVERAGE.CDREQUIREMENTREV = RQMAPPINGREQM.CDREQUIREMENTREV
   AND RQMAPCOVERAGE.CDMAPPING = RQMAPPINGREQM.CDMAPPING
   AND RQMAPCOVERAGE.CDMAPPINGREVISION = RQMAPPINGREQM.CDMAPPINGREVISION
   INNER JOIN ADDEPARTMENT ON ADDEPARTMENT.CDDEPARTMENT = RQMAPPINGREVISION.CDBUSINESSUNIT
   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-03

requirement-04