Skip Headers
Oracle® Clinical Remote Data Capture Classic Data Entry User's Guide
Release 4.6.2

Part Number E18824-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

15 Search Window

The Search window is one of two tools you use to specify a workset in the RDC Classic Spreadsheet (the other is the Activity List Window). In contrast to the Activity List window, which allows you to indirectly query the study database by choosing an activity, the Search window gives you direct access to define search criteria that results in a workset with a specific set of patient data. You can use the Search window to define search criteria that return a workset as broad – all the patient data you to which you have access – or as narrow – a single CRF – as your task requires.

This section describes the terminology, structure, and components of the Search window. The topics that are covered in this section are:

Refer to "Using the Search Window to Select Worksets" for information about how to define search criteria that allow you to complete common RDC Classic tasks.

Discussion

This section provides a description of how the Search window is organized, how to access it, the terms that are used to describe it, and the methods you can use to navigate to the various Search window components.

The Search window is central to using RDC Classic effectively because it allows you to specify which data that comprise the workset. By changing Search window criteria, you change the patients and/or CRFs that are available for your tasks. The functionality of the Search window allows you to select a subset of data that is as wide or as narrow as you require.

The Search window allows you to view the current set of search criteria in a single view. It also provides the entry point to change each criterion.

Note:

Refer to "Strategies to Best Use the Search Window" for a discussion of how setting different Search window criteria can limit the CRFs that are available for other criteria and affect the overall set of CRFs retrieved in the workset.

Figure 15-1 RDC Classic Search Window

Description of Figure 15-1 follows
Description of "Figure 15-1 RDC Classic Search Window"

Retrieving Data with the Search Window

The data that comprise a clinical study can be extensive. When you use the default settings in the Search window, the resulting workset consists of all of the CRFs to which you have access. The primary purpose of the Search window is limit the workset so you can work with a manageable set of data that is directly applicable to your task.

For example, if your task is to approve CRFs, it is generally unnecessary to include CRFs that are already approved in the workset. You can use the Search window to limit the workset so that it consists of only those CRFs that are eligible for approval. You use the Search window to define the current workset during an RDC Classic session.

It is important to recognize when the workset consists of all of the data available to you and when it consists of a portion of that data. This information is continuously displayed in the Title Bar of the Main Application Window, the Data Entry window status bar, and the RDC Classic Spreadsheet status line. In addition, the current value of each criterion is displayed in a status line in the Search window. This status line is located just to the right of each criterion label and allows you to quickly know if the it is at its default value.

Terminology

This section discusses certain terms that are used to describe the components of the RDC Classic Search window. Refer to the Glossary for complete definitions of RDC Classic-specific terms.

The terms that are used to describe the Search window are:

Access the Search Window

The method you use to access the Search window is, to a certain extent, dependent on the configuration of your RDC Classic session. Specifically, it depends on the tool that is your default method to display a workset in the Spreadsheet. This section consists of the following topics:

Session Startup

If the Activity List window is not configured for your session, the system displays the Search window as part of the session initiation process. It is displayed after you are logged in to the database and a study is selected. Refer to "Start Your RDC Classic Session" for information about session startup, study selection, and other windows that may display before the Search window displays.

Change Current Study

When you change the current study, the system displays the search window to allow you specify the workset for new study (if the Activity List window is not configured for your session). Refer to "Change the Study During an RDC Classic Session" for information on this procedure.

During a Session

The Search window is displayed as part of the RDC Classic startup process and when you change studies. If you want to modify your search criteria at any other point in your RDC Classic session, you have two options:

  1. Default values - Select File, then New Search from the option list to open the Search window with all criteria set to default values.

  2. Current values - Select either File, then Modify Search from the option list or the Search button in the Spreadsheet to open the Search window with all of the criteria set to current values. The Search button is available when the Activity List window is not configured for your session.

New Search Window

The New Search command opens the Search window with the default values set for all parameters and criteria. This command is helpful when you want to "start over" and define a new set of search criteria. Use this option if:

  • you want to use the default settings, that is, you want to retrieve all of the data that you have permission to access

  • there are many criteria currently set and you want to "start over" with the default criteria settings and modify criteria from that point.

To open the Search window in this mode, select File, then New Search from the option list.

Modify the Search Window

The Modify Search command opens the Search window with the parameters and criteria set to the values used to specify the current workset. This command is helpful when several criteria are not set to default values and you want to make minor changes to a few parameters.

To open the Search window you can either:

  • click the Search button (if the Activity List window in not configured for your session), or

  • select File, then Modify Search from the option list.

From the Activity List Window

When the system displays the Activity List window, you can use the Search button in the lower right-hand corner of the window to access the Search window. You can also use the New Search and Modify Search commands, which are components of the File menu, during the session.

The New Search menu command opens the Search window with criteria set to default values. However, the Modify Search commands opens the Search window with criteria set to the values defined by the last task you selected in the Activity List window (assuming you have not used the Search window to modify search criteria prior to this instance).

Search Window Components

The Search window (refer to Figure 15-1, "RDC Classic Search Window") encompasses the components and functionality that allow you to choose subsets of the study data. It provides the necessary navigation buttons, drop-down lists, text messages, and basic window functionality that enables you to efficiently and accurately select the appropriate criteria for the task at hand.

The Search window criteria transition from general to more specific as you move down in the window. You use the first two criteria, Book and Site, to establish the general set of data with which you want to work. The remaining five criteria allow you to "drill-down" into parameters that allow you to define narrower worksets.

The general components that comprise the Search window are listed and described in Table 15-1, "Components of the Search Window".

Table 15-1 Components of the Search Window

Component Type Description

Book criterion

Drop-down list

Allows you to change the setting for the Book criterion. This component cannot be altered if only one book is associated with the current study.

Site Criterion

Drop-down list

Allows you to change the setting for the Site criterion. This component cannot be altered if you have access to one site.

All...

Button

Allows you to set a criterion to its default by resetting each of its parameters. The button is only active when the criterion is set to a non-default setting.

Specify...

Button

Opens the criterion-specific subsearch window, identified by the adjacent label. The subsearch windows allow you to modify the default criteria values.

OK

Button

Closes the Search window, places focus in the first patient row and first CRF column in the Spreadsheet, and loads the workset that satisfies the current search criteria.

Load Search

Button

Opens the List of Saved Searches Window, which allows you to load a saved search in the Search window.

Cancel

Button

During a session, reverts to the current workset without altering the search criteria.

At session startup or during the process of changing the study, opens a window that allows you to:

Change Study

Button

Opens the Change Study Window. If you have access to one study, the button is inaccessible.


There is one All... and one Specify... button for each of the following criteria:

Book Criterion

