Viewing a data source table

In this section ShowHide

Data Source Tables

From within the Empirica Signal application, you can view the data source tables referenced by the data configuration associated with the currently selected run. For more information, see About source data.

Note: Only a superuser can view data source tables.

1. Click the Data Mining Runs tab.

The Data Mining Runs page appears.

2. Select the row menu ( )for a run, and then click View Jobs for Run.

The Jobs for Run page appears.

3. Click Sources.

The Data Sources page appears.

4. Click the name of the data source table that you want to view.

The data source table appears.

5. Perform actions on the table:

To set viewing options, click Options.
To filter the data that you want to view to certain specified characteristics, click Filter.
To download the data in the table, click Download (available if you have the Download Raw Data permission).

Data Source Tables

The following data source tables might be available to view:

Table	Description
Complete Results Table	Complete, raw results table, intended for troubleshooting purposes. For most purposes, the results table available from the Data Mining Results tab is more appropriate. This complete results table might contain more columns than you need to see.
Drug Index Table and Event Index Table	Oracle column indexes for drugs and events.
Master Configuration Table	Empirica Signal master data configuration table (named DM_CONFIGS), which stores attributes of all data configurations in all the source databases.
Configuration Table	Table containing information about variables in the specific data configuration that was used for the run.
Drilldown Map Table	The drilldown map table, which defines which information (such as case outcomes or narratives) appears when the results reviewer drills down to case details.
Data Source Description Table	Source description table, which defines information (such as the date the data was loaded) about the source database and appears when the results reviewer drills down to view case details and in the Notes section of tables. This table is available only it was defined for the data configuration.
Source Database Tables Referenced by Configuration	Source database tables referenced by the data configuration; for example, the demographics, drugs, and events tables.
Hierarchy Tables Referenced by Configuration	Available if an older method was used for setting up drug and event hierarchies by providing hierarchy tables for individual variables in a data configuration, and if the run used hierarchy information. For more information, see Drug and event hierarchies.
Unique Values Tables Referenced by Configuration	Unique values tables referenced by the data configuration that was used for the run.
Source Database Tables Referenced by Drilldown Map	Source database tables referenced by the drilldown map table for the data configuration. For example, the drilldown map table might reference a table containing demographics data, making demographics data available as part of the case details.