To enable you to get the most out of Leave and Absence Management intelligence reports, you need to understand the following key concepts:
The Absence Hours reports use the element information created when you enter either an absence against the absence element, or an absence in the Absence Details window.
The report plots the absence hours for the date earned. This is entered for the element. If a date earned has not been entered, then the element's effective start date is taken as the date earned.
Note: If you have entered your absences using the Absence Details window, a date earned is not set up; therefore the report uses the effective start date of the element.
Regardless of the length of time an employee has been absent, the report always plots his or her absence hours on the date earned, or the effective start date of an element. It is possible, because of the frequency and time period you select, that an absence may fall into two different time periods. The absence hours are always shown in the first time period, rather than pro-rata across two time periods.
A pre-defined formula, TEMPLATE_BIS_DAYS_TO_HOURS, calculates the absence hours. You can configure this formula to meet your requirements.
See: Discoverer Workbooks Implementation Steps
Within Oracle HRMS, you record the number of regular and overtime hours worked using elements. The Hours Worked reports process information for the hours worked through formulas, which you must provide using Oracle FastFormula.
See: Setting Up and Customizing Working Hours
The Hours Worked reports calculate the hours worked for each payroll time period using employee assignments. For the assignment to be included it must:
Be active or suspended.
Fit the criteria you enter. For example, if you enter a grade name, the assignment must have that grade entered against it.
Note: You can only run the Hours Worked reports if you previously set up Oracle FastFormula to calculate your employees' regular hours and overtime hours.
The Hours Worked reports display information about the payroll periods that most closely match the start and end dates that you enter for the report. For example, if the first date you enter is 05-Jan-2001, and the payroll begins on 01-Jan-2001, the report includes information from 01-Jan-2001.