Navigation: Protocol >

Protocols

Overview

This command will list the protocols added to the system.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
DCPROCEEDING	Protocol	CDPROCEEDING
DCPROCTYPE	Protocol type	CDPROCTYPE	DCPROCEEDING
ADUSER	User	CDUSER	DCPROCEEDING

Oracle/Postgres/SQL Server

SELECT
   CASE WHEN PT.FGTYPE = 1 THEN 'Electronic' ELSE 'Physical' END AS FGTYPE, /*NOTE1*/
   PT.IDPROCTYPE,
   P.IDPROCEEDING,
   P.NMTITLE,
   CASE
   WHEN P.FGSTATUS = 1 THEN 'To be started'
   WHEN P.FGSTATUS = 2 THEN 'In progress'
   WHEN P.FGSTATUS = 3 THEN 'Finished'
   WHEN P.FGSTATUS = 4 THEN 'Cancelled'
   END AS FGSTATUS, /*NOTE2*/
   P.DTSTART,
   P.TMSTART,
   P.DTDUEDATE,
   P.DTFINISH,
   P.NMREQUESTUSER,
   A.NMUSER AS CREATEDBY
FROM DCPROCEEDING P , DCPROCTYPE PT, ADUSER A
WHERE P.CDPROCTYPE = PT.CDPROCTYPE
AND P.CDCREATEDBY = A.CDUSER
ORDER BY PT.IDPROCTYPE, P.IDPROCEEDING

Notes

▪1: The PT.FGTYPE field indicates whether protocols will be electronic or physical. Case is used to display in text mode.

▪2: The P.FGSTATUS field indicates the protocol status. Case is used to display the status of each protocol in text mode.

Fields used on the view screen

protocol-01_1

#	Field ID	Type	Description
1	PT.FGTYPE	NUMERIC(2)
2	PT.IDPROCTYPE	VARCHAR(50)
3	P.IDPROCEEDING	VARCHAR(50)
4	P.NMTITLE	VARCHAR(255)
5	P.FGSTATUS	NUMERIC(2)
6	P.DTSTART	DATETIME
7	P.TMSTART	VARCHAR(8)
8	P.DTDUEDATE	DATETIME
9	P.NMREQUESTUSER	VARCHAR(255)