Skip to content

historical_adherence__daymetrics

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

Column Type Description
daystartoffsetsecs double precision Field daystartoffsetsecs extracted from Genesys Cloud.
adherenceschedulesecs double precision Field adherenceschedulesecs extracted from Genesys Cloud.
conformanceschedulesecs double precision Field conformanceschedulesecs extracted from Genesys Cloud.
conformanceactualsecs double precision Field conformanceactualsecs extracted from Genesys Cloud.
exceptioncount double precision Field exceptioncount extracted from Genesys Cloud.
exceptiondurationsecs double precision Field exceptiondurationsecs extracted from Genesys Cloud.
impactseconds double precision Field impactseconds extracted from Genesys Cloud.
schedulelengthsecs double precision Field schedulelengthsecs extracted from Genesys Cloud.
actuallengthsecs double precision Field actuallengthsecs extracted from Genesys Cloud.
adherencepercentage double precision Calculated percentage.
conformancepercentage double precision Calculated percentage.
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: