19R3 Data Model Changes: Quality

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

With every release, we update the data model to better support evolving needs and new feature functionality. These data model updates are automatically available in all Quality vaults.

We have made the following changes to the data model to support both the Vault Training Multi-Document Training Requirements and Instructor-Led Training features:

Added the following objects:

  • Training Requirement Impact Assessment (training_requirement_impact_assessment__v) with new fields:
    • Current Quiz Design (current_quiz_design__v)
    • Impact Assessment Reason (impact_assessment_reason__v)
    • New Quiz Design (new_quiz_design__v)
    • Re-Issue Training Upon TR Update? (reissue_training_on_update__v)
    • Training Content Set Reviewed (training_content_set_reviewed__v)
    • Training Content Set To Review (training_content_set_to_review__v)
    • Training Requirement (training_requirement__v)
  • Training Content Set (training_content_set__v) with new fields:
    • In Use by Related Training Requirement (in_use_by_rel_training_requirement__v)
    • Related Training Requirement (related_training_requirement__v)
  • Training Requirement (training_requirement__v) has been updated with new fields:
    • Force Learner to View Docs Sequentially (force_sequential_viewing__v)
    • In Use Training Content Set (in_use_training_content_set__v)
  • Training Requirement (training_requirement__v) has been updated with new fields:
    • Force Learner to View Docs Sequentially (force_sequential_viewing__v)
    • In Use Training Content Set (in_use_training_content_set__v)
  • TrainingContentSet-Document (training_content_set_doc__v) with new fields:
    • Document (document__v)
    • Document (unbound) (document_unbound__v)
    • Training Content Set (training_content_set__v)

Users who previously had permissions to view or edit Training Requirements and Training Assignments automatically have their permission sets updated so as to not interrupt the training flow for Learners or interrupt the usage of reports and dashboards regarding pre-19R3 training information upon release. 

Several other changes are being introduced as part of this release, and will require updates to your vault’s configuration to ensure trainers are able to edit and manage Training Requirements seamlessly with the release of 19R2.3. For example, the Training Document field of the Training Requirement and Training Assignment objects will no longer be editable and has been reclassified as ‘optional’ with this vault release, as it is not used to link a Training Requirement with the documents associated with it. 

As a result, while existing Page Layouts for Vault Training-related objects will continue to function without issue for any Training Requirements or Training Assignments created before the release of 19R2.3, these configurations will need to be updated to reflect these data model changes for new or updated Training Assignments or Training Requirements.

If you are a current customer of Vault Training, Veeva’s services and product management teams will be in contact with your organization regarding this change management.

We have made the following changes per the Data Model Changes for Training Assignment Checklist Lifecycle feature:

For the TA Checklist Lifecycle, existing state’s entry actions were updated for the Passed lifecycle state:

  • A condition If Quiz Issuance Tracker is blank was added to the existing entry actions
  • Copy Field To Related Object was updated with the Update Related Record Field entry action 

There is no functional impact to this change; the changes were made to be consistent with additional entry actions that were added as part of the Instructor-Led Training feature.

