Index

A B C D E F G I K L M N O P Q R S T U V W X

A

Accessible Data Only? column, 3.3.3

Accounts

RXA_READ, 13.2.1.1

RXC_DISC_REP, 13.2.1.3

accounts

create OPS$, 1.3

requirements for batch jobs, 8.1

RXC_REP, 13.2.1.2

Add Review Status button, 3.3.6

anadestab.sql, D.5

anadestab.sql script, D.5

analrtab.sql, D.5

ANALYZE command, 9.3.5

anaopatab.sql, D.5

anarxctab.sql, D.5

asynchronous PSUB jobs, 8.2.1

attributes

extended, 7.3.31

auto fill, 5.1.2

auto skip, 5.1.2

B

batch data load

and integrity of distributed data, 14.5.5.4.1

batch jobs

execution status, C.4.5.1

troubleshooting, C.4

user accounts for, 8.1

batch validation

and integrity of distributed data, 14.5.5.4.1

blind break

and distributed study conduct, 14.2.3.2

creating, at a sharing location, 14.3.1

blocking jobs, 8.2.2

Browse mode

access to, 5.1.1.1, 5.1.1.1

C

CDS

setting field display, 4.2, 4.3

check_opa_settings script, A.1.3.3

cnvstatus, 10.1

running on UNIX, 10.1.1

running on Windows, 10.1.2

codelists, setting up in a discrepancy database, 3.9

collection scripts

anadestab.sql, D.5

analrtab.sql, D.5

anaopatab.sql, D.5

anarxctab.sql, D.5

comment

operator, 5.1.1.1

Comparison Beep, 5.1.2

comparison failure, 5.1.2

comparison reconciliation, 5.1.1.1

compile_all_invalid.sql, 9.3.7

COMPUTE STATISTICS clause, 9.2.1.4

configuring data entry screens, 5.1.1

cost-based optimization, D.5

cost-based statistics, 9.2.1.4

CRF information

defined, Glossary

current study

defined, Glossary

Custom button, 5.6

D

data collection instrument (DCI)

defined, Glossary

data entry

and integrity of distributed data, 14.5.5.4.1

navigating during, 5.2.1

Data Entry Display Format, 5.1.2

data entry operator

and privileges in Browse mode, 5.1.1.1

for both first and second pass, 5.1.1.1

hiding data from, 5.2.2

in silent mode, 5.1.1.1, 5.1.1.1

notified of errors, 5.1.1.1, 5.1.1.1

notified of unenrolled patient, 5.1.1.1

data entry screen settings, 5.1

and thesaurus questions, 5.1.1.1

defaults for, 5.1.1

levels for, 5.1.1, 5.1.1

list of, 5.1.1

modifying, 5.1.1.1

overriding, 5.1.1

precedence of, 5.1.1, 5.1.1.2

replication of, 5.1.1

study-level, 5.1.1, 5.1.1.2, 5.1.1.3

undefined, 5.1.1

user-level, 5.1.1

data entry user preferences

and date format, 5.1.2

and non-updatable fields, 5.2.2

defaults for, 5.1.2, 5.1.2

layout, 5.1.2, 5.1.2

list of, 5.1.2

local database-level, 5.1.2

data extract

and integrity of distributed data, 14.5.5.4.3

enabling 3.1-style, 6.6

Data Extract View

Snapshot, 14.5.5.4.3

stable, 14.5.5.4.3

Data Extract View Maintenance

and integrity of distributed data, 14.5.5.4.3

data extract views

generating, 6.5

database

sharing, 13

Database Server

Windows

opa_settings, A.1.1

database trace session, C.5

date

formats of, 5.1.2

DCF

placeholder graphic, 3.11.2

views, 3.11.2

DCF REPORT LABELS codelist, 3.11.2

DCF STATUS CODES codelist, 3.11

DCI Book

sequencing, 5.1.1.1

using, in data entry, 5.1.1.1

deadlock detected, C.2.3

Decrease Width button, 5.2.2

default study

defined, Glossary

DISC COLS2 codelist, 4.2

DISC_FLEX1_VALUES codelist, 3.4.2

DISC_FLEX2_VALUES codelist, 3.4.2

discrepancies, 10.1

and integrity of distributed data, 14.5.5.4.1

managing, at sharing location, 14.3.3

resolution of, by data entry operator, 5.1.1.1

DISCREPANCY FUNCTIONS codelist, 3.1.2

DISCREPANCY REV STATUS CODE codelist, 3.3.6, 3.6

DISCREPANCY STATUS DM, 3.9.1.5

DISCREPANCY STATUS SITE, 3.9.1.7

discrete_val_grp_type_code, 7.3.26

distributed study conduct

and data extract, 14.5.5.4.3

and data integrity, definition, 14.5.5.4.2

