Table Type: Historical Data
This table contains the conversation participants' data.
It is common for flows (IVRs, or other pre-queue processing) to set participant data - these are key-value pairs - that are then associated with the participant and conversation.
Such 'participant data' can also be set or ready by an API, or used in reporting.
This table stores all the key-value pairs that are set. Note that Genesys does not always correctly retain information set after the participant has disconnected, so if you are adding
participant data after the fact, then the data is not always sent to CX Vizz.
Becuase reports commonly need participant data (for example, to determine progress through an IVR before a call is queued), there is a special action
which creates a custom_participant view which includes the participant and columns that correspond to desired attributes. This is
to help with backward compatibility with CX Vizz R1. See the 'update_participant_view' action for more information.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| participant_id | string | Primary Key | The ID of the participant to whom this attribute belongs |
| name | string | Primary Key | The name of the attribute |
| db_last_updated | datetime | The last time this record was updated in the database | |
| db_when_created | datetime | The time this record was created in the database | |
| val | string | The value of the attribute | |
| conversation_id | string | The ID of the conversation to which this participant belongs |