Local Reference Codelists

Local reference codelists control the behavior of some Oracle Clinical features in the selected database only. You can modify local codelists if your user role has one of the following schema: RXC_ADMIN, RXC_SUPER, or RXC_SUPER_NOGL.

For more information , see:

• BATCH QUEUE NAME Local Codelist
  
• DB_LINKS Local Codelist
  
• DCF COMMENT TEXT Local Codelist
  
• DCF DEFAULT FOOTERS Local Codelist
  
• DCF DEFAULT HEADERS Local Codelist
  
• DCF REPORT LABELS Local Codelist
  
• DISC COLS Local Codelist
  
• DISC_FLEX1 and DISC_FLEX2 Local Codelists
  
• DISC_FLEX1_VALUES and DISC_FLEX2_VALUES Local Codelists
  
• FLD RXCMCMCD RDCI DELETE Local Codelist
  
• FLD RXCMCMCD RDCI KEY Local Codelist
  
• FLD RXCMCMCD RDCM KEY Local Codelist
  
• FLD RXCMCMCD RESPONSE Local Codelist
  
• IND DISC COLS Local Codelist
  
• MAN DISC COLS Local Codelist
  
• MANHD DISC COLS Local Codelist
  
• MC CDS SORT ORDER Local Codelist
  
• MC COLUMNS Local Codelist
  
• MULTI DISC COLS Local Codelist
  
• NLS_CONFIG Local Codelist
  
• OCL_DE_CONFIG Local Codelist
  
• OCL_DE_PREFS Local Codelist
  
• OCL_JOB_PREF Local Codelist
  
• OCL MC PREFS Local Codelist
  
• OCL_MENU_ACCESS Local Codelist
  
• OCL_STATE Local Codelist
  
• PRINT QUEUE NAME Local Codelist
  
• PUBLIC_DB_LINKS Local Codelist
  
• RDC CONFIGURATION Role Local Codelists
  
• REPORT_SERVER Local Codelist
  
• SAS_QUEUE Local Codelist
  
• SQL FUNCTIONS Local Codelist
  
• TMS_DSI Local Codelist
  
• TMS_OPTIONS Local Codelist
  
• UNI DISC COLS Local Codelist
  
• WEB_DOCUMENT_CONFIG Local Codelist
  
• WEB_DOCUMENT_GROUPS Local Codelist
  
• PDR_FILE_NAMING Local Codelist
  

BATCH QUEUE NAME Local Codelist

This codelist contains batch queue names to be used by the Parameterized Submission (PSUB) utility for this Oracle Clinical instance.

The reference codelist ships with a short value of RXC_BATCH_QUEUE, and a long value of a. This short value is in turn found in the OCL_JOB_PREF reference codelist, indicating that this is the default batch queue to be used by PSUB.

You can set a different default queue for a particular user by specifying any short value from the BATCH QUEUE NAME reference codelist when you create or modify the user's account. When adding entries, the short value specifies a symbolic name for the queue, and the long value specifies a single character queue like a, d, e. b and c are excluded, as these are reserved.

You can modify the long value for the RXC_BATCH_QUEUE entry in one of 2 ways:

• change the value to another single-character queue name

• enter the value RXC_BATCH_QUEUE

If you choose the latter option, PSUB interprets this as an environment variable, whose value is set in the opa_settings file; see Environment Variables and Registry Settings.

DB_LINKS Local Codelist

This codelist contains the names of database links for standard replication.

Standard replication is a "pulling" operation; that is, the database location requesting the data must initiate the action. Each database in the installation maintains its own local DB_LINKS reference codelist. There should be an entry in the Short Value field for each of the other database locations in the installation. The Long Value contains the name of the private database link to that database, owned by the Oracle user RXC_REP.

DCF COMMENT TEXT Local Codelist

This codelist contains values you can use as the initial text for the DCF comment field.

DCF DEFAULT FOOTERS Local Codelist

This codelist contains values you can use as the footer text to be inserted into the DCF Footer field. See Defining DCF Headers and Footers.

DCF DEFAULT HEADERS Local Codelist

This codelist contains values you can use as the header text to be inserted into the DCF Header field. See Defining DCF Headers and Footers.

