Loading and Calculating Incremental Workforce Data
At the beginning of a planning cycle, you might load the entire data for a given scenario and version. However, to stay up to date with Human Resources changes, you can import new and updated information frequently. Processing and calculation performance is greatly improved when you load updated data into Workforce using Data Integration.
Data Integration functionality enables you to compare a source data file with a previous version of the source data file and load only records that are new or have changed since the last load. The Incremental File Adapter in Data Integration identifies the data that needs loading. Additionally, Workforce provides rules that dynamically generate the appropriate calculation script, depending on the changed and new data in the data load file and calculates only the data for the modified intersections.
After the Data Integration load process, the changed and new data displays in the appropriate Workforce forms. The data reflects calculations applied in the load process.
Note:
Whenever you load data from Data Integration, to copy data to future periods, you must select one of these Workforce rules.
- OWP_Incremental Process Data and Synchronize Defaults
- OWP_Incremental Process Data and Synchronize Definition
Loading incremental Workforce data and processing Workforce Incremental rules (for example, OWP_INCREMENTAL PROCESS DATA WITH SYNCHRONIZE DEFAULTS) can only be done by Administrators. When running any of the Workforce Incremental rules from Data Integration, ensure that the Data Integration Target option Enable Data Security for Admin Users is set to No. This option can only be set by an administrator.
For more information, see Loading Data Using an Incremental File Adapter in Administering Data Integration.