We have added the following objects to support the Vault Training Instructor-Led Training feature:

  • Class Schedule (class_schedule__v) with the following fields:
    • Name (name__v)
    • Classroom Training Requirement (training_requirement__v)
    • Class Overview (overview__v)
    • Delivery Format (delivery_format__v)
    • Start Date (start_date__v)
    • End Date (end_date__v)
    • Class Completion Criteria (class_completion_criteria__v)
  • Class Schedule-Document (class_schedule_document__v) with the following fields:
    • Name (name__v)
    • Document (document__v)
    • Class Schedule (class_schedule__v)
    • Display Order (display_order__v)
  • Class Roster (class_roster__v) with the following fields:
    • Name (name__v)
    • Training Assignment (training_assignment__v)
    • Class Schedule (class_schedule__v)
    • Learner (learner__v)
    • Class Completion Status (class_completion_status__v)
    • Class Roster Notes (class_roster_notes__v)
  • Session (session__v) with the following fields:
    • Name (name__v)
    • Class Schedule (class_schedule__v)
    • Start Date/Time (start_date_time__v)
    • End Date/Time (end_date_time__v)
    • Delivery Format (delivery_format__v)
    • Session Overview (session_overview__v)
    • Instructor (instructor__v)
    • Location (location__v)
    • Session Instructions (session_instructions__v)
    • Is this a required session? (required_session__v)
    • Class Completion Criteria (class_completion_criteria__v)
    • Require Quiz? (require_quiz__v)
    • Session Closure Criteria (session_closure_criteria__v)
  • Location (location__v) with the following fields:
    • Name (name__v)
  • Session-Quiz Design (session_quiz_design__v) with the following fields:
    • Name (name__v)
    • Class Schedule (class_schedule__v)
    • Session (session__v)
    • Quiz Design (quiz_design__v)
  • Session Roster (session_roster__v) with the following fields:
    • Name (name__v)
    • Session (session__v)
    • Class Roster (class_roster__v)
    • Learner (learner__v)
    • Learner Session Attendance Status (learner_session_attendance_status__v)
    • Notes (notes__v)
  • Quiz Issuance Tracker (quiz_issuance_tracker__v) with the following fields:
    • Name (name__v)
    • Training Assignment (training_assignment__v)
    • Session-Quiz Design (session_quiz_design__v)
    • Class Schedule (class_schedule__v)
    • Session (session__v)
    • Session Roster (session_roster__v)
    • Quiz Passed? (quiz_passed__v)
    • Quiz Design (quiz_design__v)
  • TA Checklist (ta_checklist__sys) updated with the following fields:
    • Quiz Issuance Tracker (quiz_issuance_tracker__v)
  • Training Assignment (training_assignment__v) updated with the following fields:
    • Content Set (training_content_set__v)
    • Part of class (part_of_class__v)

We have added or modified the following objects to support QMS Spark Connection: Change Control & Variation Management:

  • Impact Assessment (change_control_impact_assessment__v) added with new fields:
    • Title (title__v)
    • Assessment Summary (summary__v)
    • Quality Event (quality_event__v)
    • RIM Event ID (rim_event_guid__v)
  • Impacted Country (impacted_country__v) added with new fields:
    • Country (country__v)
    • Approval Status (approval_status__v)
    • Quality Event (quality_event__v)
    • RIM Activity ID (rim_activity_guid__v)
  • Quality Event (quality_event_qdm) updated with new field:
    • RIM Event ID (rim_event_guid__v)

This release also introduces Enhanced Configurability to various components in Quality vaults. Enhanced Configurability introduces 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 the Department (department__v) object, edited attributes for the Department Number/Code (number__v) field
  • On the Extension Request (extension_request__qdm) object, edited attributes for the Date Requested (date_requested__qdm) field
  • On the Facility (facility__v) object, edited attributes for the following fields:
    • Facility Address (address__v)
    • Facility Number/Code (number__v)
  • On the Risk Register (risk_register__v) object, edited attributes for the following fields:
    • Description (description__v)
    • Title (title__v)
    • Type (type__v)
  • On the Risk (risk_event__v) object, edited attributes for the following fields:
    • Description (description__v)
    • Risk Owner (risk_owner__v)
    • Title (title__v)
    • Trigger (trigger__v)
  • On the Mitigation Action (mitigation_action__v) object, edited attributes for the following fields:
    • Description (description__v)
    • Title (title__v)
    • Due Date (due_date__v)
  • On the Organization (qms_organization__qdm) object, edited attributes for the Name (name__v) field
  • On the Quality Event (quality_event__qdm) object, edited attributes for the Require Effectiveness Check (require_effectiveness_check__qdm) field
  • On the Investigation (investigation__qdm) object, edited attributes for the Department (_department__qdm_) field