About This Database Reference
Important information for Cloud customers
The Genesys Info Mart Historical Database Reference is provided for the benefit of Cloud customers for whom Data Export capability is enabled. The pages in this document are reproduced from the enterprise-level documentation for Genesys Info Mart. Some of the documented customizations, features, and functionality—including, in some cases, whole tables—might not be available in your Cloud deployment or in your Data Export.
Where release numbers are cited (for example, to indicate when certain tables or columns were introduced or modified), they refer to the Genesys Info Mart Server version. You will need to use the information in this document selectively as applicable to the Genesys Info Mart Server version in your deployment.
How do I find the Genesys Info Mart Server and schema versions for my Cloud deployment?
The output folder you receive for each data export includes a metadata file, export_XXX.extracted.xml, which contains information about the .csv files included in the export_XXX.zip archive for that data export. Open the metadata file in a text editor to view information about the Genesys Info Mart Server and schema versions in effect for populating your data. For an example, see Export metadata file.
This Physical Data Model reference is intended for operational managers and business analysts who want to query the information that is collected by Genesys Info Mart in order to make informed business decisions. It is intended also for IT reporting specialists, business intelligence team members, and data warehousing team members who want to understand how they can use the information that is collected by Genesys Info Mart to create reports that support informed business decisions. In addition, system integrators and system administrators may find helpful the data in the control tables and views for data validation and troubleshooting purposes.
This document assumes that you have a basic understanding of:
- Relational database management systems (RDBMSs).
- Structured Query Language (SQL).
- Data warehousing.
Abbreviations for Database Terms
The following abbreviations characterize fields throughout this document, to provide more detailed information about all tables, including a concise listing of primary and foreign keys for each table, default field values, mandatory fields, and from which source the Genesys Info Mart Server gathers Info Mart data:
- P, for primary key
- M, for mandatory field
- F, for 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, for default value
Abbreviations for index characterizations include the following:
- U, for unique
- C, for cluster
In the Column List on all Table-* pages, varchar/nvarchar in the Data Type column means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar.