Navigation: Time control >

Timesheet per period

Overview

This command will list the timesheets of a certain period.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
GNTIMESHEET	Stores the timesheet data	CDTIMESHEET	ADALLUSERS
ADALLUSERS	Stores the user data	CDUSER

Oracle/Postgres/SQL Server

SELECT
   GNTIMESHEET.DTACTUAL,
   GNTIMESHEET.TMSTRAIGHTHOURS,
   GNTIMESHEET.TMOVERHOURS,
   GNTIMESHEET.TMTOTALHOURS,
   ADALLUSERS.IDUSER,
   ADALLUSERS.NMUSER
FROM
   GNTIMESHEET
INNER JOIN
   ADALLUSERS ON ADALLUSERS.CDUSER = GNTIMESHEET.CDUSER
WHERE
   DTACTUAL BETWEEN 'START_DATE' /* NOTE 1 */ AND 'END_DATE' /* NOTE 2*/

Notes

▪1: Start date to be filtered in the search. The date must be entered in the YEAR-MONTH-DAY sequence.

▪2: End date to be filtered in the search. The date must be entered in the YEAR-MONTH-DAY sequence.

Fields used on the view screen

controle_atividades-01

#	Field ID	Type	Description
1	DTACTUAL	DATETIME NULL
2	TMSTRAIGHTHOURS	VARCHAR(8) NULL
3	TMOVERHOURS	VARCHAR(8) NULL
4	TMTOTALHOURS	VARCHAR(8) NULL
5	IDUSER	VARCHAR(50) NULL
6	NMUSER	VARCHAR(255) NULL