The Book criterion allows you to specify the Book that you wish to work in. It includes a drop-down list, which allows you to select any book in the current study. When you choose a book other than the default, the Default Book button becomes active. This allows you to quickly switch back to the default book.

A Note about books in RDC Classic:

A book in RDC Classic is the electronic equivalent a hard-copy casebook. It consists of a collection of CRFs.

Access

When you access the Search window upon login or when you initiate a new search, the name of the Default Book is automatically selected in the drop-down list. When you open the drop-down list, you can view all of the books that are defined for the current study.

Components

The Book criterion section of the Search window consists of a:

  1. drop-down list of books that are available in the current study

  2. Default Book button.

Usage

There is always a default book assigned to each study. When you launch RDC Classic, change to a new study, or select File, then New Search from the option list, the default book is automatically selected for the Book criterion. If you select File, then Modify Search or the Search button on the Spreadsheet, the book that you selected previously in the session is the active book.

The Default Book button remains inactive until you select a non-default book. If you click the Default Book button when it is active, the Book criterion reverts to its default value.

Whatever value is selected for the Book criterion, it does not limit the data that is displayed in the Spreadsheet. All patients with data that meet the rest of the Search window criteria are displayed in the Spreadsheet. CRFs for patients that are not assigned to the active book are displayed as unplanned pages in the Spreadsheet.

Use the Book criterion drop-down list box to change to another book.

Note:

If there is only one book defined for the current study, the drop-down list box is inactive.
Change the Book

To change from the default book to a non-default book or from a non-default book to any other non-default book:

  1. Click the Book criterion drop-down list arrow.

  2. Locate the name of the book you wish to activate and select it. If necessary, use the scroll bar to view all choices.

  3. Either:

    1. Click the OK button to close the Search window, or

    2. Select any other criteria that are necessary to your task.

Change to the Default Book

To change from a non-default book to the default book:

  1. Open the Search window.

  2. Click the Default Book button.

    Description of btn_dflt_bk_act.gif follows
    Description of the illustration btn_dflt_bk_act.gif

  3. Either:

    1. Click the OK button to close the Search window, or

    2. Select any other criteria that are necessary to your task.

Note:

The Default Book button is only active when a non-default book is selected.

Site Criterion

The Site criterion allows you to specify either one site or all of the sites that you have permission to access within the currently active Study. Note that the list of sites that are presented is not dependent on the Book criterion.

Access

You access the Site criterion by opening the Search window. Refer to "Access the Search Window" for information on how to open the Search window throughout an RDC Classic session.

Components

The Site criterion section of the Search window consists of a:

  1. drop-down list of sites that are available in the current study

  2. All Sites button.

Usage

When you access the Search window upon login or when you initiate a new search, the value of the Sites criterion is either the name of the Site to which you are assigned or, if you have access to more than one site, "ALL" sites. If you have access to more than one site, when you open the drop-down list you can view all of the sites to which you have access and you can select any one of them.

If you have access to more than one site, the All Sites button remains inactive until you select a particular site.

If you have access to only one site, the drop-down list and the All Sites button remain inactive.

Change to a single site

When you navigate to the Search window from the Select Study window or if you open the Search window by selecting File, then New Search, the Sites criterion is set to "<ALL>". To change to a single site:

  1. Click the drop-down list arrow to view all of the sites to which you have access

  2. Use the scroll bar, if necessary, to locate a site.

  3. Click the site name to select it.

Change to ALL Sites

When the Site criterion is set to a non-default value, that is, when you have selected a single site, the All Sites button is active.

Description of btn_dflt1.gif follows
Description of the illustration btn_dflt1.gif

To change the Site criterion from a single site to all sites, click the All Sites button.

Multi-Parameter Criteria

After Book and Site, the remaining criteria are managed in individual subsearch windows because each is comprised of multiple parameters. You use the subsearch window to modify these parameters. The components and usage of each of these windows is described in "Subsearch Windows".

Access

You access the criteria by opening the Search window, which may be presented at session startup and is accessible during your session. (Refer to "Access the Search Window" for information on how to open the Search window throughout an RDC Classic session.)

You access an individual criterion by clicking its associated "Specify..." button. When you click it, the system opens the subsearch window for that criterion.

Components

The Search window components for each criteria consists of a default button and a "Specify..." button.

Usage

The default button for each criteria is active or inactive based on the current value of the criterion.

  • If the criterion is set to its default value, the button is inactive.

  • If the criterion is set to a non-default value, the button is active.

When the default button is active, it allows you to quickly reset all of the parameters to default values, which, in turn, sets the criterion to its default value.

The Specify... button is always active. When you click it, the system opens the subsearch window for that criterion. The current setting of each parameter that comprises the criterion is displayed in the window.

Search Window Usage

This section describes general Search window functionality. It consists of the following topics:

Refer to "Select a Workset" for topics that describe using the Search window to accomplish specific tasks.

Using the Book and Site Drop-Down List Boxes

You use drop-down list boxes to set the Book and Site criteria. By default, these criteria are set to the following settings:

  • The book is set to the default book for the study.

  • Site is set to:

    • <ALL> if you have privileges at more than one site

    • an individual site if you have privileges at one site.

You use the drop-down list to view and select other settings that are available. If more than one book is defined for the study, use the drop-down list to select one. If you have access to more than one site, use the Site drop-down list to make a selection.

If the CRFs to which you have access are defined in only one book or only one book is defined for the study, the drop-down list is not accessible. Similarly, if you have access to only one site, the Site drop-down list no accessible.

Using the Default Buttons

There is a default button adjacent to each criteria. It remains inactive until you change one or more parameters that alter the criteria setting to something other than default. When you click an active default button the system reverts the relevant criteria to its default status.

Using the Specify... Buttons

The Specify... button is adjacent to all of the criteria, except Book and Site. It gives you access to the Subsearch window associated with the criteria that is specified in its associated criterion.

Figure 15-2 Specify Button

Description of Figure 15-2 follows
Description of "Figure 15-2 Specify Button"

The Subsearch window enables you to change the parameters that comprise a given criteria. As illustrated in Figure 15-4, "Patients Subsearch Window", a subsearch window consists of drop-down lists and buttons that you use to choose the parameters.

Within a subsearch window, use the OK button to save the changes you make to parameters and the Cancel button to revert to the previously saved parameters.

Using the Cancel Button

The functionality of the Search window Cancel button depends on the task on which you are working.

Session Startup

If you click the Cancel button during session startup, the system displays an action window that allows you to choose to:

  1. Change the study – opens the Change Study window

  2. Exit RDC Classic – closes the application

  3. Return to Search

Figure 15-3 Message Window from Cancel on Search Window

Description of Figure 15-3 follows
Description of "Figure 15-3 Message Window from Cancel on Search Window"

During a Session

If you click the Search window Cancel button during a session, the system discards any changes you have made to any criteria, reverts to the current search criteria, and closes the Search window.

