Jump to: navigation, search

About This Document

Intended Audience

This Microsoft SQL Server 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

Other Notes

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.

Related Resources

Genesys Info Mart uses source data from several Genesys products. Because of this, Genesys strongly recommends that you read the following documentation in order to better understand the data that is presented in the Genesys Info Mart:

This page was last edited on June 22, 2022, at 20:59.
Comments or questions about this documentation? Contact us for support!