Workday Integrations Changed Workday-Pro-Integrations Questions

In Workday integrations, XSLT is used to transform XML data, such as the output from an Enterprise Interface Builder (EIB) or a web service-enabled report, into a desired format for third-party systems. In this scenario, you need to write XSLT to process wd:Dependents_Group elements and output a relationship code based on the value of the wd:Relationship attribute or element. The requirement is to output "SP" for a "Spouse" relationship, "CH" for a "Child" relationship, and "OTHER" for any other relationship, using an statement within a template matching wd:Dependents_Group.

Here’s why option C is correct:

XSLT Structure: The element in XSLT provides conditional logic similar to a switch statement. It evaluates conditions in elements sequentially, executing the first matching condition, and uses for any case that doesn’t match.

Relationship as an Attribute: Based on the provided XML snippet, wd:Relationship is an attribute (e.g., Spouse within wd:Dependents_Group). However, in Workday XML for integrations, wd:Relationship is often represented as an attribute (@wd:Relationship) rather than a child element, especially in contexts like dependent data in reports. The syntax @wd:Relationship in the test attribute of correctly references this attribute, aligning with Workday’s typical XML structure for such data.

Condition Matching:

The first SP checks if the wd:Relationship attribute equals "Spouse" and outputs "SP" if true.

The second CH checks if the wd:Relationship attribute equals "Child" and outputs "CH" if true.

The OTHER handles all other cases, outputting "OTHER" if the relationship is neither "Spouse" nor "Child."

Context in Template: Since the template matches on wd:Dependents_Group, the test conditions operate on the current wd:Dependents_Group element and its attributes, ensuring the correct relationship code is output for each dependent. The XML snippet shows wd:Relationship as an element, but Workday documentation and integration practices often standardize it as an attribute in XSLT transformations, making @wd:Relationship appropriate.

Why not the other options?

A.

xml

WrapCopy

SP

CH

OTHER

This assumes wd:Relationship is a child element of wd:Dependents_Group, not an attribute. The XML snippet shows wd:Relationship as an element, but in Workday integrations, XSLT often expects attributes for efficiency and consistency, especially in report outputs. Using wd:Relationship without @ would not match the attribute-based structure commonly used, making it incorrect for this context.

B.

xml

WrapCopy

SP

CH

OTHER

This correctly uses @wd:Relationship for an attribute but has a logical flaw: if wd:Relationship='Child', the second would output "CH," but the order of conditions matters. However, the primary issue is that it doesn’t match the exact structure or intent as clearly as option C, and Workday documentation often specifies exact attribute-based conditions like those in option C.

D.

xml

WrapCopy

SP

CH

OTHER

This uses an absolute path (/wd:Relationship), which searches for a wd:Relationship element at the root of the XML document, not within the current wd:Dependents_Group context. This would not work correctly for processing dependents in the context of the template matching wd:Dependents_Group, making it incorrect.

To implement this in XSLT:

Within your template matching wd:Dependents_Group, you would include the statement from option C to evaluate the wd:Relationship attribute and output the appropriate relationship code ("SP," "CH," or "OTHER") based on its value. This ensures the transformation aligns with Workday’s XML structure and integration requirements for processing dependent data in an EIB or web service-enabled report, even though the provided XML shows wd:Relationship as an element—XSLT transformations often normalize to attributes for consistency.

Workday Pro Integrations Study Guide: Section on "XSLT Transformations for Workday Integrations" – Details the use of , , , and XPath for conditional logic in XSLT, including handling attributes like @wd:Relationship.

Workday EIB and Web Services Guide: Chapter on "XML and XSLT for Report Data" – Explains the structure of Workday XML (e.g., wd:Dependents_Group, @wd:Relationship) and how to use XSLT to transform dependent data, including attribute-based conditions.

Workday Reporting and Analytics Guide: Section on "Web Service-Enabled Reports" – Covers integrating report outputs with XSLT for transformations, including examples of conditional logic for relationship codes.

In XSLT, the processor applies transformation rules by matching nodes using XPath expressions inside statements.

“Templates define the rule, and XPath expressions determine which nodes they apply to.”

This is the foundational mechanism by which XSLT processes XML data.

Why the others are incorrect:

B. The element defines scope, not node matching.

C. invokes a named template but does not itself match nodes.

D. Namespace prefixes are used within XPath, but node matching is based on XPath.

The task involves processing the "Legal Name - First Name" field in Workday to meet a third-party vendor’s requirement of accepting only one-word first names. For workers with multiple names (e.g., "John Paul"), separated by a single space, the logic must:

Extract the value before the space (e.g., "John" from "John Paul").

Count the characters in the extracted value.

Check if the character count is greater than 0.

Use the extracted value if the count is greater than 0; otherwise, use the original "Legal Name - First Name" field.

This logic is typically implemented in Workday using calculated fields within a custom report or integration (e.g., EIB or Studio). Let’s break down the required functions:

Substring Text:This function is needed to extract the portion of the "Legal Name - First Name" field before the space. In Workday, the Substring Text function allows you to specify a starting position (e.g., 1) and extract text up to a delimiter (e.g., a space). For example, Substring Text("John Paul", 1, Index of " ") would return "John."

Text Length:After extracting the substring (e.g., "John"), the logic requires counting its characters to ensure it’s valid. The Text Length function returns the number of characters in a text string (e.g., Text Length("John") = 4). This is critical for the condition check.

True/False Condition:The logic involves a conditional check: "Is the number of characters greater than 0?" The True/False Condition function evaluates this (e.g., Text Length(extracted value) > 0), returning True if the extracted value exists and False if it’s empty (e.g., if no space exists or extraction fails).

Evaluate Expression:This function implements the if-then-else logic: if the character count is greater than 0, use the extracted value (e.g., "John"); otherwise, use the original "Legal Name - First Name" field (e.g., "John Paul"). Evaluate Expression combines the True/False Condition with the output values.

Option Analysis:

A. Extract Single Instance, Text Length, Numeric Constant, True/False Condition: Incorrect. Extract Single Instance is used for multi-instance fields (e.g., selecting one dependent), not text parsing. Numeric Constant isn’t needed here, as no fixed number is involved.

B. Text Constant, Substring Text, Arithmetic Calculation, Evaluate Expression: Incorrect. Text Constant provides a fixed string (e.g., "abc"), not dynamic extraction. Arithmetic Calculation isn’t required, as this is a text length check, not a numeric operation beyond comparison.

C. Format Text, Convert Text to Number, True/False Condition, Evaluate Expression: Incorrect. Format Text adjusts text appearance (e.g., capitalization), not extraction. Convert Text to Number isn’t needed, as Text Length already returns a number.

D. Substring Text, Text Length, True/False Condition, Evaluate Expression: Correct. These functions align perfectly with the requirements: extract the first name, count its length, check the condition, and choose the output.

Implementation:

Create a calculated field using Substring Text to extract text before the space.

Use Text Length to count characters in the extracted value.

Use True/False Condition to check if the length > 0.

Use Evaluate Expression to return the extracted value or the original field based on the condition.

References from Workday Pro Integrations Study Guide:

Workday Calculated Fields: Section on "Text Functions" details Substring Text and Text Length usage.

Integration System Fundamentals: Explains how calculated fields with conditions (True/False, Evaluate Expression) transform data for third-party systems.

Core Connectors & Document Transformation: Highlights text manipulation for outbound integration requirements.

This scenario addresses an issue where a Core Connector: Worker integration — with DIS enabled and Full-Diff mode configured — unexpectedly includes terminated workers in the output, despite a requirement to include only active workers.

The correct step to address this issue is the configuration of Integration Population Eligibility.

From the Workday Pro: Integrations – Core Connector Configuration Guide, the relevant extract states:

“The Integration Population Eligibility step allows users to define which workers or populations are eligible to be included in the integration output. This includes filtering by worker status, organization, supervisory org, or other eligibility criteria. If this is not configured to exclude terminated workers, the integration will include all workers who meet the event conditions, regardless of their current status.”

Even though the integration uses change detection and the correct launch parameters, Workday still considers any worker with a qualifying change, including those terminated, unless they are explicitly excluded via eligibility rules.

Therefore, to prevent terminated workers from appearing in the output, you must set a filter in the Integration Population Eligibility step to include only active workers (e.g., using Worker.Status = Active or similar criteria).

Incorrect Options Explained:

A. Configure Integration Attributes... Include Inactive Workers in Full FileThis option would cause inactive (e.g., terminated) workers to be included when enabled. It doesn’t help filter them out.

B. Configure Integration Transaction Log... subscribe to everything except terminationSubscription controls which events trigger processing but does not control population eligibility. Terminated workers with address changes prior to termination could still appear if eligibility is not defined.

D. Configure Integration Field Overrides... use Eligibility CriterionField Overrides change data mappings or formats, not population eligibility. It cannot exclude terminated workers.