Using the Change Study Button

If the Search window is open and you want to change the current study, you generally have to close the Search window, by clicking either the OK or Cancel buttons, and select File, then Change Study from the option list to open the Select Study window.

However, if a study is not already open, you can navigate directly from the Search window to the Select Study window and change the study. To do this:

  1. In the Search window, click the Cancel button.

    Note:

    If a study is already open when you click the Cancel button, the Search window simply closes and previously selected criteria remain active.
  2. An action window is displayed (refer to Figure 15-3), which allows you to:

    • Change studies, which opens the Select Study window

    • Exit the form, which closes RDC Classic

    • Return to Search, which closes the current window and moves focus back to the Search window.

  3. Click the "Change study" button.

  4. The Select Study window is displayed.

  5. Use the Select Study window as you normally would.

Subsearch Windows

This section describes the Search window criteria that are managed with a subsearch window. All search criteria, with the exception of the Book and Site criteria, consists of multiple parameters that combine to give each criterion its value. You use the subsearch windows to modify the parameters.

This section consists of the following topics:

Patients Subsearch Window

The Patients criterion allows you to display CRFs based on the following parameters:

Access

When you click the appropriate Specify... button on the Search window, the Patient Subsearch window is displayed, which gives you access to the parameters that define the Patients criterion.

Figure 15-4 Patients Subsearch Window

Description of Figure 15-4 follows
Description of "Figure 15-4 Patients Subsearch Window"

Components

The components that comprise the Patients Subsearch window are listed and described in Table 15-2, "Patients Subsearch Window Components". The scope and usage of each parameter are described in subsequent sections.

Table 15-2 Patients Subsearch Window Components

Parameter Type Description

Patient

Drop-down list boxes or LOV

Allows you to specify either a single or a range of patient numbers.

Freeze Status

Drop-down list box

Allows you specify the freeze status of patients.

Missing Pages

Drop-down list box

Allows you specify if the workset should include missing pages.

Overdue Visits

Drop-down list box

Allows you to specify if there are overdue visits associated with the patients.


In addition to the parameter-specific components, the window also contains an OK and a Cancel button.

Default Parameters

The default criterion is for all patients to be selected, therefore each parameter is set to "ALL" by default. This causes the search process to consider all patients that are associated with the currently selected Site criterion. The resulting workset will include all patients with at least one CRF that satisfies the search criteria.

Patient Parameter

The Patient parameter consists of two related fields that, when taken together, define an inclusive range of patient numbers. The default setting is "All", which retrieves all of the patients that your user name has access to under the currently defined Study and Site.

The list of patient numbers is dynamic: when you select the starting patient number, the patient numbers that are available in the second drop-down list start at the first value after the value in the first field.

Note:

For system performance reasons, the Patient From and To fields use drop-down lists when the number of patients to display is less than 501. If the number of patients to display is greater than 500, the system displays the set in an LOV window.

Using this parameter, you can retrieve data for:

  • all patient numbers – This is the default setting for the Patient number range parameter. It causes the search to include all patients to which you have access in the study database for which at least one CRF is created.

  • a single patient number – This setting is unique, in that it is not necessary for a CRF that satisfies the search criteria to exist. If all subsequent criteria, that is, Visit/Pages, CRF Status, etc., are set to default values, the patient number is displayed, even if a CRF has not yet been created for the patient. This allows you to use the parameter to initiate data entry for a specific patient number.

  • a contiguous range of patient numbers – This setting allows you to limit the search criteria to specific set of contiguous patient numbers. You use both drop-down list boxes: in the first, select the starting, or lower value; in the second, select the ending, or upper value.

Freeze Status Parameter

This parameter restricts the retrieved data based on whether the patient is frozen or not. This allows you to choose to work only with unfrozen patients (e.g., for a data entry session), or to work only with frozen patients (e.g., for data review sessions).

There are three possible settings for this parameter:

  1. All pages - does not limit the search based the freeze status of the patient

  2. Frozen - only frozen patients

  3. Not frozen - selects only those patients that are not frozen.

Missing Pages Parameter

This Patients Subsearch parameter allows you to restrict the data that is retrieved for a session based on whether there are missing pages for a patient.

The system considers a CRF to contain a missing page if it contains a section that should have been collected (according to the protocol) for the current patient.

There are three options for this parameter:

  1. All (default) - does not limit the search based on the presence or absence of missing CRFs

  2. With - only patients that include CRFs with missing pages

  3. Without - only patients that do not include CRFs with missing pages.

Overdue Visits Parameter

This Patients Subsearch parameter allows you to restrict the data that is retrieved for a session based on the absence or presence of overdue visits.

Tip:

Use this parameter to quickly display all patients that are currently overdue for a study visit.

There are three options for this parameter:

  1. All (default) - does not limit the search based on the presence or absence of overdue visits.

  2. With - only patients that have overdue visits

  3. Without - only patients that do not have overdue visits.

Usage

This criterion is useful if you have a certain set of patients with which you want to work. For example, to enter data for patient numbers 1 through 10, you can simply use the Patient Range parameter to display only those patients in the Spreadsheet.

Select a Single Patient Number

If you wish to display a single patient number in the Spreadsheet, you may choose a patient number that either contains or does not contain data.

Tip:

You can use this procedure to initiate data entry for a patient that does not contain data.

To select a single patient number:

  1. In the Patients Subsearch window, use the first Patient parameter drop-down list box to select the patient number.

  2. Click the OK button. The system closes the Patient Subsearch window and returns focus to the Search window.

Include a Range of Patient Numbers

To define a range of patient numbers:

  1. In the Patients Subsearch window, use the first Patient drop-down list box to select a starting patient number.

  2. Use the second Patient drop-down list box to select an ending patient number.

  3. Click the OK button. The system closes the Patient Subsearch window and returns focus to the Search window.

Note:

If you select a range of patients and none of the patients in the set contain data, only the first patient in the range is displayed in the Spreadsheet.
Include Patients Based on Freeze Status

To change the Freeze Status parameter:

  1. In the Patients Subsearch window, use the Freeze Status drop-down list box to select a freeze status.

  2. Click the OK button. The system closes the Patients Subsearch window and returns focus to the Search window.

Note:

You can use this procedure as a template to alter the "Missing pages" and "Overdue Visits" parameters.

Visit/Page Range Subsearch Window

You use the Visit/Page Range subsearch window to change the Visits/Pages criterion. The parameters that comprise this criterion allow you to define a data set that is based on the following parameters:

  1. Phase

  2. Visit

  3. Page

  4. Page status

  5. Show all unplanned pages?

