Introduction

Conceptually, master data can be divided into 3 logical groups of data:

1. Lookup tables

2. Organizational structure

3. Inspection matrix

This article explains how to define inspection matrix. 

Prerequisite for definition of inspection matrix is that the organization structure (organization, department, plant, area, line, device) has been previously defined.

By term "inspection matrix", we mean inspection points and related inspection parameters (i.e. quality characteristics), defined for organizational elements.

Open the form "Organization Structure and Inspection Matrix":

Inspection Types

in the "Organization" tab, navigate to some already defined organization, by using navigation toolbar placed on the bottom of the form.

Now, go to the tab "Inspection Types and Inspection Parameters Templates".

Explore various inspection types already defined, in order to understand how these templates are structured.

Basically, inspection types are custom sets of templates that provide description of inspection parameters (i.e. quality characteristics), which then can be reused for definition of inspection points and parameters in the inspection matrix.

Note that inspection types and templates are defined for an organization.

Inspection Scenario

Let's suppose that we have a defined department and plant for which we want to define inspection matrix for an area called "General area 1".

Let's imagine that this are has no production lines and no devices, so we created "dummy" line and "dummy" device.

Now, we want to define inspection matrix for "General Area 1" with several inspection points and inspection parameters. Let's imagine that this is a clean area with no machines, but with a demineralized water sampling point. We sample microbiological cleanliness of the area (settle plates) and sample water for microbiological and physical-chemical analysis.

1. Microbiological settle plates, placed on the floor

- 2 inspection points (MB_Plate1, MB_Plate2), each having 1 quality characteristic - number of colonies per plate, with defined specification and warning llimits (USL = 25 CFU/plate, UWL = 10 CFU/plate)

2. Microbiological sampling of water

- 1 inspection point (MB_W1) with 3 inspection parameters:

• TVC_1 Total viable count, with specification limit USL = 100 CFU/ml
• ESCH_1: Absence of Escherichia Coli
• PSE_1: Absence of pseudomonas Aeruginosa

3. Physical-chemical sampling of water

- 1 inspection point (PC_W1), with 2 inspection parameters:

• pH, with specification limits (USL = 8, LSL = 7)
• Conductivity, with limits (specification limit USL = 800 µS / cm, action limits UAL = 750 µS / cm, warning limit UWL = 700 µS / cm)

If we look at this task, we might conclude that we first need to define following inspection types:

• My Settle Plates Type
• My Water Microbiology Type
• My Water Physical-Chemical Type

So, let's create those inspection types.

Create New Inspection Type

First, let's create new inspection type called "My Settle Plates Type".

 The new record is saved if we position cursor on some other row.

Now, click on the "+" sign on the begining of the row. This will open subform for definition of new template. 

 Let's call this new template "My Settle Plates Template". It is saved if we move cursor to some other row.

 Notice that when record is saved, we have a "+" button on the beginning of the row. If we click on the "+" sign, we can open a subform for definition of inspection parameters for this template.

We said that for this inspection type we have only 1 quality characteristic - number of colonies per plate, with defined specification and warning llimits (USL = 25 CFU/plate, UWL = 10 CFU/plate), so let's define it.

 Notice columns "Data Type",  "Requirement Type" and "Unit of Measure"! We will choose Data Type and Requirement Type from drop-down menu.

For data type, we choose "integer (variable)", while for requirement type we choose "limits (integer)".