Enabling the View Builder and Converting Views

The View Builder was an enhancement in Oracle Clinical Release 3.1. If you are still using pre-View Builder views, you can convert them to View Builder-style views by running two scripts, vb_pop_view and enable_vb, for each study.

For more information , see:

• Converting Views
  
• Enabling the View Builder in a Study
  

Converting Views

Running vb_pop_view converts a study's existing old-style data extract views to the new view builder style. For example:

cd $RXC_INSTALL
sqlplus rxc/notrxc
start vb_pop_view

The script prompts you for the name of the study.

Note:

You can run vb_pop_view only once per study.

Enabling the View Builder in a Study

To make view builder-style the default for future views in a study, use the enable_vb.sql script. For example:

cd $RXC_INSTALL
sqlplus rxc/notrxc 
start enable_vb.sql

When you execute this script it performs the following actions:

• prompts you for the name of the study.

• updates the CLINICAL_STUDY_STATES table, setting VB_ENABLED to "Y".

• sets the default key template in CLINICAL_STUDY_STATES to STANDARD.

After running enable_vb, commit the changes to the database, then rerun view creation.

You can also enable view builder interactively for individual studies within the Oracle Clinical interface. However, using the command line may be more convenient.