Jump to: navigation, search

days-to-keep-cfg-facts

Section: gim-etl
Default Value: 400 or days-to-keep-gim-facts
Valid Values: Greater than, or equal to, days-to-keep-gim-facts
Changes Take Effect: At the next run of Job_MaintainGIM
Dependencies: days-to-keep-gim-facts
Introduced: 8.5.003

Specifies the number of days to retain deleted configuration fact data in GIDB and relevant fact tables. Facts that have an end time that is earlier than the retention period are eligible to be purged. The value of the days-to-keep-cfg-facts configuration options must always be greater than, or equal to, days-to-keep-gim-facts.

For a list of the tables for which this option controls the purge threshold, see Info Mart Tables Purged by the Maintenance Job in the Genesys Info Mart Operations Guide.

days-to-keep-gdpr-history

Section: gim-etl
Default Value: 15
Valid Values: An integer in the range 0-30
Changes Take Effect: At the next run of Job_MaintainGIM
Dependencies: None
Introduced: 8.5.010

Specifies the number of days to retain data in the CTL_GDPR_HISTORY table.

The table stores the actual personally identifiable information (PII) that relates to a General Data Protection Regulation (GDPR) request. For Right to Access (export) requests, the table stores the data that was requested for export. For Right of Erasure ("forget me") requests, the table stores the data that was redacted.

To ensure that this data is ephemeral, the retention period for records in the CTL_GDPR_HISTORY table is restricted to a maximum of 30 days.

days-to-keep-discards-and-job-history

Section: gim-etl
Default Value: 600
Valid Values: Any positive integer
Changes Take Effect: At the next run of Job_MaintainGIM
Dependencies: None

Specifies the number of days to retain data in the discard tables and audit and history tables.

more...

days-to-keep-gidb-facts

Section: gim-etl
Default Value: 14
Valid Values: Any positive integer
Changes Take Effect: At the next run of Job_MaintainGIM
Dependencies: None in releases 8.1.0 and 8.1.1; starting with release 8.1.2, days-to-keep-gim-facts
Related Options: days-to-keep-active-facts

Starting with release 8.1.1, specifies the number of days to retain fact data in GIDB. Facts that have a start time that is earlier than the retention period are eligible to be purged.

For multimedia interactions, this option specifies the retention period for completed facts, provided that there are no active facts that have the same (or earlier) start timestamps. If there are active facts with the same (or earlier) start timestamps, the eligible completed facts will not actually be purged until these active interactions have been terminated and, therefore, also become eligible to be purged, as described in days-to-keep-active-facts.

For a list of the tables for which this option controls the purge threshold, see Info Mart Tables Purged by the Maintenance Job in the Genesys Info Mart Operations Guide.

days-to-keep-gidb-facts

Section: gim-etl
Default Value: 14
Valid Values: Any positive integer
Changes Take Effect: At the next run of Job_MaintainGIM
Dependencies: None in releases 8.1.0 and 8.1.1; starting with release 8.1.2, days-to-keep-gim-facts
Related Options: days-to-keep-active-facts

Starting with release 8.1.1, specifies the number of days to retain fact data in GIDB. Facts that have a start time that is earlier than the retention period are eligible to be purged.

For multimedia interactions, this option specifies the retention period for completed facts, provided that there are no active facts that have the same (or earlier) start timestamps. If there are active facts with the same (or earlier) start timestamps, the eligible completed facts will not actually be purged until these active interactions have been terminated and, therefore, also become eligible to be purged, as described in days-to-keep-active-facts.

For a list of the tables for which this option controls the purge threshold, see Info Mart Tables Purged by the Maintenance Job in the Genesys Info Mart Operations Guide.

days-to-keep-gidb-facts

Section: gim-etl
Default Value: 14
Valid Values: Any positive integer
Changes Take Effect: At the next run of Job_MaintainGIM
Dependencies: None in releases 8.1.0 and 8.1.1; starting with release 8.1.2, days-to-keep-gim-facts
Related Options: days-to-keep-active-facts

