Mapping Database Roles to User Roles
- Specifying User Roles for the Oracle Clinical Discrepancy Database
- Assigning Function Privileges and Layouts
  - Assigning and Removing Function Privileges
  - Assigning Custom Layouts
Customizing Layout Definitions
Customizing Profiles
Customizing Flexfields
Defining Reason Codes for Discrepancies
Defining the Possible Review Statuses for Discrepancies
- Default Entries for the DISCREPANCY REV STATUS CODE Codelist
- Rules for the DISCREPANCY REV STATUS CODE Codelist
Defining Resolution Reasons for Discrepancies
Setting Values in the OCL_STATE Local Reference Codelist
Configuring Role-Specific Discrepancy Management for RDC
Configuring Study and Site Security for Discrepancy Management
- Updating a Discrepancy
- Navigating to Data Entry
Setting Up Data Clarification Forms (DCFs)
- Defining DCF Statuses and their Behavior
- Laying Out the DCF
Creating Reusable Standard Text for Discrepancies and DCFs

4 Configuring the Mass Changes Utility

Creating and Assigning Mass Changes Roles
Customizing Mass Changes Local Codelists
Customizing the Field Display on the Candidate Data Set Form

5 Configuring Data Entry and User Preferences

Customizing Data Entry Behavior
Customizing the Oracle Clinical Log-in Window Layout
Setting DCI Form Default Values for RDC Data Entry and Patient Data Reports
- Setting and Enforcing Values
- Settings
Customizing Flex Fields for DCI Forms
- How Flex Fields Work
- Flex Field Components
  - Shipped Functions
Customizing CRF Column Headers in the RDC Classic
Customizing Online Help
Viewing Xhelp Without Oracle Clinical

6 Configuring Data Extract

Configuring Default Installation Data Extract Settings
Setting Values in Data Extract-Related Reference Codelists
Creating Tablespaces for Data Extract Tables and Indexes
Customizing Data Extract Views
Generating Data Extract Views
- Running gen_views on UNIX Platforms
- Running gen_views on Windows
Enabling the View Builder and Converting Views
- Converting Views
- Enabling the View Builder in a Study
Controlling Access to Data Extract Views

7 Reference Codelists

Overview of Reference Codelists
Local Reference Codelists
Installation Reference Codelists
Design Installation Reference Codelists
System Reference Codelists

Part II Oracle Clinical Administration Tasks

8 Managing Batch Jobs

User Account Requirements for Batch Jobs
How PSUB Handles a Request
Starting and Stopping PSUB
Managing the PSUB Process
Batch Job Reference Codelists

9 Partitioning and Indexing

Introduction
- Timing Considerations and Deferral of Index or Partition Upgrade
  - Enforcing Pre-Version 4.0 Optimization
- About Partitioning
  - How Has the Responses Table Been Partitioned?
  - Why Partition?
Planning for Partitioning Upgrade
- Pre-upgrade Steps
Partitioning the Responses Table
Upgrading Indexes
Query Tuning Guidelines

10 Utilities

Computing the Validation Status of All Responses
- Running cnvstatus on UNIX
- Running cnvstatus on Windows
Generating Validation Procedures
- Running gen_procs on UNIX Systems
- Running gen_procs on Windows Systems
Deleting Inactive Procedures

11 Setting Up File Viewing

Overview of the Process to Set Up File Viewing
Changing the Default Protocol for File Viewing
Setting Up Image Viewing for DCI and DCM Form Layouts HTML Preview

12 Enabling Image Viewing

Setting Up a Central Image Repository
- Setting Up a Network User to Run the Oracle Process Manager Service
- Setting Up Image Viewing During Data Entry
Copying Image Files to All Installations

13 Conducting Studies in a Distributed Environment

Distributed Study Environments and Replication
Prerequisites to Setting Up Replication
Setting Up Replication
Creating the Study Design Replication Packages
Setting Up Symmetric Replication

14 Using Replication

Example of an Oracle Clinical Distributed Study
Operating from the Study-Owning Location
Operating from a Sharing Location
Enabling a Study for Replication
Using Standard Replication
Using Disconnected Replication
Changing Study Ownership
Replicated Tables

Part III Appendixes

A Environment Variables and Registry Settings

Summary of the Oracle Clinical Setup
Windows Registry Settings

B SAS_VIEW Directory Tree

C Troubleshooting

Managing High Sequence Numbers
- Assessing Sequence Sizes
- Reseeding Sequences
Error Messages
System Malfunction: GPF Occurs During Data Entry
- Situation: $ulimit unlimited
PSUB Jobs
Database Trace

D Routine Server Administration

Recreating Symbolic Links — UNIX Only
Relinking Server Code — UNIX Only
Relocating Oracle Clinical
Updating Oracle Clinical Seed Data
Collecting Statistics for Optimization

Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

Part I Configuration Tasks

1 Setting Up User Accounts

2 Oracle Clinical Menu-Based Security

3 Configuring Discrepancy Management

4 Configuring the Mass Changes Utility

5 Configuring Data Entry and User Preferences

6 Configuring Data Extract

7 Reference Codelists

Part II Oracle Clinical Administration Tasks

8 Managing Batch Jobs

9 Partitioning and Indexing

10 Utilities

11 Setting Up File Viewing

12 Enabling Image Viewing

13 Conducting Studies in a Distributed Environment

14 Using Replication

Part III Appendixes

A Environment Variables and Registry Settings

B SAS_VIEW Directory Tree

C Troubleshooting

D Routine Server Administration

E Oracle Clinical Tablespaces

Glossary

Index