Workday Workday-Pro-Integrations Practice Test Questions Answers

The scenario involves a Core Connector: Worker integration with two runs detailed in the integration events report. The goal is to determine whether Brian Hill’s compensation change, effective April 30, 2024, and entered on May 13, 2024, will be included in either of the runs based on their date launch parameters. Let’s analyze each run against the change details to identify the correct answer.

In Workday, the Core Connector: Worker integration in incremental mode (as indicated by the presence of "Last Successful" parameters) processes changes based on the Transaction Log, filtering them by theEntry Moment(when the change was entered) andEffective Date(when the change takes effect). The integration captures changes where:

TheEntry Momentfalls between theLast Successful As of Entry Momentand theAs of Entry Moment, and

TheEffective Datefalls between theLast Successful Effective Dateand theEffective Date.

Brian Hill’s compensation change has:

Entry Moment:05/13/2024 (time not specified, so we assume it occurs at some point during the day, before or up to 11:59:59 PM).

Effective Date:04/30/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 – The latest point for when changes were entered.

Effective Date:05/15/2024 – The latest effective date for changes.

Last Successful As of Entry Moment:05/01/2024 3:00:00 AM – The starting point for entry moments.

Last Successful Effective Date:05/01/2024 – The starting point for effective dates.

For Run #1 to include Brian’s change:

TheEntry Moment(05/13/2024) must be between 05/01/2024 3:00:00 AM and 05/15/2024 3:00:00 AM. Since 05/13/2024 falls within this range (assuming the change was entered before 3:00:00 AM on 05/15/2024, which is reasonable unless specified otherwise), this condition is met.

TheEffective Date(04/30/2024) must be between 05/01/2024 (Last Successful Effective Date) and 05/15/2024 (Effective Date). However, 04/30/2024 isbefore05/01/2024, so this condition isnot met.

Since the effective date of Brian’s change (04/30/2024) precedes theLast Successful Effective Date(05/01/2024), Run #1 will not include this change. In incremental mode, Workday excludes changes with effective dates prior to the last successful effective date, as those are assumed to have been processed in a prior run (before Run #1’s baseline of 05/01/2024).

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 – The latest point for when changes were entered.

Effective Date:05/31/2024 – The latest effective date for changes.

Last Successful As of Entry Moment:05/15/2024 3:00:00 AM – The starting point for entry moments.

Last Successful Effective Date:05/15/2024 – The starting point for effective dates.

For Run #2 to include Brian’s change:

TheEntry Moment(05/13/2024) must be between 05/15/2024 3:00:00 AM and 05/31/2024 3:00:00 AM. However, 05/13/2024 isbefore05/15/2024 3:00:00 AM, so this condition isnot met.

TheEffective Date(04/30/2024) must be between 05/15/2024 (Last Successful Effective Date) and 05/31/2024 (Effective Date). Since 04/30/2024 isbefore05/15/2024, this condition is alsonot met.

In Run #2, theEntry Moment(05/13/2024) precedes theLast Successful As of Entry Moment(05/15/2024 3:00:00 AM), meaning the change was entered before the starting point of this run’s detection window. Additionally, theEffective Date(04/30/2024) is well before theLast Successful Effective Date(05/15/2024). Both filters exclude Brian’s change from Run #2.

Conclusion

Run #1:Excluded because the effective date (04/30/2024) is before the Last Successful Effective Date (05/01/2024).

Run #2:Excluded because the entry moment (05/13/2024) is before the Last Successful As of Entry Moment (05/15/2024 3:00:00 AM) and the effective date (04/30/2024) is before the Last Successful Effective Date (05/15/2024).

Brian Hill’s change would have been processed in an earlier run (prior to May 1, 2024) if the integration was running incrementally before Run #1, as its effective date (04/30/2024) predates both runs’ baselines. Given the parameters provided, neither Run #1 nor Run #2 captures this change, makingD. Brian Hill will be excluded from both integration runsthe correct answer.

Workday Pro Integrations Study Guide References

Workday Integrations Study Guide: Core Connector: Worker– Section on "Incremental Processing" explains how changes are filtered based on entry moments and effective dates relative to the last successful run.

Workday Integrations Study Guide: Launch Parameters– Details how "Last Successful As of Entry Moment" and "Last Successful Effective Date" define the starting point for detecting new changes, excluding prior transactions.

Workday Integrations Study Guide: Change Detection– Notes that changes with effective dates before the last successful effective date are assumed processed in earlier runs and are skipped in incremental mode.

