I have used the Absence section to view absences within a rang, but employees that have overlapping dates will not be shown. Example, if an employee (Barry) is off from the 26th of April to the 7th of June, if I run a report in May for employees that are absent in May, Barry will not be shown as their absence started in April and ends in June.
Is there a way to see Absences for employees that are absent for today (the day the request was ran) or absent in the region that I selected (regardless of their start date but the fact that they have a absence in that period)?
Page 1 / 1
@nrodney8 : Please let me know which pages/ section you are using to see this information? Have you created any customized report?
As an alternate option, you can use ‘Team Calendar’ to see the attendance/absence information of employees. There are multiple selection criteria available to filter the records.
Best Regards
@nrodney8 : Please let me know which pages/ section you are using to see this information? Have you created any customized report?
As an alternate option, you can use ‘Team Calendar’ to see the attendance/absence information of employees. There are multiple selection criteria available to filter the records.
Best Regards
Hi @vickyrohilya I was looking at this from an HR perspective via Human Capital Management>HCM Services>Time Management>Absence Management>Absences
This view does not address the issue that I raised. Do you know of a way around this?
@nrodney8 : ‘Absences’ screen is having ‘Date From’ and ‘Date To’ for filtering the records. If you are filtering for dates within current month, then it will not show the absence records which start in past month and ending in next month.
You may ask your developer to create a report to display this data.
Alternatively, you can also use ‘Employee Results’ screen to see the employee attendance (including absence, normal hours, overtime hours etc.) for a specific period.
Best Regards
@nrodney8 : ‘Absences’ screen is having ‘Date From’ and ‘Date To’ for filtering the records. If you are filtering for dates within current month, then it will not show the absence records which start in past month and ending in next month.
You may ask your developer to create a report to display this data.
Alternatively, you can also use ‘Employee Results’ screen to see the employee attendance (including absence, normal hours, overtime hours etc.) for a specific period.
Best Regards
I have managed to fix this by injecting the following into a Quick Report:
SELECT A.emp_no, c.employee_name FROM ABSENCE_REGISTRATION A JOIN COMPANY_PERSON C ON C.emp_no = A.emp_no WHERE (TRUNC(SYSDATE) - date_from) > 0 AND date_to > TRUNC(SYSDATE) AND A.company_id = :company_id
The logic behind this report is: (Find employees that have a holiday that already started, but their holiday started period falls in line with today, whilst their holiday end date is after today)
