21R2 Data Model Changes: QualityOne

Pre-Release Date: July 12, 2021 | Release Date: July 30 & August 6, 2021

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 21R2.

Added components to support the Product Hierarchy Data Model for QualityOne feature:

• Added the following new objects:
  • Product Composition (product_composition__v)
  • Formulation (formulation__v)
  • Formulation Composition (formulation_composition__v)
  • Product Batch (product_batch__v)
  • Product-Organization (product_organization__v)
  • NCR-Product (ncr_product__v)
  • CAR-Product (car_product__v)
  • Change Control-Product (change_control_product__v)
  • CII-Product (cii_product__v)
  • Complaint-Product (complaint_product__v)
  • Master Specification Group (master_specification_group__v)
  • Master Specification (master_specification__v)
  • Specification Acceptable Attribute(specification_acceptable_attribute__v)
• Added the following fields to the Product (product__v) object:
  • Title (title__v)
  • Formulation (formulation__v)
  • Version Source (version_source__v)
  • Version Number (version_number__v)
  • Product Type (product_type__v)
  • Specification Group (specification__v)
• Added the Specific Product (specific_product__v) field to the following objects:
  • Component Matching Variant (component_matching_variant__v)
  • Inspection (inspection__v)
  • Inspection Plan (inspection_plan__v)
  • Purchase Order Line Item (purchase_order_line_item__v)
• Added the Master Specification Lifecycle (master_specification_lifecycle__v) object lifecycle.

Added components to support the HACCP Phase 1 feature:

• Added the following new objects:
  • Hazard (hazard__v)
  • Process Step (process_step__v)
  • CCP Library (ccp_library__v)
  • Process-Process Step (process_process_step__v)
  • Product-Process Step (product_process_step__v)
  • HACCP Plan (haccp_plan__v)
  • HACCP Plan Ingredient (haccp_plan_ingredient_v)
  • HACCP Plan-Process Step (haccp_plan_process_step__v)
  • Ingredient Hazard Analysis (ingredient_hazard_analysis__v)
  • Process Hazard Analysis (process_hazard_analysis__v)
  • CCP-Hazard Analysis (ccp_hazard_analysis__v)
  • CCP-Audit (ccp_audit__v)

Added components to support the Incident Management - Track Labor Information feature:

• Added the new Labor Information(labor_information__v) object.

Added components to support the Training Management Phase 3 feature:

Administrator visibility of the following components has been updated:

• The Preview E-Learning Content and Set E-Learning Standard User Actions are now visible in the Admin section of all QualityOne Vaults. This User Action can only be used on Training Management Vaults.

External Training Type:

• Added the External Training Requirement (external_training_requirement__v) object type to the Training Requirement (training_requirement__v) object.
• Added the External Training Assignment (external_training_assignment__v) object type to the Training Assignment(training_assignment__v) object.
• Added the following fields to the Training Requirement (training_requirement__v) object:
  • Instructions (instructions__v)
  • Training Link (training_link__v)
• Added the following fields to the Training Assignment (training_assignment__v) object:
  • Instructions (instructions__v)
  • Training Link (training_link__v)
• Added the following new object workflows:
  • Complete External Training Assignment(complete_external_training_assignment__v)
  • Verify External Training Assignment(verify_external_training_assignment__v)
  • Resubmit External Training Assignment(resubmit_external_training_assignment__v)

Direct Assignment to Multiple Learners and Direct Assignment to Curriculum:

• Added the following fields to the Direct Assignment User Input (direct_assignment_user_input__v) object:
  • Apply to Training Requirements in (apply_to_trs_in__v)
  • Learners(learners__v)
• Added the Direct Assignment User Input(direct_assignment_user_input__v) field to the Direct Assignment Request (direct_assignment_request__v) object.
• The Learner(learner__v) field from the Direct Assignment User Input (direct_assignment_user_input__v) object is no longer a required field.

Complete Training Assignment Workflow Visible in Admin:

• Added the Complete Training Assignment (complete_training_assignment__v) object workflow.

E-Learning Standards Support:

• Added the following new objects:
  • Training Completion Criteria (training_completion_criteria__v)
  • Training Completion Criteria Detail (training_completion_criteria_detail__v)
  • Training Content Status (training_content_status__v)
  • E-Learning Status Details (e_learning_status_detail__v)
