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

Table CAMPAIGN_GROUP_SESSION_FACT

Description


In partitioned databases, this table is partitioned.


Each row represents an outbound campaign group session, where a session is started when a campaign group is loaded and ended when a campaign group is unloaded. The grain of the fact is an accumulating snapshot that represents the duration of the campaign group session.

Column List

Legend

Column Data Type P M F DV

CAMP_GROUP_SESSION_FACT_KEY

numeric(19) X X

GROUP_KEY

integer X X

CAMPAIGN_KEY

integer X X

TENANT_KEY

integer X X

START_DATE_TIME_KEY

integer X X

END_DATE_TIME_KEY

integer X X

CREATE_AUDIT_KEY

numeric(19) X X

UPDATE_AUDIT_KEY

numeric(19) X X

START_TS

integer

END_TS

integer

TOTAL_DURATION

integer

CAMPAIGN_GROUP_SESSION_ID

varchar(64)

ACTIVE_FLAG

numeric(1)

PURGE_FLAG

numeric(1)

CAMP_GROUP_SESSION_FACT_KEY


The primary key of this table.

GROUP_KEY


The surrogate key that is used to join the GROUP_ dimension to the fact tables.

CAMPAIGN_KEY


The surrogate key that is used to join the CAMPAIGN dimension to the fact tables.

TENANT_KEY


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

START_DATE_TIME_KEY


Identifies the start of a 15-minute interval in which the campaign group session began. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the START_TS timestamp to an appropriate time zone.

END_DATE_TIME_KEY


Identifies the start of a 15-minute interval in which the campaign group session ended. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the END_TS timestamp to an appropriate time zone.

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.

START_TS


The UTC-equivalent value of the date and time at which the campaign group session began.

END_TS


The meaning depends on the value of ACTIVE_FLAG. For an inactive row, this field represents the UTC-equivalent value of the date and time at which the campaign group session ended. For an active row, this value represents a UTC-equivalent value of the date and time far in the future, so that applications do not have to test for null.

TOTAL_DURATION


The meaning depends on the value of ACTIVE_ FLAG. For an inactive row, the total duration, in seconds, of the campaign group session. For an active row, the duration, in seconds, that the campaign group session was active, from start time to the time that the ETL last executed.

CAMPAIGN_GROUP_SESSION_ID


The ICON source SessID for the campaign group session with which this session fact is related.

ACTIVE_FLAG


Indicates whether the campaign group session is currently active: 0 = No, 1 = Yes.

PURGE_FLAG


This field is reserved.


Index List

CODE U C Description

I_CGSEF_SID

X Ensures that the facts that are stored in the table are for unique sessions.

I_CGSEF_DT

Improves access time, based on the Start Date Time key.

I_CGSEF_TNT

Improves access time, based on the Tenant.

Index I_CGSEF_SID

Field Sort Comment
CAMPAIGN_GROUP_SESSION_ID Ascending
START_DATE_TIME_KEY Ascending

Index I_CGSEF_DT

Field Sort Comment
START_DATE_TIME_KEY Ascending
END_DATE_TIME_KEY Ascending

Index I_CGSEF_TNT

Field Sort Comment
TENANT_KEY Ascending

Subject Areas

  • Facts - Represents the relationships between subject area facts.

 

Comment on this article:

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