Table Type: Historical Data
Contains one row per custom field on a Genesys Cloud workitem.
The val column stores a report-friendly string representation. The value_json column keeps the full serialized value for complex custom field types.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| workitem_id | string | Primary Key | The workitem id. |
| name | string | Primary Key | The custom field name. |
| db_last_updated | datetime | When this record was last updated in UTC. | |
| db_when_created | datetime | When this record was created in the database. | |
| val | string | The custom field value as a report-friendly string. | |
| value_json | string | The custom field value serialized as JSON. | |
| value_type | string | The .NET or JSON token type of the custom field value. |