Navigation: Time control >

Tasks under execution

Overview

This command will list the data of tasks under execution.

Related tables

TABLE

Description

Primary key (PK)

Connection tables

PRTASK

Stores the nonproject task data

CDTASK

PRTASKTYPE

GNCALENDAR

ADALLUSERS

Stores the data of users responsible for nonproject tasks

CDUSER

Oracle/Postgres/SQL Server

SELECT
   PRTASK.NMIDTASK,
   PRTASK.NMTASK,
   USEREXEC.IDUSER AS IDUSEREXEC,
   USEREXEC.NMUSER AS NMUSEREXEC,
   PRTASK.DTREPLST,
   PRTASK.DTREPLEND,
   PRTASK.QTACTPERC
FROM
   PRTASK
INNER JOIN
   ADALLUSERS USEREXEC ON USEREXEC.CDUSER = PRTASK.CDTASKEXECRESP
WHERE
   PRTASK.FGTASKTYPE = 3 AND PRTASK.CDTASK = PRTASK.CDBASETASK /* NOTE 1 */ AND PRTASK.FGPHASE = 2 AND QTACTPERC IS NOT NULL /* NOTE 2 */

Notes

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

▪2: Determines that only data of nonproject tasks with the "Execution" status will return.

Fields used on the view screen

controle_atividades-02

#	Field ID	Type	Description
1	NMIDTASK	VARCHAR(255) NULL
2	NMTASK	VARCHAR(255) NULL
3	IDUSEREXEC NMUSEREXEC	VARCHAR(50) NULL VARCHAR(255) NULL
4	DTREPLST	DATETIME NULL
5	DTREPLEND	DATETIME NULL
6	QTACTPERC	NUMERIC(10,0) NULL