Wir suchen den Arbeitsplan pro Mitarbeiter (NL: rooster). In „Schedules“ wird angegeben, wie viele Tage und Stunden die Mitarbeiter arbeiten. Was uns jedoch fehlt, sind die genauen Tage, an denen ein bestimmter Mitarbeiter arbeitet, sozusagen die zugrunde liegenden Planzeilen (also an welchen Tagen der Mitarbeiter arbeitet).
Zum Beispiel
Montag, Dienstag, Mittwoch, Donnerstag (32 Stunden)
Dienstag, Mittwoch, Donnerstag (24 Stunden)
forums
7. Oktober 2020 um 06: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