Genesys Info Mart Physical Data Model for a PostgreSQL Database

Welcome to the Physical Data Model for a PostgreSQL Database for the Current release. This document, formerly called a Reference Manual, acquaints you with the subject areas and tables that make up the Genesys Info Mart star schemas.

This document will help you make informed business decisions, based on the information that is collected by Genesys Info Mart. It will also help you understand how you can use the data that is collected by Genesys Info Mart to create reports. In brief, you will find the following information in this document:

• Overview and general information about the Info Mart database — Genesys Info Mart Database Schema and Genesys Info Mart Tenant User Schema and Tenant Views
• New in This Release information, including a Summary of Info Mart Schema Changes
• Descriptions of each dimensional model table and its columns and indexes — see Info Mart Tables
• Descriptions of each dimension view and its columns — see Info Mart Views
• Descriptions of important service tables and administrative views — see Info Mart Service and Staging Tables and Administrative Views
• Summary lists of:
  • Indexes
  • References
  • Partitioned tables

This document is valid only for 8.5 releases of Genesys Info Mart that are part of 9.0.