The parameters are arranged in order, with the parameter with the largest scope, Phase, at the top of the window. When you change a parameter from its default value, it generally limits the scope of subsidiary parameters. For example, if you set the Phase parameter to "Phase 1", the visits that are available in the Visits parameter are limited to those that are part of Phase 1.

Access

When you click the appropriate Specify... button on the Search window, the system displays the Visit/Page Range Subsearch window, which gives you access to the parameters that define the Visit/Page Range criterion.

Figure 15-5 Visits/Page Range Subsearch Window

Description of Figure 15-5 follows
Description of "Figure 15-5 Visits/Page Range Subsearch Window"

Components

The components that comprise the Visit/Page Range Subsearch window are listed and described in Table 15-3. The scope and usage of each parameter are described in subsequent sections.

Table 15-3 Visit/Page Range Subsearch Window Components

Parameter Type Description

Phase

Drop-down list box

Allows you to specify a single phase.

Visit

Drop-down list boxes

Allows you to specify either a single visit or a range of sequential visits.

Page

Drop-down list boxes

Allows you to specify either the name of a single page number or a range of sequential page numbers.

Page status

Drop-down list box

Performs the action you initiated on the Approval task tab and closes the window.

Show all unplanned pages?

Check box

Specifies the initial setting of the Hide/Show Unplanned pages toggle button.


In addition to the parameter-specific components, the window also contains an OK and a Cancel button.

Default criterion

The default criterion is for all visits and pages to be selected, therefore each parameter controlled by drop-down list boxes is set to "ALL". This causes the search process to consider all visits that are associated with the currently selected Site criterion.

Phase parameter

The Phase parameter allows you to choose either all of the phases in the book, which is the default setting, or a single phase.

Visit parameter

The Visit parameter consists of two related fields that, when taken together, define an inclusive range of visits. The default settings is "ALL," which allows the search to consider all visits.

The list of visits is dynamic:

  • when you select a single phase (using the Phase parameter), the visits that are available in the first drop-down list box are limited to those that are associated with the selected phase

  • when you select the starting visit number in the first drop-down list box, the visits that are available in the second start at the first visit after the value in the first field.

Using this parameter, you can retrieve data for:

  • all visits – This is the default setting for the Visit parameter. When the parameter is set to this value, the search will include all of the visits that are available.

  • a single visit – When you select a value in the first, but not the second, drop-down list box, the search is limited to that single visit.

  • a range of visits – This setting allows you to limit the search to specific set of sequential visits. You use both drop-down list boxes: in the first, select the starting, or earlier, visit; in the second, select the ending visit.

Page parameter

The Page parameter consists of two related fields that, when taken together, define an inclusive range of CRF page numbers. The default settings is "ALL," which allows the search to consider all CRF pages.

The list of pages is dynamic:

  • when you select a single visit (using the Visit parameter), the CRFs that are available in the first drop-down list box are limited to those that are associated with the selected visit

  • when you select the starting CRF page number in the first drop-down list box, the pages that are available in the second start at the first page number after the value in the first field.

Using this parameter, you can retrieve data for:

  • all CRF pages – This is the default value for the Page parameter. When it is set to the default, the search includes all available CRF pages.

  • a single CRF page – When you select a value in the first drop-down list box, but not the second, the search is limited to a single CRF page number.

  • a range of CRF page numbers – This setting allows you to limit the search to a specific set of sequential CRF page numbers. You use both drop-down boxes: in the first, select the starting, or lower, CRF page number; in the second, select the ending number.

Page status parameter

The Page status parameter consists of a single drop-down list box in which you can specify that the search be limited to either planned or unplanned CRFs.

The default setting is to retrieve all pages. When the default is selected, the CRFs for all planned pages are displayed in the Spreadsheet and the "Show Unplanned Pages" button is displayed in the first column header after the last planned paged column.

Using this parameter, you can retrieve data for:

  • all CRF page – This is the default value. When the parameter is set to this value, the search includes both planned and unplanned CRFs.

  • planned pages only – When you select this value, by selecting "Planned" in the drop-down list box, the search includes only those CRFs that are planned for the current book. In addition, the system forces the Show all unplanned pages? parameter check box to clear and does not permit it to be selected; in the RDC Classic Spreadsheet, the "Hide/Show Planned Pages" toggle button is unavailable.

  • unplanned pages only – When you select this value, by selecting "Unplanned" in the drop-down list box, the search only includes those CRFs that are not planned for the current book. In addition, the system automatically selects the Show all unplanned pages? parameter check box; in the RDC Classic Spreadsheet, the "Show/Hide Unplanned Pages" toggle button is not available because only unplanned pages are displayed in the Spreadsheet.

    Note:

    When you choose "Unplanned" in the Page Status drop-down list, the "Show all unplanned pages?" check box is automatically selected.
Show all unplanned pages? parameter

This parameter consists of a check box that causes the system to automatically display unplanned pages without use of the "Show/Hide Unplanned Pages" toggle button.

The default setting is for this parameter to be not active. This setting causes the "Show Unplanned Pages" button to be displayed in the first empty column after the planned pages for each visit.

If you select this parameter the check box to select this parameter, unplanned pages are displayed in the Spreadsheet and the "Hide Unplanned Pages" button is displayed in the first empty column after the unplanned pages for each visit.

This parameter has a direct dependency on the Page status:

  • If the Page Status is set to "Planned Pages," the system sets this parameter to its default setting, that is, the check box is clear. It also prevents you from selecting it.

  • If the Page Status is set to "Unplanned Pages," the system sets this parameter to its non-default setting, that is, the check box is selected.

Usage

The Visit/Pages Range Subsearch window allows you define a data set that is based on:

  • the study phase

  • a visit or a range of visits

  • a page or range of pages

  • the planned/unplanned status of pages

In addition, you can specify whether or not you want unplanned pages to be displayed automatically.

Select all visits in a phase

You use the Phase drop-down list box to view all phases in the current book. To limit the search criteria to a single phase, select an item in the list.

Select a specific visit

You use the first Visit drop-down list box to select a specific visit. The list includes all of the visits in the current book and possibly limited by the Phase parameter.

Note:

Use these instructions as the basis to set the Page parameter to a single of CRF page numbers.
Select a range of visits

To select a range of visits:

  1. In the Visit/Page Range Subsearch window, use the first Visit parameter drop-down list box to select the starting visit.

  2. Use the second drop-down list box to select the last visit you want to include in the parameter.

  3. Click the OK button. The system closes the subsearch window and returns focus to the Search window.

Note:

Use these instructions as the basis to set the Page parameter to a range of CRF page numbers.
Revert to the Default Values of a Range Parameter

When you have previously changed a range parameter from its default and you want to revert to its default, which typically is "ALL", there are two methods you can use:

  1. Use the All Visits button on the Search window - this reverts all parameters in the Visit/Page Range Subsearch window to default values.

  2. In the relevant parameter, select "ALL" in the starting (i.e., the left-hand) drop-down list box.

