Index

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

A

Accessible Data Only? column, 3.4.1.2

accounts

create OPS$, 1.3

requirements for batch jobs, 8.1

Add Review Status button, 3.4.1.5

anadestab.sql, E.5

anadestab.sql script, E.5

analrtab.sql, E.5

ANALYZE command, 9.3.5

ananlstab.sql, E.5

anaopatab.sql, E.5

anarxctab.sql, E.5

application_area_code, 7.4.1

application_system_name, 7.4.2

approve_verify_retain_code, 7.4.3

approve_verify_reverse_code, 7.4.4

asynchronous PSUB jobs, 8.2.1

attributes

extended, 7.4.31

auto fill, 5.1.2

auto skip, 5.1.2

B

batch jobs

execution status, C.4.5.1

troubleshooting, C.4

user accounts for, 8.1

batch_queue_name, 7.3.1

bj10, 8.3.6

blind_type_code, 7.4.5

blk_master_privs, 1.6.3

blocking jobs, 8.2.2

Browse mode

access to, 5.1.1.1, 5.1.1.1

C

cbex10P, 8.3.9.2

CDS

setting field display, 4.2, 4.3

check_opa_settings script, A.1.3.3

clinical_phase, 7.4.6

cnvstatus, 10.1

running on UNIX, 10.1.1

running on Windows, 10.1.2

codelists, setting up in a discrepancy database, 3.10

codelists_desinst, 7.1

codelists_inst, 7.1

codelists_local, 7.1

codelists_system, 7.1

collection scripts

anadestab.sql, E.5

analrtab.sql, E.5

ananlstab.sql, E.5

anaopatab.sql, E.5

anarxctab.sql, E.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, E.5

cost-based statistics, 9.2.1.4

countries, 7.4.7

CRF information

defined, Glossary

crf_page_numbering_scheme, 7.4.8

crf_page_status_codes, 7.4.9

crf_page_status_query, 7.4.10

crjobset, 8.3.9.1

current study

defined, Glossary

Custom button, 5.6

custom_help, 5.6.1

D

data collection instrument (DCI)

defined, Glossary

data entry

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

local database-level, 5.1.1.1

modifying, 5.1.1.1

overriding, 5.1.1

precedence of, 5.1.1.2

study-level, 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

data extract

enabling 3.1-style, 6.6

data extract views

generating, 6.5

data_change_reason_type_code, 7.4.11

data_change_reason2_type_code, 7.4.12

Database Server

Windows

opa_settings, A.1.1

database trace session, C.5

date

formats of, 5.1.2

db_links, 7.3.2

db_password, 1.10.2

DCF

placeholder graphic, 3.12.2

views, 3.12.2

DCF REPORT LABELS codelist, 3.12.2

DCF STATUS CODES codelist, 3.12

dcf_comment_text, 7.3.3

dcf_default_footers, 7.3.4

dcf_default_headers, 7.3.5

dcf_lock_conditions, 7.4.13

dcf_optional_status_codes, 7.4.14

dcf_report_labels, 7.3.6

dcf_status_codes, 7.4.15

DCI Book

sequencing, 5.1.1.1

using, in data entry, 5.1.1.1

dci_form_local_db_settings, 5.3

dcif_checkbox_size, 7.4.16

dcif_font_typesize, 7.4.17

dcif_page_definition, 7.4.18

dcm_dci_qg_type_code, 7.4.19

de_config_settings, 5.1.1.1

de_user_prefs, 5.1.2

deadlock detected, C.2.2

Decrease Width button, 5.2.2

default study

defined, Glossary

DISC COLS2 codelist, 4.2

disc_cols, 7.3.7

disc_flex1, 3.5.1

disc_flex1_values, 3.5.2

DISC_FLEX1_VALUES codelist, 3.5.2

disc_flex2, 3.5.1

disc_flex2_values, 3.5.2

DISC_FLEX2_VALUES codelist, 3.5.2

disc_stdst_values, 7.4.27

discrepancies, 10.1

resolution of, by data entry operator, 5.1.1.1

DISCREPANCY FUNCTIONS codelist, 3.2.1

DISCREPANCY REV STATUS CODE codelist, 3.4.1.5, 3.7

DISCREPANCY STATUS DM, 3.10.1.5

DISCREPANCY STATUS SITE, 3.10.1.7

discrepancy_actions_cra, 3.10.2.2

discrepancy_actions_dm, 3.10.2.3

discrepancy_actions_inv, 3.10.2.4

