24R3 Data Model Changes: QualityOne

Pre-Release Date: November 4, 2024 | Release Date: November 22, 2024 & December 6, 2024

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 24R3.

Data Model Updates - QualityOne

Added components to support the Teams Enhancement: Manage Team Assignments feature:

• Added the Teams Update Operation Complete (team_update_operation_complete__v) notification template.

In support of the QualityOne Standard Checkbox Defaulting feature, Vault automatically sets the following standard checkbox fields to No (false) upon record creation. This behavior only applies when the field is not configured with a default value.

• Audit Response (audit_response__sys) object: Audit Finding (audit_finding__v)
• Auditor Role (auditor_role__v) object: Requires Requalification? (requires_requalification__v)
• Inspection (inspection__v) object: COA Approved (coa_approved__v)
• Inspection Plan Requirement (inspection_plan_requirement__v) object: CTQ? (ctq__v)
• Item Specifications (item_specifications__v) object: CTQ? (ctq__v)
• Master Specification (master_specification__v) object: CTQ? (ctq__v)
• Role Qualification Criteria (role_qualification_criteria__v) object: Requires Requalification? (requires_requalification__v)
• Controlled Copy Trace (controlled_copy_trace__v) object:
  • Include Signature Page (include_signature_page__v)
  • Migrated (migrated__v)
  • Released From Vault (released_from_vault__v)
• Person (person__sys) object: Person is not a Vault user (person_is_not_a_vault_user__v)
• Training Assignment (training_assignment__v) object:
  • Quiz Passed? (quiz_passed__v)
  • Person is not a Vault user (person_is_not_a_vault_user__v)
• Training Content Set (training_content_set__v) object: In Use by Related Training Requirement (in_use_by_rel_training_requirement__v)
• Training Requirement (training_requirement__v) object: Is A Substitute Training Requirement (is_a_substitute_tr__v)
• Training Requirement Impact Assessment (training_requirement_impact_assessment__v) object: Is A Substitute Training Requirement (is_a_substitute_tr__v)
• Why (why__v) object:
  • Is Expected? (is_expected__v)
  • Is Root Cause? (is_root_cause__v)

Data Model Updates - QMS (QualityOne)

Added components to support the Generate Documents for Additional QMS Processes feature:

• Added the following document fields:
  • Continuous Improvement Initiative Record (cii_record__v)
  • Lab Investigation Record (lab_investigation_record__v)
  • Inspection Record (inspection_record__v)

Added components to support the Periodic Reviews: APQRs for Internal Facility feature:

• Added the following fields to the APQR (apqr__v) object and APQR object type of the Periodic Review Template (periodic_review_template__v) object:
  • Internal Facility (internal_facility__v)
  • Organization (qms_organization__v)
• Added the following document fields:
  • Internal Facility (internal_facility__v)
  • QMS Organization (qms_organization__v)

Added components to support the Inspection Sample Test Result Moving to Raw Object feature:

• Updated the Data Store attribute of the Inspection Sample Test Result (inspection_sample_test_results__v) object from Standard to Raw.

Added components to support the Reuse CCPs & OPRPs within the Same HACCP Plan feature:

• Added the following objects:
  • HACCP Hazard Control (haccp_hazard_control__v)
  • HACCP Process Modification (haccp_process_modification__v)
  • PHA - HHC (pha_hhc__v)
• Added the Brief Description (brief_description__v) field to the Process Hazard Analysis - Hazard (pha_hazard__v) object.

Added components to support the Generate HACCP Flow Diagram & Data Documents feature:

• Added the HACCP Reports (haccp_reports__v) document type.

Added components to support the HACCP Flow Diagram: Hazard Analysis Completeness Check Enhancement feature:

• Added the Hazard Analysis Complete (hazard_analysis_complete__v) field to the Process Hazard Analysis (process_hazard_analysis__v) object.

Added components to support the HACCP Flow Diagram: Adjust Connection Line Position feature:

