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.flowoutcomedata

      Description Conversation Flow Outcome Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false conversationid varchar(50) true Conversation GUID conversationstartdate timestamp without time zone false Conversation ...

    • public.scheduledata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false userid varchar(50) true Agent GUID buid varchar(50) true Business Unit GUID scheduleid varchar(50) true Schedule GUID shiftid integer true Shift GUID ...

    • public.offeredforecastdata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(150) false businessunitid varchar(50) true scheduleid varchar(50) true planninggroup varchar(50) true shorttermforecastid varchar(50) true startdate timestamp ...

    • public.vwcallabandonedsummary

      Description Shows the details for abandoned calls in the detailed interaction data – Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwcallabandonedsummary AS ( SELECT det.conversationid, det.conversationstartdate, ...

    • public.vwheadcountforecast

      Description See HeadCountForecast - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwheadcountforecast AS ( SELECT hcf.businessunitid, bu.name AS businessunitname, hcf.planninggroup AS planninggroup_id, pg.name AS ...