Contains a chronological history of case-related events, comments, and interactions. This table supports auditability, collaboration, and case resolution tracking.

Table Specific Information

Select

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

For example:

SELECT * FROM CasesTimeline WHERE Cases_Id = '12345';

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)

Columns

Name	Type	Description
Id [KEY]	String	The unique identifier (Id) for the case timeline item. This Id ensures that each timeline entry is distinctly tracked within the case history.
Cases_Id [KEY]	String	The Workday Id of the case that owns this timeline entry. This Id associates the timeline event with its corresponding case.
CaseSolverDisplayOverrides_HideSubmittedByProfileLink	Bool	The configuration setting you can use to hide the profile link for the person who submitted the timeline item.
CaseSolverDisplayOverrides_HideSubmittedByProfilePicture	Bool	The configuration setting you can use to hide the profile picture for the person who submitted the timeline item.
CaseSolverDisplayOverrides_SubmittedByDisplayName	String	The display name of the worker who submitted the timeline item.
Comment_Content	String	The comment added to the case in rich text format. This field supports formatted text, including styling and embedded links.
Comment_TextBody	String	The comment added to the case in plain text format. This version of the comment removes any formatting or rich text elements.
CreationDate	Datetime	The date and time when the case timeline item was created. This timestamp provides an audit trail for case-related activities.
Description	String	A detailed message included in the case creation timeline entry. This field captures the original message provided by the case creator.
FormattedCreationDate	String	The creation date of the timeline item formatted with year, month, day, hour, and minute. The format adapts to the processing user’s locale and timezone settings.
Guidance_KbArticle_Descriptor	String	The display name of the instance
Guidance_KbArticle_Id	String	The unique Id for the knowledge base article linked to the case. This Id ensures that the correct article is referenced.
Guidance_UiTask_Descriptor	String	The display name of the instance
Guidance_UiTask_Id	String	The unique Id for the UI task related to the timeline item. This Id ensures accurate tracking of tasks associated with the case.
Guidance_UiTask_Url	String	A direct Uniform Resource Locator (URL) to the UI task associated with this case timeline entry. This link enables users to quickly access the relevant task in Workday.
Note_Id	String	Id of the instance
Note_LastUpdatedMoment	String	The last updated moment of the note, formatted to include the year, month, day, hour and minute. The date format depends on the processing user's locale and uses the user's timezone.
Note_TextBody	String	The note text
QuestionnaireResponse_Questionnaire_Descriptor	String	The display name of the instance
QuestionnaireResponse_Questionnaire_Href	String	A direct link to the questionnaire response instance. This link allows programmatic access to retrieve response details.
QuestionnaireResponse_Questionnaire_Id	String	The unique Id for the questionnaire response linked to the case. This Id ensures proper association of the survey data.
SubmittedBy_Descriptor	String	The display name of the instance
SubmittedBy_ExternalCreator_Email	String	The email address of the external creator who submitted the case timeline item. This contact detail helps track externally initiated case updates.
SubmittedBy_ExternalCreator_Id	String	The unique Id for the external creator of the timeline item. This Id ensures accurate tracking of contributions from external users.
SubmittedBy_ExternalCreator_Name	String	The name of the external creator, with 'External' in parentheses or a note indicating a purged record. This field identifies case updates submitted by external sources.
SubmittedBy_Id	String	The unique Id for the person who submitted the timeline entry. This Id ensures proper tracking of contributions to the case.
SubmittedBy_Worker_Descriptor	String	The display name of the instance
SubmittedBy_Worker_Id	String	The unique Id for the worker who submitted the case timeline item. This Id links the timeline entry to the responsible employee.
SubmittedBy_Worker_Person_Descriptor	String	The display name of the instance
SubmittedBy_Worker_Person_Href	String	A direct link to the worker’s instance. This link allows programmatic retrieval of details about the employee who submitted the timeline item.
SubmittedBy_Worker_Person_Id	String	The unique Id for the worker linked to the case submission. This Id ensures the correct employee is referenced in case history.
Type_Descriptor	String	The display name of the instance
Type_Id	String	The unique Id for the type of case timeline entry. This Id categorizes the timeline event for reporting and tracking purposes.
Desc_Prompt	Bool	If the value is 'true', the query sorts the results in descending order. This setting ensures the most recent case timeline entries 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 case timeline entries for cases owned by the processing user. This filter ensures only relevant case history records are displayed.
OpenCases_Prompt	Bool	Retrieves timeline entries 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 timeline events are displayed chronologically.
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).