CasesTimeline

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 add-in 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)

Aggregate Fields

The add-in 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

[{
  contentType: { /* Content type of the attachment */
     -descriptor: Text /* A description of the instance */
     -href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
  descriptor: Text /* A preview of the instance */
  fileLength: Numeric /* File length of the attachment */
  fileName: Text /* File name of the attachment */
  id: Text /* \~Case\~ Attachment ID. */
}]

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	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	False	The Workday Id of the case that owns this timeline entry. This Id associates the timeline event with its corresponding case.
Attachments_Aggregate	String	False	A collection of attachments linked to the timeline item. These attachments can include supporting documents, images, or additional details related to the case event.
Comment_Content	String	False	The comment added to the case in rich text format. This field supports formatted text, including styling and embedded links.
Comment_TextBody	String	False	The comment added to the case in plain text format. This version of the comment removes any formatting or rich text elements.
CreationDate	Datetime	False	The date and time when the case timeline item was created. This timestamp provides an audit trail for case-related activities.
Description	String	False	A detailed message included in the case creation timeline entry. This field captures the original message provided by the case creator.
FormattedCreationDate	String	False	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	False	A human-readable summary of the knowledge base article linked to this case timeline item. This summary provides quick context on the related guidance document.
Guidance_KbArticle_Id	String	False	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	False	A human-readable summary of the UI task linked to the timeline item. This summary helps users understand the purpose of the associated action.
Guidance_UiTask_Id	String	False	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	False	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.
QuestionnaireResponse_Questionnaire_Descriptor	String	False	A human-readable summary of the questionnaire response associated with this case. This summary provides insight into the survey or feedback collected.
QuestionnaireResponse_Questionnaire_Href	String	False	A direct link to the questionnaire response instance. This link allows programmatic access to retrieve response details.
QuestionnaireResponse_Questionnaire_Id	String	False	The unique Id for the questionnaire response linked to the case. This Id ensures proper association of the survey data.
SubmittedBy_Descriptor	String	False	A human-readable summary of the person who submitted the timeline entry. This summary provides context on who contributed to the case history.
SubmittedBy_ExternalCreator_Email	String	False	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	False	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	False	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	False	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	False	A human-readable summary of the worker who submitted the timeline entry. This summary provides insight into the employee contributing to the case record.
SubmittedBy_Worker_Id	String	False	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	False	A human-readable summary of the worker associated with the case submission. This summary provides additional context about the case participant.
SubmittedBy_Worker_Person_Href	String	False	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	False	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	False	A human-readable summary of the type of case timeline entry. This summary provides context on the nature of the recorded event.
Type_Id	String	False	The unique Id for the type of case timeline entry. This Id categorizes the timeline event for reporting and tracking purposes.
Desc_Prompt	Bool	False	If the value is 'true', the query sorts the results in descending order. This setting ensures the most recent case timeline entries appear first.
MyCases_Prompt	Bool	False	Retrieves case timeline entries for cases owned by the processing user. This filter ensures only relevant case history records are displayed.
OpenCases_Prompt	Bool	False	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	False	Specifies the field used to sort query results. The default sorting field is creationDate, ensuring timeline events are displayed chronologically.