Exclude Planned or Unplanned CRFs

To set the Page Status parameter:

  1. In the Visit/Page Range Subsearch window, use the Page status parameter drop-down list arrow to select either value.

  2. Click the OK button. The system closes the subsearch window and returns focus to the Search window.

CRF Status Subsearch Window

The CRF Status Subsearch window allows you to modify the CRF Status criterion. It allows you to set the following parameters:

  1. CRF Status

  2. Discrepancy Status

  3. Verification Status

  4. Approval Status

  5. Lock Status

Access

When you click the appropriate Specify... button on the Search window, the system displays the CRF Status Subsearch, with each parameter set to its current value.

Figure 15-6 CRF Status Subsearch Window

Description of Figure 15-6 follows
Description of "Figure 15-6 CRF Status Subsearch Window"

Components

The CRF Status Subsearch window consists of five drop-down list boxes, which you use to change the value of each parameter, and two buttons.

Table 15-4 CRF Status Subsearch Window Components

Component Type Description

CRF Status

Drop-down list box

Allows you to specify the data entry status of CRFs.

Discrepancy Status

Drop-down list box

Allows you to specify the discrepancy status of CRFs.

Verification Status

Drop-down list box

Allows you to specify the verification status of CRFs.

Approval Status

Drop-down list box

Allows you to specify the approval status of the CRFs.

Lock Status

Drop-down list box

Allows you to specify the lock status of the CRFs.


In addition to the parameter-specific components, the window also contains an OK and a Cancel button.

Default Parameters

The default criterion is for all CRFs to be selected, therefore, each parameter is set to "ALL" by default. This causes the search process to consider all available CRFs without regard to the different CRF statuses.

CRF Status Parameter

The CRF Status parameter allows you select data based on the entry status of CRFs. The values that are available for this parameter are listed in Table 15-5, "CRF Status Parameter Settings".

Table 15-5 CRF Status Parameter Settings

Setting Includes

All (Default)

All CRFs, regardless of the data entry status

Blank

CRFs that are marked as blank

Created

CRFs with an entry status of created

Entry started

CRFs with an entry status of entry started

Entry complete

CRFs with an entry status of entry complete

Pass 2 Started

CRFs with an entry status of pass 2 started

Pass 2 Complete

CRFs with an entry status of pass 2 complete

Batch Loaded

CRFs that have been batch loaded


You can use these parameter settings to retrieve CRFs that are all at a certain juncture in the data entry and validation process.

Discrepancy Status Parameter

The Discrepancy Status parameter allows you to retrieve CRFs based on the absence or presence of discrepancies and, if present, the status or designation of the discrepancies in the CRF.

Table 15-6 Discrepancy Status Parameter Settings

Setting Description

All (Default)

Includes all CRFs, regardless of the presence of discrepancies or discrepancy status

Without discrepancies

CRFs that do not contain a open discrepancy

With actionable discrepancies

CRFs that contain at least one active discrepancy that can be acted upon by the current user

With other discrepancies

CRFs that contain at least one other discrepancy that can be acted upon by another user

With actionable or other discrepancies

CRFs that contain at least one open discrepancy

With closed discrepancies

CRFs that contain at least one closed discrepancy


As Table 15-6 indicates, a CRF with several different types of discrepancies can be retrieved using several parameter settings. For example, if a CRF contains both actionable and closed discrepancies, it will be retrieved with the following parameter settings:

  • All

  • With actionable discrepancies

  • With actionable or other discrepancies

  • With closed discrepancies

Verification Status Parameter

The verification status parameter allows you to retrieve a set of CRFs that are at the same point in the verification process. Table 15-7 describes the five settings available for this parameter.

The default value for the verification status parameter is retrieve all CRFs, of all verification statuses. In order to limit the CRFs retrieved to a set with a certain verification status, use the other settings.

Table 15-7 Verification Status Parameter Settings

Setting Description

All (Default)

Includes all CRFs, regardless of the verification status

Not verified

CRFs that are not assigned a verification status of verified

Verified

CRFs with a verification status of verified

Awaiting re-verification

CRFs with a verification status of awaiting re-verification

Verification undone

CRFs with a verification status of verification undone


Approval Status Parameter

The approval status parameter allows you to retrieve a set of CRFs that are at the same point in the approval process. Table 15-8 describes the five settings available for this parameter.

Table 15-8 Approval Status Parameter Settings

Setting Description

All (Default)

Includes all CRFs, regardless of the approval status

Not approved

CRFs that are not assigned a approval status of approved

Approved

CRFs with a approval status of approved

Awaiting re-approval

CRFs with a approval status of awaiting re-approval

Approval undone

CRFs with a approval status of approval undone


Lock Status Parameter

The lock status parameter allows you to retrieve a set of CRFs that are either locked or unlocked. Table 15-9 describes the three settings available for this parameter.

Table 15-9 Lock Status Parameter Settings

Setting Description

All (Default)

Includes all CRFs, regardless of the lock status

Locked

CRFs that are not assigned a lock status of locked

Unlocked

CRFs with a lock status of unlocked


Usage

You can define the CRF status criterion using any combination of the following parameters:

  • Data entry status

  • Discrepancy status

  • Verification status

  • Approval status

  • Lock status

Include All CRFs of a Given Status

The procedures for modifying a parameter settings are similar for all parameters in the CRF Status Subsearch window. Use the following instructions to change each parameter:

To change a parameter setting:

  1. In the CRF Status Subsearch window, use the appropriate drop-down list box to select a value for the parameter of interest.

  2. Click the OK button. The system closes the subsearch window and returns focus to the Search window.

  3. Click the OK button to close the Search window and cause the system to display the new workset.

For example, you can use this criterion to display in the Spreadsheet only those CRF that are at the "Entry Complete" status, or only those CRFs that contain "Closed" discrepancies.

Use Multiple Parameters to Define the CRF Status Criterion

You can use other parameters in the CRF Status subsearch window to further limit the data set. For example, by combining the "Entry Complete" setting for the CRF Status parameter and "Not verified" setting for the Verification status parameter, you can include in the workset those entry complete CRFs that are not verified.

CRF/Visit Dates Subsearch Window

The CRF/Visit Dates criterion allows you to retrieve a set of CRFs that is based on when either CRFs and/or discrepancies are created and/or modified. Unlike most other subsearch windows, the CRF/Visit Dates Subsearch window is not divided into discrete parameter-based components.

You use the CRF/Visit Subsearch window, which the graphic in Figure 15-7, "CRF/Visit Dates Subsearch Window" depicts, to define a series of parameters that, when taken together, form a phrase that RDC Classic uses to search the data and retrieve a set of CRFs that satisfy the search phrase.

Essentially, you construct a search phrase that answers the questions, "What happened?" and, "When did it happen?" In addition, you can use the "Visit dates from" parameter to further constrain the search.

Access

When you click the appropriate Specify... button on the Search window, the system displays the CRF/Visit Dates Subsearch window, with each parameter set to its current value.

Figure 15-7 CRF/Visit Dates Subsearch Window

Description of Figure 15-7 follows
Description of "Figure 15-7 CRF/Visit Dates Subsearch Window"

Components

The CRF/Visit Date Subsearch window consists of five drop-down list boxes. You coordinate four of them to construct a search phrase. The fifth, "Visit data from," is optional, but, if used, further limits the search phrase. Each parameter is listed and described in Table 15-10, "CRF /Visit Dates Subsearch Window Components".

Table 15-10 CRF /Visit Dates Subsearch Window Components

Component Type Description

CRFs/Discrepancies

Drop-down list box

Allows you to specify the subject of the search phrase

Created/Modified

Drop-down list box

Allows you to specify the action of the search phrase

Time Frame

Drop-down list box

Allows you to specify a time frame for the search phrase

Timestamp

Combination list box(es)

Allows you to specify a timestamp, or a time period, that defines the time frame, by either selecting a system-provided date or typing a date in the field

Visit Date

Drop-down list boxes

Allows you to limit the search phrase based on a visit date range

OK

Button

Saves the settings in the window, closes it, and reverts focus to the Search window

Cancel

Button

Discards changes to the settings in the window, closes it, and reverts focus to the Search window


Default Criterion

The default setting for this criterion is for all CRFs to be selected, which means that none of the parameters on the CRF/Visit Dates Subsearch window are set.

CRFs/Discrepancies Parameter

This parameter consists of the first of two drop-down list box fields adjacent to the "Where" label. You use the two fields in combination to form part of search phrase. Table 15-11 describes the three settings for the CRFs/Discrepancies parameter.

Table 15-11 CRFs/Discrepancies Parameter Settings

Setting Description

CRFs

The search phrase will pertain to CRFs only

Discrepancies

The search phrase will pertain to discrepancies only

CRFs or Discrepancies

The search phrase will pertain to either CRFs or discrepancies


Created/Modified Parameter

This parameter consists of the second of two drop-down list box fields adjacent to the "Where" label. You use this field to complete the first part of the search phrase. Table 15-12 describes the three settings for the Created/Modified parameter.

Table 15-12 Created/Modified Parameter Settings

Setting Description

were Created

The search phrase only pertains to created timestamps

were Modified

The search phrase only pertains to modified timestamps

were Created or Modified

The search phrase pertains to both created and modified timestamps


Time Frame Parameter

This parameter consists of a drop-down list box that allows you to specify a time frame during which the event defined by the first two parameters occurred. Table 15-13 describes the four settings for the Time Frame parameter.

Table 15-13 Time Frame Parameter Settings

Setting Description

Before

The search is limited to dates that occurred before the Timestamp parameter

On

The search is limited to the date specified by the value of the Timestamp parameter.

On or After

The search is limited to date that occurred on and after the value of the Timestamp parameter.

Between

The search is limited to the period between the two timestamps. You must select a value for each timestamp field.


When you select the "Between" value, the system changes the Timestamp parameter so that two timestamps can be set, which define a time period.

Timestamp Parameter

This parameter consists of one or two fields. You use combination list boxes to set the value of each. The number of fields you use depends on the value of the Timestamp parameter. If its value is "Between", the system displays a second field that allows you to select a second timestamp as the ending point of the period.

The values that are available for this parameter are simply a list of dates in the previous year. You also have the option of typing a date directly in either of these fields that is not in the LOV. Use the same date format that you would for a data entry date field.

The date that you enter in the second timestamp field must be greater, that is, it must come after, the date you entered in the first field. When you use a second timestamp field, its list of values is restricted to those dates that are after the value you entered in the first timestamp field.

Visit Date Parameter

This parameter consists of drop-down list of all of the visit dates in the currently selected book, although the list may be further constrained by other criteria, such as a visit range specified in the Visit/Page and, as stated above, a default value of "ALL", which includes all of the visit dates in the book in the subsearch.

The "Visit date from" parameter allows you to limit the criterion to a time period that is described by a set of visit dates. In contrast to the other parameters in the window, this parameter is not required in order to construct search phrase. However, you can use this parameter either in conjunction with a search phrase. Alternatively, you can not set the search phrase parameters and use only the Visit Date parameter.

Description of srch_crfdt_subsrch2.gif follows
Description of the illustration srch_crfdt_subsrch2.gif

When you select any value other than the default, the system displays a second field, which also consists of a drop-down list box, which allows you to specify a range of dates. The range extends from the visit date you select in the first drop-down list forward in time to the date you select in the second drop-down list.

Usage

The two basic uses of the CRF/Visit Subsearch window are to construct a search phrase and specify a range of visit dates.

Construct a Search Phrase

Use the CRF/Visit Subsearch window to define a series of parameters that, when processed together, form a phrase that RDC Classic uses to search the data and retrieve a set of CRFs that satisfy the search phrase.

  1. In the CRF/Visit Dates Subsearch window, use the CRFs/Discrepancies drop-down list box to select a subject.

  2. Use the Created/Modified drop-down list box to select the action.

  3. Use the Timeframe drop-down list to select a timeframe for the search. The value you select determines if there is one or two fields in the Timestamp parameter. The "Between" value causes the system to display a second field, which is for the ending timestamp.

  4. Use the drop-down list box(es) to select the value of the Timestamp parameter.

    You can use the "Specify Visit Dates" line to further narrow your search by specifying that the CRFs retrieved by the parameters in the first two lines are restricted by the visit date.

  5. Click the OK button. The system closes the subsearch window and returns focus to the Search window.

Specify Visit Dates

To specify a visit date range in which to search:

  1. Use the first field of the "Visit date from" parameter to select the earliest visit date that you want to define the time period. When you make a selection, that is, when you change the default, the system displays a second field.

  2. Use the drop-down list box in the second field to set the endpoint of the time period:

    1. if you use the default, which is "All," the visit date range that is defined includes all visits dates between the date you set in the first drop-down list and the current calendar date

    2. if you select a date, the visit date range that is defined includes all visits in the time period, inclusive.

  3. Close the subsearch window.

  4. Close the Search window.

Data Subsearch Window

The Data Subsearch window allows you to define a set of parameters that is based on specific data contained in existing CRFs. Use this criterion if you wish to retrieve existing CRFs so that you can review, update, verify, and or approve the data that each contain.

Access

When you click the Specify... button adjacent to the Data label on the Search window, the system opens the Data Subsearch window with each parameter set to its current value.

Figure 15-8 Data Subsearch Window

