Specifying Group Update Changes

From the Candidate Data Set window, click the Grp Updates button or enter the keyboard combination Ctrl+A to open the Group Updates pop-up window. The window has two columns. The left column, labeled 'Column/Question' lists all the fields you can change.

To specify the changes, do the following:

1. For each key or question whose value you want to change, enter the new value to the right of the key or question name. Do one of the following:

   • Select a value from the LOV. Each field contains a list of the valid values for that field.

     In the case of keys, the LOV also contains the values key and new_key; for example, Site and New_Site. If you enter the value (not new) key, when you run the group update, the value is changed back to the value the records had when the CDS was created. The new_key value is equivalent to the most recent value set for the field. You can use it, for example, to change the value to the existing value concatenated with a suffix, such as new_key||'_XX'. For example, where the site has already been changed to General_Hospital, you could change it to General_Hospital_Oncology.

     In the case of responses, the LOV includes value and new_value, where value is the value of the question response when the CDS was created and new_value is the most recent change. You can use these values the same way you use key and new_key.

   • Enter a fixed value surrounded by single quotes; for example: 'value'. To update to a fixed date value, use the format 'MM-DD-YYYY' (including the single quotes). The system converts the date to the internal 'YYYYMMDD' date format.

   • Enter a SQL statement. For example, to add 40 days to value dci_date, enter: to_char(to_date(dci_date,'YYYYMMDD')+40,'YYYYMMDD') in the update column of a expression.dci_date_new

2. (Optional) Enter a Where clause to specify which records in the CDS should be updated. Do not include the word "where" in the clause; it is supplied by the system.

   If you are making a response change, refer to the question response values as VALUE_TEXT1, or VALUE_TEXT2, and so on, where VALUE_TEXT1 is the current value of the first question you entered in the MCS. See the example below. Do not use the question name in the Where clause.

3. (Optional) If you want to explicitly exclude individual records from the group update, you can click the Back button and exclude the records, then return to the Group Update window to run the update. The system saves your settings in the Group Update window. See Excluding Records from the Group Update.
4. Update the records within the CDS. See Running the Group Update on the CDS.

Example 6-1 Response Change

To change the value of the Child Bearing Potential question to "No" for all male patients, where "Sex" is the first question displayed and "Child Bearing Potential" is the second question displayed, do the following in the Group Update window:

1. In the Where... field enter: VALUE_TEXT1='MALE'

2. In the child_bearing_potential_new field, enter 'NO' for the new value.

Example 6-2 RDCI Key Change

If a data entry operator logged information collected at Visit 6 for Patient 11 for Patient 111 instead, you can correct the mistakes for all of Patient 11's Visit 6 records by doing the following:

1. In the Where... field enter: CLINICAL_PLANNED_EVENT_NAME='VISIT6' AND PATIENT=111 AND DATE=20050606

2. In the patient_new field enter: 11