23R2 Data Model Changes: Platform

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 Platform data model. These data model updates are automatically included in all Platform Vaults, but Admins must make configuration changes to make them available. For information on feature functionality, see What’s New in 23R2.

The following changes were made to support the Checklists: Sum Score feature:

  • Enabled the Sum Score (sum_score__sys) field for the following objects:
    • [target object] Checklist ([target_object]_checklist__sys)
    • [target object] Section ([target_object]_section__sys)
    • [target object] Subchecklist ([target_object]_subchecklist__sys)

The following changes were made to support the Visual Checklist Designer feature:

  • For Question Design (question_design__sys), Library Question (library_question__sys), Response (response__sys), and [target object] Response ([target object]_response__sys} objects:
    • Set the following fields to Inactive
      • Attachment Allowed (Document) (doc_attachment_allowed__sys)
      • Attachment Required (Document) (doc_attachment_required__sys)
    • Enabled the following fields across all object types (if the field exists, primarily in Quality and QualityOne Vaults):
      • Documents Allowed (documents_allowed__sys)
      • Documents Required (documents_required__sys)
  • For records of Question Design (question_design__sys) and Library Question (library_question__sys) objects:
    • If Documents Allowed (documents_allowed__sys) field value is null, copied the values from Attachment Allowed (Document) (doc_attachment_allowed__sys) field to Documents Allowed (documents_allowed__sys) field
    • If Documents Required (documents_required__sys) field value is null, copied the equivalent values from Attachment Required (Document) (doc_attachment_required__sys) field to Documents Required (documents_required__sys) field
    • Note: In Quality and QualityOne Vaults, records of quiz_multiple_choice_question_v object types are excluded from the data copying, as attaching documents in checklists is not officially supported by Quizzes.

The following changes were also made to ensure that, where applicable, checklist respondents are still allowed or required to attach a document for active checklists that are not completed yet:

  • For [target object] Response ([target object]_response__sys) objects, if the record is a child record of a checklist that is not in the Completed (completed_state__sys) or Inactive (inactive_state__sys) state:
    • If Documents Allowed (documents_allowed__sys) field value is null, copied the values from Attachment Allowed (Document) (doc_attachment_allowed__sys) field to Documents Allowed (documents_allowed__sys) field.
    • If Documents Required (documents_required__sys) field value is null, copied the equivalent values from Attachment Required (Document) (doc_attachment_required__sys) field to Documents Required (documents_required__sys) field.
  • In Quality and QualityOne Vaults, TA Response (ta_response__sys) records for Quizzes are excluded from the data copying, as attaching documents in checklists is not officially supported by Quizzes.