View a data source table
From within Oracle Empirica Signal, you can view the data source tables referenced by the data configuration associated with the currently selected run. For more information, see What is source data?
Note:
Only a superuser can view data source tables.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 Data Mining Results 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 |
Oracle 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. |
Parent topic: View source data