Navigation: Protocol >

Protocols and documents

Overview

This command will list the protocols and documents added to the system.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
DCPROCEEDING	Protocol	CDPROCEEDING
DCPROCTYPE	Protocol type	CDPROCTYPE	DCPROCEEDING
DCPROCDOCUMENT	Protocol documents	CDPROCEEDING CDDOCUMENT CDREVISION	DCPROCEEDING DCDOCREVISION
DCDOCREVISION	Document	CDDOCUMENT CDREVISION	DCPROCDOCUMENT
GNREVISION	Revision	CDREVISION

Oracle/Postgres/SQL Server

SELECT
   PT.IDPROCTYPE,
   P.IDPROCEEDING,
   P.NMTITLE,
   DR.IDDOCUMENT,
   DR.NMTITLE,
   R.IDREVISION,
   P.DTSTART
FROM DCPROCEEDING P
INNER JOIN DCPROCTYPE PT ON P.CDPROCTYPE = PT.CDPROCTYPE
LEFT JOIN DCPROCDOCUMENT PD ON PD.CDPROCEEDING = P.CDPROCEEDING /*NOTE1*/
LEFT JOIN DCDOCREVISION DR ON DR.CDDOCUMENT = PD.CDDOCUMENT AND DR.CDREVISION = PD.CDREVISION
LEFT JOIN GNREVISION R ON R.CDREVISION = DR.CDREVISION
ORDER BY PT.IDPROCTYPE, P.IDPROCEEDING

Notes

▪1: The relationship with documents is made through LEFT JOIN; if there are no associated documents, the protocol would not be listed.

Fields used on the view screen

protocol-03

protocol-04

#	Field ID	Type	Description
1	PT.IDPROCTYPE	VARCHAR(50)
2	P.IDPROCEEDING	VARCHAR(50)
3	P.NMTITLE	VARCHAR(255)
4	DR.IDDOCUMENT	VARCHAR(50)
5	DR.NMTITLE	VARCHAR(255)
6	R.IDREVISION	VARCHAR(50)
7	P.DTSTART	DATETIME