Starting with release 8.1.1, specifies the number of days to retain fact data in GIDB. Facts that have a start time that is earlier than the retention period are eligible to be purged.

For multimedia interactions, this option specifies the retention period for completed facts, provided that there are no active facts that have the same (or earlier) start timestamps. If there are active facts with the same (or earlier) start timestamps, the eligible completed facts will not actually be purged until these active interactions have been terminated and, therefore, also become eligible to be purged, as described in days-to-keep-active-facts.

For a list of the tables for which this option controls the purge threshold, see Info Mart Tables Purged by the Maintenance Job in the Genesys Info Mart Operations Guide.

days-to-keep-active-facts

Section: gim-etl
Default Value: 30
Valid Values: Any positive integer
Changes Take Effect: At the next run of Job_TransformGIM or Job_MaintainGIM
Dependencies: None in releases 8.1.0 and 8.1.1; starting with release 8.1.2, days-to-keep-gim-facts
Modified: 8.1.1 (behavior and default value changed); 8.1.2 (dependencies introduced)

Starting with release 8.1.1, specifies the maximum number of days to retain active multimedia interactions in GIDB and the dimensional model, including certain Staging tables, after which the interactions become eligible for artificial termination. For a list of the tables in which this option affects retention behavior, see Info Mart Tables Purged by the Maintenance Job in the Genesys Info Mart Operations Guide.

more...

days-to-keep-gidb-facts

Section: gim-etl
Default Value: 14
Valid Values: Any positive integer
Changes Take Effect: At the next run of Job_MaintainGIM
Dependencies: None in releases 8.1.0 and 8.1.1; starting with release 8.1.2, days-to-keep-gim-facts
Related Options: days-to-keep-active-facts

Starting with release 8.1.1, specifies the number of days to retain fact data in GIDB. Facts that have a start time that is earlier than the retention period are eligible to be purged.

For multimedia interactions, this option specifies the retention period for completed facts, provided that there are no active facts that have the same (or earlier) start timestamps. If there are active facts with the same (or earlier) start timestamps, the eligible completed facts will not actually be purged until these active interactions have been terminated and, therefore, also become eligible to be purged, as described in days-to-keep-active-facts.

For a list of the tables for which this option controls the purge threshold, see Info Mart Tables Purged by the Maintenance Job in the Genesys Info Mart Operations Guide.

days-to-keep-deleted-annex

Section: gim-etl
Default Value: 2
Valid Values: Any positive integer
Changes Take Effect: At the next run of Job_MaintainGIM
Dependencies: None

Specifies the number of days to retain deleted records in the *_ANNEX dimension tables.

more...

days-to-keep-gim-facts

Section: gim-etl
Default Value: 400
Valid Values: Any positive integer
Changes Take Effect: At the next run of Job_MaintainGIM
Dependencies: None

Starting with release 8.1.1, specifies the number of days to retain fact data in the dimensional model. Facts that have a start time that is earlier than the retention period are eligible to be purged. Job_MaintainGIM does not purge active fact data, dimension data, or aggregate tables (if aggregation is enabled).

Starting with release 8.1.2, Genesys Info Mart enforces days-to-keep-active-facts < days-to-keep-gim-facts and days-to-keep-gidb-facts < days-to-keep-gim-facts.

more...

days-to-keep-gim-facts

Section: gim-etl
Default Value: 400
Valid Values: Any positive integer
Changes Take Effect: At the next run of Job_MaintainGIM
Dependencies: None

Starting with release 8.1.1, specifies the number of days to retain fact data in the dimensional model. Facts that have a start time that is earlier than the retention period are eligible to be purged. Job_MaintainGIM does not purge active fact data, dimension data, or aggregate tables (if aggregation is enabled).

Starting with release 8.1.2, Genesys Info Mart enforces days-to-keep-active-facts < days-to-keep-gim-facts and days-to-keep-gidb-facts < days-to-keep-gim-facts.