DCF REPORT LABELS Local Codelist

This codelist contains user-configurable labels for the DCF Report.

DISC COLS Local Codelist

This codelist contains the variables that can be specified for MCU CDS Discrepancy criteria; see Customizing Mass Changes Local Codelists.

DISC_FLEX1 and DISC_FLEX2 Local Codelists

See Customizing Flexfields for information.

DISC_FLEX1_VALUES and DISC_FLEX2_VALUES Local Codelists

See Customizing Flexfields for information.

FLD RXCMCMCD RDCI DELETE Local Codelist

This codelist contains the display and order of RDCI Delete Candidate Data Set fields; see Customizing Mass Changes Local Codelists.

FLD RXCMCMCD RDCI KEY Local Codelist

This codelist contains the display and order of RDCI Key Change Candidate Data Set fields; see Customizing Mass Changes Local Codelists.

FLD RXCMCMCD RDCM KEY Local Codelist

This codelist contains the display and order of RDCM Key Change Candidate Data Set fields; see Customizing Mass Changes Local Codelists.

FLD RXCMCMCD RESPONSE Local Codelist

This codelist contains the display and order of response Candidate Data Set fields; see Customizing Mass Changes Local Codelists.

IND DISC COLS Local Codelist

This codelist contains variables that you can specify for MCU CDS Ind discrepancy criteria; see Customizing Mass Changes Local Codelists.

MAN DISC COLS Local Codelist

This codelist contains variables that you can specify for MCU CDS manual discrepancy criteria; see Customizing Mass Changes Local Codelists.

MANHD DISC COLS Local Codelist

This codelist contains variables that you can specify for MCU CDS manual header discrepancy criteria; see Customizing Mass Changes Local Codelists.

MC CDS SORT ORDER Local Codelist

This codelist contains the sort order of CDS fields; see Customizing Mass Changes Local Codelists for information.

MC COLUMNS Local Codelist

This codelist contains variables that you can specify for MCU CDS criteria; see Customizing Mass Changes Local Codelists.

MULTI DISC COLS Local Codelist

This codelist was used for the NLS option, which is no longer supported.

NLS_CONFIG Local Codelist

This codelist was used for the NLS option, which is no longer supported.

OCL_DE_CONFIG Local Codelist

This codelist controls Data Entry configuration settings. The entries for values are listed and described in the following table.

Note:

The settings with sequence numbers 1-9, 12-14, and 17 are also updatable in the Maintain Installation Configuration window under Admin, DE Admin, DE Config Settings; see Define Data Entry Configuration Settings.

Table 7-3 Values for the OCL_DE_CONFIG Reference Codelist

Seq	Short Value	Long Value	Description
1	2ND PASS ALERT	Y	Determines if the alert for a 2nd Pass comparison failure is enabled.
2	DISC IN BROWSE	Y	Determines if the user is allowed to initiate a manual discrepancy when working in browse mode.
3	DISC RES IN DE	Y	Determines if the user is allowed to resolve discrepancies during data entry.
4	PRIV UPDATE	N	Determines if the privileged update is enabled at the database level.
5	THESAURUS list of values	Y	Determines if the DVG, which populates the list of values, for thesaurus questions is enabled.
6	UNIVAR ALERT	Y	Determines if the univariate validation alert, which prompts the user to a validation error during data entry, in enabled.
7	USE DCI BOOK	N	Determines if the system initiates a data entry session using a DCI book.
8	UNENROLL ALERT	Y	Determines if the system alerts the user to a patient that has been unenrolled.
9	P2 NOT BY P1	N	Determines if the system prevents a Pass 1 data entry operator from performing Pass 2 data entry.
10	OCL THES DISC	N	Determines if system alerts the user to OLC Thesaurus discrepancies during data entry.
11	OCL THES list of values	N	Determines if the lists of values for OCL Thesaurus questions are enabled.
12	BROWSE ACC ONLY	N	Determines if data in accessible documents is browse only.
13	DEF PAGE HEIGHT	22	Sets the default height of the DCM data entry page in points, pixels, inches, or centimeters, depending on the unit of measure selected in the Maintain Installation Configuration window under Admin, DE Admin, DE Config Settings; see Define Data Entry Configuration Settings. Applies only to Oracle Clinical.
14	DEF PAGE WIDTH	78	Sets the default height of the DCM data entry page in points, pixels, inches, or centimeters, depending on the unit of measure selected in the Maintain Installation Configuration window under Admin, DE Admin, DE Config Settings; see Define Data Entry Configuration Settings. Applies only to Oracle Clinical.
15	P2 ALWAYS ALERT	Y	Determines if the system alerts the user whenever Pass 2 data differs from the corresponding Pass 1 data. Note: The Long Value should be a maximum of 2 characters; longer values cause problems in Oracle Clinical data entry.
16	AUTO SEQ DFLT	Y	Sets the default auto sequence behavior; when a user presses tab in the last field of a DCM/CRF Section, the system opens the next DCM for data entry.
17	DCI DATE REQ	Y	Sets the default as to whether the DCI date is required in the Log-in form.
18	DVGSEQOVERALPHA	N	Used only when a question meets the following criteria: An internal DVG and an alpha DVG are assigned. An Enter By Sequence is enabled for the internal DVG. The internal DVG and the alpha DVG have values with the same sequence number. When the user enters a sequence number that exists in both DVGs, the system: Records the internal DVG value if the DVGSEQOVERALPHA value is set to Y. Records the alpha DVG value with the same sequence number if the DVGSEQOVERALPHA value is set to N.
19	DVG List of Values STYLE	SEQ	Determines how the system displays the list of values for DVG and Alpha DVG questions. Note: The Long Value should be a maximum of 15 characters; longer values cause problems in Oracle Clinical data entry
20	COMMCHGREAS_REQ	Y	Determines if a change reason is required for updates to RDCI comments in accessible documents.
21	JUSTENTERP1TIME	0	Sets the time period (in minutes) during which a Pass 1 Complete RDCI/RDCM can be modified in Pass 1 mode.
22	JUSTENTERP2TIME	0	Sets the time period (in minutes) during which a Pass 2 Complete RDCI/RDCM can be modified in Pass 2 mode.
23	SEQUENCEBUFFER	1000000	Defines the sequence buffer used to prevent the sequence from reaching its maximum value. At this setting, when a sequence number is within 1,000,000 of 9,999,999,999, the system displays a warning message when a user attempts to use a relevant subsystem and the system exits the current screen; see Managing High Sequence Numbers.
24	RSTRCT LCKD CRF	N	Determines if some actions are permitted on a locked CRF. Applies to RDC Onsite only.

For more information , see:

• DVG List of Values STYLE
  
• COMMCHGREAS_REQ
  
• JUSTENTERP1TIME
  
• JUSTENTERP2TIME
  
• RSTRCT LCKD CRF
  

DVG List of Values STYLE

This value determines how the system displays the list of values for DVG and Alpha DVG questions. The options for this value are SEQ and SHORT.

Note:

If "Enter by Sequence" is not selected in the DVG definition, this reference codelist setting (SEQ or SHORT) has no effect. The list of values does not display the sequence number, sorts records by the DVG value, and displays these columns in this order:

1. Short Value, which is titled "DVG Value" in the list of values

2. Alpha Column, which contains "A" if it is an Alpha DVG value or is null for all others

3. Long Value, which is titled "Description" in the list of values.

SEQ

If the Long Value is set to "SEQ" and "Enter by Sequence" is selected in the DVG definition, the columns in the list of values are displayed in this order:

1. Display SN (prefixed with "A" if it is an Alpha DVG value)

2. Short Value, which is titled, "DVG value" in the list of values

3. Long Value, which is titled "Description" in the list of values.

The records are sorted by DVG sequence number.

SHORT

If the Long Value is set to "SHORT" and "Enter by Sequence" is selected in the DVG definition, the columns in the list of values are displayed in this order:

1. Short Value, which is titled "DVG Value" in the list of values

2. Display SN (prefixed with "A" if it is an Alpha DVG value)

   Note:

   The sequence number is displayed only if there is an alpha DVG associated with the question.

3. Long Value, which is title "Description" in the list of values.

The records are sorted by DVG sequence number.

COMMCHGREAS_REQ

This value determines if the system requires a change reason when the RDCI comment is updated and the document is internally accessible. The options for this value are "Y" and "N". The default value is "Y", which causes the system to require a change reason for an update to the RDCI comment.

JUSTENTERP1TIME

This value defines time period (in minutes) during which a user can modify or query a previously Pass 1 Complete RDCI/RDCM in Pass 1 mode.

The initial value of this entry is "0".

JUSTENTERP2TIME

This value defines the time period (in minutes) during which a user can modify/query a previously Pass 2 Complete RDCI/RDCM in Pass 2 mode.

The initial value of this entry is "0".

RSTRCT LCKD CRF

By default, RDC Onsite restricts access to locked CRFs. You can use the RSTRCT LCKD CRF setting in the OCL_DE_CONFIG local reference codelist to allow some users to take actions on locked CRFs.

• Y — Specifies that users cannot update discrepancies for a locked CRF, verify a locked CRF, or approve a locked CRF unless the CRF is specifically unlocked for them.

• N — Specifies that any user with UPD_DISCREP privileges can work on discrepancies in a locked CRF, any user with VERIFY privileges can verify a locked CRF, and any user with APPROVE privileges can approve a locked CRF.

OCL_DE_PREFS Local Codelist

This codelist enables you to set the default data entry preferences for this instance. The default entries are displayed and described in the following table. You can also set almost all of these values in the Maintain Installation Preferences under Admin, DE Admin, DE User Prefs. The exceptions, which you can set only here, are: AUTO NEXT FORM and AUTO SEQ DEFLT.

Table 7-4 Values for the OCL_DE_PREF Reference Codelist

Seq	Short Value	Long Value	Description
1	AUTO SKIP	Y	Determines if auto skip is enabled.
2	AUTO FILL	Y	Determines if auto fill is enabled.
3	UNIVAR BEEP	Y	Determines if the system sounds a beep when a recorded response value generates a validation error.
4	COMPARISON FAILURE	Y	Determines if the system sounds a beep when a response value generates a comparison failure.
5	END FORM BEEP	Y	Determines if the system sounds a beep when the user navigates from the last field in a form.
6	DATE ENTRY FMT	US	Determines the default format for dates that the system assumes during data entry.
7	DATE DISPLAY FMT	STANDARD	Determines the format the system uses to present dates in the display.
8	RDCI ORDER	PATIENT	The "order-by" the system uses for RDCI queries.
9	AUTO NEXT FORM	Y	Determines if the system automatically displays the next data entry form in the sequence.
10	AUTO SEQ DEFLT	Y	Determines if auto-sequence is set by default.

OCL_JOB_PREF Local Codelist

This codelist sets default values in the Oracle Clinical PSUB job window.

Oracle Clinical ships default system-wide values in the local reference codelist OCL_JOB_PREF. Each entry refers to a specific row in another reference codelist, which must be updated with correct values for your installation. The long value in this reference codelist is populated from the short value in the other reference codelist. The following table lists the defaults you can set.

Table 7-5 Entries in the OCL_JOB_PREF Reference Codelist

Short Value	Description	Refers to Reference Codelist
PSUB_PRINTER	Default PSUB Printer	PRINT QUEUE NAME Local Codelist
DFLT_PSUB_QUEUE	Default PSUB Queue	BATCH QUEUE NAME Local Codelist
DFLT_REPORT_RS	Default Reports Server	REPORT_SERVER Local Codelist
DFLT_JOBSET_RS	Default Job Set Reports Server	REPORT_SERVER Local Codelist
DFLT_PSUBSCH_RS	Default for PSUB Scheduling, generating DCI Forms, and previewing	REPORT_SERVER Local Codelist
DFLT_RS_PRINTER	Default Reports Server Printer	PRINT QUEUE NAME Local Codelist

For example, to set a printer as the default for reports at an installation:

1. Navigate to Admin, then Reference Codelists, and Local Codelists.