• Added the HPPSC Position (hppsc_position__v) object.

Added components to support the Comparison IDs for HACCP Plans feature:

• Added the Comparison ID (comparison_id__v) field to the following objects:
  • Action Item (action_item_qdm)
  • CCP-Hazard Analysis (ccp_hazard_analysis__v)
  • HACCP Plan (haccp_plan__v)
  • HACCP Plan Ingredient (haccp_plan_ingredient__v)
  • HACCP Plan Process Step (haccp_plan_process_step__v)
  • HACCP Plan Process Step Connection (haccp_plan_process_step_connection__v)
  • HACCP Plan Process Step Group (haccp_plan_process_step_group__v)
  • HACCP Plan Process Step Position (haccp_plan_process_step_position__v)
  • HPPS - PHA (hpps_pha__v)
  • HPPSG - HPPS (hppsg_hpps__v)
  • Ingredient Hazard Analysis (ingredient_hazard_analysis__v)
  • Ingredient Involved (hpps_hpi__v)
  • PHA - Subsequent Step (pha_subsequent_step__v)
  • Process Hazard Analysis (process_hazard_analysis__v)
  • Process Hazard Analysis - Hazard (pha_hazard__v)
  • PRP/CM - Hazard Analysis (prp_cm_hazard_analysis__v)

Added components to support the HACCP Plan Translation feature:

• Added the following objects:
  • Generate Translation Copy User Input (generate_translation_copy_user_input__v)
  • HACCP Translation Generation (haccp_translation_generation__v)
• Added the following object types to the Critical Control Translation (ccp_library_translation__v) object:
  • CCP (ccp__v)
  • Control Measure (control_measure__v)
  • OPRP (oprp__v)
  • Prerequisite Program (prerequisite_program__v)
• Added the following object types to the Detectability Translation (detectability_translation__v) object:
  • Qualitative Detectability (qualitative_detectability__v)
  • Quantitative Detectability (quantitative_detectability__v)
• Added the following object types to the Occurrence Translation (occurrence_translation__v) object:
  • Qualitative Occurrence (occurrence_qualitative__v)
  • Quantitative Occurrence (occurrence_quantitative__v)
• Added the following object types to the Process Step Translation (process_step_translation__v) object:
  • Connector (diagram_connector__v)
  • Logistics Step (logistics_step__v)
  • Material Step (material_step__v)
  • Process Step (process_step__v)
• Added the following object types to the Risk Matrix Translation (risk_matrix_translation__v) object:
  • Risk Matrix - Qualitative (risk_matrix_qualitative__v)
  • Risk Matrix - Quantitative (risk_matrix_quantitative__v)
• Added the following object types to the Severity Translation (severity_translation__v) object:
  • Qualitative Severity (severity_qualitative__v)
  • Quantitative Severity (quantitative_severity__v)
• Added the Translated Field (ccp_hazard_translated_field__v) field to the CCP-Hazard Analysis (ccp_hazard_analysis__v) object.
• Added the Translated Field (haccp_hazard_control_translated_field__v) field to the HACCP Hazard Control (haccp_hazard_control__v) object.
• Added the Translated Field (haccp_ps_translated_field__v) field to the HACCP Plan Process Step (haccp_plan_process_step__v) object.
• Added the Translated Field (pha_translated_field__v) field to the Process Hazard Analysis (process_hazard_analysis__v) object.

Data Model Updates - QMS (QualityOne) & HSE

Added components to support the Auto-Create Proposed Audit Enhancements feature:

• Added the ability for Admins to configure the User must always enter a value (required) attribute for the following fields on the Organization (qms_organization_qdm) object:
  • Next Audit Date (next_audit_date__v)
  • Risk Classification (risk_classification__v)

Data Model Updates - HSE

Added components to support the Generate Documents for Standard HSE Processes feature:

• Added the following document fields:
  • HSE Event Record (hse_event_record__v)
  • Permit to Work Record (permit_to_work_record__v)