Skip to content

bu_agent_schedules__shifts__activities

Description: Child table derived from the nested structure of bu_agent_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.
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_source_key_schedule_id text Technical control field from the Singer/SDC pipeline.
_sdc_source_key_week_date 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: