Documentation:GIM:Library:AboutThisPDM:8.5DRAFT

About This Document

Intended Audience

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

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: JD to do: Add links (and probably toggle)

• Genesys Info Mart 8.5 Deployment Guide -- this one has the version specified
• Genesys Info Mart Operations Guide
• Genesys Info Mart User’s Guide
• Genesys Info Mart Database Size Estimator
• Genesys Info Mart Business Continuity Deployment Guide
• Genesys Info Mart Database Compatibility Reference
• Interaction Concentrator 8.x Deployment Guide -- this one has no version
• Interaction Concentrator 8.x Deployment Guide -- this one specifies "latest"
• Interaction Concentrator Physical Data Model for your particular RDBMS
• Framework Configuration Manager Help
• Genesys Technical Publications Glossary, which is available on the Genesys Documentation website and provides a list of Genesys and computer-telephony integration (CTI) terms and acronyms
• Release Notes and Product Advisories for this product, which are available on the Genesys Documentation website

Genesys product documentation is available on the:

• Genesys Customer Care website.
• Genesys Documentation website.
• Genesys Documentation Library DVD, which you can order by e-mail from Genesys Order Management at orderman@genesys.com.