and lab definition, 14.5.6

components of, 14.5.6

enforcing data integrity in, 14.5.5.4.1, 14.5.5.4.2

planning, 14.5.6.2

E

End of Form Beep, 5.1.2

enrollment of patients

and integrity of distributed data, 14.5.5.4.1

Enterprise Manager, 8.3.3.3

environment variables, A

equipartitioned

defined, 9.1.2.1

error messages, C.2

Not using named package, C.2.1

ORA-04020, C.2.3

ORA-12223, C.2.2

ORA-20009, C.2.4

execution status

batch jobs, C.4.5.1

exp_resp_param.dat file, 9.3.2

Export utility, 9.3.2

F

field

non-updatable, in data entry, 5.2.2

file viewing

configure application server, 11.2

files

protection, B

PSUB, 8.2

FLD RXCMCMCD RDCI DELETE codelist, 4.2, 4.3

FLD RXCMCMCD RDCI KEY codelist, 4.2, 4.3

FLD RXCMCMCD RDCM KEY codelist, 4.2, 4.3

FLD RXCMCMCD RESPONSE codelist, 4.2, 4.3

freezing

and integrity of distributed data, 14.5.5.4.1

full replication

Global Library, 14.5.2

study definition, 14.5.4

function privileges

defining, 3.1.2

G

gen_alter_partition script, 9.3.11.3

gen_create_part_index script, 9.2.1.4

gen_create_part_table script, 9.2.1.4

gen_procs

syntax, 10.2

gen_views, 6.5

running on UNIX, 6.5.1

running on Windows, 6.5.2

genprocs

running on UNIX, 10.2.1

running on Windows, 10.2.2

Global Lab Replication menu, 14.5.6.1

Global Library

and distributed study conduct, 14.5.6.2

replication, 14.5.2, 14.5.6.1

granting

program access, 1.5.1

project access, 1.5.1

I

imp_resp_param.dat file, 9.3.4

Import utility, 9.3.4

Increase Width button, 5.2.2

incremental replication

Global Library, 14.5.2

study definition, 14.5.4

IND DISC COLS2 codelist, 4.2

indexing, 9

initialization error, C.4.5.6

installation reference codelist

DISCREPANCY STATUS DM, 3.9.1.5

DISCREPANCY STATUS SITE, 3.9.1.7

invalid objects, 13.5.4.2

partitioning, 9.3.7

investigator assignment

and distributed study conduct, 14.2.2

and integrity of distributed data, 14.5.5.4.1

at a sharing location, 14.3.1

Items Not Displayed, 5.2.2

K

Kernel32.DLL error, C.4.5.6

key templates

domain, 6.1, 6.1

L

lab assignment criteria (LAC)

and location relationship, 14.5.6

Lab Panel

and location relationship, 14.5.6

lab reference ranges

and distributed study conduct, 14.5.6, 14.5.6.2

lab units

and location relationships, 14.5.6

Labs and Ranges Replication menu, 14.5.6.2

launchps.sh file, D.3

layout

Log-In

editing function of, 5.2

editing instructions, 5.2.2

modifying RDCI window in, 5.2.2

modifying RDCM window in, 5.2.3

modifying Smart RDCM window in, 5.2.4

layout definitions, 3.2

list_study_resp_cnt_part script, 9.3.11.2.2

location codes, 13.3.1

location, in distributed study conduct

and lab information, 14.5.6

sharing, 14.3

tasks, 14.3.3

study-owning

tasks, 13.1.1.2

locking

and integrity of distributed data, 14.5.5.4.1

profile criteria, 3.3.3

Log-In

and integrity of distributed data, 14.5.5.4.1

at sharing location, 14.3.3

navigating during, 5.2.1

Log-In Layout Editor menu option, 5.2.1

M

Maintain Partition Mapping Tables window, 9.2.1.3

MANHD DISC COLS2 codelist, 4.2

Manual Discrepancy in Browse parameter, 5.1.1.1

master profiles, 3.3

MC CDS SORT ORDER codelist, 4.2

MC COLUMNS codelist, 4.2

menus

modifying, 2.3, 2.3

More button, 5.6

MULTI DISC COLS2 codelist, 4.2

N

NLS_DATE_FORMAT, A.1.1

NLS_DATE_FORMAT environment variable, A.1.5.1

NLS_LANG, A.1.1

NLS_LANG environment variable, A.1.5.2

NOLOGGING clause, 9.2.1.4

non-blocking PSUB jobs, 8.2.1

O

objects

invalid, 13.5.4.2

OCL MC PREFS codelist, 4.2

ocl_add_user.sql script, 1.3

OCL_DE_CONFIG, 7.2.21

OCL_STATE codelist, 3.8

OCL_STATE reference codelist, 9.1.1.1