more...

days-to-keep-gim-facts

Section: gim-etl
Default Value: 400
Valid Values: Any positive integer
Changes Take Effect: At the next run of Job_MaintainGIM
Dependencies: None

Starting with release 8.1.1, specifies the number of days to retain fact data in the dimensional model. Facts that have a start time that is earlier than the retention period are eligible to be purged. Job_MaintainGIM does not purge active fact data, dimension data, or aggregate tables (if aggregation is enabled).

Starting with release 8.1.2, Genesys Info Mart enforces days-to-keep-active-facts < days-to-keep-gim-facts and days-to-keep-gidb-facts < days-to-keep-gim-facts.

more...

Info Mart Tables Purged by the Maintenance Job

This page lists the tables in the Info Mart database schema that the Genesys Info Mart maintenance job, Job_MaintainGIM, purges. The maintenance job automatically purges all data that it determines is eligible to be purged, based on configurable retention policies. The maintenance job can be scheduled to run daily, or it can be run manually from the Genesys Info Mart management GUI.

The maintenance job purges data from particular tables within the following table groups:

For more information about the maintenance job, see Job_MaintainGIM. For information about the configuration options that specify the data-retention policies, see the days-to-keep-* options in the Genesys Info Mart Options Reference.

Dimensional model tables

The following table lists the fact tables in the dimensional model that are purged by Job_MaintainGIM.

Dimensional Model Fact Tables Purged by Job_MaintainGIM
Type of Data Tables Purged Purge Eligibility
Voice and Multimedia interactions INTERACTION_FACT

INTERACTION_RESOURCE_FACT
IXN_RESOURCE_STATE_FACT
IRF_USER_DATA_KEYS and custom high-cardinality user-data tables (IRF_CUST_* in the make_gim_UDE_template.sql or make_gim_UDE_template_partitioned.sql script)
MEDIATION_SEGMENT_FACT

days-to-keep-gim-facts
Agent activity SM_RES_SESSION_FACT

SM_RES_STATE_FACT
SM_RES_STATE_REASON_FACT

days-to-keep-gim-facts
Outbound Contact activity CAMPAIGN_GROUP_SESSION_FACT

CALLING_LIST_METRIC_FACT
CAMPAIGN_GROUP_STATE_FACT
CONTACT_ATTEMPT_FACT

days-to-keep-gim-facts

The following table lists the dimension tables in the dimensional model that are purged by Job_MaintainGIM.

Dimensional Model Dimension Tables Purged by Job_MaintainGIM
Type of Data Tables Purged Purge Eligibility
Configuration-related GROUP_ANNEX

RESOURCE_ANNEX

days-to-keep-deleted-annex

GIDB fact tables

The following table lists the fact tables in GIDB that are purged by Job_MaintainGIM.

GIDB Tables Purged by Job_MaintainGIM
Type of Data Tables Purged Purge Eligibility
Voice interactions GIDB_G_IR_V

GIDB_G_IR_HISTORY_V
GIDB_G_CALL_V
GIDB_G_VIRTUAL_QUEUE_V
GIDB_G_CALL_HISTORY_V
GIDB_G_CALL_STAT_V
GIDB_G_ROUTE_RES_VQ_HIST_V
GIDB_G_ROUTE_RESULT_V
GIDB_G_SECURE_UD_HISTORY_V
GIDB_G_USERDATA_HISTORY_V
GIDB_G_CUSTOM_DATA_S_V
GIDB_G_IS_LINK_V
GIDB_G_IS_LINK_HISTORY_V
GIDB_G_PARTY_V
GIDB_G_PARTY_HISTORY_V

days-to-keep-gidb-facts
Multimedia interactions GIDB_G_IR_MM

