New article
Recently updated
Asset Module Data Dictionary (Field Map)
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 the Asset module only. If you need to review the data dictionary for other modules please see Ideagen Quality Management Data Dictionary (Field Map).
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. Asset Fields
The table below contains the following columns:
- Asset Field Name: The name of the field as shown in the CA/PA record
- SQL Table Name: The name of the SQL table where this field can be found
- Column Name: The corresponding SQL column in the table that holds the data
- Table Referenced: Where appropriate, the table that is referenced by any ID's
- Column Referenced: Where appropriate, the column that is referenced by any ID's
| Asset Field Name |
SQL Table Name |
Column Name |
Table Referenced | Column Referenced |
|---|---|---|---|---|
| Asset Number | EquipmentItem | Number | N/A | N/A |
| Description | EquipmentItem | Description | N/A | N/A |
| Serial Number | EquipmentItem | SerialNumber | N/A | N/A |
| Owner | EquipmentItem | OwnerPersonID | Person | ID |
| Asset Type | EquipmentItem | EquipmentItemTypeID | yEquipmentItemType | ID |
| Location | EquipmentItem | EquipmentItemLocationID | yEquipmentItemLocation | ID |
| Manufacturer | EquipmentItem | ManufacturerID | zManufacturer | ID |
| Department | EquipmentItem | DepartmentID | yDepartment | ID |
| Available | EquipmentItem | IsAvailable | N/A | N/A |
| Unavailable Reason | EquipmentItem | UnavailableReasonID | zUnavailableReason | ID |
| Activity Type | zActivityType | Name | ||
| Activity Owner | ActivityItem | OwnerPersonID | Person | ID |
| Due Date | ActivityItem | DueDate | N/A | N/A |
| Performed Date | ActivityItem | PerformedDate | N/A | N/A |
| Performed By | ActivityItem | PerformedBy PersonID |
Person | ID |
| Outcome | ActivityItem | OutcomeID | yActivityOutcome | ID |
| Certificate Number | ActivityItem | CertificateNumber | N/A | N/A |
| Performed By (Internal) | ActivityItem | PerformedByPersonID | Person | ID |
| Performed By (Supplier) | ActivityItem | PerformedBySupplierID | ySupplier | ID |
| Comment | ActivityItem | Comment | N/A | N/A |
| Standard Item | ActivityItem | StandardItemID | yStandardItem | ID |
| Standard Certificate | ActivityItem | StandardCertificateNumber | N/A | N/A |
| Activity Notes | ActivityItemNote | NoteText | N/A | N/A |
| Purchased Cost | EquipmentItem | Cost | N/A | N/A |
| Purchased Date | EquipmentItem | PurchasedDate | N/A | N/A |
| User Defined Field 1 | EquipmentItem | UserDefinedField1 | N/A | N/A |
| User Defined Field 2 | EquipmentItem | UserDefinedField2 | N/A | N/A |
| User Defined Field 3 | EquipmentItem | UserDefinedField3 | N/A | N/A |
| User Defined Field 4 | EquipmentItem | UserDefinedField4 | N/A | N/A |
| User Defined Field 5 | EquipmentItem | UserDefinedField5 | N/A | N/A |
| User Defined Field 6 | EquipmentItem | UserDefinedField6 | N/A | N/A |
| User Defined Field 7 | EquipmentItem | UserDefinedField7 | N/A | N/A |
| User Defined Field 8 | EquipmentItem | UserDefinedField8 | N/A | N/A |
| User Defined Field 9 | EquipmentItem | UserDefinedField9 | N/A | N/A |
| Notes | EquipmentItemNote | NoteText | N/A | N/A |
| Attachment | EquipmentItemAttachmentItem | ID | N/A | N/A |