Validate Results in Workbook Cells

Use this activity to validate results in workbook cells.

Activity Steps

1. Open a workbook session in normal mode to display the CCWKOP—Workbook Open Detail screen or in transposed mode to display the CCWKOP—Workbook Open Transposed Detail screen.
2. Select cells where results are to be validated.
3. Access the Validate native workbook command (accessed via a workbook menu).
4. Do one of the following:
   1. Click Submit.

      The changes made during the workbook session are saved. Focus returns to the cell selected prior to the submit. Where multiple cells were selected prior to the submit, focus returns to the last selected cell.

   2. Click Submit and Close.

      The changes made during the workbook session are saved and the sheet is closed.

   • Given the sample scheme analyte's Workflow Status is Released, and either no validation results user group is defined, or the user is a member of that group, and the sample scheme analyte's Composite QC Status is not one of the failure statuses, as per the restrictions outlined above, then the sample scheme analyte is validated.
   • When a sample scheme analyte is validated, the sample scheme analyte's Workflow Status is set to Completed if it is not already Listed Not Received, Insufficient Sample, Not Analysed or No Result (in which case, it is left as that), its Validated Date is stamped and Validated By is set to the current user.
   • When a sample scheme analyte's Composite Specification Status, Composite QC Status or Workflow Status is updated, the cascade engine re-evaluates these statuses up the respective production and/or laboratory batch job trees. Refer to Appendix—Cascade Engine.
   • Conditions for Calculating Expiry and Warning Dates
   • Conditions for Auto-calculation of Ready Dates