public.dimension_date

public.dimension_date

Description

Columns

Name Type Default Nullable Children Parents Comment
date_dim_id integer false
date_actual date false
epoch bigint false
day_suffix varchar(4) false
day_name varchar(9) false
day_of_week integer false
day_of_month integer false
day_of_quarter integer false
day_of_year integer false
week_of_month integer false
week_of_year integer false
week_of_year_iso character(10) false
month_actual integer false
month_name varchar(9) false
month_name_abbreviated character(3) false
quarter_actual integer false
quarter_name varchar(9) false
year_actual integer false
first_day_of_week date false
last_day_of_week date false
first_day_of_month date false
last_day_of_month date false
first_day_of_quarter date false
last_day_of_quarter date false
first_day_of_year date false
last_day_of_year date false
mmyyyy character(6) false
mmddyyyy character(10) false
weekend_indr boolean false

Constraints

Name Type Definition
dimension_date_pkey PRIMARY KEY PRIMARY KEY (date_dim_id)

Indexes

Name Definition
dimension_date_pkey CREATE UNIQUE INDEX dimension_date_pkey ON public.dimension_date USING btree (date_dim_id)
dimension_date_date_actual_idx CREATE INDEX dimension_date_date_actual_idx ON public.dimension_date USING btree (date_actual)

    • Related Articles

    • public.copilotusagedata

      Description Copilot feature usage analytics data with full groupBy dimension support Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false SHA256 hash of all groupBy dimensions + interval for uniqueness conversationid ...

    • public.vwcopilotsummaryinsights

      Description Copilot summary insights with usage context Table Definition CREATE VIEW vwcopilotsummaryinsights AS ( SELECT cs.conversationid, cs.conversationstartdate, cs.conversationenddate, cs.conversationstartdateltc, cs.conversationenddateltc, ...

    • public.vwcopilotusagedata

      Description Copilot usage analytics with user and queue context Table Definition CREATE VIEW vwcopilotusagedata AS ( SELECT cu.keyid, cu.conversationid, cu.summaryid, cu.usagedate, cu.userid, ud.name AS agent_name, ud.username AS agent_username, ...

    • public.agentcopilotaggregatesdata

      Description Aggregated agent copilot usage metrics from Genesys Cloud Analytics API with all 24 dimensions Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false SHA256 hash of all 24 dimensions + interval for uniqueness ...

    • public.knowledgeaggregatesdata

      Description Aggregated knowledge base usage metrics from Genesys Cloud Analytics API Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false Primary key - SHA256 hash of all dimensions and interval agentassistantid ...