Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
  • DV = Default value
  • In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.)

Table TIME_ZONE

Description


In partitioned databases, this table is not partitioned.


This table allows facts to be described based on attributes of a time zone. Each row describes one time zone, as configured in Configuration Database. Configuration Database includes one instance of a time zone, regardless of whether Daylight Saving Time (DST) is in effect. For this reason, the offset for a given time zone may be different at different points in time.

This table is necessary to describe a contact's time zone in outbound campaigns, because time zones of campaign contacts may differ from the time zones of contact centers.

Column List

Legend

Column Data Type P M F DV

TIME_ZONE_KEY

int X X

TENANT_KEY

int X X

TIME_ZONE_NAME

varchar(255)/nvarchar(255)

TIME_ZONE_NAME2

varchar(255)/nvarchar(255)

DESCRIPTION

varchar(255)/nvarchar(255)

TIME_ZONE_CFG_DBID

int

GMT_OFFSET

int

IS_DST_OBSERVED

numeric(1)

DST_START_MONTH

int

DST_STOP_MONTH

int

DST_START_WEEK

int

DST_STOP_WEEK

int

DST_START_DAY

int

DST_STOP_DAY

int

DST_START_TIME

int

DST_STOP_TIME

int

DST_START_YEAR

int

DST_STOP_YEAR

int

START_TS

int

END_TS

int

CREATE_AUDIT_KEY

numeric(19) X X

UPDATE_AUDIT_KEY

numeric(19) X X

PURGE_FLAG

numeric(1)

TIME_ZONE_KEY

The primary key of this table. This value is generated by Genesys Info Mart.

TENANT_KEY

The surrogate key that is used to join to the TENANT dimension.

TIME_ZONE_NAME

The name of the time zone, as defined in Configuration Database.

TIME_ZONE_NAME2

An alternative name for the time zone.

DESCRIPTION

The description of the time zone. This field can be updated by users.

TIME_ZONE_CFG_DBID

The database identifier (DBID) that is assigned by Configuration Server to the time zone configuration object in this contact center configuration environment.

GMT_OFFSET

The time zone offset from UTC, in seconds, when Daylight Saving Time is not in effect.

IS_DST_OBSERVED

A flag that indicates whether DST is used.

DST_START_MONTH

A number that specifies the month at which DST starts:

  • 1 = January
...
  • 12 = December

When DST is not observed, this value is set to 0.

DST_STOP_MONTH

A number that specifies the month at which DST ends:

  • 1 = January
...
  • 12 = December

When DST is not observed, this value is set to 0.

DST_START_WEEK

In conjunction with DST_START_MONTH and DST_START_DAY, specifies when DST starts. This field is set to one of the following values:

  • 0 — DST is not observed, or the week is not specified.
  • 1 thru 5 — The occurrence of the weekday within the month.
  • 7 — The last occurrence of the weekday within the month.

For example:

  • If DST_START_MONTH is 4, DST_START_WEEK is 1, and DST_START_DAY is 1, DST starts on the first Sunday in April.
  • If DST_START_MONTH is 3, DST_START_WEEK is 7, and DST_START_DAY is 1, DST starts on the last Sunday in March.

DST_STOP_WEEK

In conjunction with DST_STOP_MONTH and DST_STOP_DAY, specifies when DST ends. This field is set to one of the following values:

  • 0 — DST is not observed, or the week is not specified.
  • 1 thru 5 — The occurrence of the weekday within the month.
  • 7 — The last occurrence of the weekday within the month.

For example:

  • If DST_STOP_MONTH is 11, DST_STOP_WEEK is 2, and DST_STOP_DAY is 1, DST ends on the second Sunday in November.
  • If DST_STOP_MONTH is 10, DST_STOP_WEEK is 7, and DST_STOP_DAY is 1, DST ends on the last Sunday in October.

DST_START_DAY

Specifies the weekday on which DST starts, if the week is specified (DST_START_WEEK does not equal 0). This field is set to one of the following values:

  • 0 — DST is not observed.
  • 1 — Sunday.
  • 7 — Saturday.
  • 63 — The last day of the month.

DST_STOP_DAY

Specifies the weekday on which DST ends, if the week is specified (DST_START_WEEK does not equal 0). This field is set to one of the following values:

  • 0 — DST is not observed.
  • 1 — Sunday.
  • 7 — Saturday.
  • 63 — The last day of the month.

DST_START_TIME

Specifies the DST start time, in seconds, which is counted from the start of the day on which daylight saving starts.

DST_STOP_TIME

Specifies the DST end time, in seconds, which is counted from the start of the day on which daylight saving ends.

DST_START_YEAR

Specifies DST start year for the Time Zone configuration objects that are defined for a specific year only. Year 2001 is assigned a value of 1. A value of 0 indicates that DST is not observed or that the year is not specified.

DST_STOP_YEAR

Specifies DST stop year for the Time Zone configuration objects that are defined for a specific year only. Year 2001 is assigned a value of 1. A value of 0 indicated that DST is not observed or that the year is not specified.

START_TS

The UTC-equivalent value of the date and time at which the time zone was added to the contact center configuration.

END_TS

The UTC-equivalent value of the date and time at which the time zone was removed from the contact center configuration.

CREATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools—that is, applications that need to identify newly added data.

UPDATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools—that is, applications that need to identify recently modified data.

PURGE_FLAG

This field is reserved.

   

Subject Areas

  • Contact_Attempt - Represents outbound campaign contact record attempts. An attempt may or may not include dialing.

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 29 August 2016, at 14:53.