Nous recherchons l’horaire de travail par employé (NL : rooster). Dans « Horaires », il est indiqué combien de jours et d’heures les employés travaillent. Mais il nous manque les jours exacts où un employé donné travaille, c’est-à-dire les lignes d’horaire sous-jacentes (donc quels jours l’employé travaille).
Par exemple
lundi, mardi, mercredi, jeudi (32 heures)
mardi, mercredi, jeudi (24 heures)
forums
Octobre 7, 2020, 6:56
2
There is yet no table to retrieve the hours to work according to employment contract.
When needed, please vote here: Exact Online idea .
For actuals hours worked, you can use:
pjttimetransactions
leave registrations
absence registrations
The last two can be hard to use, so some samples.
Absence registrations
select arn.causecode
, arn.causedescription
, art.startdate + coalesce((art.starttime - trunc(art.starttime)), 0) startdate
, art.startdate + coalesce((art.endtime - trunc(art.endtime)), 0) enddate
, art.hours
, art.hoursfirstday
, art.hourslastday
from AbsenceRegistrationTransactions art
join AbsenceRegistrations arn
on arn.id = art.absenceregistration
order
by startdate
Result:
Leave registrations
select lrn.startdate + (lrn.starttime - trunc(lrn.starttime)) startdate
, lrn.endtime
, lrn.description
, lrn.employeehid
, lrn.hours
, lrn.hoursfirstday
, lrn.hourslastday
from LeaveRegistrations lrn
order
by startdate
Result:
With the following tables from Exact Globe we are able to create the correct insight. Maybe it helps you to create it for Exact Online.
workschedulelinks
workschedulegroups
workschedules