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
- 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
- PDR_FILE_NAMING Local Codelist
- REPORT_CONFIG Local Codelist
Parent topic: Reference Codelists
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.
Parent topic: Local Reference Codelists
DCF COMMENT TEXT Local Codelist
This codelist contains values you can use as the initial text for the DCF comment field.
Parent topic: Local Reference Codelists
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.
Parent topic: Local Reference Codelists
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.
Parent topic: Local Reference Codelists
DCF REPORT LABELS Local Codelist
This codelist contains user-configurable labels for the DCF Report.
Parent topic: Local Reference Codelists
DISC COLS Local Codelist
This codelist contains the variables that can be specified for MCU CDS Discrepancy criteria; see Customizing Mass Changes Local Codelists.
Parent topic: Local Reference Codelists
DISC_FLEX1 and DISC_FLEX2 Local Codelists
See Customizing Flexfields for information.
Parent topic: Local Reference Codelists
DISC_FLEX1_VALUES and DISC_FLEX2_VALUES Local Codelists
See Customizing Flexfields for information.
Parent topic: Local Reference Codelists
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.
Parent topic: Local Reference 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.
Parent topic: Local Reference 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.
Parent topic: Local Reference 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.
Parent topic: Local Reference 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.
Parent topic: Local Reference 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.
Parent topic: Local Reference 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.
Parent topic: Local Reference Codelists
MC CDS SORT ORDER Local Codelist
This codelist contains the sort order of CDS fields; see Customizing Mass Changes Local Codelists for information.
Parent topic: Local Reference Codelists
MC COLUMNS Local Codelist
This codelist contains variables that you can specify for MCU CDS criteria; see Customizing Mass Changes Local Codelists.
Parent topic: Local Reference Codelists
MULTI DISC COLS Local Codelist
This codelist was used for the NLS option, which is no longer supported.
Parent topic: Local Reference Codelists
NLS_CONFIG Local Codelist
This codelist was used for the NLS option, which is no longer supported.
Parent topic: Local Reference Codelists
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:
When the user enters a sequence number that exists in both DVGs, the system:
|
19 |
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 |
Y |
Determines if a change reason is required for updates to RDCI comments in accessible documents. |
|
21 |
0 |
Sets the time period (in minutes) during which a Pass 1 Complete RDCI/RDCM can be modified in Pass 1 mode. |
|
22 |
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 |
N |
Determines if some actions are permitted on a locked CRF. Applies to RDC Onsite only. |
For more information , see:
Parent topic: Local Reference Codelists
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:
-
Short Value, which is titled "DVG Value" in the list of values
-
Alpha Column, which contains "A" if it is an Alpha DVG value or is null for all others
-
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:
-
Display SN (prefixed with "A" if it is an Alpha DVG value)
-
Short Value, which is titled, "DVG value" in the list of values
-
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:
-
Short Value, which is titled "DVG Value" in the list of values
-
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.
-
Long Value, which is title "Description" in the list of values.
The records are sorted by DVG sequence number.
Parent topic: OCL_DE_CONFIG Local Codelist
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.
Parent topic: OCL_DE_CONFIG Local Codelist
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".
Parent topic: OCL_DE_CONFIG Local Codelist
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".
Parent topic: OCL_DE_CONFIG Local Codelist
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.
Parent topic: OCL_DE_CONFIG Local Codelist
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. |
Parent topic: Local Reference Codelists
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 |
|
DFLT_PSUB_QUEUE |
Default PSUB Queue |
|
DFLT_REPORT_RS |
Default Reports Server |
|
DFLT_JOBSET_RS |
Default Job Set Reports Server |
|
DFLT_PSUBSCH_RS |
Default for PSUB Scheduling, generating DCI Forms, and previewing |
|
DFLT_RS_PRINTER |
Default Reports Server Printer |
For example, to set a printer as the default for reports at an installation:
-
Navigate to Admin, then Reference Codelists, and Local Codelists.
-
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.)
- Short Value – Name of the printer, for example,
-
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.
Parent topic: Local Reference Codelists
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.
Parent topic: Local Reference 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 |
Parent topic: Local Reference Codelists
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. |
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. |
— |
The database block size from init.ora. |
|
DB_HOST |
— |
Host name for the database, as entered in tnsnames.ora file. |
DB_NAME |
|
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. |
DISC_AUTO_CRFPG |
Y |
Auto Generation of CRF Page Number. |
DISC_AUTO_HDFT |
Y |
Auto Generation of Header/Footer Text. |
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). |
|
DMGR RDC ACCESS |
YES |
See Granting Automatic Access in RDC to Studies Granted in Oracle Clinical. |
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 |
— |
— |
Client name for the current location. |
|
OPA_LESTR_SYNCH |
1 |
This value is not used. |
PRINTER_TYPE |
|
Default type of printer output. |
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.) |
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. |
— |
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 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). |
|
— |
Temporary Tablespace for use in new account creation activities. |
|
FAIL |
Determines whether Batch Validation continues when TMS derivation fails during Batch Validation: WARN or FAIL. |
|
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
Parent topic: Local Reference Codelists
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
Parent topic: OCL_STATE Local Codelist
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.
Parent topic: OCL_STATE Local Codelist
LOCATION_CODE
The LOCATION_CODE value is the client name for the current location. The system collects and stores this value during database creation.
Parent topic: OCL_STATE Local Codelist
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.
Parent topic: OCL_STATE Local Codelist
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.
Parent topic: OCL_STATE Local Codelist
TEMP_TABLES
This entry specifies the name of the temporary tablespace the system users when creating DX study_access_accounts.
Parent topic: OCL_STATE Local Codelist
DM_PROMPT
This entry is used by the Discrepancy Management form as the prompt to use for Study site.
Parent topic: OCL_STATE Local Codelist
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.
Parent topic: OCL_STATE Local Codelist
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
Parent topic: OCL_STATE Local Codelist
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.
Parent topic: OCL_STATE Local Codelist
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.
Parent topic: OCL_STATE Local Codelist
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
Parent topic: OCL_STATE Local Codelist
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.
Parent topic: Local Reference Codelists
PUBLIC_DB_LINKS Local Codelist
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.
Parent topic: Local Reference Codelists
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.
Parent topic: Local Reference Codelists
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.
Parent topic: Local Reference Codelists
SAS_QUEUE Local Codelist
This codelist specifies the value(s) in the BATCH QUEUE NAME Local Codelist that is required to run SAS.
Parent topic: Local Reference Codelists
SQL FUNCTIONS Local Codelist
This codelist provides a list SQL functions that you can then use when building queries.
Parent topic: Local Reference Codelists
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.
Parent topic: Local Reference Codelists
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.
Parent topic: Local Reference Codelists
UNI DISC COLS Local Codelist
This codelist contains variables that you can specify for Mass Change Utility CDS Univariate Discrepancy criteria.
Parent topic: Local Reference Codelists
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.
Parent topic: Local Reference Codelists
REPORT_CONFIG Local Codelist
This codelist allows you to define the JDBC_DATA_SRC value for the database that is connected to Oracle Clinical to generate XDO reports. This codelist contains the JNDI name of the data source in the WebLogic Server Administration Console.
To update the local reference codelist REPORT_CONFIG with the data source JNDI name:
- Log in to Oracle Clinical using https://computer_name.host/opa54/launch.htm.
- Navigate to Admin > Reference Codelists > Local Codelists.
- Query for the REPORT_CONFIG codelist:
- Press F7.
- Enter REPORT_CONFIG in the Name field.
- Press F8. The system displays the short value JDBC_DATA_SRC.
- Enter the JNDI name value as the long value. For example, jdbc/rdc.
- Save the codelist.
Parent topic: Local Reference Codelists