Skip to content

historical_adherence__exceptioninfo

Description: Child table derived from the nested structure of historical_adherence extracted from Genesys Cloud.

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.

Last updated: