Re: Store Specs With Trial?
Posted by:
S D
Date: March 03, 2018 07:45PM
A Spec is a document for a particular Product, describing how to prepare the equipment (TrialSetup) and the acceptable limits (TrialResultLimits).
Each Spec document starts at Revision 1 (which I already implement). Trials actually reference a SpecRev. When a new Rev is approved, I add a new Rev to the database and mark the previous Rev as inactive.
If all lab testing strictly followed a Spec, I would not even consider duplicating or "snapshots."
The special cases add complexity.
- For regular testing, sometimes a one-time override is approved.
- For special testing, there is no Spec document.
Since, in these cases, I don't have a paper SpecRev document to reference, how do I store how the Trial was prepared and the acceptable limits?
Option 1: Store a copy
For regular testing, populate (preload) Trial form with the TrialSetup and TrialResultLimits from the latest SpecRev for the Product.
For overrides, modify the preloaded Trial form entries.
For special testing, nothing is preloaded, so all entries must be entered.
Option 2: One-time SpecRev
For regular testing, point to the latest SpecRev.
For overrides, copy the SpecRev to a new, one-time, inactive SpecRev.
For special testing, create a new, one-time, inactive SpecRev.
Option 3: ??? (open to suggestions)