Navigation:  Action plan >

Action plan templates

 Previous  Top  Next

Overview (Description):

This command will list the main data referring to an action plan action/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

GNACTIVITY

GNACTIONPLAN

GNTASK

ADUSER

ADEXTERNALUSER

ADTEAM

GNCOSTCONFIG

GNTASK

Specific actions table (both plan actions/plan template and isolated actions)

CDTASK

GNACTIVITY

GNACTIONPLAN

Specific table for action plans/plan templates

CDACTIONPLAN

GNACTIVITY

GNGENTYPE

Generic type table (category)

CDGENTYPE

GNTASK

ADUSER

Internal users view

CDUSER

GNACTIVITY

ADEXTERNALUSER

External users view

CDEXTERNALUSER

GNACTIVITY

ADTEAM

Team table

CDTEAM

GNACTIVITY

GNCOSTCONFIG

Cost table

CDCOSTCONFIG

GNACTIVITY

 

Oracle/Postgres/SQL Server

SELECT   ACAO.CDGENACTIVITY, /*NOTE1*/
ACAO.IDACTIVITY,
ACAO.NMACTIVITY,
ACAO.FGSTATUS,
ACAO.DSDESCRIPTION,
ACAO.DSACTIVITY,
ACAO.DTSTARTPLAN,
ACAO.QTTIMESTARTPLAN,
ACAO.DTFINISHPLAN,
ACAO.QTTIMEFINISHPLAN,
ACAO.QTDURATIONPLAN,
ACAO.DTSTART,
ACAO.QTTIMESTART,
ACAO.DTFINISH,
ACAO.QTTIMEFINISH,
ACAO.QTDURATIONREAL,
ACAO.VLPERCENTAGE,
GNTASK.FGIMMEDIATEACTION,
GNTASK.DSWHERE,
GNTASK.DSWHY,
GNGENTYPE.IDGENTYPE,
GNGENTYPE.NMGENTYPE,
ADUSER.IDUSER,
ADUSER.NMUSER,
ADEXTERNALUSER.NMEMAIL,
ADEXTERNALUSER.NMUSER,
ADTEAM.IDTEAM,
ADTEAM.NMTEAM,
GNCOSTCONFIG.MNCOSTPROG,
GNCOSTCONFIG.MNCOSTREAL
FROM GNACTIVITY PLANO
INNER JOIN GNACTIONPLAN ON GNACTIONPLAN.CDGENACTIVITY = PLANO.CDGENACTIVITY
INNER JOIN GNACTIVITY ACAO ON ACAO.CDACTIVITYOWNER = PLANO.CDGENACTIVITY
INNER JOIN GNTASK ON GNTASK.CDGENACTIVITY = ACAO.CDGENACTIVITY
LEFT OUTER JOIN GNGENTYPE ON GNGENTYPE.CDGENTYPE = GNTASK.CDTASKTYPE 
LEFT OUTER JOIN ADUSER ON ADUSER.CDUSER = ACAO.CDUSER
LEFT OUTER JOIN ADEXTERNALUSER ON ADEXTERNALUSER.CDEXTERNALUSER = ACAO.CDEXTERNALUSER
LEFT OUTER JOIN ADTEAM ON ADTEAM.CDTEAM = ACAO.CDTEAM
LEFT OUTER JOIN GNCOSTCONFIG ON GNCOSTCONFIG.CDCOSTCONFIG = ACAO.CDCOSTCONFIG
WHERE PLANO.IDACTIVITY = 'Plan_or_plan_template_ID /*NOTE2*/
  AND ACAO.IDACTIVITY = 'Plan_action_or_template_ID' /*NOTE3*/

 

Notes

▪1: Unique internal code of the action;

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

▪3: Action plan action/Action plan template ID #.

 

Fields used on the view screen

 

action_plan-01

 

#

Field ID

Type

Description

1

ACAO.FGSTATUS

NUMERIC(2)/*SQL Server*/

NUMBER(2)/*Oracle*/

