![]() The process for mass RDCI soft deletes is somewhat different from other mass changes see "Soft-Deleting RDCIs". You cannot use Mass Changes to correct these errors the RDCIs must be properly re-entered. Soft-delete means that the system keeps a record of the change. RDCI Soft Deletes soft-deletes whole RDCIs this would be necessary, for example, if an operator logged in many RDCIs under the wrong study. However, if you enter the name of a DCI that includes DCMs that are qualified in any way - by event, subevent, qualifying value, lab, etc. - you get a failure. In RDCI Key Changes, you can change the DCI name. Privileged update is required for changing locked data, or the data of "frozen" patients.įor an explanation of RDCIs and RDCMs, question groups and questions, see the Oracle Clinical Creating a Study manual. In addition, you can make changes with the Mass Change utility only on data that you are allowed to update through Data Entry. To test mass change options only, you must have the database role RXC_MC_TEST. To perform all types of mass changes, you must have one of the following database roles: RXC_MC, RXC_SUPER, or RXC_SUPER_NOGL. See Oracle Clinical Creating a Study for more information. Oracle Clinical stores all of the details of applied mass changes in the following Oracle Clinical tables: RESPONSES, RDCI_HISTORY, and DISCREPANCY_ENTRIES.Īfter completing the mass changes job, the system automatically runs the incremental expectedness calculation job for all patients whose data changed. 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. 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"). ![]() Those records cannot be changed again through the same CDS. Records marked for change are changed in the database if the change is valid. You can test the validity of changes before applying them to the database.Īpply changes to the database. You can also update records in the CDS individually. 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. The system includes all the records that meet the criteria defined in the MCS. 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). See "Defining the Mass Change Specification". ![]() 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. Identify the change type - RDCM Key, RDCI Key, Soft-delete RDCI, or Responses - as you open the Mass Change utility. For information on Oracle Clinical's tables and columns, see the Oracle Clinical Stable Interface Technical Reference Manual, available from Oracle Support.Ĭomplete the following tasks to make a mass change: To use the Mass Change utility, you need an understanding of SQL and of Oracle Clinical tables and columns. 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. You can update patient response data, RDCM keys, or RDCI keys. ![]() Oracle Clinical provides the Mass Changes utility for correcting error s in multiple records at the same time. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |