Data configuration and variables information

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 medications.

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.

Name

Unique name of the variable as it appears to Empirica Signal users on the Select Configuration page. For example, a column might be named SYMPTOM in the analysis table, and Event in the 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.

Prefix

A prefix is required only if the variable type is Event, Drug, or Generalized Item. The alphabetical order of prefixes determines the column names for the variables in the complete results table. For example, if the prefix for the drug variable is D and the prefix for the event variable is E, the drug variable is in the ITEM1 column and the event variable is in the ITEM2 column.

Note: Multiple variables with the same prefix cannot be used as item variables in the same data mining run.

Variable Type

For possible variable types, see Adding or editing 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 Adding or editing 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.

Hide from Query Wizard

If you do not want the variable to be available during creation of a query, from the Hide from Query Wizard drop-down list, select Yes.

Value Case

For possible value cases, see Adding or editing a configuration variable.

Unique Values Table

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

Hierarchy Table

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

Data Transformation

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