Skip to Content
0

How to get Inspection Types to write to both QASR and QASE tables

Apr 13, 2017 at 03:06 PM

16

avatar image

I am trying to create a SQVI query for all QM test results. However, I am struggling with the fact that some Inspection lots are only writing results to either QASR or QASE tables & not both. Some Inspection Types are triggering writing to both tables, but others only write to QASE or QASR. Thus, it is currently not possible to write one SQVI to get results from all Inspection Types to appear on the same query/report.

I know there is a master data setting which impacts this - In Control Indicators, the Results confirmation section will impact this if pick "Summ recording" or "Single Result" options. However, beyond that, I cannot find anywhere in config or master data which will help with this.

Do you have any suggestions on how to get all results, for all Inspection Types, to write to both QASR and QASE, regardless of whether there is more than one result per inspection point or not (depending on the assigned Sample Procedure)?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers