Using the data browser

Select View > Search Panel or click the Open Search Panel icon to open the search panel. General help on using the search panel
- When you open the search panel, it will appear as it was when the panel was last closed.
- At any time you can clear all the search fields by clicking the Clear Search fields icon at the top of the panel.
- To save a search for future use, click the Save Search icon at the top of the panel to save the current combination of search settings. Enter a name for the new search or click Replace Search and select a search to overwrite. Click Save. Searches are stored separately for each user. To open a previously stored search, click the arrow to the right of the Open Stored Search icon at the top of the panel and select a search from the drop down list.
Select the type of report you wish to run from the drop down list at the top. See image

Select your search criteria. Help on each field within the search panel

Click the Execute search buttonto display the data in the Data Browser in the main window. What to do if you are told your search exceeds the maximum number of records

You will be alerted if your search results exceed the maximum number of records allowed in a browser report. If this happens the DCR browser will not open until you change your search criteria to reduce the number of DCRs in the results.

Once the report is open in the browser, the number of records displayed is shown at the bottom of the browser.

To change the maximum records limit, go to Tools > Options.../Administrator Options...

The data browser displays a tree view listing of subject data organised as subject/visit/eForm/question. Within an eForm, each row corresponds to a question. Across the top of the table are a number of information columns which can be customised.

Question	The question name (not code).
Value	The question response value.
Date and Time	The date/time that the response was saved to the local web server. More information...
Database Date and Time	The date/time that the response was saved to the database server. More information...
Transfer	Not used in this version.
User	The username of the user who answered the question.
Full User Name	The full name of the user who answered the question.
Thesaurus Name/Version/Language	The details of the medical dictionary used to code the question, if applicable.
Decode	The decode selected during the clinical coding of this question, if applicable.
Coding Status	The coding status assigned to this question, if applicable.
Comment	The comment attached to this question if one has been added.
Reason For Change	The RFC selected for this question response if the value has been changed from a previous value.
Overrule Reason	The Reason for Overrule selected for this response if the value triggered a warning which was overridden by the user.
Validation Message	The validation message displayed to the user if the value entered triggered a validation warning/rejection/flag.
Response TZ	The timezone setting for the local machine where 0 = GMT
Database TZ	The timezone setting for the database where 0 = GMT

You can change the number of records displayed on a page and also the maximum number of records retrieved. Set this in Tools > Options > Environment > General.

The data browser only displays data that is saved to the database. There are a few instances in which data might change but not be saved. For example, if an eForm is opened by a data entry user, some derived values may get updated and appear with new values on the eForm, but unless this eForm is actually saved, these new values will not appear in the data browser. Note that derivations on an eForm are only updated when an eForm is opened and saved by a data entry user, or when the subject is revalidated using Batch Validation.

Organising data in the browser

Editing data from the browser

Right click on a question, eForm, visit or subject and, depending on your user permissions, you can select from the popup menu to:

Opening an eForm from the browser

Double click on a question to open the eForm on which the question exists. The eForm will open in the main window and if available, the question will be highlighted.

A question would not be available if it has the status 'not applicable' or if it is 'locked'.

To return to the Data browser, click the 'Close Current eForm' button

in the tool bar. The search results will be updated with any changes you have made whilst on the eForms.

Improving performance

To improve the speed at which results are displayed in the data browser, you can switch on High Performance Mode.

Study	If you are permitted access to data from more than one study, you can choose to view data from all studies, or from a particular study only. Select your choice from the drop down list.
Site	If you are permitted access to data from more than one site, you can choose to view data from all sites, or from a particular site only. Select your choice from the drop down list.
Subject	You can choose to view data entered for a particular subject only, by entering the subject label (part or whole), or the subject ID. The subject list will open, containing only those subjects who fit your search criteria.

Select/Clear All	Use this toggle to either check all the status boxes or to clear all checks. Hover over a status icon to see the status label as a tooltip.
status	Click these check boxes to include all questions with a particular status or combination of statuses. You can select multiple check boxes.
Comments	You can choose to: disregard comments (by leaving the list blank) only include questions with no comments attached (None) only include questions with comments attached (All). Select your choice from the drop down list.
Notes	You can choose to: disregard notes (by leaving the list blank) only include questions with no notes attached (None) only include questions with notes attached (All). Select your choice from the drop down list.

DCR	Select a status from the list to include questions with DCRs of that status. The statuses are raised, responded, closed, printed or received. This section is only available if your user permissions allow you access to DCR data.
SDV	Select a status from the list to include questions with SDV marks of that status. The statuses are planned, queried, done or cancelled. This section is only available if your user permissions allow you access to SDV data.

Visit	You can include data from all visits, or from a particular visit only. Select your choice from the drop down list.
eForm	You can include data from all eForms, or from a particular eForm only. Select your choice from the drop down list. This list will only contain eForms available in the selected visit.
Question	You can include data from a particular question only. Select your choice from the drop down list. This list will only contain questions available in the selected visit/eForm combination.

Search	You can search for data before or after a certain date, during a certain period or with no date restrictions. Select your choice from the drop down list.
From	Enter the date from which you want to search by clicking the arrow and selecting the date form the popup calendar.
To	Enter the date to which you want to search by clicking the arrow and selecting the date form the popup calendar.

Using the data browser

Search Detail Level

General

Statuses

Frozen/Locked

DCRs/SDV Status

Study Level

User

Date Range

Clinical Coding

Organising data in the browser

Editing data from the browser

Opening an eForm from the browser

Improving performance

Type	You can choose to view thesaurus questions associated with all MedDRA dictionaries, or from a particular dictionary only. Select your choice from the drop down list.
Statuses	You can choose to view thesaurus questions with a specific coding status. Select your choice from the drop down list.