Table Type: Historical Data
This table stores per-session flow outcomes emitted by Genesys Analytics.
Each record links a conversation participant session to a specific flow outcome id and its value/state.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| conversation_id | string | Primary Key | The unique identifier of the conversation. |
| participant_id | string | Primary Key | The unique identifier of the participant. |
| session_id | string | Primary Key | The unique identifier of the session. |
| flow_outcome_id | string | Primary Key | The unique identifier of the flow outcome. |
| flow_outcome_value | string | Flow outcome value, e.g. SUCCESS. | |
| flow_outcome_start_timestamp | datetime | Timestamp when the flow started. | |
| flow_outcome_end_timestamp | datetime | Timestamp when the flow ended. | |
| flow_outcome | string | Raw outcome string 'id:value' from Genesys. | |
| db_last_updated | datetime | When this record was last updated in UTC. | |
| db_when_created | datetime | When this record was created in UTC. |