Navigation:  Project >

Allocated hours per project and resource

 Previous  Top  Next

Overview

This command will list the data of created projects.

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

PRTASKALLOC

Stores the resource allocation data

CDTASK

NRSEQ

FGREVISION

PRTASK

GNRESOURCE

PRTASK

Stores the project task data and project data

CDTASK

GNRESOURCE

Stores the resource data

CDRESOURCE

 

Oracle/Postgres/SQL Server

SELECT
   GNRESOURCE.IDRESOURCE,
   GNRESOURCE.NMRESOURCE,
   PRTASK.NMTASK AS PROJECTNAME,
   ACTIVITY.NMTASK,
   PRTASKALLOC.TMPLANHOURS,
   PRTASKALLOC.TMREPLHOURS   
FROM
   PRTASKALLOC
INNER JOIN
   PRTASK ACTIVITY ON ACTIVITY.CDTASK = PRTASKALLOC.CDTASK
INNER JOIN 
   PRTASK ON PRTASK.CDTASK = ACTIVITY.CDBASETASK
INNER JOIN
   GNRESOURCE ON GNRESOURCE.CDRESOURCE = PRTASKALLOC.CDRESOURCE
WHERE 
   PRTASK.NMIDTASK = 'PROJECT_ID' /* NOTE 1 */  AND GNRESOURCE.IDRESOURCE = 'RESOURCE_ID' /* NOTE 2 */

 

Notes

▪1: ID # of the project to be filtered.

▪2: ID # of the resource to be filtered.

 

Fields used on the view screen

 

project-02

 

#

Field ID

Type

Description

1

IDRESOURCE

VARCHAR(50) NULL

2

NMRESOURCE

VARCHAR(255) NULL

3

NMTASK

VARCHAR(255) NULL

4

NMTASK

VARCHAR(255) NULL

5

TMPLANHOURS

VARCHAR(8) NULL

6

TMREPLHOURS

VARCHAR(8) NULL