2. Insert a record in the PRINT QUEUE NAME Local Codelist:

   • Short Value – Name of the printer, for example, boston09
   • Long Value – Printer specification, for example, \\ocldsn1\boston09
   • Description – Information about the printer that may be helpful to the end user

   (Note that all three values display in the Submission Details screens.)

3. In the OCL_JOB_PREF codelist, update the Long Value of the DFLT_RS_PRINTER entry with the Short Value of the printer from Step 2.

OCL MC PREFS Local Codelist

This codelist's single value, MAX_CDS_RECORDS, sets the default maximum number of records to change using the Mass Changes utility. Its initial value is 1000; see Customizing Mass Changes Local Codelists.

OCL_MENU_ACCESS Local Codelist

This codelist contains settings that support configuration of menu options.

Table 7-6 OCL_MENU_ACCESS Default Values

Seq	Short Value	Long Value
1	PRPJ	Y
2	ORUN	Y
3	REGION	Y
4	STUDY	Y
5	FACTOR	Y
6	STRATA	Y
7	ACSU	Y
8	DRUG	Y
9	REGIMEN	Y
10	SITES	Y
11	INVEST	Y
12	PATTERN	Y

OCL_STATE Local Codelist

OCL_STATE tracks information about the database, such as its name, operating system, and RDBMS version, which Oracle Clinical requires to complete certain processes. Some of the short values are described in more detail following the table.

Table 7-7 Values for the OCL_STATE Reference Codelist

Short Value	Long Value	Description
BDL_ROOT	—	Path to the batch data load root directory used for input and output files.
BDL_R_SE	—	Specifies the rollback segment for Batch Data Load processes.
BDL_USERDIRS	Y	If Y, there are user-specific directories for Batch Data Load, which you must create. If N, there are not. See Creating Directories for Input and Output Files of Certain Job Types.
BOOK_ASSIGN	N	Assign DCI book to patient on first data entry: Y or N.
BOOK_CHANGE	ALLOW	Change of DCI Book for patient: ALLOW, DISALLOW, or DISALLOW IF DATA.
BOOK_USAGE	IGNORE	(Applies only to Oracle Clinical data entry) If set to IGNORE (the default) the system allows the user to use any book for the patient, regardless of the patient's book assignment. If set to PROMPT, the sytem allows the use of any book but gives a warning. If set to ENFORCE, the system does not allow using any book other than the one to which the patient is assigned.
DB_BLOCK_SIZE	—	The database block size from init.ora.
DB_HOST	—	Host name for the database, as entered in tnsnames.ora file.
DB_NAME	name of service	If you have a RAC environment, enter the name of the service. If you do not have a RAC installation, this is normally the name of the database.
DB_PORT	—	Port number for the database as entered in tnsnames.ora file.
DB_VERSION	—	The database version, this is used by Data Extract to determine optimization.
DCF_TEXT_SYNC	N	Edits to comment and resolution texts in DCFs propagate to discrepancy management.
DFLT_PAGE_TRACK	Y	Specifies the default value of the "Page Tracking Enabled" study level setting.
DISC_AUTO_CRFPG	Y	Auto Generation of CRF Page Number.
DISC_AUTO_HDFT	Y	Auto Generation of Header/Footer Text.
DISC_DCM_PROMPT	QUESTION_NAME	The single-record mode of the Maintain Discrepancy Database form's Characteristics panel has a button that toggles the three long value settings. Choose the value to display by default: question_name (displays the name of the question associated with the discrepancy).
DISC_REP_WALLET	—	If you use disconnected replication, enter the wallet alias you created for RXC_DISC_REP during installation.
DMGR RDC ACCESS	YES	See Granting Automatic Access in RDC to Studies Granted in Oracle Clinical.
DM_PROMPT	Study Site	Prompt for the DM window.
FILE_VIEWER	Y	Used by PSUB to view the log and output files.
INVOKE_IMAGE	N	Enable imaging interface (Y/N) ?
INVOKE_WORKFLOW	N	Used by the Login form to determine if a workflow system can be used.
LAB_ROOT	—	Path to the root directory for Lab Ranges Batch Data Load files.
LAB_USERDIRS	Y	If Y, there are user-specific directories for Lab Ranges Batch Data Load input and out files, which you must create. If N, there are not. See Creating Directories for Input and Output Files of Certain Job Types.
LANGUAGE	ENGLISH	—
LOCATION_CODE	—	Client name for the current location.
OPA_LESTR_SYNCH	1	This value is not used.
PRINTER_TYPE	PDF	Default type of printer output.
PROC_LAB_ALIAS	LAB	The name of the lab variable for the standard Procedure question group prompt.
PSUB_DEL_FILES	N	Select Y to automatically delete PSUB log and output files from the user-specific subdirectory of the PSUB_LOGS_DIR after the file is written to the database table where it will be stored and viewed from permanently. Select N to keep the files in the user-specific subdirectory as well as the database table.
PSUB_LOGS_DIR	/home/opapps/log	Path to the temporary base log and output file directory for PSUB jobs. You must create the directory. The system automatically creates a subdirectory for each user who runs PSUB jobs.
PSUB_SESSION	—	Internal setting - PSUB session ID
QUERY MENU SEC	Y	If set to Y (default), the data security rules applicable to the non-query (enterable) forms applies to the query only forms also. If set to N, the query form displays all data independent of the data security rules defined for the non-query forms.
RAND_ROOT	—	Path to the root directory for Randomization files.
RAND_USERDIRS	Y	If Y, there are user-specific directories for Randomization input and out files, which you must create. If N, there are not. See Creating Directories for Input and Output Files of Certain Job Types.
REMOTE_SASOUT	—	Leave blank. (Reserved for possible future use where you would specify a value if SAS is installed on a separate computer that is not in your intranet. Files would be transferred via SFTP from SAS_OUTPUT_ROOT to REMOTE_SASOUT.)
REMOTE_SAS_SERV	—	Specify the name of the server if SAS is installed on a separate computer within your intranet. Oracle Clinical does not use the specific value that is specified, it only checks if this field is null or not.
REMOTE_SAS_VIEW	—	Leave blank. (Reserved for possible future use where this value would store the equivalent on the remote SAS server of the directory path stored in the RXC_SAS_VIEW environment variable and files would be transferred via SFTP from RXC_SAS_VIEW to REMOTE_SAS_VIEW for MANUAL execution.)
REPL_ROOT	—	Path to the root directory on the PSUB server where disconnected replication export files are exported to and imported from.
SAS_CONNECTION	ORACLE_WALLET	ORACLE_WALLET or SAS_ENCRYPTION SAS authentication method; see Authenticating the SAS Connection.
SAS_DX_EXEC	AUTOMATIC	AUTOMATIC to execute SAS jobs automatically. MANUAL if SAS is local and Oracle Clinical is hosted. If set to AUTOMATIC or not specified, the second job in a SAS DX execution, which must be run by SAS, is executed automatically; see Authenticating the SAS Connection. If set to MANUAL, the user must execute the second job manually in SAS.
SAS_OUTPUT_ROOT	—	Full path to the root directory for DX SAS Datasets and Proc Print output jobs; see Creating SAS Output File Directories.
SAS_USERDIRS	Y	Y or N. Y indicates user-specific subdirectories in SAS_OUTPUT_ROOT. If Y or null, then the user account name is appended to the value of SAS_OUTPUT_ROOT. Note: Unless all SAS users have access to the same studies, customers should use user directories in order to maintain security; see Creating SAS Output File Directories.
SEC_STORE_DIR	—	The Installer populates this with the path of the secret store directory.
SERVER_NAME	—	PSUB server name. In a RAC configuration, if you start PSUB on a different node, you must update this value to the new PSUB server name.
SERVER_OS	Server operating system	Indicates the operating system that the server is running. Valid entries are NT (to represent any supported version of Windows) or UNIX (to represent any supported version of UNIX).
TEMP_TABLES	—	Temporary Tablespace for use in new account creation activities.
TMS_FAIL_BV_ACT	FAIL	Determines whether Batch Validation continues when TMS derivation fails during Batch Validation: WARN or FAIL.
UPD_FV_INCREM	Y	Y or N - Y means do only incremental PDR Templates and HTML Forms generation.
USR_SAVE_OSPASS	N	Not used.

