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_date_dim_id_pk PRIMARY KEY PRIMARY KEY (date_dim_id)

Indexes

Name Definition
dimension_date_date_dim_id_pk CREATE UNIQUE INDEX dimension_date_date_dim_id_pk 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.subuserusagedata

      Description Subscription Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false Primary Key date timestamp without time zone true Date userlogin varchar(50) true User GUID licensename varchar(200) true ...

    • public.wfmauditdata

      Description Audit Table for WFM Schedule Change Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(150) false Primary Key modifiedby varchar(50) true Schedule GUID scheduleid varchar(50) true addorremove varchar(10) true ...

    • public.convsummarydata

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

    • public.userpresencedetaileddata

      Description User Presence Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false Primary Key userid varchar(50) true Agent GUID starttime timestamp without time zone false Start Time (UTC) starttimeltc ...

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