Skip to main content
Solved

Absence today

  • June 3, 2025
  • 4 replies
  • 33 views
nrodney8
Sidekick (Customer)
Forum|alt.badge.img+4

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)?

 

Best answer by nrodney8

​@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)

Some cause happiness wherever they go; others whenever they go.

4 replies

V
Hero (Partner)
Forum|alt.badge.img+11
  • vickyrohilya
  • Hero (Partner)
  • 181 replies
  • June 11, 2025

​@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

 

Vikas Jain
nrodney8
Sidekick (Customer)
Forum|alt.badge.img+4
  • nrodney8
  • Author
  • Sidekick (Customer)
  • 6 replies
  • June 11, 2025

​@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?

Some cause happiness wherever they go; others whenever they go.
V
Hero (Partner)
Forum|alt.badge.img+11
  • vickyrohilya
  • Hero (Partner)
  • 181 replies
  • June 11, 2025

​@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

Vikas Jain
nrodney8
Sidekick (Customer)
Forum|alt.badge.img+4
  • nrodney8
  • Author
  • Sidekick (Customer)
  • 6 replies
  • Answer
  • June 13, 2025

​@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)

Some cause happiness wherever they go; others whenever they go.


Terms & ConditionsCookie settingsAccessibility statement