23R2 Data Model Changes: QualityOne

Pre-Release Date: July 17, 2023 | Release Date: August 4, 2023 & August 11, 2023

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

Data Model Updates - QMS

Added components to support the Product Groups feature:

• Added the Product Group (product_group__v) object.

Added components to support the Lab Investigations feature:

• Added the following objects:
  • CAR - Lab Investigation (car_lab_investigation__v)
  • Lab Investigation (lab_investigation__v)
  • Lab Investigation - Inspection (lab_investigation_inspection__v)
  • Material - Lab Investigation (material_lab_investigation__v)
  • NCR - Lab Investigation (ncr_lab_investigation__v)
• Added the following picklists:
  • Impacted Areas (lab_inv_impacted_areas__v)
  • Investigation Type (lab_investigation_type__v)
  • Lab Investigation Classification (lab_inv_classification__v)
  • Lab Investigation Review List (lab_inv_review_list__v)
  • Lab Investigation Severity Type (lab_inv_severity_type__v)
  • Lab Investigation Trend Review (lab_inv_trend_review__v)
  • Product Type (lab_inv_product_type__v)
  • Retest Results (retest_results__v)
  • Sample Type (lab_inv_sample_type__v)
  • Yes/No (yes_no__v)

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

• Added the following document fields:
  • CAR Record (car_record__v)
  • Change Control Record (change_control_record__v)
  • Complaint Record (complaint_record__v)
  • Formulation Record (formulation_record__v)
  • NCR Record (ncr_record__v)
  • Packaging Record (packaging_record__v)
  • Product Record (product_record__v)
  • Risk Register Record (risk_register_record__v)
  • Risk Study Record (risk_study_record__v)

Added components to support the COA: Expanded Email Intake Support feature:

• Added the following fields to the Inspection (inspection__v) object:
  • COA Ingestion Error Type (coa_ingestion_error_type__v)
  • COA Ingestion Source (coa_ingestion_source__v)
  • COA Ingestion Status (coa_ingestion_status__v)
  • COA Ingestion Status Last Modified (coa_ingestion_status_last_modified__v)
• Added the following picklists:
  • COA Ingestion Error Type (coa_ingestion_error_type__v)
  • COA Ingestion Source (coa_ingestion_source__v)
  • COA Ingestion Status (coa_ingestion_status__v)
• Added the following notification templates:
  • COA Email: Failed to Ingest Attachment (coa_email_failed_to_ingest_attachment__v)
  • COA Email: No Files Ingested (coa_email_no_files_ingested__v)
  • COA Email Processor Cannot Create Record (coa_email_processor_cannot_create_record__v)
  • COA Missing Material Feature Flag Config (coa_missing_material_ff_config__v)

Added components to support the Supporting Multi-Batch Identification for COA feature:

• Added the Main Batch (main_batch__v) field to the Inspection (inspection__v) object.
• Added the Contains Multiple Batches? (contains_multiple_batches) document field.
• Added the COA Analysis Success Multi-Batch (coa_analysis_success_multibatch__v) notification template.

Added components to support the HACCP Flow Diagram feature:

• Added the HACCP Plan Process Step Position (haccp_plan_process_step_position__v) object.
• Added the Diagram Locked (diagram_locked__v) field to the HACCP Plan (haccp_plan__v) object.
• Added the following fields to the HACCP Plan Process Step (haccp_plan_process_step__v) object:
  • CCP (ccp__v)
  • Code (code__v)
  • Display Label (display_label__v)
  • OPRP (oprp__v)
  • Step Name (step_name__v)
• Added the following fields to the HACCP Plan Process Step Connection (haccp_plan_process_step_connection__v) object:
  • Input Step (input_step__v)
  • Label (label__v)
  • Step Connection Type (step_connection_type__v)
• Added the Step Connection Type (step_connection_type__v) picklist.

Added components to support the HACCP Plan Enhancement feature:

• Added the HPPS - PHA (hpps_pha__v) object.
• Added the Display Label (display_label__v) field to the CCP Hazard Analysis (ccp-hazard_analysis__v) object.
• Added the following fields to the Ingredient Hazard Analysis (ingredient_hazard_analysis__v) object:
  • CCP (ccp__v)
  • HACCP Plan (haccp_plan__v)
  • Hazard Status (hazard_status__v)
  • OPRP (oprp__v)
  • Significant Hazard (significant_hazard__v)
• Added the following fields to the Process Hazard Analysis (process_hazard_analysis__v) objects:
  • CCP (ccp__v)
  • HACCP Plan (haccp_plan__v)
  • HACCP Plan Process Step (haccp_plan_process_step__v)
  • Hazard Status (hazard_status__v)
  • OPRP (oprp__v)
  • Significant Hazard (significant_hazard__v)
• Added the Hazard Status (hazard_status__v) picklist.

Data Model Updates - Document Control

Added components to support the Recall Controlled Copies feature:

• Added the Recall System Details (recall_system_details__v) field to the Controlled Copy Trace (controlled_copy_trace__v) object.
• Added the following state types to the Controlled Copy Trace (controlled_copy_trace__v) object lifecycle:
  • Controlled Copy In Recall (controlled_copy_in_recall__v)
  • Controlled Copy In Use (controlled_copy_in_use__v)

Data Model Updates - HSE

Added components to support the Permit to Work feature:

• Added the following objects:
  • Isolation (isolation__v)
  • Permit to Work (permit_to_work__v)
  • Permit to Work-Risk Event (permit_to_work_risk_event__v)
• Added the following picklists:
  • Isolation Type (isolation_type__v)
  • Work Type (work_type__v)

Additional Data Model Updates

Added components to support the QualityOne Training Connector: eLearning Data Model Provisioning feature. See 23R2 Data Model Changes: Quality for more details.