We zijn op zoek naar het werkrooster per medewerker (NL: rooster). In Schedules staat vermeld hoeveel dagen en uren medewerkers werken. Maar we missen de exacte dagen waarop een bepaalde medewerker werkt, de onderliggende roosterregels zogezegd (dus op welke dagen de medewerker werkt).
Bijvoorbeeld
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:
The last two can be hard to use, so some samples.
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:
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.
