SSIS Components for Workday

Build 25.0.9434

CasesSatisfactionSurveyResultsQuestionnaireResponseQuestionAnswerPair

Stores questionnaire response-and-answer pairings from satisfaction surveys that are associated with cases. This table facilitates sentiment analysis, service quality assessment, and operational improvements.

Workday Resource Information

Retrieves a list of case details that the user is secured to view. Case details include: title, detailed message, case ID, status, creation date, case link, assignee, confidential, about, by, for, type, and serviceTeam.

Secured by: Help Case Data+TG, Self Service: Help Case Management+TG

Scope: Help

Aggregate Fields

The component represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is. Fields marked with a hyphen are read-only and must not be included when calling stored procedures or when performing an INSERT or UPDATE.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

Attachments_Aggregate


[{
  comment: Text /* Questionnaire attachment comment */
  fileName: Text /* File name of the attachment */
  href: Text /* A link to the instance */
  id: Text /* Id of the instance */
}]

Columns

Name Type Description
Cases_Id String The Workday identifier (Id) of the case that includes this question-answer pair in the satisfaction survey results. This Id links the survey response to the corresponding case record for tracking and reference.
Answer String The text response provided for the survey question. This field captures qualitative feedback from the user related to the case.
Attachments_Aggregate String A collection of questionnaire attachments. These attachments can include supporting documents, images, or additional context provided by the respondent.
Question String The text of the survey question presented to the respondent. This field defines the specific aspect of the case being evaluated or commented on.
Desc_Prompt Bool If the value is 'true', the query sorts the results in descending order. This option allows users to retrieve the most recent survey responses first when querying data.
MyCases_Prompt Bool Retrieves cases owned by the processing user. This filter ensures that only cases assigned to or initiated by the user are included in the results.
OpenCases_Prompt Bool Retrieves open cases and cases that were resolved or canceled less than 7 days ago. This filter helps users focus on active or recently closed cases that might require attention.
Sort_Prompt String The field used to sort results in query responses. The default sorting field is creationDate, ensuring results are ordered chronologically based on when the case was created.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434