Enumerations related to User Workflow Statuses

A user workflow status is assigned by the user to a sample scheme analyte, to provide further details as to why a particular core workflow status is present for a Listed Not Received, Insufficient Sample, Not Analysed or No Result workflow status.

User workflow statuses are configured in the MSETBL—Table Code Service application and are stored in the MSF010 system table with a Table Code of CC30—User Workflow Statuses.

A sample scheme analyte's User Workflow Statuses is then selected from a multi-choice drop-down sourced from those table codes via the CCWorkbookService.searchUserWorkflowStatuses service.

Note: Table codes are set up across the instance and cannot be filtered by organisation nor laboratory.

The list of tables contained within the MSF010 table is itself contained within the XX table, and can be seen by performing a search in the MSF010 system table by setting the Table Type criteria to XX. The following header record points to the table that contains the enumerations for core workflow statuses. Modify header records at your own risk!

Table Type Table Code Entry description

XX

CC30

User Statuses

As it can be seen from the search results, the CC30—User Statuses table within the MSF010 table contains core workflow statuses.

Therefore the list of user workflow statuses defined for the instance can be seen by performing a search in the MSF010 system table by setting the Table Type criteria to CC30. A user workflow status record can be opened to inspect its contents. A user workflow status record must contain the following:

  • Table Type—CC30
  • Table File Code—The code that a user selects in workbook to set a particular user workflow status.
  • Table file entry description—Reportable string.
  • Table File Associated Values—The core workflow status of LNR, IS, NA, NR, as contained within the CC31—Workflow Statuses table within the MSF010 table, that is assigned to a sample scheme analyte when a user applies the user workflow status to it.
  • Active Flag—Checked

User workflow statuses can be updated by the user, and affect the entire instance.

The following table displays examples of user workflow status.

Table Type

Table File Code

Table file entry description

Associated Values

Active Flag

CC30

BRK

Sample Breakage

IS

Y

CC30

CONT

Sample Contaminated

NA

Y

CC30

IS

Insufficient Weight

IS

Y

CC30

LIL

Lost in Lab

IS

Y

CC30

LIP

Lost in Prep

NA

Y

CC30

LNR

Listed Not Received

LNR

Y

CC30

NA

Not Analysed

NA

Y

CC30

NR

No Result

NR

Y

CC30

OVR

Over Range

NA

Y

CC30

RTC

Result To Come

NR

Y

CC30

UNSEALED

Sample Unsealed

NA

Y