workitem

Table Type: Historical Data

Contains Genesys Cloud work automation workitems.

Workitems are task-management records, not conversation media. This table stores the stable reporting fields for each workitem. Customer-specific workitem custom fields are stored in the workitem_custom_field table.

Columns

Column Type Modifiers Notes
id string Primary Key The unique identifier of the workitem.
db_last_updated datetime When this record was last updated in UTC.
db_when_created datetime When this record was created in the database.
db_when_deleted datetime When this record was deleted in the database. NULL if not deleted.
name string The name of the workitem.
description string The description of the workitem.
division_id string The division id of the workitem.
division_name string The division name of the workitem.
type_id string The worktype id of the workitem.
type_name string The worktype name of the workitem.
language_id string The language id of the workitem.
language_name string The language name of the workitem.
priority int32 The priority of the workitem.
date_created datetime The creation date of the workitem.
date_modified datetime The modified date of the workitem.
date_due datetime The due date of the workitem.
date_expires datetime The expiry date of the workitem.
duration_seconds int32 The estimated duration in seconds to complete the workitem.
ttl int32 The time to live of the workitem in seconds.
status_id string The current status id of the workitem.
status_name string The current status name of the workitem.
status_category string The current status category of the workitem.
date_status_changed datetime The date the workitem status last changed.
date_closed datetime The date the workitem was closed.
workbin_id string The workbin id that contains the workitem.
workbin_name string The workbin name that contains the workitem.
reporter_id string The reporter user id of the workitem.
reporter_name string The reporter user name of the workitem.
assignee_id string The assignee user id of the workitem.
assignee_name string The assignee user name of the workitem.
external_contact_id string The external contact id associated with the workitem.
external_contact_name string The external contact name associated with the workitem.
external_tag string The external tag associated with the workitem.
modified_by_id string The user id that last modified the workitem.
queue_id string The queue id associated with the workitem.
queue_name string The queue name associated with the workitem.
assignment_state string The assignment state of the workitem.
date_assignment_state_changed datetime The date the assignment state last changed.
alert_timeout_seconds int32 The duration in seconds before an alert times out.
auto_status_transition boolean Whether automatic status transition is enabled.
schema_id string The custom field schema id associated with the workitem.
schema_version int32 The custom field schema version associated with the workitem.
script_id string The script id associated with the workitem.
script_name string The script name associated with the workitem.
custom_fields_json string All custom fields serialized as JSON.

Actions and Background Tasks

Actions