Skip to content

bu_agent_schedules__shifts

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

Column Type Description
id text Unique identifier of the record in Genesys Cloud.
start_date timestamp with time zone Start date/time of the period or item.
length_minutes double precision Value in minutes.
manually_edited 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.

Last updated: