Navigation: Process >

Process attributes

Overview

This command will list the attributes added to the process and configured in the process type.

Related tables

Table	Description	Primary key (PK)	Connection tables
PMACTREVISION	Process revision table	PMACTREVISION
PMACTIVITY	Table with Process/Activity/Decision information	PKPMACTIVITY
GNACTIVITYATTRIB	Generic activity attribute value table	PKGNACTIVITYATTRIB
ADATTRIBUTE	Attribute record table	PKADATTRIBUTE

Oracle/Postgres/SQL Server

SELECT
ATRB.NMATTRIBUTE
FROM
PMACTREVISION AREV
INNER JOIN PMACTIVITY A ON AREV.CDACTIVITY = A.CDACTIVITY
INNER JOIN GNACTIVITYATTRIB ATT ON ATT.CDACTIVITY = A.CDGENACTIVITY
INNER JOIN ADATTRIBUTE ATRB ON ATRB.CDATTRIBUTE = ATT.CDATTRIBUTE
WHERE
AREV.FGCURRENT = 1
AND AREV.IDACTIVITY = 'BPM000001' /*NOTE1*/

Notes

▪1: Process ID #.

Fields used on the view screen

processo-01

#	Field ID	Type	Description
1	NMATTRIBUTE	VARCHAR(255)	Field of the ADATTRIBUTE table