Description of Figure 15-8 follows
Description of "Figure 15-8 Data Subsearch Window"

Components

The Data Subsearch window consists of seven parameters, several of which use multiple fields. The components are listed and described in Table 15-14, "Data Subsearch Window Components". Fuller descriptions of each parameter can be found in subsequent sections.

Table 15-14 Data Subsearch Window Components

Component Type Description

CRF

Drop-down list box

Allows you to specify the name of a CRF.

Section

Drop-down list box

Allows you to specify the name of a CRF section.

Question Name

Drop-down list box(es)

Allows you to specify a question name as the first part of a Question/Response search phrase.

Relational Operator

Drop-down list box(es)

Allows you to select an operator that joins the Question Name and the Response Value settings.

Response Value

Drop-down list box(es) or text box

Allows you to specify a response value as the second part of a Question/Response search phrase. Each instance of this parameter is active when its corresponding Question Name parameter is set.

If the Relational Operator is set to "=", "Like", or "Not Like", this field is text box that accepts a text search string.

If the Relational Operator is set to "Null" or "Not Null", this parameter is not present.

Boolean Operator

Drop-down list box

Allows you to select an operator that relates the first and the second Question/Response search phrases. This active when the first Response Value parameter is set.

Document Number

Drop-down list box

Allows you to select a document number.

Lab With/Without Subset

Drop-down list box

Allows you to specify the name of a laboratory that supplied data. This is active when the CRF/Section includes laboratory-supplied data.

Qualifying Value

Drop-down list box

Allows you to specify a value to a qualifying question. This is active when the CRF and/or Section contains a qualifying question group.

Comment Type

Drop-down list box

Allows you to specify a type of comment to search.

Comment Text

Text field

Allows you to specify a search string that the system uses to search comments of the type specified in the Comment type parameter. This is active when a Comment type is selected.


Default Setting

The default for the Data criterion is to retrieve all data, without regard to the contents of the CRFs. Consequently, all parameters are either set to "ALL" or are set to NULL, which means that the parameter is not set.

CRF and Section Parameters

The first line of the Data Subsearch window consists of two parameters, labeled "CRF" and "Section". The parameters are related to one another – for example, the value of the CRF parameter may affect the set of values available in the Section parameter. Several of the choices that are available in other subsequent parameters are dependent on the selections you make in these two parameters.

The default setting for both parameters is "ALL", which selects all CRFs and all Sections, respectively.

  • When the Section parameter is "ALL", the CRF parameter may be set to any CRF name in the current book, subject to other, higher-level criteria selections that may restrict the data. When you select a CRF name, the set of values in the Section parameter is limited to the section names that exist in the selected CRF.

  • When the CRF parameter is "ALL", the Section parameter may be set to any section name in the current book, subject to other criteria restricting the data. When you select a value for the Section parameter, the CRF parameter must be set to either "ALL" or a CRF name that contains the section specified in the Section parameter.

  • If you select a section that contains a qualifying value question, the system makes Qualifying Value parameter active.

Question Name

There are two Question name parameters: one for each search phrase that can be constructed in the subsearch window. There is no default value for either parameter. The values that are available in the drop-down lists are dependent on the settings of the CRF and Section parameters. When a CRF, or CRF and CRF section combination are selected, the system populates the first Question Name parameter with all questions in the relevant CRF or section.

The system does not populate the second Question Name parameter with questions until all three parameters in the first Question Name search phrase are set.

There are no default values for the either the Question or the Answer values in either search phrase. However, each of these values remain inactive until a parameter or value that is its antecedent is selected.

Relational Operator

This parameter consists of a drop-down list box that you use to select an operator. Each Question Name search phrase is constructed with a relational operator, which links the Question Name and Response Value parameters. Table 15-15 describes the ten operators that you can use to construct the search phrase.

The equal sign ("=") is the default value for the relational operator, however, it is not displayed until it is required.

When the search is run, if you have not used a wildcard in your search string, the system "wraps" the Response Value in wildcards. The effect of this is the search will match any value that contains the search string.

Also, when you select either the "Null" or the "Not Null" operator, the system removes the Response Value parameter from the search phrase, since it is not required to complete the search.

Table 15-15 Values for the Relational Operators in the Data Subsearch Window

Operator Description

=

Only includes data that matches the response value; can be used with either numeric or alphabetic data.

<>

Only includes data that does not match the response value. Use for numerical data only.

>

Only includes data that is greater than the response value. Use for numerical data only.

>=

Only include data that is greater than or equal to the response value. Use for numerical data only.

<

Only includes data that is less than the response value. Use for numerical data only.

<=

Only includes data that is less than or equal to the response value. Use for numerical data only.

Like

Includes the search string that is set as the value of the Response Value parameter.

Not Like

Excludes the search string that is set as the value of the Response Value parameter.

Null

Includes all responses that do not contain a value.

Not Null

Includes all responses that contain a value.


Response Value

This parameter can be a drop-down list box that provides a list of the current set of values entered for the Question Name you've specified. However, any value can be specified, with the numeric restriction noted above (below) and keeping in mind the datatype of the question.

The form that the parameter takes is dependent on the value of the Relational Operator parameter. If it is set to equal to, less than, or greater than, the Response Value parameter is a drop-down list box. When the Relational Operator parameter is set to the equal sign, you can set the Response Value to any value, that is, either alphabetic characters, alphanumerical, or numerical.

For the Relational Operators below, only numeric values should be specified. Non-numeric values are not properly evaluated with respect to these operators.

Refer to Table 15-15, "Values for the Relational Operators in the Data Subsearch Window" for the list of operators that should only be used with numeric data.

When the Relational Operator parameter is set to "Like" or "Not Like", type a search string in the Response Value text box. The system returns any responses that contain the search string.

Note:

Note that the search string is case-sensitive and you can use the "%" wildcard in the string.

When the Relational Operator parameter is set to "Null" or "Not Null", the value of the response is not considered. The only factor that the system considers is whether a given response field contains data or not. If it does, it is not null. If it does not contain data, it is null. Therefore the Response Value parameter is not required.

Boolean Operator

This parameter links the first and the second search phrases. It is only active when the first search phrase is complete. There are two values that is can be set to:

  • AND – requires that both the first and the second search phrases are met in order for the system to return the CRF

  • OR – requires that either the first or the second search phrase is met in order for the system to return the CRF.

The AND value is the default for the Boolean operator, however, it is not displayed until it is required.

Document Number

The Document number parameter is a drop-down list that allows you to specify and retrieve a document based on its assigned number.

The default value for the Document number parameter is "ALL", which retrieves every existing CRF document from the set that is defined by any previous criteria or parameter choices.

If you wish to select a value other than the default, use the drop-down list box controls to view the scrollable list of values and click the appropriate entry.

