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)

Options: ReplyQuote


Subject
Written By
Posted
S D
March 03, 2018 04:56PM
Re: Store Specs With Trial?
S D
March 03, 2018 07:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.