Description: Child table derived from the nested structure of conversations_messages extracted from Genesys Cloud.
Columns
Section titled “Columns”| Column | Type | Description |
|---|---|---|
id |
text |
Unique identifier of the record in Genesys Cloud. |
chat |
text |
Field chat extracted from Genesys Cloud. |
body_type |
text |
Field body_type extracted from Genesys Cloud. |
body |
text |
Field body extracted from Genesys Cloud. |
message |
text |
Field message extracted from Genesys Cloud. |
utc |
text |
Field utc extracted from Genesys Cloud. |
participant_purpose |
text |
Field participant_purpose extracted from Genesys Cloud. |
pcfrom |
text |
Field pcfrom extracted from Genesys Cloud. |
sender_communication_id |
text |
Identifier of a related entity in Genesys Cloud. |
to |
text |
Field “to” extracted from Genesys Cloud. |
type |
text |
Field type extracted from Genesys Cloud. |
user__id |
text |
Identifier of the user/agent in Genesys Cloud. |
user__name |
text |
Descriptive name of the related entity. |
user__display_name |
text |
Descriptive name of the related entity. |
user__username |
text |
Field user__username extracted from Genesys Cloud. |
exported |
boolean |
Indicates whether the record was marked as exported by the pipeline. |
_sdc_source_key_id |
text |
Technical control field from the Singer/SDC pipeline. |
_sdc_sequence |
bigint |
Technical ingestion sequence from the Singer/SDC pipeline. |
_sdc_level_0_id |
bigint |
Technical identifier of the first nested array level in the Singer/SDC pipeline. |

