Description: Child table derived from the nested structure of historical_adherence extracted from Genesys Cloud.
Columns
Section titled “Columns”| Column | Type | Description |
|---|---|---|
systempresence |
text |
Field systempresence extracted from Genesys Cloud. |
startoffsetseconds |
double precision |
Field startoffsetseconds extracted from Genesys Cloud. |
endoffsetseconds |
double precision |
Field endoffsetseconds extracted from Genesys Cloud. |
exported |
boolean |
Indicates whether the record was marked as exported by the pipeline. |
_sdc_source_key_userid |
text |
Technical control field from the Singer/SDC pipeline. |
_sdc_source_key_management_unit_id |
text |
Technical control field from the Singer/SDC pipeline. |
_sdc_source_key_startdate |
timestamp with time zone |
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. |

