Custom Reporting Exported Records

Enghouse Interactive Quality Management Suite’s (QMS) internal data is exported to five different tables in a Custom Reporting database. A single table in the Custom Reporting database typically represents a composite of data from more than one QMS table. The Custom Reporting records are generally an expansion of a like type record in QMS where related data from tables not directly represented in the Custom reporting database are projected onto a record in the Custom Reporting database, this simplifies the table structure in Custom Reporting while still maximizing the data available for analysis. There are certain scenarios where a many-to-one relationship in QMS has been simplified to a one-to-one relationship in Custom Reporting. These scenarios are outlined in the detail for each table. The five Custom Reporting tables are:

Each of the Custom Reporting tables has a primary key, and tables other than User_Details have a foreign key relationship to either an entry in User_Details, Recording_Details or both, however foreign key constraints aren’t enforced in the Custom Reporting database.