System maintenance of aggregate details for jobs and samples

The following aggregate details for jobs and samples are maintained by the system:

Object type

Aggregate

Description

Job

Number of samples registered (#S)

Number of samples in a job or batch job, excluding draft samples.

Number of unknown samples registered (#U)

Number of unknown samples in a job, excluding draft samples.

Number of job schemes registered (#JS)

Number of job schemes in a job.

Number of job schemes started (#JSSta)

Number of job schemes in a job that has a Workflow Status of Started, Analysed or Released.

Number of job schemes completed (#JSCpl)

Number of job schemes in a job that has a Workflow Status of Completed.

Sample

Number of sample schemes registered (#SS)

Number of sample schemes in a sample.

Number of sample schemes started (#SSSta)

Number of sample schemes in a sample that has a Workflow Status of Started, Analysed, Released, Listed Not Received, Insufficient Sample, Not Analysed, No Result.

Number of sample schemes completed (#SSCpl)

Number of sample schemes in a sample that has a Workflow Status of Completed.

Aggregate Details for Jobs and Samples

When the workflow status of samples, job schemes and sample schemes change, the system maintains the following aggregate details for jobs:

  • #Samples—The number of samples in a job.
  • #Unks—The number of unknown samples in a job.
  • #JS—The number of job schemes in a job.
  • #JSStart—The number of job schemes in a job that have a Workflow Status of Started, Analysed or Released.
  • #JSComp—The number of job schemes in a job that have a Workflow Status of Completed.

and the following aggregate details for samples:

  • #SS—The number of sample schemes in a sample.
  • #SSStart—The number of sample schemes in a sample that have a Workflow Status of Started, Analysed, Released, Listed Not Received or Insufficient Sample.
  • #SSComp—The number of sample schemes in a sample that have a Workflow Status of Completed, Listed Not Received or Insufficient Sample.

Processes that Change Aggregate Details on Production Jobs

Job attributes

Recalculation point

Criteria

#Samples

Samples added to or removed from a job.

Exclude draft samples (unexpanded sample groups), if present.

#Unk

Samples added to or removed from a job.

Only where the sample's Primary Analytical Type is Unknown.

Exclude draft samples (unexpanded sample groups), if present.

#Schemes

Job schemes added or removed from a job, triggered when a sample scheme is added to or removed from a sample.

 

#Schemes Started

Job scheme Workflow Status changed, updated during a workflow status cascade.

Only where the job scheme's Workflow Status is Started, Analysed or Released.

#Schemes Completed

Job scheme Workflow Status changed, updated during a workflow status cascade.

Only where the job scheme's Workflow Status is Completed.

Processes that Change Aggregate Details on Production Samples

Sample attributes

Recalculation point

Criteria

#Schemes

Sample schemes added to or removed from a sample.

 

#Schemes Started

Sample scheme Workflow Status changed, updated during a workflow status cascade.

Only where the sample scheme's Workflow Status is Started, Analysed,Released, Listed Not Received, Insufficient Sample, Not Analysed or No Result.

#Schemes Completed

Sample scheme Workflow Status changed, updated during a workflow status cascade.

Only where the sample scheme's Workflow Status is Completed, Listed Not Received, Insufficient Sample, Not Analysed or No Result.

Processes that Change Aggregate Details on Laboratory Batch Jobs

Batch Job attributes Recalculation point Criteria

#Samples

Samples added to or removed from a batch, when a laboratory batch job is created, or when samples are de-linked from a batch.

Exclude draft samples (unexpanded sample groups), if present (not generally possible for a laboratory batch job).

#Unk

Samples added to or removed from a batch, when a laboratory batch job is created, or when samples are de-linked from a batch.

Only where the sample's Primary Analytical Type is Unknown.

Exclude draft samples (unexpanded sample groups), if present (not generally possible for a laboratory batch job).

#Schemes

Job schemes added or removed from a laboratory batch job, triggered when a sample scheme is added to or removed from a laboratory batch sample.

 

#Schemes Started

Laboratory batch job scheme Workflow Status changed, updated during a workflow status cascade.

Only where the laboratory batch job scheme's Workflow Status is Started, Analysed or Released.

#Schemes Completed

Laboratory batch job scheme Workflow Status changed, updated during a workflow status cascade.

Only where the laboratory batch job scheme's Workflow Status is Completed.

Processes that Change Aggregate Details on Laboratory Batch Samples

Batch Sample attributes Recalculation point Criteria

#Schemes

Sample schemes added to or removed from a laboratory batch sample, when a laboratory batch job is created, or when samples are de-linked from a batch.

 

#Schemes Started

Laboratory batch sample scheme Workflow Status changed, updated during a workflow status cascade.

Only where the laboratory batch sample scheme's Workflow Status is Started, Analysed,Released, Listed Not Received, Insufficient Sample, Not Analysed or No Result.

#Schemes Completed

Laboratory batch sample scheme Workflow Status changed, updated during a workflow status cascade.

Only where the laboratory batch sample scheme's Workflow Status is Completed, Listed Not Received, Insufficient Sample, Not Analysed or No Result.

Processes that Change Aggregate Details on Jobs and Samples—By Application

At the following points, that is, when changes occur, the system updates aggregate details for a job:

Application

Action/s

#S

#U

#JS

#JSSta

#JSCpl

#SS

#SSSta

#SSCpl

Notes

CCBTCH

Grid flow Create Batch

Y

Y

Y

Y

Y

Y

Y

Y

 

CCQCSM

Mark samples for deletion -> Submit

Y

Y

Y

Y

Y

Y

Y

Y

 

CCQCSM

Grid flow Add Dup/Rep

Y

 

 

 

 

Y

 

 

JS count does not change when Dup/Rep is added as the scheme is added already.

CCQCSM

Grid flow Add Standard/Blank

Y

 

 

 

 

Y

 

 

JS count does not change when Std/Blk is added as the scheme is added already.

CCQCSM

Grid flow Add Spike

Y

 

 

 

 

Y

 

 

JS count does not change when Spk is added as the scheme is added already.

CCREGN

Mark samples for deletion -> Submit

Y

Y

Y

Y

Y

Y

Y

Y

Update mode only.

CCREGN

Flow: Append QC

Y

Y

 

Y

Y

Y

Y

Y

JS count does not change when QCs are added to an existing scheme.

CCREGN

Flow: Overwrite QC

Y

Y

 

Y

Y

Y

Y

Y

JS count does not change when QCs are overwritten on an existing scheme.

CCREGN

Flow: Create Composite Sample

Y

Y

 

Y

Y

Y

Y

Y

JS count does not change when a composite sample is created.

CCREGN

Row flow: Copy Sample

Y

Y

 

Y

Y

Y

Y

Y

Update mode only.

JS count does not change when a sample is copied.

CCREGN (Search)

Row flow: Set Scheme Workflow Status

 

 

 

Y

Y

Y

Y

Y

Job scheme count does not change when a scheme's workflow status is updated.

CCSAMP

Submit

Y

Y

Y

Y

Y

Y

Y

Y

Create mode only.

CCSAMP

Flow: Add Tests from Sample

 

 

Y

Y

Y

Y

Y

Y

Update mode only.

CCSAMP

Row flow: Add Entire Scheme

 

 

Y

Y

Y

Y

Y

Y

Update mode only.

CCSAMP

Row flow: Add Scheme with Mandatory Analytes

 

 

Y

Y

Y

Y

Y

Y

Update mode only.

CCSAMP

Row flow: Add Analytes

 

 

Y

Y

Y

Y

Y

Y

Update mode only.

CCSAMP

Grid flow Remove Analyte

 

 

Y

Y

Y

Y

Y

Y

Update mode only.

CCSAMP

Grid flow Remove Scheme

 

 

Y

Y

Y

Y

Y

Y

Update mode only.

CCSAMP (Search)

Grid flow Import Samples

Y

Y

Y

Y

Y

Y

Y

Y

LibMan Import Sample Template feature.

As a sample can be imported into an exist job, or a new job is created for it, then the job properties change also.

CCSAMPMULTI
EDIT

Submit

 

 

Y

Y

Y

Y

Y

Y

 

CCSGRD

Submit

 

 

 

Y

Y

Y

Y

Y

JS count does not change when workflow status is updated via the CCSGRD application.

CCVALN

Grid flow Ignore DL

 

 

 

Y

Y

Y

Y

Y

JS count does not change if workflow status is updated via the CCVALN application.

CCVALN

Grid flow Ignore QC

 

 

 

Y

Y

Y

Y

Y

JS count does not change if workflow status is updated via the CCVALN application.

CCVALN

Grid flow Release

 

 

 

Y

Y

Y

Y

Y

JS count does not change if workflow status is updated via the CCVALN application.

CCVALN

Grid flow Request Repeat

 

 

 

Y

Y

Y

Y

Y

JS count does not change if workflow status is updated via the CCVALN application.

CCVALN

Grid flow Unvalidate Jobs

 

 

 

Y

Y

Y

Y

Y

JS count does not change if workflow status is updated via the CCVALN application.

CCVALN

Grid flow Unvalidate Samples

 

 

 

Y

Y

Y

Y

Y

JS count does not change if workflow status is updated via the CCVALN application.

CCVALN

Grid flow Validate

 

 

 

Y

Y

Y

Y

Y

JS count does not change if workflow status is updated via the CCVALN application.

CCVALN

Grid flow Validate Jobs

 

 

 

Y

Y

Y

Y

Y

JS count does not change if workflow status is updated via the CCVALN application.

CCVALN

Grid flow Validate Samples

 

 

 

Y

Y

Y

Y

Y

JS count does not change if workflow status is updated via the CCVALN application.

CCWKOP

Submit

 

 

 

Y

Y

Y

Y

Y

JS count does not change if workflow status is updated via the CCWKOP application.

CCWKOP
TRAN

Submit

 

 

 

Y

Y

Y

Y

Y

JS count does not change if workflow status is updated via the CCWKOP application.

--

Any workflow action performed on a laboratory batch job

 

 

 

Y

Y

 

Y

Y

Also recalculates aggregate details for the corresponding production job.

--

Any workflow action performed on a laboratory batch sample

 

 

 

Y

Y

 

Y

Y

Also recalculates aggregate details for the corresponding production sample.

--

Script invokes an operation

 

 

 

 

 

 

 

 

Depends upon the operation being invoked.

--

Web service invocation

 

 

 

 

 

 

 

 

Depends upon the operation being invoked.