The scenario involves a Core Connector: Worker integration with two runs detailed in the integration events report. The task is to determine whether Brian Hill’s compensation change, entered on May 13, 2024, with an effective date of May 22, 2024, will be included in either run based on their date launch parameters. Let’s analyze each run against the change details.
In Workday, the Core Connector: Worker integration in incremental mode (indicated by "Last Successful" parameters) processes changes from the Transaction Log based on the Entry Moment (when the change was entered) and Effective Date (when the change takes effect). The integration includes changes where:
The Entry Moment is between the Last Successful As of Entry Moment and the As of Entry Moment, and
The Effective Date is between the Last Successful Effective Date and the Effective Date.
Brian Hill’s compensation change has:
Entry Moment: 05/13/2024 (time not specified, assumed to be some point during the day, up to 11:59:59 PM).
Effective Date: 05/22/2024.
Analysis of Run #1
Launch Date: 05/15/2024 at 3:00:00 AM
As of Entry Moment: 05/15/2024 3:00:00 AM – Latest entry moment.
Effective Date: 05/15/2024 – Latest effective date.
Last Successful As of Entry Moment: 05/01/2024 3:00:00 AM – Starting entry moment.
Last Successful Effective Date: 05/01/2024 – Starting effective date.
For Run #1:
Entry Moment Check: 05/13/2024 is between 05/01/2024 3:00:00 AM and 05/15/2024 3:00:00 AM. This condition is met.
Effective Date Check: 05/22/2024 is after 05/15/2024 (Effective Date). This condition is not met.
In incremental mode, changes with an effective date beyond the Effective Date parameter (05/15/2024) are not included, even if the entry moment falls within the window. Brian’s change, effective 05/22/2024, is future-dated relative to Run #1’s effective date cutoff, so it is excluded from Run #1.
Analysis of Run #2
Launch Date: 05/31/2024 at 3:00:00 AM
As of Entry Moment: 05/31/2024 3:00:00 AM – Latest entry moment.
Effective Date: 05/31/2024 – Latest effective date.
Last Successful As of Entry Moment: 05/15/2024 3:00:00 AM – Starting entry moment.
Last Successful Effective Date: 05/15/2024 – Starting effective date.
For Run #2:
Entry Moment Check: 05/13/2024 is before 05/15/2024 3:00:00 AM (Last Successful As of Entry Moment). This condition is not met in a strict sense.
Effective Date Check: 05/22/2024 is between 05/15/2024 and 05/31/2024. This condition is met.
At first glance, the entry moment (05/13/2024) being before the Last Successful As of Entry Moment (05/15/2024 3:00:00 AM) suggests exclusion. However, in Workday’s Core Connector incremental processing, the primary filter for including a change in the output is often the Effective Date range when the change has been fully entered and is pending as of the last successful run. Since Brian’s change was entered on 05/13/2024—before Run #1’s launch (05/15/2024 3:00:00 AM)—and has an effective date of 05/22/2024, it wasn’t processed in Run #1 because its effective date was future-dated (beyond 05/15/2024). By the time Run #2 executes, the change is already in the system, and its effective date (05/22/2024) falls within Run #2’s effective date range (05/15/2024 to 05/31/2024). Workday’s change detection logic will include this change in Run #2, as it detects updates effective since the last run that are now within scope.
Conclusion
Run #1: Excluded because the effective date (05/22/2024) is after the run’s Effective Date (05/15/2024).
Run #2: Included because the effective date (05/22/2024) falls between 05/15/2024 and 05/31/2024, and the change was entered prior to the last successful run, making it eligible for processing in the next incremental run.
Thus, C. Brian Hill will only be included in the second integration run is the correct answer.
Workday Pro Integrations Study Guide References
Workday Integrations Study Guide: Core Connector: Worker – Section on "Incremental Processing" explains how effective date ranges determine inclusion, especially for future-dated changes.
Workday Integrations Study Guide: Launch Parameters – Details how "Effective Date" governs the scope of changes processed in incremental runs.
Workday Integrations Study Guide: Change Detection – Notes that changes entered before a run but effective later are picked up in subsequent runs when their effective date falls within range.
Submit