Protocols and their attributes

TABLE	Description	Primary key (PK)	Connection tables
DCPROCEEDING	Protocol	CDPROCEEDING
DCPROCATTRIB	Protocol attributes	CDPROCEEDING CDATTRIBUTE	DCPROCEEDING
ADATTRIBUTE	Attributes	CDATTRIBUTE	DCPROCATTRIB
ADATTRIBVALUE	List of values	CDATTRIBUTE CDVALUE	ADATTRIBUTE DCPROCATTRIB

Oracle/Postgres/SQL Server

SELECT  P.IDPROCEEDING,
   P.NMTITLE,
   ATT.NMLABEL, /*NOTE1*/
   PATT.NMVALUE, /*NOTE2*/
   PATT.DTVALUE, /*NOTE3*/
   PATT.VLVALUE, /*NOTE4*/
   ATTV.NMATTRIBUTE, /*NOTE5*/
   PATT.DSVALUE, /*NOTE6*/
   ATTV.DTATTRIBUTE,/*NOTE7*/
   ATTV.VLATTRIBUTE,/*NOTE8*/
   PATT.FGREQUIRED/*NOTE9*/
   FROM DCPROCEEDING P
   INNER JOIN DCPROCATTRIB PATT ON P.CDPROCEEDING= PATT.CDPROCEEDING
   INNER JOIN ADATTRIBUTE ATT ON PATT.CDATTRIBUTE = ATT.CDATTRIBUTE
   LEFT OUTER JOIN ADATTRIBVALUE ATTV ON ATTV.CDATTRIBUTE = ATT.CDATTRIBUTE AND ATTV.CDVALUE = PATT.CDVALUE
ORDER BY P.IDPROCEEDING

Notes

▪1: The ATT.NMLABEL field displays the name of the attribute related to the protocol.

▪2: The PATT.NMVALUE field will display a value if the attribute has a value of the indeterminate text type filled out in the protocol.

▪3: The PATT.DTVALUE field will display a value if the attribute has a value of the indeterminate date type filled out in the protocol.

▪4: The PATT.VLVALUE field will display a value if the attribute has a value of the indeterminate numeric type filled out in the protocol.

▪5: The ATTV.NMATTRIBUTE field will display a value if the attribute has a value of the list of values text type filled out in the protocol.

▪6: The PATT.DSVALUE field will display a value if the attribute has a value of the text type (4000 characters) filled out in the protocol.

▪7: The ATTV.DTATTRIBUTE field will display a value if the attribute has a value of the list of values text type filled out in the protocol.

▪8: The ATTV.VLATTRIBUTE field will display a value if the attribute has a value of the list of values text type filled out in the protocol.

▪9: The PATT.FGREQUIRED field indicates whether the attribute is required to be filled out in the protocol (value =1 required).

Fields used on the view screen

#	Field ID	Type	Description
1	P.IDPROCEEDING	VARCHAR(50)
2	P.NMTITLE	VARCHAR(255)
3	ATT.NMLABEL	VARCHAR(255)
4	PATT.VLVALUE	NUMERIC(28,12) NULL
5	PATT.DTVALUE	DATETIME NULL
6	PATT.DSVALUE	TEXT NULL
7	ATTV.DTATTRIBUTE	DATETIME NULL
8	ATTV.NMATTRIBUTE	VARCHAR(255) NULL
9	ATTV.VLATTRIBUTE	NUMERIC(28,12) NULL
10	PATT.FGREQUIRED	NUMERIC(2) NULL	1-Yes;2-No

Protocols and their attributes

Overview

Related tables

Oracle/Postgres/SQL Server

Notes

Fields used on the view screen