For more information , see:

• SAS_CONNECTION
  
• SERVER_OS
  
• LOCATION_CODE
  
• SERVER_NAME
  
• DB_BLOCK_SIZE
  
• TEMP_TABLES
  
• DM_PROMPT
  
• PROC_LAB_ALIAS
  
• DISC_DCM_PROMPT
  
• BOOK_ASSIGN
  
• TMS_FAIL_BV_ACT
  
• UPD_FV_INCREM
  

SAS_CONNECTION

During installation, the Database installer prompts you for the SAS_CONNECTION value and adds it to the OCL_STATE reference code list. The short value is SAS_CONNECTION.

The two long values, indicating the method used to connect the SAS and database servers:

• ORACLE_WALLET

• SAS_ENCRYPTION

SERVER_OS

Make sure the Long Value of the SERVER_OS entry in the OCL_STATE local reference codelist is correct for your operating system. You can enter one of the following values:

• NT — Indicates the server is running one of the Windows operating systems currently supported by Oracle Clinical.

• UNIX — Indicates the server is running the UNIX or Linux operating system.

LOCATION_CODE

For replication, the specific piece of information required is the LOCATION_CODE value, which is the client name for the current location. The system collects and stores this value during database creation.

SERVER_NAME

Set the SERVER_NAME value in this codelist to the database/PSUB server.

On UNIX systems, the Long Value of the SERVER_NAME entry must be in lowercase letters.

DB_BLOCK_SIZE

This entry is used by the DX table code to obtain the block size, which is used for space calculations. It is used for the dictionary-managed tablespace algorithm.

TEMP_TABLES

This entry specifies the name of the temporary tablespace the system users when creating DX study_access_accounts.

DM_PROMPT

This entry is used by the Discrepancy Management form as the prompt to use for Study site.

PROC_LAB_ALIAS

This entry is used during procedure generation to determine the alias of the standard RDCM Question LAB in the Procedure Question Group declarations. The system sets this to a default value of "LAB". This default value for the alias will conflict with the Question QGalias.LAB if you have a study question named "LAB."

If there is a conflict with the study question named LAB, you should redefine PROC_LAB_ALIAS to a different name, such as, "RDCM_LAB," to avoid errors during procedure generation. In this case, any references to the standard Received DCM Lab question must be changed to RDCM_LAB, or a generation error will occur. When you do this, procedure references to QGalias.LAB will relate to the study question LAB and references to QGalias.RDCM_LAB will relate to the standard Received DCM Lab.

DISC_DCM_PROMPT

Specifies the source of the question in a discrepancy. The options for the Long Value are:

• DEFAULT_PROMPT

• QUESTION_NAME

• SAS_LABEL

BOOK_ASSIGN

If set to Y, the system automatically assigns the DCI Book defined as the default for the study (in DCI Books or Enhanced DCI Books, under Definition) to each patient when data is first entered for the patient.

TMS_FAIL_BV_ACT

Use this entry to indicate whether batch validation should continue or stop after a TMS-related error is encountered. The two values are 'WARN' and 'FAIL,' which is the default value. It causes batch validation to fail when there is a TMS failure; for example, when either an invalid dictionary or an invalid domain is defined. Irrespective of the value for TMS_FAIL_BV_ACT, if a TMS-related error occurs, the batch validation status is always failure and batch validation completes the process with a TMS warning.

UPD_FV_INCREM

This setting pertains to the upgrade utility provided with Oracle Clinical/RDC 4.5.3 and above that allows you to migrate from PDF to HTML data entry forms. By default, the Upgrade utility generates the HTML data entry forms and the PDR templates for all DCI Form Versions in the study that have PDF data entry forms generated.

There may be times when you have problems with the form or template generation. For example, perhaps some images used in the form layout are no longer in the correct location so the Upgrade utility does not generate a few of the DCI Form versions. For such cases, you can temporarily change the utility to run in incremental mode. In incremental mode, the Upgrade utility only creates the HTML data entry forms and the PDR templates if they do not already exist.

Set the long value to Y or N:

