Description: Child table derived from the nested structure of historical_adherence extracted from Genesys Cloud.
Columns
Section titled “Columns”| Column | Type | Description |
|---|---|---|
startoffsetseconds |
double precision |
Field startoffsetseconds extracted from Genesys Cloud. |
endoffsetseconds |
double precision |
Field endoffsetseconds extracted from Genesys Cloud. |
scheduledactivitycodeid |
text |
Field scheduledactivitycodeid extracted from Genesys Cloud. |
scheduledactivitycategory |
text |
Field scheduledactivitycategory extracted from Genesys Cloud. |
actualactivitycategory |
text |
Field actualactivitycategory extracted from Genesys Cloud. |
systempresence |
text |
Field systempresence extracted from Genesys Cloud. |
routingstatus |
text |
Field routingstatus extracted from Genesys Cloud. |
impact |
text |
Field impact extracted from Genesys Cloud. |
secondarypresencelookupid |
text |
Field secondarypresencelookupid 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. |

