WikiSysop: Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_GDPR_HISTORY |Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}} }} {{PDMTab..."

2022-06-29T04:30:42Z

Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_GDPR_HISTORY |Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}} }} {{PDMTab..."

New page

{{ArticleSimplifiedWikiEdit
|DisplayName=Table CTL_GDPR_HISTORY
|Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}}
}}
{{PDMTable
|tableName = CTL_GDPR_HISTORY
|shortDesc =
|tableDesc = This table provides details about General Data Protection Regulation (GDPR) "export" or "forget" requests that were processed successfully. A row is added to this table for each field that might have contained an instance of personally identifiable information (PII) specified in the customer-provided JSON file.

The following tables and columns potentially contain PII:

{{{!}}
! '''Table'''
! '''Column'''
{{!}}-
{{!}} colspan="2" style="text-align:center;" {{!}} '''For Consumer GDPR Requests'''
{{!}}-
{{!}} INTERACTION_FACT
{{!}} SOURCE_ADDRESS 
TARGET_ADDRESS
{{!}}-
{{!}} INTERACTION_RESOURCE_FACT
{{!}} TARGET_ADDRESS
{{!}}-
{{!}} IXN_RESOURCE_STATE_FACT
{{!}} TARGET_ADDRESS
{{!}}-
{{!}} CONTACT_ATTEMPT_FACT
{{!}} CONTACT_INFO 
RECORD_FIELD_*
{{!}}-
{{!}}CALLBACK_FACT
{{!}} CUSTOMER_ANI 
CUSTOMER_PHONE_NUMBER
{{!}}-
{{!}} CDR_FACT
{{!}} ANI 
DNIS
{{!}}-
{{!}} LDR_FACT
{{!}} CLIENT_ID 
CONTACT_INFO
{{!}}-
{{!}} SDR_CUST_ATRIBUTES_FACT
{{!}} ATRIBUTE_VALUE
{{!}}-
{{!}} SDR_SESSION_FACT
{{!}} ANI
{{!}}-
{{!}} SDR_SURVEY_TRANSCRIPT_FACT
{{!}} TRANSCRIPTION
{{!}}-
{{!}} Custom user data fact tables (e.g., IRF_USER_DATA_CUST_1)
{{!}} CUSTOM_DATA_*
{{!}}-
{{!}} colspan="2" style="text-align:center;" {{!}} '''For Employee GDPR Requests'''

{{!}}-
{{!}} GIDB_GC_AGENT
{{!}} USERNAME 
EMPLOYEEID 
FIRSTNAME 
LASTNAME 
EMAIL
{{!}}-
{{!}} RESOURCE_
{{!}} RESOURCE_NAME 
EMPLOYEE_ID 
AGENT_FIRST_NAME 
AGENT_LAST_NAME
{{!}}-
{{!}} ROUTING_TARGET 
(starting with release 8.5.015.19)
{{!}} TARGET_OBJECT_SELECTED
{{!}}}

For audit purposes, a value of "NULL" in a record indicates that the field was evaluated for a particular instance of PII and was found to be empty.

By default, data is retained in the CTL_GDPR_HISTORY table for 15 days. You can configure the [[Documentation:Options:GIM:GIM-gim-etl:Draft#days-to-keep-gdpr-history|days-to-keep-gdpr-history]] option to specify a different retention period, up to 30 days.

For more information about Genesys Info Mart support for GDPR compliance, see [[Documentation:System:SDG:GDPR:8.5.x|General Data Protection Regulation (GDPR)]] and [[Documentation:System:SDG:GDPR-GIM:8.5.x|Genesys Info Mart Support for GDPR]] in the ''Genesys Security Deployment Guide.''
|subjectAreas =
|introduced = 8.5.010
|modified = 8.5.015.19 (scope extended to include ROUTING_TARGET.TARGET_OBJECT_SELECTED); 8.5.010.16 (scope extended to cover employee GDPR requests)
|discontinued =
|group =
|partitioned =
}}

{{PDMColumn
|colName = CONSUMER_ID
|dataType_Ora = VARCHAR2(255 CHAR)
|dataType_MSSQL = varchar(255)/nvarchar(255)
|dataType_Postgre = varchar(255)
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = The instance of PII that was searched for. The value is derived from one of the following consumer- or employee-identifying attributes in the customer-provided JSON input file:
* For consumers:
** "phone"
** "email"
* For employees:
** "username"
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = FACT_ID
|dataType_Ora = VARCHAR2(255 CHAR)
|dataType_MSSQL = varchar(255)/nvarchar(255)
|dataType_Postgre = varchar(255)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The ID of the table record in which the PII was found. A value of NULL indicates that a particular table was evaluated for that PII and no instance was found.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = TABLE_NAME
|dataType_Ora = VARCHAR2(64 CHAR)
|dataType_MSSQL = nvarchar(64)
|dataType_Postgre = varchar(64)
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = The name of the table that was evaluated for PII. (See the table description above for possible values.)
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = COLUMN_NAME
|dataType_Ora = VARCHAR2(64 CHAR)
|dataType_MSSQL = nvarchar(64)
|dataType_Postgre = varchar(64)
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = The name of the column that was evaluated for PII. (See the table description above for possible values.)
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = KEY_NAME
|dataType_Ora = VARCHAR2(255 CHAR)
|dataType_MSSQL = nvarchar(255)
|dataType_Postgre = varchar(255)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The name of the custom user data KVP key or custom Outbound Contact Server (OCS) record field that the customer has identified might contain PII and, therefore, has specified in the "gim-attached-data" element in the JSON input file. For example, while consumers are identified in Genesys Info Mart only by phone number or email address, custom KVPs or record fields might contain PII such as a name, Social Security number, or mailing address. The custom key would already have been mapped to a custom user data table and column or a RECORD_FIELD_* column in the CONTACT_ATTEMPT_FACT table, when you configured your Genesys Info Mart deployment.

In Genesys Engage cloud deployments, this column might also specify a non-custom KEY_NAME, such as “TRANSCRIPTION.”
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = KEY_VALUE
|dataType_Ora = VARCHAR2(4000 CHAR)
|dataType_MSSQL = nvarchar(4000)
|dataType_Postgre = varchar(4000)
|primaryKey =
|mandatory =
|foreignKey =
|default =
|colDesc = The value of the custom user data KVP or custom OCS record field that contained the PII.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = AUDIT_KEY
|dataType_Ora = NUMBER(19)
|dataType_MSSQL = numeric(19)
|dataType_Postgre = numeric(19)
|primaryKey =
|mandatory =
|foreignKey = yes
|default =
|colDesc = The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key is used for data lineage purposes.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = TENANT_KEY
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory = yes
|foreignKey = yes
|default = 0
|colDesc = The surrogate key that is used to join the TENANT dimension to other tables in the Info Mart database.
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = FORGET
|dataType_Ora = NUMBER(1)
|dataType_MSSQL = numeric(1)
|dataType_Postgre = numeric(1)
|primaryKey =
|mandatory = yes
|foreignKey =
|default = 0
|colDesc = Indicates whether the PII was processed for a "forget" request: 0 = No, 1 = Yes
|introduced =
|modified =
|discontinued =
}}

{{PDMColumn
|colName = CREATED_TS
|dataType_Ora = NUMBER(10)
|dataType_MSSQL = int
|dataType_Postgre = integer
|primaryKey =
|mandatory = yes
|foreignKey =
|default =
|colDesc = The UTC-equivalent value of the date and time of row creation.
|introduced =
|modified =
|discontinued =
}}

{{PDMIndex}}
{{PDMIndexItem
|indexName = I_CTL_GDPR_H_C_ID
|indexDesc = Improves search performance.
|indexPresentInPartitioned = yes
|indexKey = CONSUMER_ID
|keyPresentInNonpartitioned = yes
|sort = Ascending
|unique =
|cluster =
}}

{{PDMIndexItem
|indexName = I_CTL_GDPR_H_CTS
|indexDesc = Improves purge performance.
|indexPresentInPartitioned = yes
|indexKey = CREATED_TS
|keyPresentInNonpartitioned = yes
|sort = Ascending
|unique =
|cluster =
}}

{{PDMRef
|foreignKey = TENANT_KEY
|parentView = TENANT
|parentColumn = TENANT_KEY
}}

{{PDMRef
|foreignKey = AUDIT_KEY
|parentTable = CTL_AUDIT_LOG
|parentColumn = AUDIT_KEY
}}

Documentation:PEC-REP/Library/PDMLibraryGIM/Table-CTL GDPR HISTORY - Revision history

WikiSysop: Created page with "{{ArticleSimplifiedWikiEdit |DisplayName=Table CTL_GDPR_HISTORY |Context={{#cargo_query:tables=PDMTable|fields=shortDesc|where=_pageName LIKE "{{FULLPAGENAME}}"}} }} {{PDMTab..."