Creating Extract Tables and Indexes

Although indexing is a task that could be considered better covered under the Definition subsystem in Oracle Clinical, it is treated here because the menu entry is under Conduct.

Follow these steps:

1. Set up additional tablespaces to store the extract data and extract indexes, calling them, for example, RXC_EXTRACT_DATA and RXC_EXTRACT_IDX, respectively.
2. Locate the installation reference codelist DX_VIEW_TABLESPACE, and enter the name(s) of the tablespace(s) allotted to extract data (for this example, RXC_EXTRACT_DATA) in the Long Value column. The Short Value column will just be a sequential number. Each tablespace name requires a row.
3. Locate the installation reference codelist DX_INDEX_TABLESPACE, and enter the name(s) of the tablespace(s) allotted to the extract index(es) (for this example, RXC_EXTRACT_IDX) in the Long Value column. The Short Value column will just be a sequential number. Each tablespace name requires a row.
4. From the Conduct menu, select Data Extract, then select Study Access Accounts, set the View/Table column to TABLE for study access accounts where you want table views.
   Study access accounts of types Snapshot and Rollsnap (see View Types and Rollsnaps) can be made into table views.
5. For the same study you chose in Step 4, from the Definition menu, select Data Extract View Builder, then select View Definitions. Change the Type field to TABLE from VIEW for each definition where you want a table view.
   Both the view definition and the study access account must be set to TABLE for table views to occur.
6. In the Indexes window (from the Conduct menu, select Data Extract, then select Indexes), specify the indexes required for the underlying tables. For example, most tables need to be indexed on patient and visit, which are common search fields.
   1. In the View Name to Index field, invoke the LOV and choose a view name from the list.
   2. Enter a description for the view name in the Index Description field.
   3. In each Template Columns to Index Column Name field, invoke the LOV to see the view columns, and choose the ones you want to use as index columns.
   4. Save, then exit the Maintain Indexes window.
7. In the Data Extract Views window (from the Conduct menu, select Data Extract, then select Data Extract Views), choose the type and name of the study access account you want, and run in full mode.