Add a drilldown map table

1. In the left navigation pane, click the Settings icon ().
2. In the Configure System section, click Manage Configurations.
3. Click the Row Action menu () for a configuration, and then click Edit.
4. In the right-most column of the configuration, click Edit.
5. Next to the Drilldown Map field, click Select/Edit Table.
6. Click Create New Table.
7. In the Enter name of new drilldown table field, type a name for the new table. Table names cannot include:
   • Spaces
   • ?, \, or "

   It is recommended that you use a name that distinguishes the table from other drilldown map tables and indicates the table’s purpose, such as DRILLDOWN_MAP.

8. Click Create Table.

   The new table appears as the selected drilldown table. The first column of the drilldown map table shows the information type.

9. Edit the drilldown map table as necessary.

   Note:

   The same drilldown map table may be used by more than one data configuration in the Oracle account. Before editing a drilldown map table, make sure you want the changes to apply to all data configurations that refer to the drilldown map table.
   1. Select the Type you want to edit and click Edit. (If you want to clear values for the type, click Clear.)
   2. In the Table field, click Select to open the Select Table and Column dialog box and select an available table and column for the drilldown table to reference.

      The application populates the Table field and Report ID Column field with your selection. The column should be compatible with the column for case IDs in the source data used in data mining.

   3. In the Section Title field, type a label for the section of the drilldown map table.

      The label appears on the Case Details page as the section heading.

   4. In the Worksheet label field, type a label for the application to apply to the table worksheet.

      This label appears on the worksheet tabs when Case Details are downloaded to Excel.

   5. In the Display Columns section, select and label each column to include.
   6. From the first Column drop-down list, select a variable.
   7. In the corresponding Label column, type a label (column heading) to apply to the variable in the drilldown table.

      In the drilldown information, variables appear in the order in which you specify them.

   8. If you want the drilldown information to show only distinct values for the variables, check Distinct.
   9. Click Save.
10. When you have finished specifying all types of information that you need, click OK.

    The Select/Edit Drilldown Table dialog box appears with the Table, Report ID Field, and Display Columns columns filled in.

Drilldown information types

The following table lists the types of information that you can include in the drilldown map table and the corresponding label in the drilldown display. The LIST type determines contents of the Cases page (first-level drilldown), and its first variable must represent the case ID. All other types determine contents of the Case Details page (second-level drilldown). Typically, the CASE, DRUG, and EVENT types, at a minimum, are included on the Case Details page.

Type	Description
CASE	Case Information
DRUG	Reported Drugs/Vaccines
EVENT	Reported Events/Symptoms
OUTCOME	Reported Outcomes
SOURCE	Reported Sources
BATCH_LOT	Batches/Lots
DEVICE	Devices
DEVICE_CODE_DEV	Facility Device Codes
DEVICE_CODE_PAT	Facility Patient Codes
DEVICE_MANU_CONCLUDE	Manufacturer Conclusion Codes
DEVICE_MANU_METHOD	Manufacturer Method Codes
DEVICE_MANU_RESULT	Manufacturer Result Codes
DIAGNOSTIC	Diagnostic Procedures Performed
DRUG_HISTORY	Patient Drug History
DRUG_IND	Indications
DRUG_REACT	Drug-Reaction Information
LINKED_CASES	Linked Cases
LITERATURE	Literature References
MEDICAL_CONDITION	Medical Conditions
MEDICAL_HISTORY	Medical History
PATIENT_REGISTRY	Patient Registry Information
PREGNANCY	Pregnancy Information
PREGNANCY_OUTCOME	Pregnancy Outcome
REPORTER	Reporter Information
CAUSE_OF_DEATH	Cause of Death
PARENT	Parent
PARENT_DRUG_HISTORY	Parent Drug History
PARENT_MEDICAL_HISTORY	Parent Medical History
AES_ADDL_HISTORY	Chronological History
AES_ADDL_INFO	Additional Information
AES_CEV_DRUG	Drug-event Information
AES_CODES_DEV	Device Codes
AES_DEVICE_CODE	Device Problems
AES_DISEASE	Diseases
AES_DOSE	Dosing Regimens
AES_EVAL	Case Evaluation Information
AES_EXPOSED_DEVICE	Devices
AES_LAB	Associated Lab Results
AES_REPORTER	Reporter Information
NARRATIVE	Narrative For example, medical history or laboratory data for the case. See Narrative text for details about setting up narrative text.)