20R1 Data Model Changes: QualityOne

Pre-Release Date: March 23, 2020 | Release Date: April 10 & April 17, 2020

With every release, we update the data model to better support evolving needs and new feature functionality. With this release, we’ve added the following components to the QualityOne data model. These data model updates are automatically included in all QualityOne Vaults, but Admins must make configuration changes to make them available. For information on feature functionality, see What’s New in 20R1.

These data model updates support features delivered in 20R1:

Added components to support QualityOne Mobile for iOS:

  • Added the following new objects and object types to QualityOne Vaults:
    • NCR Mobile Submission (ncr_mobile_submission__v) object with object types:
      • Process (process__v)
      • Production Order (production_order__v)
      • Purchase Order (purchase_order__v)
    • Defect Category (defect_category__v)
    • Defect Type (defect_type__v)
    • Manufacturing Location (manufacturing_location__v)
    • Unit (unit_of_measure__v)
  • Added the following fields to the Quality Event (quality_event__qdm) object:
    • Date Reported (date_reported__v)
    • Defect Category (defect_category__v)
    • Defect Description (defect_description__v)
    • Defect Type (defect_type__v)
    • Defective Quantity (defective_quantity__v)
    • Defective Quantity UoM (defective_quantity_uom__v)
    • Downtime (downtime__v)
    • Downtime UofM (downtime_uom__v)
    • NCR Mobile ID (ncr_mobile_id__v)
    • Process (process__v)
    • Production Order (production_order__v)
    • Purchase Order (purchase_order__v)
    • Reported By (reported_by__v)
    • Where Discovered (where_discovered__v)
  • Enabled the following fields on the Process Nonconformance (unplanned_deviation__qdm) Quality Event object type:
    • Date Reported (date_reported__v)
    • Defect Category (defect_category__v)
    • Defect Description (defect_description__v)
    • Defect Type (defect_type__v)
    • Downtime (downtime__v)
    • Downtime UofM (downtime_uom__v)
    • NCR Mobile ID (ncr_mobile_id__v)
    • Process (process__v)
    • Production Order (production_order__v)
    • Purchase Order (purchase_order__v)
    • Reported By (reported_by__v)
    • Where Discovered (where_discovered__v)
  • Enabled the following fields on the Product Nonconformance (ncmr__qdm) Quality Event object type:
    • Date Reported (date_reported__v)
    • Defect Category (defect_category__v)
    • Defect Description (defect_description__v)
    • Defect Type (defect_type__v)
    • Defective Quantity (defective_quantity__v)
    • Defective Quantity UoM (defective_quantity_uom__v)
    • Downtime (downtime__v)
    • Downtime UofM (downtime_uom__v)
    • NCR Mobile ID (ncr_mobile_id__v)
    • Production Order (production_order__v)
    • Purchase Order (purchase_order__v)
    • Reported By (reported_by__v)
    • Where Discovered (where_discovered__v)

Added components to support the Create Action Items Directly from Quality Event Checklists feature:

  • Added the fields Action Items Allowed (action_items_allowed__v), Action Items Required (action_items_required__v), and Suggested Actions (suggested_actions__v) to the following QualityOne objects:
    • Question Design (question_design__sys) for the Base (base__v) object type only
    • Available Answer Design (available_answer_design__sys) for the Base (base__v) object type only
    • Library Question (library_question__sys) for the Base (base__v) object type only
    • Answer Library Design (answer_library_design__sys)
    • Response (response__sys) for the Base (base__v) object type only
    • Available Answer (available_answer__sys)
  • Added the following fields to the Action Item (action_item_qdm) object:
    • Checklist (checklist__v)
    • Checklist Response (checklist_response__v)
    • Checklist Section (checklist_section__v)
    • Description (description__v)

Additional Data Model Updates

This release introduces Enhanced Configurability to various components in QualityOne Vaults. Enhanced Configurability adds the ability for applications to determine which field attributes in a standard object’s configuration an Admin should be able to edit. Depending on your Vault application’s data model, you may be able to edit additional settings, such as system-managed naming or if the field is required, or editing may be blocked on some of these attributes.

On QualityOne Vaults:

  • Added the ability for Admins to enable system-managed naming using the attribute System manages field value for the Name (name__v) field on the following objects:
    • Audit-Context (auditcontext__qdm)
    • Audit-Organization (auditorganization__qdm)
    • Context-Organization (context_organization__qdm)
    • Context-Quality Event (context_qualityevent__qdm)
    • Organization (qms_organization__qdm)
    • Product-Quality Event (productquality_event__qdm)
    • Related Quality Event (related_quality_event__qdm)
  • Added the ability for Admins to configure the attribute User must always enter a value (required) for the following fields and objects:
    • the Due Date (due_date__qdm) field on the Action Item (action_item_qdm) and Effectiveness Check (effectiveness_check__qdm) objects
    • the Department Number/Code (number__v) field on the Department (department__v) object
    • the Date Requested (date_requested__qdm) field on the Extension Request (extension_request__qdm) object
    • the Facility Address (address__v) and Facility Number/Code (number__v) fields on the Facility (facility__v) object
    • the Quality Event (quality_event__qdm) and Priority (priority__qdm) fields on the Investigation (investigation__qdm) object
    • the Category (category__v), Description (brief_description__v), Long Description (long_description__v), Risk Event (risk_event_name__v), Risk Matrix (risk_matrix__v), and Risk Owner (risk_owner__v) fields for the Risk Event (risk_event__v) object
    • the Description (brief_description__v), Title (title__v), and Type (type__v) fields on the Risk Register (risk_register__v) object
    • the Quality Event (quality_event__qdm) field on the Root Cause (root_cause_analysis__qdm) object
    • Added the ability for Admins to configure the attribute Maximum length for the number__v field on the Department (department__v) and Facility (facility__v) objects.
  • Added the ability for Admins to configure the attribute Allow user to select multiple values for the Category (category__v) field on the Risk Event (risk_event__v) object.
  • Added the ability for Admins to configure the attribute Status for the fields Rank (rank__v) and Trigger (trigger__v) on the Risk Event (risk_event__v) object.