Skip to content

agents_schedules__shifts__activities

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

Column Type Description
start_date timestamp with time zone Start date/time of the period or item.
length_minutes double precision Value in minutes.
description text Textual description of the record.
activity_code_id text Identifier of a related entity in Genesys Cloud.
paid boolean Boolean indicator for the record.
time_off_request_id text Identifier of a related entity in Genesys Cloud.
external_activity_id text Identifier of a related entity in Genesys Cloud.
external_activity_type text Field external_activity_type extracted from Genesys Cloud.
exported boolean Indicates whether the record was marked as exported by the pipeline.
_sdc_source_key_user_id text 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.
_sdc_level_1_id bigint Technical identifier of the second nested array level in the Singer/SDC pipeline.

Last updated: