How To Use The [OPEN_QUERY] placeholder (Doc ID 1467195.1)

Last updated on MARCH 10, 2017

Applies to:

Oracle Argus Safety - Version 5.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 30-Mar-2014***
***Checked for relevance on 11-Sep-2015***

Goal

In older versions of Argus Safety the place-holder [missing_fields] could be incorporated in a letter template.  This place-holder would find fields in the Case Form which have no information available and, by incorporating this in the letter template, automatically report the fields in the generated letter as requiring information.

The system looked at the following fields:


Outcome of Event
Event Reported Serious?
Event Onset Date/Time 
Patient Age Group 
Patient Ethnicity 
Patient Gender 
Patient Pregnancy 
Patient Age 
Patient Initials
Product Generic Name
Reporter Health Care Professional
Reporter Country
Reporter Last Name
Reporter Phone Number
Was study code broken by investigator?

In version 5.0 of Argus Safety a more powerful and versatile place-holder was created called [OPEN_QUERY] in which all the the Letter Place-holder Content of any outstanding Action Items for a case can automatically be incorporated in a generated letter.  An example follows.  

Please note that the system can be configured to be much more expansive in it's error reporting than this simple example

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms