WorkDay Tutorial-Custom XSLT

EIB & CUSTOM XSLT & WORKDAY WEB SERVICES (WWS) 

There are times when Workday does not present output in the desired format for simple integration tasks. One example is upper-case and lower-case letter. Workday stores people’s names in mixed-case, but another system might require the last name appear as all upper-case letters. Another example might be Social Security Number. SSN is typically formatted as a 9 digit numeric value (if unmasked). Another system could require that the data be passed but, only the last 4 digits. In this case an Extensible Stylesheet Language Transformation (XSLT) could be implemented with the EIB. 

·       Formatting: If Workday data comes out of the system and is incompatible with the external system, XSLT can be used to transform the data. Some common examples are date fields – Many external systems require a different date format from Workday. XSLT can be used to reformat the data to suit the endpoint’s needs. 



·       Conditional Logic: The standard EIB transformations do not allow for conditional logic. There are times when the output format should be different based upon the value of a particular data element. An example might be a contingent worker vs. a full time employee. Using if/then logic, the output can be tailored to which type of worker the XSLT is attempting to transform.

 

·       Custom Output: Finally, a integration can be scheduled to process based on the scheduling criteria that is defined by the user and the passage of time (for example – the first day of each month). The benefit is that the integration does not need to be manually launched each time. Another example would be to launch a benefit carrier integration each Friday at 6pm.