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.
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.
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.
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.
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.
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.
Type of Data | Tables Purged | Purge Eligibility |
---|---|---|
Voice and Multimedia interactions |
|
days-to-keep-gim-facts |
Agent activity |
|
days-to-keep-gim-facts |
Outbound Contact activity |
|
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.
Type of Data | Tables Purged | Purge Eligibility |
---|---|---|
Configuration-related |
|
days-to-keep-deleted-annex |
GIDB fact tables
The following table lists the fact tables in GIDB that are purged by Job_MaintainGIM.
Type of Data | Tables Purged | Purge Eligibility |
---|---|---|
Voice interactions |
|
days-to-keep-gidb-facts |
Multimedia interactions |
|
Starting with release 8.5.015.19, days-to-keep-gidb-facts
|
Agent activity |
|
days-to-keep-gidb-facts |
Outbound Contact activity |
|
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.