Working schedule per employee (rooster) on Exact Online

[forums]

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: