Workday Updated Workday-Pro-Integrations Exam Questions and Answers by amaia

The requirement is to create a calculated field for a dashboard that displays a worker’s name and the number of days until their next birthday in the format "[Worker's Name]'s birthday is in [X] days" (e.g., "Logan McNeil's birthday is in 103 days"). This involves calculating the difference between today’s date and the worker’s next birthday, then formatting the output as a text string. Let’s break down the necessary functions:

Date Difference:To calculate the number of days until the worker’s next birthday, you need to determine the difference between the current date and the worker’s birthdate in the current or next year (whichever is upcoming). The Date Difference function calculates the number of days between two dates. In this case:

Use the worker’s "Date of Birth" field (from the Worker business object).

Adjust the year of the birthdate to the current year or next year (if the birthday has already passed this year) using additional logic.

Calculate the difference from today’s date to this adjusted birthday date. For example, if today is February 21, 2025, and Logan’s birthday is June 4 (adjusted to June 4, 2025), Date Difference returns 103 days.

Format Number:The result of Date Difference is a numeric value (e.g., 103). To ensure it displays cleanly in the output string (without decimals or unnecessary formatting), Format Number can be used to convert it to a simple integer string (e.g., "103").

Text Constant:To build the output string, static text like "’s birthday is in " and " days" is needed. The Text Constant function provides fixed text values to include in the final concatenated result.

Concatenate Text:The final step is to combine the worker’s name (e.g., "Logan McNeil"), the static text, and the calculated days into one string. Concatenate Text merges multiple text values into a single output, such as "Logan McNeil" + "’s birthday is in " + "103" + " days".

Option Analysis:

A. Format Date, Increment or Decrement Date, Extract Single Instance, Format Text: Incorrect. Format Date converts dates to strings but doesn’t calculate differences. Increment or Decrement Date adjusts dates but isn’t suited for finding days until a future event. Extract Single Instance is for multi-instance fields, not relevant here. Format Text adjusts text appearance, not numeric calculations.

B. Build Date, Format Date, Extract Single Instance, Format Text: Incorrect. Build Date creates a date from components, useful for setting the next birthday, but lacks the difference calculation. Format Date and Extract Single Instance don’t apply to the core need.

C. Date Difference, Format Number, Text Constant, Concatenate Text: Correct. These functions cover calculating the days, formatting the number, adding static text, and building the final string.

D. Increment or Decrement Date, Format Number, Text Constant, Concatenate Text: Incorrect. Increment or Decrement Date can’t directly calculate days to a future birthday without additional complexity; Date Difference is more appropriate.

Implementation:

Use Date Difference to calculate days from today to the next birthday (adjusting the year dynamically with additional logic if needed).

Apply Format Number to ensure the result is a clean integer.

Use Text Constant for static text ("’s birthday is in " and " days").

Use Concatenate Text to combine Worker Name, static text, and the formatted number.

References from Workday Pro Integrations Study Guide:

Workday Calculated Fields: Section on "Date Functions" explains Date Difference for calculating time spans.

Report Writer Fundamentals: Covers Concatenate Text and Text Constant for string building in reports.

In the Workday Pro Integrations program, the process of uploading an XSLT file for a brand-new Document Transformation system follows a specific workflow designed to ensure the transformation logic is properly attached and configured within the integration system. The correct sequence involves first creating the XSLT Attachment Transformation and then configuring the Integration Attachment Service to utilize it. Here's a step-by-step breakdown based on Workday's integration methodology:

Create XSLT Attachment Transformation:

The initial step is to create an XSLT Attachment Transformation object within Workday. This involves uploading the XSLT file, which contains the transformation logic needed to convert XML data into the desired format for the Document Transformation system. In Workday, XSLT (Extensible Stylesheet Language Transformations) is used to define how data from a source (typically in XML format) is transformed into an output format compatible with an external system.

To do this, you navigate to the Integration System, access the related actions, and select the option to create a new "XSLT Attachment Transformation." You then name the transformation, upload the XSLT file (with a size limit of 30 MB as per Workday specifications), and save it. This step establishes the transformation logic as an object that can be referenced by the integration system.

Configure Integration Attachment Service:

Once the XSLT Attachment Transformation is created, the next step is to configure the Integration Attachment Service to incorporate this transformation. The Integration Attachment Service is a component of the Document Transformation system that handles the delivery or processing of the transformed data.

In this step, you edit the integration system, navigate to the "Services" tab, and configure the Integration Attachment Service. Here, you specify the previously created XSLT Attachment Transformation as the transformation to be applied. This links the XSLT logic to the integration workflow, ensuring that the data processed by the Document Transformation system is transformed according to the uploaded XSLT file.

Why Other Options Are Incorrect:

A. Configure XSLT Attachment Transformation, then Create Integration Attachment Service: This is incorrect because you cannot "configure" an XSLT Attachment Transformation before it exists. It must first be created as an object in Workday before any configuration or association with services can occur.

C. Create Integration Attachment Service, then Configure Integration Attachment Service: This option skips the creation of the XSLT Attachment Transformation entirely, which is a critical step. Without the transformation defined, configuring the service alone would not enable the XSLT upload or its functionality.

D. Configure Integration Attachment Service, then Create Integration Service Attachment: This sequence is reversed and misleading. The Integration Attachment Service must be configured to use an existing XSLT Attachment Transformation, not the other way around. Additionally, "Create Integration Service Attachment" is not a standard term in this context within Workday documentation.

Workday Pro Integrations Study Guide References:

Workday Integration System Fundamentals: This section outlines the components of an integration system, including the use of XSLT for document transformation and the role of attachment services.

Document Transformation Module: Specifically details the process of uploading and applying XSLT files, emphasizing the creation of an XSLT Attachment Transformation followed by its configuration within the integration services.

Core Connectors and Document Transformation Course Manual: Provides practical steps for setting up transformations, including the sequence of creating and then configuring transformation attachments (e.g., Activities related to "Upload a Custom XSLT Transformation" and "Edit XSLT Attachment Transformation").

Workday Community Documentation: Confirms that XSLT files are uploaded as attachment transformations and then linked to services like the Integration Attachment Service for processing.

As an integration developer working with Workday, you are tasked with transforming the output of an Enterprise Interface Builder (EIB) that calls the Get_Job_Profiles web service operation. The provided XML shows the response from this operation, and you need to write XSLT to select the value of the element. The root template of your XSLT matches on and applies a template to . Within this template, you use the element to extract the value. Let’s analyze the XML structure, the requirement, and each option to determine the correct XPath syntax.

Understanding the XML and Requirement

The XML snippet provided is a SOAP response from the Get_Job_Profiles web service operation in Workday, using the namespace xmlns:wd="urn:com.workday/bsvc" and version wd:version="v43.0". Key elements relevant to the question include:

The root element is .

It contains , which includes elements.

Within , there are:

, which contains elements (e.g., a Job_Profile_ID).

, which contains with the value Senior_Benefits_Analyst.

The task is to select the value of (e.g., "Senior_Benefits_Analyst") using XPath within an XSLT template that matches . The element outputs the value of the selected node, so you need the correct XPath path from the context to .

Analysis of Options

Let’s evaluate each option based on the XML structure and XPath syntax rules:

Option A: wd:Job_Profile/wd:Job_Profile_Data/wd:Job_Code

This XPath starts from wd:Job_Profile and navigates to wd:Job_Profile_Data/wd:Job_Code. However, in the XML, is the parent element, and is a direct child containing . The path wd:Job_Profile/wd:Job_Profile_Data/wd:Job_Code is technically correct in terms of structure, as it follows the hierarchy:

→ → .

However, since the template matches , the context node is already . You don’t need to include wd:Job_Profile/ at the beginning of the XPath unless navigating from a higher level. Starting directly with wd:Job_Profile_Data/wd:Job_Code (Option C) is more concise and appropriate for the context. This option is technically valid but redundant and less efficient, making it less preferred compared to Option C.

Option B: wd:Job_Profile_Data[@wd:Job_Code]

This XPath uses an attribute selector ([@wd:Job_Code]) to filter based on an attribute named wd:Job_Code. However, examining the XML, does not have a wd:Job_Code attribute—it has a child element with the value "Senior_Benefits_Analyst." The [@attribute] syntax is used for attributes, not child elements, so this XPath is incorrect. It would not select the value and would likely return no results or an error. This option is invalid.

Option C: wd:Job_Profile_Data/wd:Job_Code

This XPath starts from wd:Job_Profile_Data (a direct child of ) and navigates to wd:Job_Code. Since the template matches , the context node is , and wd:Job_Profile_Data/wd:Job_Code correctly points to the element within . This path is:

Concise and appropriate for the context.

Directly selects the value "Senior_Benefits_Analyst" when used with .

Matches the XML structure, as contains as a child.

This is the most straightforward and correct option for selecting the value within the template.

Option D: wd:Job_Profile_Reference/wd:ID[@wd:type='Job_Profile_ID']

This XPath navigates to (a child of ) and then to with an attribute wd:type="Job_Profile_ID". In the XML, contains:

1740d3eca2f2ed9b6174ca7d2ae88c8c

Senior_Benefits_Analyst

The XPath wd:Job_Profile_Reference/wd:ID[@wd:type='Job_Profile_ID'] selects the element with wd:type="Job_Profile_ID", which has the value "Senior_Benefits_Analyst." However, this is not the value—the is a separate element under , not . The question specifically asks for the value, so this option is incorrect, as it selects a different piece of data (the job profile ID, not the job code).

Why Option C is Correct

Option C, wd:Job_Profile_Data/wd:Job_Code, is the correct XPath syntax because:

It starts from the context node (as the template matches this element) and navigates to , which directly selects the element’s value ("Senior_Benefits_Analyst").

It is concise and aligns with standard XPath navigation in XSLT, avoiding unnecessary redundancy (unlike Option A) or incorrect attribute selectors (unlike Option B).

It matches the XML structure, where is a child of and contains as a child.

When used with in the template, it outputs the job code value, fulfilling the requirement.

Practical Example in XSLT

Here’s how this might look in your XSLT:

xml

WrapCopy

This would output "Senior_Benefits_Analyst" for the element in the XML.

Verification with Workday Documentation

The Workday Pro Integrations Study Guide and SOAP API Reference (available via Workday Community) detail the structure of the Get_Job_Profiles response and how to use XPath in XSLT for transformations. The XML structure shows as the container for job profile details, including . The guide emphasizes using relative XPath paths within templates to navigate from the matched element (e.g., ) to child elements like .

Workday Pro Integrations Study Guide References

Section: XSLT Transformations in EIBs – Describes using XSLT to transform web service responses, including selecting elements with XPath.

Section: Workday Web Services – Details the Get_Job_Profiles operation and its XML output structure, including and .

Section: XPath Syntax – Explains how to navigate XML hierarchies in Workday XSLT, using relative paths like wd:Job_Profile_Data/wd:Job_Code from a context.

Workday Community SOAP API Reference – Provides examples of XPath navigation for Workday web service responses.

Option C is the verified answer, as it correctly selects the value using the appropriate XPath syntax within the template context.

In this scenario, a calculated field (Phone Allowance Type) is available and validated in the tenant, but it does not appear in the Core Connector: Worker output. The integration is configured with DIS enabled, and the expected behavior is for all specified worker data — including name, address, and calculated fields — to be included in the output file.

The correct action is to enable the field from the Configure Integration Field Attributes step.

From Workday Pro: Integrations materials:

“In order for a calculated field to be included in a Core Connector output, it must be explicitly located and selected from within the Configure Integration Field Attributes task. This step determines what fields are extracted in the integration output — including any standard or calculated fields available in the object model.”

Even though the field exists and is functional, it must be manually located within the relevant section (e.g., Worker Data > Compensation or Worker Details), and marked to include in the output.

Incorrect Options Explained:

A. Configure Integration Field Overrides: This is used to change or override output formatting but does not control field visibility.

B. Configure Integration Maps: Used for mapping values or converting code sets, not for selecting fields for output.

C. Create a Custom Field Override service: This is not necessary for simply adding a calculated field; the existing field can be enabled via attributes configuration.