discrepancy_actions_site, 3.10.2.5

discrepancy_messages, 7.4.21

discrepancy_no_other_update, 3.10.3

discrepancy_resolu_type_code, 3.8

discrepancy_rev_status_code, 3.7

discrepancy_status_cra, 3.10.1.4

discrepancy_status_dm, 3.10.1.5

discrepancy_status_inv, 3.10.1.6

discrepancy_status_site, 3.10.1.7

discrete_val_grp_type_code, 7.4.26, 7.4.26

dm_profiles, 3.4

dose_form_type_code, 7.4.28

dose_frequency_type_code, 7.4.29

dx_config, 7.4.30

dx_extended_attributes, 7.4.31

dx_index_tablespace, 7.4.32

dx_installation_config, 6.1

dx_key_name, 7.4.33

dx_roles, 7.4.34

dx_view_tablespace, 7.4.35

E

End of Form Beep, 5.1.2

Enterprise Manager, 8.3.3.3

environment variables, A, A.1.5

changing, A.1.3

equipartitioned

defined, 9.1.2.1

error messages, C.2

ORA-04020, C.2.2

ORA-12223, C.2.1

ORA-20009, C.2.3

execution status

batch jobs, C.4.5.1

execution_sched_code, 7.4.36

exp_design_type_code, 7.4.37

exp_resp_param.dat file, 9.3.2

Export utility, 9.3.2

external_trans_type, 7.4.38

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

fld_rxcmcmcd_rdci_delete, 7.3.10

fld_rxcmcmcd_rdci_key, 7.3.11

fld_rxcmcmcd_rdcm_key, 7.3.12

fld_rxcmcmcd_response, 7.3.13

FTP file viewing protocol, 11.1

function privileges

defining, 3.2.1

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

granting

program access, 1.5.1

project access, 1.5.1

H

HTTP file viewing protocol, 11.1

I

imp_resp_param.dat file, 9.3.4

Import utility, 9.3.4

Increase Width button, 5.2.2

IND DISC COLS2 codelist, 4.2

ind_disc_cols, 7.3.14

indexing, 9

initialization error, C.4.5.6

installation reference codelist

DISCREPANCY STATUS DM, 3.10.1.5

DISCREPANCY STATUS SITE, 3.10.1.7

invalid objects

partitioning, 9.3.7

Items Not Displayed, 5.2.2

J

js10, 8.3.9

K

Kernel32.DLL error, C.4.5.6

key templates

domain, 6.1, 6.1

L

lab_range_subset_code, 7.4.39

launchps.sh file, E.3

layout

Log-In

editing function of, 5.2, 5.2.1

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.3

layout_definitions, 3.3

list_study_resp_cnt_part script, 9.3.11.2.2

locking

profile criteria, 3.4.1.2

Log-In

navigating during, 5.2.1

Log-In Layout Editor menu option, 5.2.1

login_layout_editor, 5.2.1

lognames, 8.3.8

M

m_dir_maps, 11.3

Maintain Partition Mapping Tables window, 9.2.1.3

man_disc_cols, 7.3.15

MANHD DISC COLS2 codelist, 4.2

manhd_disc_cols, 7.3.16

Manual Discrepancy in Browse parameter, 5.1.1.1

manual_source_type_code, 7.4.40

mapping_type, 7.4.41

master profiles, 3.4

MC CDS SORT ORDER codelist, 4.2

MC COLUMNS codelist, 4.2

mc_cds_sort_order, 7.3.17

mc_columns, 7.3.18

medical_eval_type_code, 7.4.42

menus

modifying, 2.3, 2.3

More button, 5.6

MULTI DISC COLS2 codelist, 4.2

multi_disc_cols, 7.3.19

N

nls_config, 7.3.20

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

objective_type_code, 7.4.43

objects

special database, 1.10.1

OCL MC PREFS codelist, 4.2

ocl_add_user.sql script, 1.3

OCL_DE_CONFIG, 7.3.22

ocl_de_config, 7.3.22

ocl_de_prefs, 7.3.23

ocl_domains, 7.4.44

ocl_installation, 7.4.45

ocl_job_pref, 7.3.24

ocl_mc_prefs, 7.3.21, 7.3.25

ocl_menu_access, 7.3.26

ocl_options_type_code, 7.4.46

ocl_state, 7.3.27

OCL_STATE codelist, 3.9

OCL_STATE reference codelist, 9.1.1.1, C.4.5.6

