Additional Filter to Include Findings Records

The Additional Filter to Include Findings Records field is an optional parameter that enables you to filter Findings Records from the domain-specific data set chosen for analysis (specified by the Findings Domain to Analyze). Only those observations that meet all of the conditions specified in this field are included in the analysis.

Tip: It is recommended that you use the Findings Test Short Name variable with suffix TESTCD.

Important: For Vital Signs or ECG tests, if the variable with suffix POS exists (for example, VSPOS), this value is concatenated to the TESTCD variable prior to WHERE statement filtering. For example, type VSTESTCD = “HR SUPINE” to plot heart rate tested in supine position only. Type VSTESTCD contains “HR” to plot heart rate tested at all positions. For Lab Tests, if the variable with suffix SPEC exists (for example, LBSPEC), this value is concatenated to the TESTCD variable prior to where statement filtering. For example, type LBTESTCD = “GLUC BLOOD” to plot blood glucose levels only. Type LBTESTCD contains “GLUC” to plot glucose levels in all specimens.

For more information about using filter fields, see The WHERE Expression.