In Workday integrations, the Extension for Transformation and Validation (ETV) framework is used within XSLT transformations to apply validation and formatting rules to XML data, such as the output from a Core Connector (e.g., Positions integration). In this scenario, you need to perform an XSLT transformation on the Core Connector: Positions XML output file to display a hyperlink for positions that are not available for hiring as an entry in the Message tab. This requires configuring ETV attributes to ensure the data is present and correctly targeted for the hyperlink.

Here’s why option B is correct:

Requirement Analysis: The requirement specifies showing a hyperlink for positions "not available for hiring." In the provided XML, the ps:Available_For_Hire field under ps:Position_Data indicates whether a position is available for hire (e.g., true). For positions where this is false, you need to create a message (hyperlink) in the Message tab, which typically requires linking to a Workday ID (WID) or other identifier.

ETV Attributes:

etv:required="true": This ensures that the ps:WID value under ps:Additional_Information is mandatory for the transformation. If the WID is missing, the transformation will fail or generate an error, ensuring that the hyperlink can be created only for valid positions with an associated WID.

etv:target="[ps:Additional_Information/ps:WID]": This specifies that the target of the transformation (e.g., the hyperlink) should be the WID value found at ps:Additional_Information/ps:WID in the XML. This WID can be used to construct a hyperlink to the position in Workday, meeting the requirement to show a hyperlink for positions not available for hiring.

Context in XML: The XML shows ps:Additional_Information containing ps:WID (e.g., 73bd4d8562e04b1820f55818467905b), which is a unique identifier for the position. By targeting this WID with etv:target, you ensure the hyperlink points to the correct position record in Workday when ps:Available_For_Hire is false.

Why not the other options?

A.

etv:minLength="0"

etv:targetWID="[ps:Additional_Information/ps:WID]"

etv:minLength="0" allows the WID to be empty or have zero length, which contradicts the need for a valid WID to create a hyperlink. It does not ensure the data is present, making it unsuitable. Additionally, etv:targetWID is not a standard ETV attribute; the correct attribute is etv:target, making this option incorrect.

C.

etv:minLength="0"

etv:target="[ps:Additional_Information/ps:WID]"

Similar to option A, etv:minLength="0" allows the WID to be empty, which does not meet the requirement for a mandatory WID to create a hyperlink. This makes it incorrect, as the hyperlink would fail if the WID is missing.

D.

etv:required="true"

etv:targetWID="[ps:Additional_Information/ps:WID]"

While etv:required="true" ensures the WID is present, etv:targetWID is not a standard ETV attribute. The correct attribute is etv:target, making this option syntactically incorrect and unsuitable for the transformation.

To implement this in XSLT for a Workday integration:

Use the ETV attributes from option B (etv:required="true" and etv:target="[ps:Additional_Information/ps:WID]") within your XSLT template to validate and target the ps:WID for positions where ps:Available_For_Hire is false. This ensures the transformation generates a valid hyperlink in the Message tab, linking to the position’s WID in Workday.

References:

Workday Pro Integrations Study Guide: Section on "ETV in XSLT Transformations" – Details the use of ETV attributes like required and target for validating and targeting data in Workday XML, including handling identifiers like WID for hyperlinks.

Workday Core Connector and EIB Guide: Chapter on "XML Transformations" – Explains how to use ETV attributes in XSLT to process position data, including creating messages or hyperlinks based on conditions like Available_For_Hire.

Workday Integration System Fundamentals: Section on "ETV for Message Generation" – Covers applying ETV attributes to generate hyperlinks in the Message tab, ensuring data integrity and correct targeting of Workday identifiers like WID.

In Workday reporting, selecting the appropriatePrimary Business Object (PBO)andRelated Business Objects (RBOs)is critical to ensure that the report retrieves and organizes data correctly based on the requirements. The requirement here is to create a report that outputs one row per worker for a specified supervisory organization, including their active benefit plans and the names and ages of all related dependents. The Worker business object contains fields like Employee, Benefit Plans, and Dependents, while the Dependent business object provides the Name and Age fields for dependents.

Why Worker as the PBO?The report needs to output "one row per worker," making the Worker business object the natural choice for the PBO. In Workday, the PBO defines the primary dataset and determines the granularity of the report (i.e., one row per instance of the PBO). Since the report revolves around workers and their associated data (benefit plans and dependents), Worker is the starting point. Additionally, the requirement specifies a supervisory organization at runtime, which is a filter applied to the Worker business object to limit the population.

Why Dependent as an RBO?The Worker business object includes a "Dependents" field, which is a multi-instance field linking to the Dependent business object. To access detailed dependent data (Name and Age), the Dependent business object must be added as an RBO. This allows the report to pull in the related dependent information for each worker. Without the Dependent RBO, the report could only reference the existence of dependents, not their specific attributes like Name and Age.

Analysis of Benefit Plans:The Worker business object already contains the "Benefit Plans" field, which provides access to active benefit plan data. Since this is a field directly available on the PBO (Worker), no additional RBO is needed to retrieve benefit plan information.

Option Analysis:

A. PBO: Dependent, RBO: Worker: Incorrect. If Dependent were the PBO, the report would output one row per dependent, not one row per worker, which contradicts the requirement. Additionally, Worker as an RBO would unnecessarily complicate accessing worker-level data.

B. PBO: Worker, RBO: Dependent: Correct. This aligns with the requirement: Worker as the PBO ensures one row per worker, and Dependent as the RBO provides access to dependent details (Name and Age). Benefit Plans are already accessible via the Worker PBO.

C. PBO: Dependent, no RBOs: Incorrect.This would result in one row per dependent and would not allow easy access to worker or benefit plan data, failing to meet the "one row per worker" requirement.

D. PBO: Worker, no RBOs: Incorrect. While Worker as the PBO is appropriate, omitting the Dependent RBO prevents the report from retrieving dependent Name and Age fields, which are stored in the Dependent business object, not directly on Worker.

Implementation:

Create a custom report withWorkeras the PBO.

Add a filter for the supervisory organization (specified at runtime) on the Worker PBO.

AddDependentas an RBO to access Name and Age fields.

Include columns from Worker (e.g., Employee, Benefit Plans) and Dependent (e.g., Name, Age).

References from Workday Pro Integrations Study Guide:

Workday Report Writer Fundamentals: Section on "Selecting Primary and Related Business Objects" explains how the PBO determines the report’s row structure and RBOs extend data access to related objects.

Integration System Fundamentals: Discusses how multi-instance fields (e.g., Dependents on Worker) require RBOs to retrieve detailed attributes.

The requirement is to filter a custom report to show only workers terminated after a user-prompted date. In Workday, filters are defined in the Filter tab of the custom report definition, and conditions can be combined using AND/OR logic to refine the dataset. Let’s analyze the requirement and options:

Key Conditions:

Workers must beterminated, so the "Worker Status" field must equal "Terminated."

The termination must occuraftera user-specified date, so the "Termination Date" must be greater than the prompted value.

Both conditions must be true for a worker to appear in the report, requiring anANDcombination.

Option Analysis:

A. Worker Status is equal to the value "Terminated" OR Termination Date is greater than a value retrieved from a prompt: Incorrect. Using OR means the report would include workers who are terminated (regardless of date) OR workers with a termination date after the prompt (even if not terminated), which doesn’t meet the strict requirement of terminated workers after a specific date.

B. Worker Status is equal to the value retrieved from a prompt AND Termination Date is less than a value retrieved from a prompt: Incorrect. Worker Status shouldn’t be a prompted value (it’s fixed as "Terminated"), and "less than" would show terminations before the date, not after.

C. Worker Status is equal to the value retrieved from a prompt OR Termination Date is equal to a value retrieved from a prompt: Incorrect. Worker Status shouldn’t be prompted, and "equal to" limits the filter to exact matches, not "after" the date. OR logic also broadens the scope incorrectly.

D. Worker Status is equal to the value "Terminated" AND Termination Date is greater than a value retrieved from a prompt: Correct. This ensures workers are terminated (fixed value) AND their termination date is after the user-entered date, precisely meeting the requirement.

Implementation:

In the custom report’s Filter tab, add two conditions:

Field: Worker Status, Operator: equals, Value: "Terminated".

Field: Termination Date, Operator: greater than, Value: Prompt for Date (configured as a report prompt).

Set the logical operator between conditions toAND.

Test with a sample date to verify only terminated workers after that date appear.

References from Workday Pro Integrations Study Guide:

Workday Report Writer Fundamentals: Section on "Creating and Managing Filters" details combining conditions with AND/OR logic and using prompts.

Integration System Fundamentals: Notes how filtered reports support integration data sources with dynamic user inputs.

