Data configuration and variables information

The Modify Configuration page provides information about the data configuration and the data configuration variable.

Data configuration information

The Modify Configuration page provides the following information about the data configuration:

Field Description

ID

Unique identifier that is assigned automatically to the configuration.

Name

Name of the configuration.

Description

Description supplied for the configuration.

Database Group

Name of the database group to which the configuration is assigned. Results reviewers can use the database group when finding and selecting a data mining run. The application also uses the database group when determining color changes for case ID links that are visited by users.

Owner

Full name associated with the username that created the configuration.

Table

Name of the Oracle table containing the specification of the configuration.

Drill Down Map Table

Name of the drilldown map table, which specifies the source of case details that appear when a user drills down to view case details.

Source Description Table

Name of the source description table, which provides information about the source database.

Timestamped

YES, if the configuration supports timestamped data.

NO, if the configuration does not support timestamped data.

Drug Hierarchy Account (or Drug Hierarchy Version Table)

Name of the Oracle account that drug variables with a selection type of Select from Drug Browser in the configuration use for hierarchical values.

For timestamped configurations, name of the table that stores one or more valid hierarchy accounts by date.

Event Hierarchy Account (or Event Hierarchy Version Table)

Name of the Oracle account that event variables with a selection type of Select from Event Browser in the configuration use for hierarchical values.

For timestamped data, name of the table that stores one or more valid hierarchy accounts by date.

Includes Concomitant Drugs

YES, if the configuration includes suspect and concomitant drugs.

NO, if the configuration includes suspect drugs only. Results reviewers can use this information to find a data mining run.

Hide From Data Mining

YES, if the configuration can be used for case series and reporting only.

NO, if the configuration can be used for data mining, case series and reporting.

Valid

YES, if the configuration has been validated successfully.

NO, if the configuration has never been validated or failed validation.

Data configuration variable information

The Modify Configuration page provides the following information about each variable in the data configuration:

Field Description

Variable

Unique name of the variable as it appears to Oracle Empirica Signal users on the Select Configuration page. For example, a column might be named SYMPTOM in the analysis table, and Event in the Oracle Empirica Signal application.

Desc

Description of the variable.

Table

Name of the source database table containing the column that corresponds to the variable.

Column

Name of the database table column that corresponds to the variable.

Variable Type

For possible variable types, see Add or edit a configuration variable. If a subtype (Generic, Trade, or Ingredient) is specified for a variable with a variable type of Drug, it appears after Drug in parentheses.

Selection Type

For possible selection types, see Add or edit a configuration variable.

Hierarchy Level

Displays the hierarchy level, if any, specified for event or drug variables with a selection type of Select from Drug (or Event) Hierarchy.

Visibility

DM & Q, if the variable is available for data mining runs and query-based case series.

DM, if the variable is available for data mining runs but not for query-based case series.

Value Case

For possible value cases, see Add or edit a configuration variable.

Hierarchy Table

Name of the hierarchy table, if any, associated with the variable.

Unique Values Table

Name of the unique values table, if any, associated with the variable.

Data Transform

Name of the data transformation, if any, associated with the variable.