INTEGER/*Postgres*/

1- Planning

2- Planning approval

3- Execution

4- Effectiveness/action verification

5- Finished

6- Cancelled

2

ACAO.IDACTIVITY

VARCHAR(50)

3

ACAO.NMACTIVITY

VARCHAR(255)

4

GNGENTYPE.IDGENTYPE

GNGENTYPE.NMGENTYPE

VARCHAR(50)

VARCHAR(255)

5

GNTASK.FGIMMEDIATEACTION

NUMERIC(2)/*SQL Server*/

NUMBER(2)/*Oracle*/

INTEGER/*Postgres*/

1- Immediate action

2- Planned action

6

ADUSER.IDUSER

ADUSER.NMUSER

ADEXTERNALUSER.NMEMAIL

ADEXTERNALUSER.NMUSER

VARCHAR(50)

VARCHAR(255)

VARCHAR(255)

VARCHAR(255)

ADEXTERNALUSER table: when it is an external user

7

ADTEAM.IDTEAM

ADTEAM.NMTEAM

VARCHAR(50)

VARCHAR(255)

8

ACAO.DTSTARTPLAN

DATETIME/*SQL Server*/

DATE/*Oracle*/

DATE/*Postgres*/

9

ACAO.QTTIMESTARTPLAN

NUMERIC(10)/*SQL Server*/

NUMBER(10)/*Oracle*/

INTEGER/*Postgres*/

Total in minutes

10

ACAO.DTFINISHPLAN

DATETIME/*SQL Server*/

DATE/*Oracle*/

DATE/*Postgres*/

11

ACTION QTTIMEFINISHPLAN

NUMERIC(10)/*SQL Server*/

NUMBER(10)/*Oracle*/

INTEGER/*Postgres*/

Total in minutes

12

ACAO.QTDURATIONPLAN

NUMERIC(10)/*SQL Server*/

NUMBER(10)/*Oracle*/

INTEGER/*Postgres*/

Total in days

13

GNCOSTCONFIG.MNCOSTPROG

NUMERIC(28,12)/*SQL Server*/

NUMBER(28,12)/*Oracle*/

NUMERIC(28,12)/*Postgres*/

14

ACAO.DTSTART

DATETIME/*SQL Server*/DATE/*Oracle*/

DATE/*Postgres*/

15

ACAO.QTTIMESTART

NUMERIC(10)/*SQL Server*/

NUMBER(10)/*Oracle*/

INTEGER/*Postgres*/

Total in minutes

16

ACAO.DTFINISH

DATETIME/*SQL Server*/

DATE/*Oracle*/

DATE/*Postgres*/

17

ACAO.QTTIMEFINISH

NUMERIC(10)/*SQL Server*/

NUMBER(10)/*Oracle*/

INTEGER/*Postgres*/

Total in minutes

18

ACAO.QTDURATIONREAL

NUMERIC(10)/*SQL Server*/

NUMBER(10)/*Oracle*/

INTEGER/*Postgres*/

Total in days

19

ACAO.VLPERCENTAGE

NUMERIC(28,12)/*SQL Server*/

NUMBER(28,12)/*Oracle*/

NUMERIC(28,12)/*Postgres*/

20

GNCOSTCONFIG.MNCOSTREAL

NUMERIC(28,12)/*SQL Server*/

NUMBER(28,12)/*Oracle*/

NUMERIC(28,12)/*Postgres*/

21

GNACTIVITY.DSACTIVITY

TEXT/*SQL Server*/

CLOB/*Oracle*/

TEXT/*Postgres*/

22

GNTASK.DSWHY

TEXT/*SQL Server*/

CLOB/*Oracle*/

TEXT/*Postgres*/

23

GNACTIVITY.DSDESCRIPTION

TEXT/*SQL Server*/

CLOB/*Oracle*/

TEXT/*Postgres*/

24

GNTASK.DSWHERE

TEXT/*SQL Server*/

CLOB/*Oracle*/

TEXT/*Postgres*/