The scenario describes a Core Connector: Worker integration configured to output specific fields (Position Title and Business Title) for workers who meet the Integration Population Eligibility criteria (Is Manager = true) and where the Transaction Log service is subscribed to the "Position Edit Event." The integration is launched with specific date parameters, and a test edit is made to Jared Ellis’ position, who is a manager. However, despite the edit being completed with an effective date of 05/24/2024 and an entry moment of 05/24/2024 07:58:53 AM, Jared does not appear in the output. Let’s analyze why and determine the correct configuration element to modify.

In Workday integrations, the Core Connector: Worker uses change detection mechanisms to identify and process updates based on the Transaction Log and date launch parameters. The Transaction Log service captures events such as the "Position Edit Event" and records them with anEffective Date(when the change takes effect) and anEntry Moment(when the change was entered into the system). The integration’s date launch parameters define the time window for which changes are retrieved:

As of Entry Moment:05/25/2024 12:00:00 AM – This specifies the latest point in time for when changes were entered into Workday.

Effective Date:05/25/2024 – This defines the date for which the changes are effective.

Last Successful As of Entry Moment:05/23/2024 12:00:00 AM – This indicates the starting point for entry moments from the last successful run.

Last Successful Effective Date:05/23/2024 – This indicates the starting point for effective dates from the last successful run.

For an incremental run (like this one, since "Last Successful" parameters are provided), Workday processes changes where theEntry Momentfalls between theLast Successful As of Entry Moment(05/23/2024 12:00:00 AM) and theAs of Entry Moment(05/25/2024 12:00:00 AM), and where theEffective Datefalls between theLast Successful Effective Date(05/23/2024) and theEffective Date(05/25/2024).

Now, let’s evaluate Jared Ellis’ edit:

Entry Moment:05/24/2024 07:58:53 AM – This falls within the range of 05/23/2024 12:00:00 AM to 05/25/2024 12:00:00 AM.

Effective Date:05/24/2024 – This falls within the range of 05/23/2024 to 05/25/2024.

At first glance, Jared’s edit seems to fit the date parameter window. However, the issue lies in thetime componentof the date launch parameters. Workday interprets these parameters with precision down to the second. TheAs of Entry Momentis set to 05/25/2024 12:00:00 AM (midnight), which is the very start of May 25, 2024. Jared’sEntry Momentof 05/24/2024 07:58:53 AM is correctly within the range from 05/23/2024 12:00:00 AM to 05/25/2024 12:00:00 AM. However, the Transaction Log subscription to "Position Edit Event" relies on the change being fully processed and available in the log by the time the integration runs.

The integration might have run at a point where the effective date window or the subscription logic did not correctly capture the event due to a mismatch in how theEffective Dateis evaluated against theLast Successful Effective Date. Specifically, if the integration only processes changes with anEffective DatestrictlyaftertheLast Successful Effective Date(05/23/2024) up to theEffective Date(05/25/2024), and the logic excludes changes effective exactly on 05/24/2024 due to a boundary condition or a timing issue in the transaction log, Jared’s change might not be picked up.

To resolve this, modifying theDate launch parametersis necessary. Adjusting theAs of Entry Momentto a later time (e.g., 05/25/2024 11:59:59 PM) or ensuring theEffective Daterange explicitly includes all changes effective on or after 05/23/2024 through 05/25/2024 would ensure Jared’s edit is captured. This adjustment aligns the time window to include all relevant transactions logged before the integration run.

Let’s evaluate the other options:

A. Integration Population Eligibility:This is set to "Is Manager = true," and Jared is a manager. This filter is working correctly and does not need modification.

B. Integration Field Attributes:These are configured to output Position Title and Business Title, and the edit was to the Job Profile (part of Position Data). The fields are appropriately configured, so this is not the issue.

D. Transaction Log Subscription:The subscription is set to "Position Edit Event," which matches Jared’s edit. The subscription type is correct, so no change is needed here.

Thus, the issue stems from the date launch parameters not fully encompassing the timing of Jared’s edit in the Transaction Log, makingC. Date launch parametersthe correct answer.

Workday Pro Integrations Study Guide References

Workday Integrations Study Guide: Core Connector: Worker– Section on "Change Detection Using Transaction Log" explains how Transaction Log subscriptions filter events based on date parameters.

Workday Integrations Study Guide: Launch Parameters– Details the role of "As of Entry Moment" and "Effective Date" in defining the scope of incremental runs.

Workday Integrations Study Guide: Incremental Processing– Describes how "Last Successful" parameters establish the baseline for detecting changes in subsequent runs.