You can use Payflow to create a report on absences which have been deleted. This information can be helpful for identifying time off employees in your organization have booked but not actually taken. Data on deleted records is available in the system for 15 days, therefore the recommended interval for running the report is at least every two weeks, if not more frequently.
When run, the report includes details for all deleted absence records in the system, not with respect to the last report run.
A standard configuration file, which can be imported into a org, is typically used as a starting point for configuring this report.
To configure a deleted absences report export from scratch, follow these steps:
-
Create a Payflow Service with the following details entered:
-
Payflow Service Name: a name for the service.
Leave all other fields at default values.
-
-
On the Payflow Service page, select Configure.
-
On the Payroll Configure page, in the Download Files section, select New.
-
Complete the details as follows:
-
In the Details section:
-
Download File Name: enter a name for the data export
For example: Deleted_Absences.csv
-
Group: select Absence
-
Select 1: select IsDeleted and enter TRUE in the field on the right.
-
-
-
On the Payroll Configure page, in the Download Files section, select Download Configure.
-
On the configuration page:
-
in the Bonus Selection, Benefits Selection, Absence Selection, and Timesheet Selection sections, ensure only the Absence Include Deleted checkbox in the Absence Selection section is selected and all other checkboxes in these selections are unselected.
Select Save to save your changes.
-
-
On the Payroll Configure page, in the Mapping HCM to Download Files section, select New.
-
Map each field in the report as suggested in the following table, enter a name for the field using the Download Field Name field in the mapping, and leave all other fields at the default values. You can also map other fields to suit the needs of your organization.
The value in is download as HCM Object HCM Field Sub-Group Order Team Member fHCM2__Unique_Id__c Absence 10.00 Team Member fHCM2__Name_Full__c Absence 20.00 Absence fHCM2__Reason__c Absence 30.00 Absence fHCM2__Start_Date__c Absence 40.00 Absence fHCM2__End_Date__c Absence 50.00 Absence IsDeleted Absence 60.00 When completed, the mapping looks similar to the following screenshot:
-
Select Cancel to return to the Payflow Service details.
For information on how to run the download to get the report, see Running a download.