Hi

It is quite common that lab may miss out some tests in the EDT file.
>From sponsor point of view, may i know how best we can detect missing
tests during batch loading process (or afterwards) in Oracle Clinical
so that the missing tests are logged into the "discrepancy database".

or do we have to use a PL/SQL to do it which sort of have to be done
"outside" the OC system.

for some advice please
Thank you
Boon Yiang

chuaby@hotmail.com wrote:
> Hi
>
> It is quite common that lab may miss out some tests in the EDT file.
>>From sponsor point of view, may i know how best we can detect missing
> tests during batch loading process (or afterwards) in Oracle Clinical
> so that the missing tests are logged into the "discrepancy database".
>
> or do we have to use a PL/SQL to do it which sort of have to be done
> "outside" the OC system.
>
> for some advice please
> Thank you
> Boon Yiang

You have posted insufficient information from which anyone can provide
help. Fix your business processes.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org