20R2 Data Model Changes: QualityOne

Pre-Release Date: July 13, 2020 | Release Date: July 31 & August 7, 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 20R2.

These data model updates support features delivered in 20R2:

Added components to support Supplier Portal Phase I:

• Added the following new objects and object types to QualityOne Vaults:
  • NCR (ncr__v) object with object types:
    • Process NCR (process_ncr__v)
    • Product NCR (product_ncr__v)
    • Supplier NCR (supplier_ncr__v)

In addition: note that for the NCR (ncr__v) object, record-level locking is not available for Related Object List View sections in Vaults with Supplier Portal enabled.

Added components to support the Automated Inspection of Certificate of Analysis feature:

• Added the following new objects and object types to QualityOne Vaults:
  • Inspection (inspection__v):
    • COA Inspection (coa_inspection__v):
  • Inspection Plan Requirement (inspection_plan_requirement__v):
    • Attribute Specification (attribute_specification__v)
    • Variable Specification (variable_specification__v)
  • Acceptable Attribute (acceptable_attribute__v)
  • Inspection Sample (inspection_sample__v)
  • Inspection Sample Test Results (inspection_sample_test_result__v)
    • Test Result Attribute Data (test_result_attribute_data__v)
    • Test Result Variable Data (test_result_variable_data__v)
  • COA Header OCR Data (coa_header_ocr_data__v)
  • COA Test Results OCR Data (coa_test_results_ocr_data__v)
  • Item Group (Brand) (item_group__v)
  • Item Version (item_version__v)
    • Manufactured Item (manufactured_item__v)
    • Purchased Item (purchased_item__v)
  • Item Specification (item_specification__v)
    • Attribute Specification (attribute_specification__v)
    • Variable Specification (variable_specification__v)
  • COA Matching Rule (coa_matching_rule__v)
  • COA Matching Rule Variant (coa_matching_rule_variant__v)
  • Item Specification Acceptable Attribute (item_specification_acceptable_attribute__v)
  • Characteristic (characteristic__v)
  • Purchased-Item Organization (purchased_item_organization__v)
  • Purchase Order Line Item (purchase_order_line_item__v)
  • Component Matching Variant (component_matching_variant__v)
    • Unit Matching Variant (unit_matching_variant__v)
    • Characteristic Matching Variant (characteristic_matching_variant__v)
• Added the following fields to the Product (product__v) object:
  • Item Group (Brand) (item_group__v)
• Added the following fields to the Purchase Order (purchase_order__v) object:
  • Expected Delivery Date (expected_delivery_date__v)
  • Actual Delivery Date (actual_delivery_date__v)
  • Date Shipped (date_shipped__v)

Added components to support the QualityOne Station Manager Updates feature:

• Added the following new fields to the Station Device (station_device__v) object:
  • Operating System (operating_system__v)
  • Application Version (application_version__v)
  • Sync Details (sync_details__v)
• Added the following field to the Station (station__v) object:
  • Station Configuration (station_configuration__v)

Administrator visibility of the following components has been updated:

• The Pending Change Control Approval State, In Change Control Approval State, and Change Control Approved State Document Lifecycle State Types are now visible in the Admin section of all QualityOne Vaults. These State Types are meant only for use with the Multi-Document Change Control feature in Document Control.
• The Recall Controlled Copies and CC: Set Change Control to Ready for Approval Entry Actions are now visible in the Admin section of all QualityOne Vaults. These Entry Actions will run only on Document Control Vaults.
• The Download Controlled Copy User Action is now visible in the Admin section of all QualityOne Vaults. This User Action can be used only on Document Control Vaults.