Who is this article for?

IT personnel working with the Ideagen Quality Management database.

SQL database access is required.

If you are working with the Ideagen Quality Management database then you may need to identify where data in the Ideagen Quality Management system is located in the SQL database. This information will be particularly useful if you are:

• Developing a solution using the Ideagen Quality Management API Web Services
• Querying the database in order to perform an export from the database
• Connecting a business intelligence system to the Ideagen Quality Management database
• Importing data into the Ideagen Quality Management database

This article links to the data dictionary for each module, providing a breakdown of the Ideagen Quality Management field, the SQL database table, the column name and any additionally referenced fields.

Important Note: This information is intended for use by qualified database administrators only.  Any edits made directly within the Ideagen Quality Management SQL database (e.g. importing data) are not supported by Ideagen. It is strongly recommended that a full backup of your database is taken before making any changes and that all changes are thoroughly tested before being rolled out to your production system.

1. Data Dictionary List

The below modules are available in the data dictionary:

• CA/PA
• Documents
• Audit
• Customer
• Supplier
• People
• Training
• Asset
• Occurrences
• Incident

2. Further Reading

1. Ideagen Quality Management 7 Technical Overview
2. How to Backup the Ideagen Quality Management Database
3. How to Restore the Ideagen Quality Management Database from a Backup