Records responses to questionnaires that are embedded in case timelines. This table enables structured data collection, survey analytics, and process optimization.

Table Specific Information

Select

The Workday connector requires filtering on Cases_Id in order to perform the query.

For example:

SELECT * FROM CasesTimelineQuestionnaireResponseQuestionAnswerPair WHERE Cases_Id = '1234';

Workday Resource Information

Retrieves timeline items for a case. Comment timeline items include comments and associated attachments. Action timeline items include an action with an action text. Creation timeline items include a description, associated attachments, and a questionnaire answer if applicable.

Secured by: REST API Public

Contains attachment(s)

Aggregate Fields

The connector 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
CasesTimeline_Id	String	The Workday identifier (Id) of the case timeline entry that contains this questionnaire response. This Id ensures that the response is correctly associated with the relevant timeline event within the case.
Cases_Id	String	The Workday Id of the case that owns this questionnaire response. This Id ensures that the response is linked to the appropriate case for accurate tracking and reference.
Answer	String	The recorded answer for the questionnaire question. This field captures the respondent’s input, which can be used for case resolution or further analysis.
Attachments_Aggregate	String	A collection of attachments related to the questionnaire response. These attachments can include supporting documents or additional context provided by the respondent.
Question	String	The text of the questionnaire question being answered. This field provides context for the corresponding answer in the response.
Desc_Prompt	Bool	If the value is 'true', the query sorts results in descending order. This option ensures that the most recent questionnaire responses appear first.
Flag_Prompt	String	Retrieves cases with the assigned flag(s).
Label_Prompt	String	Retrieves cases with the assigned label(s).
MyCases_Prompt	Bool	Retrieves questionnaire responses for cases owned by the processing user. This filter ensures that only relevant case-related responses are included in the results.
OpenCases_Prompt	Bool	Retrieves questionnaire responses for open cases and cases that were resolved or canceled within the last seven days. This filter helps users focus on active or recently closed cases.
Sort_Prompt	String	Specifies the field used to sort query results. The default sorting field is creationDate, ensuring responses are displayed in chronological order.
Status_Prompt	String	Retrieves cases with the specified status(es).
Substatus_Prompt	String	Retrieves cases with the specified substatus(es).
Team_Prompt	String	Retrieves cases with the specified service team(s).