Applying a Custom QC Status to a Sample Scheme Analyte

• Applying a Custom QC Status to a Sample Scheme Analyte
  • Overview
  • Process
    • Defining Custom QC Statuses
    • Setting a Custom QC Status on Workbook Cells

Overview

Sometimes there is a need to provide more information as to why a sample scheme analyte's Composite QC Status was achieved. To do this, a custom QC status is applied.

Process

Defining Custom QC Statuses

Custom QC statuses are entered as System Table Codes with a Table Type of C33—User QC Statuses, as configured in the MSETBL—Table Code Service application.

Note: Where a sample scheme analyte has a User QC Status set by the user, this status is not linked in any way to the sample scheme analyte's Composite QC Status.

Examples of user QC status configuration:

Table Type	Table File Code (System Short Form)	Table file entry description	Table File Associated Values (Related core Composite QC Status)
CC33	EXTDWNDFT	Extreme downward drift	FAILURE
CC33	EXTUPDFT	Extreme upward drift	FAILURE
CC33	MODDWNDFT	Moderate downward drift	WARNING
CC33	MODUPDFT	Moderate upward drift	WARNING

The Table Code can be set to any combination of letters, digit, and symbols, as appropriate (maximum length is 18).

The Entry description can be modified as appropriate for reporting purposes (maximum length is 50).

By default, the drop-down list of user QC statuses is built from the CC33—User QC Statuses Table Type, ordered by Table Code. For example, using the table above, the drop-down list presented when marking workbook cells with a user QC status is ordered: EXTDWNDFT, EXTUPDDFT, MODDWNDFT, MODUPDFT. Refer to Appendix—Job Audit Event Codes.

To change this default order, where a pipe character (|) is included in the Table File Associated Values, then the portion before the pipe character contains the sequence for display, and the portion after the pipe character contains the actual user status. For example:

Table Type	Table File Code (System Short Form)	Table file entry description	Table File Associated Values (Related core Composite QC Status)
CC33	EXTDWNDFT	Extreme downward drift	2|FAILURE
CC33	EXTUPDFT	Extreme upward drift	4|FAILURE
CC33	MODDWNDFT	Moderate downward drift	1|WARNING
CC33	MODUPDFT	Moderate upward drift	3|WARNING

populates the drop-down list of available user QC statuses in the order: MODDWNDFT, EXTDWNDFT, MODUPDFT, EXTUPDDFT.

Where only some of the entries have the sort order defined, then the drop-down list is ordered first by those that have a sort order in the given sort order, and secondly by those that do not have a sort order in the given table order.

Setting a Custom QC Status on Workbook Cells

A custom QC status can be set only via a workbook script (typically accessed via the right-click menu from workbook cells) for selected workbook cells.

Mark workbook cells with a user QC status

Use wild-cards to apply filtering on the drop-down list.

Any update to a QC sample scheme analyte's User QC Status is persisted to the associated QC history observation.