Workforce - Clear Data
  • 5 Minutes to read
  • Dark
    Light
  • PDF

Workforce - Clear Data

  • Dark
    Light
  • PDF

Article summary

You can now delete the Workforce Actuals in the clear data screen. You can see the Workforce option in the Select Area drop-down list.

You can select Time Period as a parameter and delete the Actuals loaded data in the Workforce Clear Data screen. Once you select the Time Periods and click Delete, a job will be scheduled. After completion of the job, a confirmation alert message containing exported file links is displayed.

For the Workforce Employee Data, you will receive an alert message if you click the Clear Data button and data exists. The alert message indicates that employee data exists and if you proceed, all employee details and associated data will be deleted. Clear Data deletes data from whichever scenario is selected and saved in the Define Overall Rule Settings step of the data load. If employees are mapped to any other scenario, the data is retained in that scenario.

Notes:
  • Users having access to the Clear Data screen can delete Workforce Actuals data for the selected period, and a copy of the deleted Workforce Actuals data will be exported automatically.
  • This feature is applicable for GL Data, Translations Data, Workforce - Employee Data.

To learn how to Clear Data for Specified Time Periods, click here.

Preview and Export Data for Selected Time Periods

You can preview and export the loaded Workforce Actuals in the Clear Data screen before deleting them.

The Preview option allows you to view the details of actuals data of employees such as Scenario Name, Employee Number, Employee Name, Employee Position Description, Home Budget Entity, Position Budget Entity, Account, other finance segments, Currency(LC), and loaded amounts for selected time periods. The Export to CSV option allows you to export all the data for a selected time period. You can select the required time period and click Export to CSV to submit a request to export data. You can view the export status in the Job Manager. You will also receive a message containing links to download the exported file. The data is exported as a ZIP file. You can extract the ZIP file to see the exported data.

With this release, you can see the actual amounts in Local currency only. The preview screen only supports two digits after the decimal.
To learn how to Preview Data for Specified Time Periods, click here.
To learn how to Export Data for Specified Time Periods, click here.

Home Budget Entity

As a Workforce admin user, you will have the ability to Delete Actuals data based on the entity access. If you do not have access to the entities will not be able to see the Workforce data. You will also be able to export the data based on the selections in the Selection Criteria column, allowing you to maintain a file of data for future references. You can also delete the wrong actual amounts loaded into the planful system by specifying the home budget entity and time period. Before deleting actuals for a Home Budget Entity, you can also preview the data to verify before the deletion.

  • To learn how to Preview Data for Specified Home Budget Entity, click here
  • To learn how to Export Data for a Specified Home Budget Entity, click here.

Combination of Finance Segments

As a Workforce admin user, you will have the ability to Preview, Export, and Delete Workforce Actuals data based on the combination of finance segments. All the finance segments are displayed under the workforce area in the Clear Data screen. In case of no data available for the selected segment combination, a notification is displayed when you click on Preview. You will be able to delete the data displayed based on the selection of segments on the Clear Data screen.

  • To learn how to Preview Data for Specified Segment Combination, click here
  • To learn how to Delete Data Using the Specified Segment Combination, click here.

Employee and Position

As a Workforce admin user, you will have the ability to Preview, Export, and Delete workforce actuals data based on Employee and Position. This will provide you the ability to preview multiple employees and delete and reload the wrong actual amounts loaded into the system. 

The Preview option allows you to view the details of actuals data of employees such as Scenario Name, Employee Number, Employee Name, Employee Position Description, Home Budget Entity, Position Budget Entity, Account, other finance segments, Currency(LC), and loaded amounts for selected time periods. Once the selection is complete, you can click Delete, and a job will be scheduled. The Export to CSV option allows you to export all the data for a selected employee and positions. You can select the employee and positions and click Export to CSV to submit a request to export data. You can view the export status in the Job Manager. You will also receive a message containing links to download the exported file. The data is exported as a ZIP file. You can extract the ZIP file to see the exported data.

  • To learn how to Preview Data for Specified Employee and Position, click here
  • To learn how to Delete Data Using the Specified Employee and Position, click here.
  • To learn how to Export Data Using the Specified Employee and Position, click here.

Enhancement to Workforce Area in Clear Data Preview Screen

As an Admin user, you will be able to see up to 1000 rows of data in the Clear Data Preview Screen. Previously this limitation only existed in the Finance area, now with this release, it is applied to the Workforce area as well.SP_ClearDataPreviewEnhancement

Clear Data- Currency types Updated

We have introduced few currency types in the Clear Data screen. Previously we only had Local Currency as currency type mapped against the employees, which has now been updated to the Currency field. As an admin user you will now be able to view Local currency, Common currency, and Position Entity currency type against the employees. You can also see an ‘Amount in’ column in the Clear Data preview screen, that will display currency names mapped against the employees.

Note:
If the Local Currency and Common Currency are the same for an employee, then the duplicate row will not be displayed in the clear data preview screen.

Was this article helpful?