About Mass Changes

Oracle Clinical provides the Mass Changes utility for correcting error s in multiple records at the same time. You can update patient response data, RDCM keys, or RDCI keys. For example, if many patient positions were logged into an incorrectly spelled site, instead of correcting each record individually, you can apply the correct spelling to all of them in one operation.

To use the Mass Change utility, you need an understanding of SQL and of Oracle Clinical tables and columns. For information on Oracle Clinical's tables and columns, see the Oracle Clinical Stable Interface Technical Reference Manual, available from Oracle Support.

Complete the following tasks to make a mass change:

• Identify the change type — RDCM Key, RDCI Key, Soft-delete RDCI, or Responses — as you open the Mass Change utility.

• Specify the records you need to change by defining a Mass Change Specification (MCS) consisting of a few basic identifiers such as the DCM and/or Discrepancy Type, plus one or more SQL statements identifying further criteria for inclusion in the mass change. See Defining the Mass Change Specification. You can count the records that meet the criteria and refine your MCS before using it to generate a set of records called a Candidate Data Set (CDS).

• Generate the Candidate Data Set. The system includes all the records that meet the criteria defined in the MCS.

• Within the context of the CDS, change records by performing one or more group updates, one at a time, excluding any records you do not want changed from a particular group update, either with a SQL Where clause or by explicitly excluding individual records. You can also update records in the CDS individually. You can test the validity of changes before applying them to the database.

• Apply changes to the database. Records marked for change are changed in the database if the change is valid. Those records cannot be changed again through the same CDS. If you want to change them again as a group, you can copy the MCS and generate another CDS from the same criteria (see Copying a Mass Change Specification). Any records that were marked for exclusion, or which could not be changed because the change was invalid, can still be changed through the original CDS.

Oracle Clinical stores all of the details of applied mass changes in the following Oracle Clinical tables: RESPONSES, RDCI_HISTORY, and DISCREPANCY_ENTRIES.

After completing the mass changes job, the system automatically runs the incremental expectedness calculation job for all patients whose data changed. See Oracle Clinical Creating a Study for more information.

To perform all types of mass changes, you must have one of the following database roles: RXC_MC, RXC_SUPER, or RXC_SUPER_NOGL. To test mass change options only, you must have the database role RXC_MC_TEST. In addition, you can make changes with the Mass Change utility only on data that you are allowed to update through Data Entry. Privileged update is required for changing locked data, or the data of "frozen" patients.

For an explanation of RDCIs and RDCMs, question groups and questions, see the Oracle Clinical Creating a Study manual.