Lab With/Without Subset

The "Lab with/without subset" parameter allows you to select the laboratory that is responsible for the data in a CRF. Even with the CRF parameter at its default value ("ALL"), the Lab... parameter is only active if the data in at least one of the CRFs has been collected from a laboratory. Similarly, if the CRF parameter is at its default value and you choose a section parameter that does not contain laboratory data, the Lab... parameter is inactive.

When the parameter is active, its default value is "ALL".

The values in the Lab... parameter are displayed in a drop-down list. The list includes all of the laboratories that supply data that was collected for the CRF and/or section settings that are defined in those parameters.

Qualifying Value

This parameter is inactive until you select a CRF section, using the Section parameter, that contains a qualifying question. When the Section parameter is set to a section name that contains qualifying value question, the system presents the following entries in the drop-down box for the parameter:

  • <ALL> – this is the default value, it searches for every occurrence of the section

  • "Value" – searches for one of the response values that are defined in the qualifying question definition; there is a separate setting for each response value. There is a separate item for each acceptable response value in the question definition.

When you set this parameter, you can choose to search for all occurrences of the response values for the qualifying question, or you can choose to search for an individual response value.

For example, a multi-section CRF contains four identical "Vitals" sections, which collect vital statistics at different times post dose, and differentiates between the sections via a qualifying question with the values: "0," "1," "2," and "3" hours post dose. If you selected "Vitals" for the Section parameter, the Qualifying Question parameter would allow you to choose from five entries: <ALL>, "0," "1," "2," and "3."

Comment Type

The Comment type parameter allows you to specify a particular the type of comment that you want to search. You use this parameter in conjunction with the Comment Text, which you use to specify a text string.

The default value for the Comment type parameter is "ALL," which indicates that all comment text is included in the query. That is, CRFs are not selected based the comment.

There are seven comment types from which you can choose. If you change this parameter from its default value, the system requires that you also type a search string in the Comment Text.

Table 15-16 Descriptions of the Comment Type Parameter Options

Comment type Description

CRF comment

The Comment field of a CRF headers

Discrepancy text

The text that is displayed in the Text field of the Discrepancy task tab and the Error Message field of discrepancy windows

Discrepancy comment

The text that is displayed in the Comment field of the Discrepancy task tab and the Optional or Internal Comment field of discrepancy windows

Investigator comment

The text of an investigator comment that is associated with a data response field

Verification comment

The comment text that is included with a verification action.

Approval comment

The comment text that is included with an approval action.

Audit comment

The comment text that is included with an audit change reason.


Comment Text

The comment text parameter allows you to type a search string that is used to retrieve CRFs that contain text that matches the search string in a comment of the type that you select in the Comment Type. When you do select a Comment type parameter, the system requires that you also include a search string in the Comment text parameter.

The default setting for Comment text is "inactive." The field remains inactive until you select a Comment Type.

When you type a search string in the text box, RDC Classic automatically inserts the percent character ("%") before the first search string character and after the last. RDC Classic uses this value as the basis for searching the CRFs that are selected by your previous Selection window criteria choices for a matching comment type that includes your search string.

The percent character has a special meaning when used in database applications: it acts as a "wildcard" for any string of characters. The implication of this is that the search string that you enter can be a part of a larger word or it can stand on its own.

Usage

The Data criterion allows you to define a data set that is based on response data contained in the CRFs.

Note that setting the "Qualifying value" parameter must be done in conjunction with other parameters in the Data Subsearch window that specify a CRF that contains a qualifying value. Unless such parameters are set, the Qualifying value parameter remains inactive.

The tasks that are described in this topic are:

Specify CRF and Section Parameters

To specify the CRF and/or the Section parameters:

  1. You can choose to select either or both of these parameters.

    1. To specify the CRF parameter, click its drop-down list and select a CRF. Your choice determines the values that are displayed in the Section drop-down list. Proceed to Step 2.

    2. To specify the Section parameter only, do not change the CRF parameter from its default value. Click the Section drop-down list and chose a section. Proceed to Step 3.

  2. If you want to specify a Section parameter, in addition to the CRF parameter, click the Section drop-down list and choose a section.

  3. Close the subsearch window.

  4. Close the Search window.

Construct a CRF Question Search Phrase

The CRF question search phrase consists of three fields, which, when taken together, form a search phrase that specifies a question name and a set of acceptable response values:

  • a question value

  • a relational operator value, and

  • an answer value.

When you select a value for the Question Name parameter, the system populates the drop-down list associated with the Response Value parameter with all existing responses to the selected question name.

Sequence of Value List Generation

After the CRF/Section parameter is specified, the Question value drop-down list is populated with all of the questions that comprise the CRF or section that you chose.

The second search phrase remains inactive until you completely define the first search phrase by specifying an Answer value. When you select a value for the first search phrase answer:

  1. the default Boolean operator, is displayed in its drop-down list, and

  2. the Question value drop-down list in the second search phrase is populated with all of the questions that comprise the CRF or section that you chose.

When you select a value for the Question value in the second search phrase:

  1. the default relational operator, is displayed in its drop-down list

  2. the Answer value for the second search phrase is populated.

Figure 15-9 Top Portion of the Data Subsearch Window

Description of Figure 15-9 follows
Description of "Figure 15-9 Top Portion of the Data Subsearch Window"

Constructing Search Phrases

The first search phrase drop-down list contains the set of question names that exist for the CRFs and/or sections that you selected above. When you make a selection for this parameter, the Value drop-down list is populated with all of the answers that have been collected for that question.

The second drop-down list contains a set of relational operators that allow you define a range of allowable values or limit the search to a specific value.

You must make a selection in each of the three drop-down lists in order to construct a viable search phrase.

Specify a Document Number

To specify a document number:

  1. In the Data Subsearch window, click the Document number drop-down list arrow.

  2. Select a document number.

  3. Click the OK button to close the Data Subsearch window.

  4. Click the OK button to close the Search window.

Specify a Lab

To specify a lab:

  1. In the Data Subsearch window, click the "Lab with/without subset" drop-down list arrow.

  2. Select a the name of a lab.

  3. Click the OK button to close the Data Subsearch window.

  4. Click the OK button to close the Search window.

Specify a Comment Type and Content

To specify the type of comment and the content of the comment:

  1. In the Data Subsearch window, click the Comment Type drop-down list arrow. The set of possible types of comments are displayed.

  2. Select a comment type. The "Comment text" field becomes active.

  3. In the Comment text field, type the text that is included in the comments of the type you want to retrieve.

    • you can search for partial text strings using the "%" character

    • the text field must contain at least the "%" character (no quote marks), which will retrieve CRFs that contain comments of the type you specified in Step 2.

  4. Click the OK button to close the Data Subsearch window.

  5. Click the OK button to close the Search window.