To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Report on retro absence records
Summary
Retro absence records for payrollContent
Hi all,
I am trying to modify a custom report to include absences that were added to the system during the pay cycle but was taken previously
For example:
Pay period between 08-22-2020 and 09-04-2020
Employee was out sick from 08-11-2020 to 08-17-2020 but the manager didn't add it to the system until 08-25-2020
Our report is looking for anyone that has time booked over the 80 hours per pay
The original query is
SELECT
SUM(absecedetails.duration)
FROM
anc_per_abs_entry_dtls absecedetails
WHERE
absecedetails.per_absence_entry_id = absence.per_absence_entry_id