GIDB_G_IR_HISTORY_MM
GIDB_G_CALL_MM
GIDB_G_VIRTUAL_QUEUE_MM
GIDB_G_CALL_HISTORY_MM
GIDB_G_ROUTE_RES_VQ_HIST_MM
GIDB_G_ROUTE_RESULT_MM
GIDB_G_SECURE_UD_HISTORY_MM
GIDB_G_USERDATA_HISTORY_MM
GIDB_G_CUSTOM_DATA_S_MM
GIDB_GM_F_USERDATA
GIDB_GM_L_USERDATA
GIDB_G_PARTY_MM
GIDB_G_PARTY_HISTORY_MM

days-to-keep-active-facts or

days-to-keep-gidb-facts, whichever is greater

Agent activity GIDB_G_AGENT_STATE_HISTORY_V

GIDB_G_AGENT_STATE_RC_V
GIDB_G_DND_HISTORY_V
GIDB_G_LOGIN_SESSION_V
GIDB_GX_SESSION_ENDPOINT_V
GIDB_G_AGENT_STATE_HISTORY_MM
GIDB_G_AGENT_STATE_RC_MM
GIDB_G_DND_HISTORY_MM
GIDB_G_LOGIN_SESSION_MM
GIDB_GX_SESSION_ENDPOINT_MM

days-to-keep-gidb-facts
Outbound Contact activity GIDB_GO_CAMPAIGN

GIDB_GO_CAMPAIGNHISTORY
GIDB_GO_METRICS
GIDB_GO_CHAIN
GIDB_GO_CHAINREC_HIST
GIDB_GO_FIELDHIST
GIDB_GO_SEC_FIELDHIST
GIDB_GOX_CHAIN_CALL

days-to-keep-gidb-facts

Discard and control tables

Job_MaintainGIM purges discarded operational data from the following Staging tables:

  • STG_TRANSFORM_DISCARDS
  • STG_IDB_FK_VIOLATION

Job_MaintainGIM purges data lineage and ETL history data from the following Control tables:

  • CTL_AUDIT_LOG
  • CTL_ETL_HISTORY
  • CTL_EXTRACT_HISTORY
  • CTL_PURGE_HISTORY
  • CTL_TRANSFORM_HISTORY

Starting with release 8.5.010, Job_MaintainGIM purges the personally identifiable information (PII) that related to a General Data Protection Regulation (GDPR) request and that was stored in the GDPR Control table:

  • CTL_GDPR_HISTORY

Except for the GDPR control table, purge eligibility is determined by the days-to-keep-discards-and-job-history configuration option, calculated from the timestamp of the ETL processing event—ETL_TS for the Staging tables and CREATED_TS for the Control tables. For CTL_GDPR_HISTORY, purge eligibility is determined by days-to-keep-gdpr-history, calculated from the time the maintenance job processed the GDPR request.

Configuration fact tables

Starting with release 8.5.003, Genesys Info Mart purges deleted configuration fact data from the following tables:

  • GIDB_GCX_AGENT_PLACE
  • GIDB_GCX_CAMPGROUP_INFO
  • GIDB_GCX_CAMPLIST_INFO
  • GIDB_GCX_ENDPOINT_PLACE
  • GIDB_GCX_FORMAT_FIELD
  • GIDB_GCX_GROUP_AGENT
  • GIDB_GCX_GROUP_ENDPOINT
  • GIDB_GCX_GROUP_PLACE
  • GIDB_GCX_GROUP_ROUTEDN
  • GIDB_GCX_LIST_TREATMENT
  • GIDB_GCX_LOGIN_INFO
  • GIDB_GCX_SKILL_LEVEL
  • GIDB_GCX_SUBCODE
  • CALLING_LIST_TO_CAMP_FACT_
  • GROUP_TO_CAMPAIGN_FACT_
  • PLACE_GROUP_FACT_
  • RESOURCE_GROUP_FACT_
  • RESOURCE_SKILL_FACT_


Purge eligibility is determined by the days-to-keep-cfg-facts configuration option, calculated from the timestamp of the DELETED_TS or END_TS value of the fact record.

This page was last modified on December 12, 2018, at 07:42.

Feedback

Comment on this article:

blog comments powered by Disqus