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

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
Modified: 8.5.015.19, 8.1.2 (behavior changed with respect to multimedia interactions)
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.

Starting with release 8.5.015.19, the retention period for multimedia facts in GIDB is determined solely by the value of days-to-keep-gidb-facts. For releases 8.5.015.19 through 8.5.016.01, be aware that, if days-to-keep-gidb-facts is less than days-to-keep-active-facts, user data for active multimedia interactions older than days-to-keep-gidb-facts might not be transformed correctly (see the Known Issue for GIM-13320 in the Genesys Info Mart 8.5.x Release Note).

For multimedia interactions in releases earlier than 8.5.015.19, this option, together with days-to-keep-active-facts, specifies the retention period for facts in GIDB: The retention period is the greater of the days-to-keep-gidb-facts and days-to-keep-active-facts option values.

In 8.1.1 releases, days-to-keep-gidb-facts specifies the retention period for completed multimedia 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.

Important
Genesys expects the value of days-to-keep-gidb-facts to be less than 30. Be aware that, although many GIDB tables contain personally identifiable information (PII), Genesys Info Mart does not include most GIDB tables in General Data Protection Regulation (GDPR) processing.

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
Modified: 8.5.015.19, 8.1.2 (behavior changed with respect to multimedia interactions)
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.

Starting with release 8.5.015.19, the retention period for multimedia facts in GIDB is determined solely by the value of days-to-keep-gidb-facts. For releases 8.5.015.19 through 8.5.016.01, be aware that, if days-to-keep-gidb-facts is less than days-to-keep-active-facts, user data for active multimedia interactions older than days-to-keep-gidb-facts might not be transformed correctly (see the Known Issue for GIM-13320 in the Genesys Info Mart 8.5.x Release Note).

For multimedia interactions in releases earlier than 8.5.015.19, this option, together with days-to-keep-active-facts, specifies the retention period for facts in GIDB: The retention period is the greater of the days-to-keep-gidb-facts and days-to-keep-active-facts option values.

In 8.1.1 releases, days-to-keep-gidb-facts specifies the retention period for completed multimedia 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.

Important
Genesys expects the value of days-to-keep-gidb-facts to be less than 30. Be aware that, although many GIDB tables contain personally identifiable information (PII), Genesys Info Mart does not include most GIDB tables in General Data Protection Regulation (GDPR) processing.

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
Modified: 8.5.015.19, 8.1.2 (behavior changed with respect to multimedia interactions)
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.

Starting with release 8.5.015.19, the retention period for multimedia facts in GIDB is determined solely by the value of days-to-keep-gidb-facts. For releases 8.5.015.19 through 8.5.016.01, be aware that, if days-to-keep-gidb-facts is less than days-to-keep-active-facts, user data for active multimedia interactions older than days-to-keep-gidb-facts might not be transformed correctly (see the Known Issue for GIM-13320 in the Genesys Info Mart 8.5.x Release Note).

For multimedia interactions in releases earlier than 8.5.015.19, this option, together with days-to-keep-active-facts, specifies the retention period for facts in GIDB: The retention period is the greater of the days-to-keep-gidb-facts and days-to-keep-active-facts option values.

In 8.1.1 releases, days-to-keep-gidb-facts specifies the retention period for completed multimedia 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.

Important
Genesys expects the value of days-to-keep-gidb-facts to be less than 30. Be aware that, although many GIDB tables contain personally identifiable information (PII), Genesys Info Mart does not include most GIDB tables in General Data Protection Regulation (GDPR) processing.

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.5.015.19 (plays no role in determining purge thresholds); 8.1.2 (dependencies introduced); 8.1.1 (behavior and default value changed)

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.

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
Modified: 8.5.015.19, 8.1.2 (behavior changed with respect to multimedia interactions)
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.

Starting with release 8.5.015.19, the retention period for multimedia facts in GIDB is determined solely by the value of days-to-keep-gidb-facts. For releases 8.5.015.19 through 8.5.016.01, be aware that, if days-to-keep-gidb-facts is less than days-to-keep-active-facts, user data for active multimedia interactions older than days-to-keep-gidb-facts might not be transformed correctly (see the Known Issue for GIM-13320 in the Genesys Info Mart 8.5.x Release Note).

For multimedia interactions in releases earlier than 8.5.015.19, this option, together with days-to-keep-active-facts, specifies the retention period for facts in GIDB: The retention period is the greater of the days-to-keep-gidb-facts and days-to-keep-active-facts option values.

In 8.1.1 releases, days-to-keep-gidb-facts specifies the retention period for completed multimedia 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.

Important
Genesys expects the value of days-to-keep-gidb-facts to be less than 30. Be aware that, although many GIDB tables contain personally identifiable information (PII), Genesys Info Mart does not include most GIDB tables in General Data Protection Regulation (GDPR) processing.

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
Modified: 8.5.015.19, 8.1.2 (behavior changed with respect to multimedia interactions)
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.

Starting with release 8.5.015.19, the retention period for multimedia facts in GIDB is determined solely by the value of days-to-keep-gidb-facts. For releases 8.5.015.19 through 8.5.016.01, be aware that, if days-to-keep-gidb-facts is less than days-to-keep-active-facts, user data for active multimedia interactions older than days-to-keep-gidb-facts might not be transformed correctly (see the Known Issue for GIM-13320 in the Genesys Info Mart 8.5.x Release Note).

For multimedia interactions in releases earlier than 8.5.015.19, this option, together with days-to-keep-active-facts, specifies the retention period for facts in GIDB: The retention period is the greater of the days-to-keep-gidb-facts and days-to-keep-active-facts option values.

In 8.1.1 releases, days-to-keep-gidb-facts specifies the retention period for completed multimedia 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.

Important
Genesys expects the value of days-to-keep-gidb-facts to be less than 30. Be aware that, although many GIDB tables contain personally identifiable information (PII), Genesys Info Mart does not include most GIDB tables in General Data Protection Regulation (GDPR) processing.

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.

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.

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.

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.

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.

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_MEDIA_NEUTRAL_STATE_FACT
  • 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
Other reporting data

No results

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
Starting with release 8.5.015.19, days-to-keep-gidb-facts


In releases earlier than 8.5.015.19, 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 edited on November 12, 2020, at 19:18.
Comments or questions about this documentation? Contact us for support!