Navigation:  Time control >

Nonproject task listing

 Previous  Top  Next

Overview

Query that will return the nonproject task data.

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

PRTASK

Stores the nonproject task data

CDTASK

PRTASKTYPE

GNCALENDAR

ADALLUSERS

PRTASKTYPE

Stores the nonproject task type data

CDTASKTYPE

GNCALENDAR

Stores the data of the calendar used in the nonproject task

CDCALENDAR

ADALLUSERS

Stores the data of users responsible for nonproject tasks

CDUSER

 

Oracle/Postgres/SQL Server

SELECT 
   PRTASK.NMIDTASK,
   PRTASK.NMTASK,
   PRTASKTYPE.IDTASKTYPE,
   PRTASKTYPE.NMTASKTYPE,
   PRTASK.FGPHASE,
   GNCALENDAR.IDCALENDAR,
   GNCALENDAR.NMCALENDAR,
   USERRESP.IDUSER,
   USERRESP.NMUSER,
   USEREXEC.IDUSER AS IDUSEREXEC,
   USEREXEC.NMUSER AS NMUSEREXEC,
   PRTASK.DTPLANST,
   PRTASK.DTPLANEND,
   PRTASK.QTPLANDUR,
   PRTASK.DTREPLST,
   PRTASK.DTREPLEND,
   PRTASK.QTREPLDUR,
   PRTASK.DTACTST,
   PRTASK.DTACTEND,
   PRTASK.QTACTDUR,
   PRTASK.QTACTPERC
FROM
   PRTASK
INNER JOIN
   PRTASKTYPE ON PRTASKTYPE.CDTASKTYPE = PRTASK.CDTASKTYPE
INNER JOIN
   GNCALENDAR ON GNCALENDAR.CDCALENDAR = PRTASK.CDCALENDAR
INNER JOIN 
   ADALLUSERS USERRESP ON USERRESP.CDUSER = PRTASK.CDTASKRESP
INNER JOIN
   ADALLUSERS USEREXEC ON USEREXEC.CDUSER = PRTASK.CDTASKEXECRESP
WHERE 
   PRTASK.FGTASKTYPE = 3 AND PRTASK.CDTASK = PRTASK.CDBASETASK /* NOTE 1 */

 

Notes

▪NOTE1: Determines that only nonproject task data will return.

 

Fields used on the view screen

 

 

 

#

Field ID

Type

Description

1

NMIDTASK

VARCHAR(255) NULL

2

NMTASK

VARCHAR(255) NULL

3

IDTASKTYPE

NMTASKTYPE

VARCHAR(50) NULL

VARCHAR(255) NULL

4

FGPHASE

NUMERIC(2,0) NULL

1 – Planning

2 – Execution

3 – Verification

4 – Finished

5 – Approval

6 – Postponed

7 – Cancelled

5

IDCALENDAR

NMCALENDAR

VARCHAR(50) NULL

VARCHAR(255) NULL

6

IDUSER

NMUSER

VARCHAR(50) NULL

VARCHAR(255) NULL

7

IDUSEREXEC

NMUSEREXEC

VARCHAR(50) NULL

VARCHAR(255) NULL

8

DTPLANST

DTPLANEND

QTPLANDUR

DATETIME NULL

DATETIME NULL

NUMERIC(10,0) NULL

9

DTREPLST

DTREPLEND

QTREPLDUR

DATETIME NULL

DATETIME NULL

NUMERIC(10,0) NULL

10

DTACTST

DTACTEND

QTACTDUR

QTACTPERC

DATETIME NULL

DATETIME NULL

NUMERIC(10,0) NULL

NUMERIC(10,0) NULL