OCLSASCR user group

and SAS data extract views, 1.8.2

oclupg32to40opt5.sql script, 9.4.5

opa_settings

Windows back end, A.1.1

opa_settings script, A.1.3

checking for errors, A.1.3

opapps directory, B

opapps userid, D.2

operating system passwords, 1.10.5

optimization, D.5

Oracle accounts, 5.1.1.3

assign access, 1.5.1

deleting, 1.5.4

for studies, 1.5.2

revoking, 1.5.4

to Programs or Projects, 1.5.1

P

page dimension, 5.1.1.1, 5.1.1.1, 5.1.1.2

partitioning, 9

compile_all_invalid.sql, 9.3.7

cost-based statistics, 9.2.1.4

database trigger, 9.3.7

defined, 9.1.2

disk space, 9.1.2.2.4

invalid objects, 9.3.7

merging, 9.2.1.3

percent free, 9.2.1.4

performance, 9.1.2.2.3

preparing for, 9.3.3

pruning, 9.5

redo log file, 9.2.1.4

storage clauses, 9.2.1.3

tablespaces, 9.3.3.2, 9.3.11.5

tuning, 9.5

passwords

auditing, 1.10.4

characters allowed, 1.10

operating system, 1.10.5

schema or role, 1.10.1

security, 1.10.3

setting up, 1.10

Patient Positions

and integrity of distributed data, 14.5.5.4.1

setting up for distributed study conduct, 14.2.1.1

patients

personal details of in distributed study conduct, 14.2.3.2

planned events

in the Smart RDCM window, 5.2.4

populate_part_map_table script, 9.2.1.2

privileges

of data entry operator, 5.1.1.1

procedures

deleting inactive, 10.3

production mode, C.2.4

.profile, 1.2.5

.profile file, 1.9.1

profile views, 3.3.1

profiles, 3.3

criteria, 3.3.1

locking criteria, 3.3.3

setting up, 3.3

PSLAUNCH error, C.4.7

PSUB

and character sets, on Windows, A.1.1

and opa_settings on Windows, A.1.1

asynchronous jobs, 8.2.1

blocking jobs, 8.2.2

create log directory, 1.2.3

definition, 8

execution permission, 1.2.4

files created, 8.2

non-blocking jobs, 8.2.1

checking, 8.2.3

troubleshooting, C.4

PSUB jobs

printing on UNIX, 8.4.4.3

PSUB process, 8.4

Q

Question Groups

repeating, 5.1.1.1

questions

attributes of, 7.3.31

R

RDC

customize workspace, 5.5.3

RDCI sort order, 5.1.2

RDCM, 5.2.1, 5.2.3, 5.2.4

RDCM window, 5.2.3

rdcpb_client.sql

customize CRF Column Header, 5.5.3

rebuild_respt_index script, 9.4.4

Received DCMs

updating locked, 5.1.1.1

record type key

code_environment, A.1.3

db_code_pair, A.1.3

db_env_setting, A.1.3

opa_home, A.1.3

oratab_filespec, A.1.3

remote_db_home, A.1.3

tnsnames_filespec, A.1.3

recreating symbolic links, D.1

reference codelist

OCL_DE_CONFIG, 7.2.21

reference codelists

design, 7.1

installation, 7.1, 7.3

and distributed study conduct, 13.1.1.1

local, 7.1

OCL_STATE, 9.1.1.1

SOURCE LOCATION CODE, 13.3.1

system, 7.1

TMS_SOURCE_MAT_VIEWS, 7.3.64

registry settings, A.2

relink_rxc.log file, D.2

relink_rxc.sh script, D.1

relinking server code, D.2

relocating Oracle Clinical, D.3

repeat default, 5.1.1.1

replacement parameters, and standard text, 3.12.2

replication

conflict resolution, 13.5.3.1

enabling studies for, 14.5.3

Global Library, 14.5.2

incremental, 14.5.6.1

reconciling data, 13.5.3

scheduling, 14.5.5.4.3, 14.5.7

scripts, 13.4

setup requirements, 13.2

setup tasks, 13.3.4.3

source location code, 13.3.1

study definition, 14.5.4

study design, 13.5, 14.3.1, 14.5.3

symmetric

troubleshooting, 13.5.4

tables, 13.2.2, 13.5.3.2

REPORT_SERVER reference codelist, 1.3.5, 1.3.5, 1.4, 1.4, 1.4

resolution type codes

resolution, of discrepancies, 10.1

RESPONSES table

validation status, 10.1

Responses table, 9

resptrig script, 9.3.7

Revert button, 5.2.2

review status codes

defining, 3.6

roles

creating new, 2.2.3

RXA_READ account, 13.2.1.1

RXC_BATCH_QUEUE environment variable, A.1.5.3

RXC_BDL_DIR environment variable, A.1.5.4

RXC_DEBUG_BUFFER_SIZE environment variable, A.1.5.5

RXC_DISC_REP, 1.10.1

RXC_DISC_REP account, 13.2.1.3

RXC_DISC_REP schema, 1.10.1

RXC_IMMED_QUEUE environment variable, A.1.5.6

RXC_INSTALL

and USER_QUERIES table, 1.8.3

RXC_LOG, A.1.5.7

and PSUB log directory, 1.2.3

RXC_MAA, 1.10.1

RXC_MAA schema, 1.10.1

RXC_MAA_TAB_SPACE environment variable, A.1.5.8

RXC_NOW_STRING environment variable, A.1.5.9

RXC_PD, 1.10.1

RXC_PD schema, 1.10.1

RXC_PRINTER environment variable, A.1.5.10

RXC_REP, 1.10.1

RXC_REP account, 13.2.1.2

RXC_REP schema, 1.10.1

RXC_SAS_BATCH_QUEUE environment variable, A.1.5.11

RXC_SAS_CONNECT environment variable, A.1.5.12

RXC_USER

location for SAS data extract views, 1.8.2

rxc_user directory, 1.8.2

RXC_USER environment variable, A.1.5.13

rxcchkobj.sh utility, D.2

rxcdcf.bmp, 3.11.2

rxcdelproc, 10.3

RXCLIN_MOD, 1.10.1

RXCLIN_MOD role, 1.10.1

RXCPROD

and execution permission, 1.2.4

using PSUB to create OS account, 1.2

RXCPROD account

PATH, 1.2.5

S

SAS data extract views

adding users on UNIX, 1.8.2

location, 1.8.2

SAS datasets, 1.8.2

SAS_VIEW directory, B

SASORA, A.1.5.14

schema

RXC_DISC_REP, 1.10.1

RXC_MAA, 1.10.1

RXC_PD, 1.10.1

RXC_REP, 1.10.1

RXCLIN_MOD, 1.10.1

script

scripts

ocl_add_user.sql, 1.3

Second-Pass comparison failure alert, 5.1.1.1

seed data

updating manually, D.4

seed number, 13.2.3

sequence generator, 13.2.3

sequencing

DCI Book, 5.1.1.1

of RDCIs, 5.1.2

server code

relinking, D.2

set_pwd utility, 1.10.1, 1.10.1

site assignment

and distributed study conduct, 14.2.2

and integrity of distributed data, 14.5.5.4.1

at a sharing location, 14.3.1

site plans

and integrity of distributed data, 14.5.5.4.1

at a sharing location, 14.3.1

Smart RDCM window, 5.2.1, 5.2.4

SOURCE LOCATION CODE reference codelist, 13.3.1

SQL

adding to profiles, 3.3.4

standard text

adding replacement parameters, 3.12.2

creating, 3.12

editing, 3.12.3

setting up, 3.12

statistics, cost-based, 9.2.1.4

studies

enabling for replication, 14.5.3

study definition

and ownership, 14.3

replication, 14.5.4

study design

and ownership, 14.3.1

replication, 13.5

study plan, and integrity of distributed data, 14.5.5.4.1

STUDY_REPLICATION_JOBS table, 14.5.5.2

Sub Type, and standard text, 3.12.1

sub-event

number, in Smart RDCM window, 5.2.4

symbolic links, D.1

symmetric replication

enabling, 13.5.1.1

system accounts, 1.2.2

System malfunctions, C.3

T

tablespaces, E

partitioning, 9.3.11.5

TEMP environment variable, A.1.5.15

test mode, C.2.4

text type, 3.12.1

Thesaurus Management System

U

Unenrolled Patient Alert parameter, 5.1.1.1

UNI DISC COLS2 codelist, 4.2

Univariate Beep, 5.1.2

Univariate Failure Alert, 5.1.2

Univariate Failure Alert parameter, 5.1.1.1

UNIX passwords, 1.10.5.1

Update mode, 5.1.1.1

update privileges

and review status settings, 3.3.7.3

setting for discrepancies, 3.3.7.1

user accounts

creating on UNIX, 1.2.2.2

creating on Windows, 1.2.2.3

general, 1.2.2

requirements, 8.1

user groups

setup, 3.1.1

User menu, 2.3

USER_BV_JOB environment variable, A.1.5.16

USER_QUERIES table

creating, 1.8.3

V

validation procedures

generating, 10.2

validation status

computing, 10.1

variables, and standard text, 3.12.2

visit

number, in Smart RDCM window, 5.2.4

W

wildcards

to grant access to Programs and Projects, 1.5.1

Windows passwords, 1.10.5.2

X

Xhelp, 5.6

topic files, 5.6.2