Effective Dates
The payroll interface extract uses the effective start date and end date features to manage the data elements. The two data elements EffectiveStartDate and EffectiveEndDate contain the start and end date of the records extracted.
For extracting data, the interface uses the Process End Date parameter specified at the time of submitting the payroll interface as the effective date.
For example, consider these set of date effective assignment data records for an employee:
Record ID |
Start Date |
End Date |
Description |
---|---|---|---|
1 |
1-Jan-17 |
31-May-17 |
The worker is hired as Consultant. |
2 |
1-Jun-17 |
30-Nov-17 |
The worker gets promoted as Senior Consultant. |
3 |
1-Dec-17 |
End of time |
The worker gets a change in location. |
Scenario 1
When you run the extract process with effective date as 10-Dec-2017, the application extracts Record 3.
This figure shows which record is extracted when the extract process is run with effective date as 10-Dec-17:
![The figure shows that when the extract process is run with the effective date as 6/10/17, then the application extracts record 2](images/ExtractProcess1_20064852.png)
Scenario 2
When you run the extract process with effective date as 10-June-2017, the application extracts Record 2.
This figure shows which record is extracted when the extract process is run with effective date as 10-June-17:
![The figure shows that when the extract process is run with the effective date as 6/10/17, then the application extracts record 2.](images/ExtractProcess2_20064853.png)