• Added the following new object lifecycles:
  • Training Completion Criteria Lifecycle (training_completion_criteria_lifecycle__v)
  • Training Completion Criteria Details Lifecycle (training_completion_criteria_details_lc__v)
  • Training Content Status Lifecycle (training_content_status_lifecycle__v)
  • E-Learning Status Details Lifecycle (e_learning_status_detail_lifecycle__v)
• Added the Training Completion Criteria (training_completion_criteria__v) field to the Training Content Set-Document (training_content_set_document__v) object.

Facilitated Training:

• Added the following new objects:
  • Facilitated Training Request (facilitated_training_request__v)
  • Facilitated Training Request-Training Assignment(facilitated_training_request_training_assignment__v)
• Added the following fields to the Training Assignment (training_assignment_v) object:
  • Completion Source (completion_source__v)
  • Facilitated Training Request (facilitated_training_request__v)
• Added the Person is not a Vault user (person_is_not_a_vault_user__v) field to the Person (person__sys) object.
• Added the Facilitated Training Request Lifecycle (facilitated_training_request_lc__v) object lifecycle.
• Added the “[Person is not a Vault user] [is] [No]” Entry Action condition for the Assigned state of the Training Assignment Lifecycle (training_assignment_lifecycle__v) object lifecycle.

Training Assignment Lifecycle User Actions:

• User Actions are now editable for any lifecycle state of the Training Assignment Lifecycle (training_assignment_lifecycle__v) object lifecycle.

Assignment Details Lifecycle State No Longer Updated:

• Added the Training Assignment Lifecycle State (training_assignment_lifecycle_state__v) field to the Assignment Details (assignment_details__v) object.
• Removed the Change Related Object Lifecycle State Entry Action of the Assignment Details(assignment_details__v) object for the Assigned, Completed, and Cancelled states of the Training Assignment Lifecycle (training_assignment_lifecycle__v) object lifecycle.

Classroom Training:

• Added the View Classroom Training Assignment (view_classroom_training_assignment__v) object workflow.
• Added the View Classroom Training Assignment(view_classroom_training_assignment__v) object workflow auto-start Entry Action for the Assigned state of the Training Assignment Lifecycle (training_assignment_lifecycle__v) object lifecycle.

Substitute Training:

• Added the following new objects:
  • Training Rule Set (training_rule_set__v)
  • Training Rule (training_rule__v)
  • Related Training Assignment (related_training_assignment__v)
• Added the Is a substitute Training Requirement (is_a_substitute_training_requirement__v) field to the Training Requirement (training_requirement__v) object.
• Added the Creation Source (creation_source__v) field to the Training Assignment (training_assignment__v) object.
• Added the following new object lifecycles:
  • Training Rule Set Lifecycle (training_rule_set_lifecycle__v)
  • Training Rule Lifecycle (training_rule_lifecycle__v)
• Added the Pending Substitute Completion (pending_substitute_completion_state__v) state to the Training Assignment Lifecycle (training_assignment_lifecycle__v) object lifecycle.

Mobile Training Task Completion:

• Added the following new page components:
  • Vault Training Mobile: Document Information Page (training_mobile_document_info_page__v)
  • Vault Training Mobile: Interstitial (training_mobile_interstitial_page__v)
  • Vault Training Mobile: Learner Task Page (training_mobile_learner_task_page__v)
  • Vault Training Mobile: Success Page (training_mobile_success_page__v)

Learner Homepage:

• Added the My Learning (training_my_learning_tab__v) tab component.
• Added the Vault Training Learner Homepage: My Learning Page (training_my_learning_page__v) page component.
• Added the following fields to the Training Assignment (training_assignment__v) object:
  • Completion Date(completion_date__v)
  • Description(description__v)
  • Learner Homepage Card Image(learner_homepage_card_image__v)
• Added the Completion Date (completion_date__v) field to the Assignment Details (assignment_details__v) object.
• Added the Learner Homepage Card Image (learner_homepage_card_image__v) field to the Training Requirement (training_requirement__v) object.

Additional Data Model Updates

Updated components to support Incident Management in this release:

• Added the following picklist values to Case Classification (case_classification__v) picklist:
  • First Aid (first_aid__v)
  • Medical Treatment (medical_treatment__v)
  • Restricted Work (restricted_work__v)
  • Lost Time (lost_time__v)
  • Fatality (fatality__v)
• Added the following picklist values to Injury Illness Type (injuryillness_type__v) picklist:
  • Skin Disorder (skin_disorder__v)
  • Respiratory Condition (respiratory_condition__v)
  • Poisoning (poisoning__v)
  • Hearing Loss (hearing_loss__v)