Jump to: navigation, search
m (1 revision imported: Some parameters changed for consistent camelCase usage)
Line 1: Line 1:
 
= Table CAMPAIGN_GROUP_STATE_FACT =
 
= Table CAMPAIGN_GROUP_STATE_FACT =
  
 +
{{PDMColumn
 +
|colName=CAMP_GROUP_STATE_FACT_KEY
 +
|colDesc=The primary key of this table.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=TENANT_KEY
 +
|colDesc=The surrogate key that is used to join the TENANT dimension to the fact tables.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CAMPAIGN_KEY
 +
|colDesc=The surrogate key that is used to join the CAMPAIGN dimension to the fact tables.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=GROUP_KEY
 +
|colDesc=The surrogate key that is used to join the GROUP_ dimension to the fact tables.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CAMPAIGN_GROUP_STATE_KEY
 +
|colDesc=The surrogate key that is used to join the CAMPAIGN_GROUP_STATE dimension to the fact tables.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CAMP_GROUP_SESS_FACT_SDT_KEY
 +
|colDesc=The value of the START_DATE_TIME_KEY field of the record in the CAMPAIGN_GROUP_
 +
SESSION_FACT table. On a partitioned database, CAMP_GROUP_SESS_FACT_SDT_KEY in combination with CAMP_GROUP_SESSION_FACT_KEY forms a value of the composite primary key for the CAMPAIGN_GROUP_SESSION_FACT table.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CAMP_GROUP_SESSION_FACT_KEY
 +
|colDesc=The value of the primary key of the CAMPAIGN_GROUP_SESSION_FACT table. This surrogate key is used to join this campaign group state fact to its campaign group session fact. In other words, this key places the campaign group state within the context of a campaign group session.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=START_DATE_TIME_KEY
 +
|colDesc=Identifies the start of a 15-minute interval in which this state for the campaign group 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.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=END_DATE_TIME_KEY
 +
|colDesc=Identifies the start of a 15-minute interval in which this state for the campaign group 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.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CREATE_AUDIT_KEY
 +
|colDesc=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.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=UPDATE_AUDIT_KEY
 +
|colDesc=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.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=START_TS
 +
|colDesc=The UTC-equivalent value of the date and time at which the campaign group entered this state.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=END_TS
 +
|colDesc=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 this state for the campaign group 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.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=TOTAL_DURATION
 +
|colDesc=The meaning depends on the value of ACTIVE_FLAG. For an inactive row, the total duration, in seconds, of the campaign group in started state. For an active row, the amount of time, in seconds, that the campaign group has been in started state, from the time that it entered started state to the time that the ETL last executed.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CAMPAIGN_GROUP_SESSION_ID
 +
|colDesc=The ICON source SessID for the campaign group session with which this session fact is related.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=ACTIVE_FLAG
 +
|colDesc=Indicates whether the campaign group state is currently active: 0 = No, 1 = Yes.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=PURGE_FLAG
 +
|colDesc=This field is reserved.
 +
}}
  
 
[[Category:V:GIM:8.5DRAFT]]
 
[[Category:V:GIM:8.5DRAFT]]

Revision as of 13:55, May 5, 2016

Table CAMPAIGN_GROUP_STATE_FACT

Comments or questions about this documentation? Contact us for support!