Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
  • DV = Default value
  • In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar.

Table STG_IDB_FK_VIOLATION

Description

Modified: 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics)

In partitioned databases, this table is not partitioned.


This table stores information about errors that Genesys Info Mart encounters during transformation of configuration data. Errors are detected through verification of relationships between primary and foreign keys in tables that store related data.

For example, a record in a table that stores configuration object relationship data (such as GIDB_GCX_CAMPLIST_INFO) would refer to a record in a table that stores configuration object data (such as GIDB_GC_CAMPAIGN). The transformation logic interprets the absence of the record that has the primary key as an error (in the GIDB_GC_CAMPAIGN table, in the example); the error indicates the absence of the related data (such as the Campaign configuration object). As a result, the transformation job encounters a foreign key constraint violation and stores a record in the STG_IDB_FK_VIOLATION table that identifies the two involved tables and the key that caused the violation.

Tip
To assist you in preparing supplementary documentation, click the following link to download a comma-separated text file containing information such as the data types and descriptions for all columns in this table: Download a CSV file.

Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.

Column List

Legend

Column Data Type P M F DV
ID numeric(19) X X
CREATE_AUDIT_KEY numeric(19) X X
FK_TABLE_NAME varchar(30) X
PK_TABLE_NAME varchar(30) X
PK_ID numeric(19) X
FK_ID numeric(19) X
ETL_TS int X
ETL_DATE_TIME_KEY int X

ID

The primary key for this table.

CREATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG dimension.

FK_TABLE_NAME

The name of the table whose record includes a foreign key that violates the foreign key constraint. (Continuing with the example that is used in the table description, the value of this field would be GIDB_GCX_CAMPLIST_INFO.)

PK_TABLE_NAME

The name of the table in which a record appears to be missing, based on the foreign key constraint violation in another table. (In the preceding example, the value of this field would be GIDB_GC_CAMPAIGN.)

PK_ID

The primary key of the record that exists in the table that is specified by FK_TABLE_NAME and that violates the foreign key constraint. Use this value to identify the problematic record. (In the preceding example, the value would come from the GIDB_GCX_CAMPLIST_INFO.ID field, which is the primary key of the GIDB_GCX_CAMPLIST_INFO table.)

FK_ID

The foreign key of the record that exists in the table that is specified by FK_TABLE_NAME and that violates the foreign key constraint. Use this value to identify the missing record in the table that is specified by PK_TABLE_NAME. (In the preceding example, the value would come from the GIDB_GCX_CAMPLIST_INFO.CAMPAIGNID field, which is the foreign key of the GIDB_GCX_CAMPLIST_INFO table and which points to the primary key in the GIDB_GC_CAMPAIGN table. Thus, a Campaign object data is detected to be missing.)

ETL_TS

The UTC-equivalent date and time at which the ETL job created a record in this table.

ETL_DATE_TIME_KEY

Identifies the 15-minute interval in which the ETL job created a record in this table.

Index List

No indexes are defined.

Subject Areas

No subject area information available.

This page was last edited on October 2, 2020, at 12:24.
Comments or questions about this documentation? Contact us for support!