Description: Child table derived from the nested structure of historical_adherence extracted from Genesys Cloud.
Columns
Section titled “Columns”| 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. |