OCLSASCR user group

and SAS data extract views, 1.8.2

oclupg32to40opt5.sql script, 9.4.5

opa_menu_roles, 7.4.47

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, E.2

operating system passwords, 1.10.5

optimization, E.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

oracle_accounts, 1.4

oracle_accounts_programs, 1.5.1

oracle_accounts_studies, 1.5.2

os_password, 1.10.5

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

partitioning_mapping_tables, 9.2

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_status_code, 7.4.48

plan_study_int_type_code, 7.4.49

planned events

in the Smart RDCM window, 5.2.4

populate_part_map_table script, 9.2.1.2

print_queue_name, 7.3.28

privileges

of data entry operator, 5.1.1.1

procedure_type_code, 7.4.50

procedures

deleting inactive, 10.3

production mode, C.2.3

.profile, 1.2.5

.profile file, 1.9.1

profile views, 3.4.1

profiles, 3.4

criteria, 3.4.1

locking criteria, 3.4.1.2

setting up, 3.4

protocols

for file viewing, 11.1

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.3.8.3

PSUB process, 8.3

public_db_links, 7.3.29

Q

Question Groups

repeating, 5.1.1.1

question_category_type_code, 7.4.51

questions

attributes of, 7.4.31

R

RDC

customize workspace, 5.5.3

rdc_security_main, 3.11

RDCI sort order, 5.1.2

rdci_change_reason_type_code, 7.4.52

rdci_change_reason2_type_code, 7.4.53

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, E.1

reference codelist

OCL_DE_CONFIG, 7.3.22

reference codelists

design, 7.1

installation, 7.1, 7.4

local, 7.1

OCL_STATE, 9.1.1.1

system, 7.1

reference_codelists_report, 7.2.2

region_type_code, 7.4.54

registry settings, A.2

relink_rxc.log file, E.2

relink_rxc.sh script, E.1

relinking server code, E.2

relocating Oracle Clinical, E.3

repeat default, 5.1.1.1

replacement parameters, and standard text, 3.13.2

report_server, 7.3.30

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

retirement_reason_type_code, 7.4.55

Revert button, 5.2.2

review status codes

defining, 3.7

roles

creating new, 2.2.3

route_of_admin_type_code, 7.4.56

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 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 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, E.2

rxcdcf.bmp, 3.12.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_formats, 7.4.57

sas_queue, 7.3.31

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, E.4

sequencing

DCI Book, 5.1.1.1

of RDCIs, 5.1.2

server code

relinking, E.2

SERVER_NAME reference codelist entry, C.4.5.6

SERVER_OS reference codelist entry, C.4.5.6

set_pwd utility, 1.10.1, 1.10.1

single_dci_types, 7.4.58

Smart RDCM window, 5.2.1, 5.2.4

source_location_code, 7.4.59

SQL

adding to profiles, 3.4.1.3

sql_functions, 7.3.32

standard text

adding replacement parameters, 3.13.2

creating, 3.13

editing, 3.13.3

setting up, 3.13

standard_text, 3.13

standards_affil_type_code, 7.4.60

statistics, cost-based, 9.2.1.4

study_status_type_code, 7.4.61

Sub Type, and standard text, 3.13.1

sub-event

number, in Smart RDCM window, 5.2.4

symbolic links, E.1

system accounts, 1.2.2

System malfunctions, C.3

system_codelists, 7.6

T

tablespaces, D

partitioning, 9.3.11.5

TEMP environment variable, A.1.5.15

test mode, C.2.3

text type, 3.13.1

Thesaurus Management System

U

UNC file viewing protocol, 11.1

Unenrolled Patient Alert parameter, 5.1.1.1

UNI DISC COLS2 codelist, 4.2

uni_disc_cols, 7.3.34

units_of_measure_type_code, 7.4.68

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.4.1.6.3

setting for discrepancies, 3.4.1.6.1

user accounts

creating on UNIX, 1.2.2.1

creating on Windows, 1.2.2.2

general, 1.2.2

requirements, 8.1

user groups

setup, 3.2

User menu, 2.3

USER_BV_JOB environment variable, A.1.5.16

user_group_dms, 3.2

user_group_roles, 3.1

user_groups, 3.2

USER_QUERIES table

creating, 1.8.3

V

validation procedures

generating, 10.2

validation status

computing, 10.1

validation_failure_type_code, 7.4.71

variables, and standard text, 3.13.2

view mode icons, illustrated, 3.4

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