Overview

This command will list the main data referring to an action plan/action plan template.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
GNACTIVITY	Table that stores common activity information (it is also used by other components, such as Workflow, Survey, Asset, etc.)	CDGENACTIVITY	GNACTIONPLAN ADUSER ADTEAM GNCOSTCONFIG GNCALENDAR GNEVALRESULTUSED
GNACTIONPLAN	Specific table for action plans/plan templates	CDACTIONPLAN	GNACTIVITY GNGENTYPE
GNGENTYPE	Generic type table (category)	CDGENTYPE	GNACTIONPLAN
ADUSER	Users view	CDUSER	GNACTIVITY
ADTEAM	Team table	CDTEAM	GNACTIVITY
GNCOSTCONFIG	Cost table	CDCOSTCONFIG	GNACTIVITY
GNCALENDAR	Calendar table	CDCALENDAR	GNACTIVITY
GNEVALRESULTUSED	Generic evaluation table	CDEVALRESULTUSED	GNACTIVITY
GNEVALRESULT	Evaluation result table	CDEVALRESULT	GNEVALRESULTUSED

Oracle/Postgres/SQL Server

SELECT GNACTIVITY.CDGENACTIVITY, /*NOTE1*/
GNACTIVITY.IDACTIVITY,
GNACTIVITY.NMACTIVITY,
GNACTIVITY.FGSTATUS,
GNACTIVITY.DSDESCRIPTION,
GNACTIVITY.DSOBJECTIVE,
GNACTIVITY.DSREASON,
GNACTIVITY.DSBENEFIT,
GNACTIVITY.DTSTARTPLAN,
GNACTIVITY.QTTIMESTARTPLAN,
GNACTIVITY.DTFINISHPLAN,
GNACTIVITY.QTTIMEFINISHPLAN,
GNACTIVITY.QTDURATIONPLAN,
GNACTIVITY.DTSTART,
GNACTIVITY.QTTIMESTART,
GNACTIVITY.DTFINISH,
GNACTIVITY.QTTIMEFINISH,
GNACTIVITY.QTDURATIONREAL,
GNACTIVITY.VLPERCENTAGE,
GNACTIVITY.FGUSETYPEACCESS,
GNACTIONPLAN.FGMODEL,
GNGENTYPE.IDGENTYPE,
GNGENTYPE.NMGENTYPE,
ADUPLAN.IDUSER AS IDUSERPLAN,
ADUPLAN.NMUSER AS NMUSERPLAN,
ADUEXEC.IDUSER AS USEREXEC,
ADUEXEC.NMUSER AS NMUSEREXEC,
ADTPLAN.IDTEAM AS IDTEAMPLAN,
ADTPLAN.NMTEAM AS NMTEAMPLAN,
ADTEXEC.IDTEAM AS IDTEAMEXEC,
ADTEXEC.NMTEAM AS NMTEAMEXEC,
GNCOSTCONFIG.MNCOSTPROG,
GNCOSTCONFIG.MNCOSTREAL,
GNCALENDAR.IDCALENDAR,
GNCALENDAR.NMCALENDAR,
GNEVALRESULT.NMEVALRESULT,
GNEVALRESULTUSED.VLEVALRESULT
FROM GNACTIVITY
INNER JOIN GNACTIONPLAN ON GNACTIONPLAN.CDGENACTIVITY = GNACTIVITY.CDGENACTIVITY
INNER JOIN GNGENTYPE ON GNGENTYPE.CDGENTYPE = GNACTIONPLAN.CDACTIONPLANTYPE
INNER JOIN ADUSER ADUPLAN ON ADUPLAN.CDUSER = GNACTIVITY.CDUSER
INNER JOIN ADUSER ADUEXEC ON ADUEXEC.CDUSER = GNACTIVITY.CDUSERACTIVRESP
LEFT OUTER JOIN ADTEAM ADTPLAN ON ADTPLAN.CDTEAM = GNACTIVITY.CDTEAMPLAN
LEFT OUTER JOIN ADTEAM ADTEXEC ON ADTEXEC.CDTEAM = GNACTIVITY.CDTEAM
LEFT OUTER JOIN GNCOSTCONFIG ON GNCOSTCONFIG.CDCOSTCONFIG = GNACTIVITY.CDCOSTCONFIG
LEFT OUTER JOIN GNCALENDAR ON GNCALENDAR.CDCALENDAR = GNACTIVITY.CDCALENDAR
LEFT OUTER JOIN GNEVALRESULTUSED ON GNEVALRESULTUSED.CDEVALRESULTUSED = GNACTIVITY.CDEVALRSLTPRIORITY
LEFT OUTER JOIN GNEVALRESULT ON GNEVALRESULT.CDEVALRESULT = GNEVALRESULTUSED.CDEVALRESULT
WHERE GNACTIVITY.IDACTIVITY = 'Plan_or_plan_template_ID' /*NOTE2*/

Notes

▪1: Unique internal code of the action plan/action plan template;

▪2: Action plan/action plan template ID #;

Fields used on the view screen

action_plan-02