• Y — Forces the Upgrade utility to run in incremental mode. In incremental mode, the utility will not regenerate HTML data entry forms and PDR templates for form versions that already exist.

• N (default) — Forces the Upgrade utility to generate all form versions.

This setting applies only to running the Upgrade utility for existing DCI Form versions.

Note:

Running the Upgrade utility in incremental mode is for resolving problems. Oracle recommends that you do not continue to run the utility in incremental mode. Be sure to change the UPD_FV_INCREM value back to N after you generate the forms you need

PRINT QUEUE NAME Local Codelist

This codelist populates the list of printers that you can use when you submit a batch job or a reports job and when you set up a user account.

Oracle Clinical users can select a printer name from a list of values when they submit a job. You specify that list by defining entries in this local reference codelist. Both the long and short values appear in the list of values.

The short value is a code or abbreviation for the printer. The long value of the printer name is the printer specification. You can use either an absolute path or an environment variable for the long value. For example:

• \\opaprtsrv\waltprt9 where walprt9 is the printer name

• %RXC_PRINTER% where RXC_PRINTER is the environment variable

The Default setting in the reference codelist has no effect. The OCL_JOB_PREF reference codelist determines the default printer. You can override the default when you set up a user account with any of the values in the PRINT QUEUE NAME reference codelist, and a user can override his or her own default when he or she submits a job.

PUBLIC_DB_LINKS Local Codelist

This codelist provides a list of database links for replication; it is used by RXA_DES.

Each database in the installation maintains its own PUBLIC_DB_LINKS local reference codelist. There should be an entry in the Short Value field for each of the other database locations in the installation. The Long Value contains the name of the public database link to that database.

RDC CONFIGURATION Role Local Codelists

This set of local codelists let you define the configuration settings for the Remote Data Capture application based on user role, such as CRA or investigator.

For more information about creating a configuration, defining its settings, and assigning the configuration to one or more users, see the Oracle Clinical Remote Data Capture User's Guide or the Oracle Clinical Remote Data Capture Classic Data Entry User's Guide.

REPORT_SERVER Local Codelist

This codelist defines the list of reports servers from which the user can select when setting up to run a report.

SAS_QUEUE Local Codelist

This codelist specifies the value(s) in the BATCH QUEUE NAME Local Codelist that is required to run SAS.

SQL FUNCTIONS Local Codelist

This codelist provides a list SQL functions that you can then use when building queries.

TMS_DSI Local Codelist

This codelist defines settings specific to the Disconnected System Integration (DSI) feature for Oracle Thesaurus Management System. For details about this codelist, see the Oracle Thesaurus Management System User's Guide.

TMS_OPTIONS Local Codelist

This local codelist contains TMS-specific options. It is populated only if TMS is installed in the Oracle Clinical database. When TMS is installed, currently the only option defined is FIRST_REVIEW. If the Long Value for this option is set to Y, and the Review Before TMS flag is also set to Y in the question set, then the first review for a thesaurus omission happens in the Oracle Clinical discrepancy management system, rather than in TMS. For more information on the interaction between the Oracle Clinical discrepancy management system and TMS, see the "Defining a question set" topic in the Oracle Thesaurus Management System User's Guide.

UNI DISC COLS Local Codelist

This codelist contains variables that you can specify for Mass Change Utility CDS Univariate Discrepancy criteria.

WEB_DOCUMENT_CONFIG Local Codelist

TMS refers to the settings in this codelist to configure several aspects of the Document Repository searches in the TMS HTML Browser. For details about this codelist, see the Oracle Thesaurus Management System User's Guide.

WEB_DOCUMENT_GROUPS Local Codelist

This codelist lets you define categories for the documents you retrieve using Document Repository searches in the HTML Browser. For example, you might want to specify that all documents loaded from your internal servers be categorized as Internal documents. For details about this codelist, see the Oracle Thesaurus Management System User's Guide.

PDR_FILE_NAMING Local Codelist

This codelist lets you define the naming conventions used to save Patient Data Reports (PDRs) and Blank Casebook Reports generated from RDC or from the command line. For details, see the section "File Names for Reports" in the Oracle Clinical Remote Data Capture Onsite Administrator's Guide.