Skip Headers
Oracle® Clinical Remote Data Capture Classic Data Entry User's Guide
Release 4.6.2

Part Number E18824-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

9 Data Review and Update

This section provides an overview of the CRF review and data update processes and details the tasks that allow you to accomplish each. It also describes the procedures that you use for verification and for approval of CRFs.

The following topics are in this section:

There are certain other tasks that are relevant to CRF review and data update that are documented in the Chapter 5, "Getting Started." The tasks in that section specifically related to CRF review and/or data update are:

CRFs Review

This section describes the procedures you use to review a CRF. These tasks help to ensure that response data, CRF information, and investigator comments are correct and complete. If you find it is necessary to modify any data, refer to the "Update Response Data".

The following tasks are described in this section:

In order to review CRFs, your user name must be assigned the browse or browse batch privilege. This is generally sufficient when you are verifying CRFs against the source data. In order to update data your user name must be assigned the update or update batch.

When you change the data in an existing CRF, the change is audited in all CRFs. If the CRF is at the entry complete data entry status, the system displays a change reason window, which you must complete in order for the data update process to proceed.

Review the Audit Trail for a CRF

The audit trail captures changes to response values, investigator comments, and CRF information. You can use the Audit Trail task tab to review all changes to a CRF and the changes that are associated with a response field. In order to review the audit trail for a CRF, at least one response value in the CRF must have changed since the CRF was created.

General Procedure

To review the audit trail for a CRF:

  1. Put the CRF that is of interest in focus.

  2. Click the Audit Trail. All of the changes that have occurred in the CRF since it was created are listed in the task tab.

Procedure Based on the Approval or Verification History

You can use the Approval or the Verification to automatically set the "Changes since" field on the Audit task tab. This allows you to view changes to the CRF since a specific approval or verification event.

In order to do this, there must be an approval or verification history associated with the CRF.

  1. Put the CRF that is of interest in focus.

  2. Click either the Approval or the Verification task tab.

  3. In the task tab, place focus in the history table, selecting a row that corresponds to the event you want to use in the Audit task tab.

  4. Click the Show changes button. The system changes focus to the Audit Trail task tab. The "Changes since" field is set to the event in the Approval or Verification task tab.

View the Change History for a Response

You can use the Audit Trail task tab to view the changes that have occurred to a specific response field. This procedure is also applicable to audited investigator comments and CRF header information.

To view the change history for a response:

  1. Put the CRF that is of interest in focus.

  2. Click the Audit Trail task tab.

  3. Place focus in the row that corresponds to the response field of interest.

  4. Click the Show button for that row. The system opens the Audit History Window, which displays all audited changes to the response.

Review an Investigator Comment

Use this procedure to review an existing investigator comment. When focus is in a response that contains an investigator comment, the Data Entry window title bar displays an alert, in the form of, "<Inv>". When focus is not in the response field, its value is displayed in red font color.

To review an existing investigator comment:

  1. Place focus in the response field of interest. The Data Entry window title bar displays "<Inv>" if it contains an investigator comment.

  2. Select Edit, then Investigator Comment from the option list. The system displays the Investigator Comment Window.

  3. Review the comment.

Review the Approval or Verification History of a CRF

After a CRF has been verified or approved, its change history is displayed on the Verification and/or the Approval task tab.

To review the approval or verification history of a CRF:

  1. Put the CRF that is of interest in focus.

  2. Click the appropriate task tab.

Review Discrepancies Associated with a CRF

CRFs that have at least one discrepancy of either "Active" or "Other" status are displayed in the RDC Classic Spreadsheet with a red or yellow CRF icon (respectively). In addition, a CRF that is displayed with a white icon may have one or more discrepancies in the "Closed" status.

Refer to the "Review Discrepancies" section in "Manage Discrepancies" for further information.

To view the discrepancies associated with a CRF:

  1. Click the relevant CRF to put it in focus.

  2. Click the Discrepancy to display its contents. If there is at least one discrepancy associated with the CRF currently in focus, the List of Discrepancies Tab is displayed within the Discrepancy task tab.

  3. Click an Individual Discrepancy Tab to view detailed information about a specific discrepancy.

Update Response Data

This section describes the procedures you use to modify data that has been saved in a CRF. This includes response values, investigator comments, and CRF or CRF section information.

The following topics comprise this section:

Complete the Audit Information Window

RDC Classic displays an audit information window whenever you update data in a CRF or CRF section that is assigned the entry complete data entry status.

The procedure to complete the Audit Information is similar for all types of updates. The audit information window presents a default change reason. At a minimum, the system requires that you acknowledge the default change reason and close the window before you can continue with your data update tasks. However, you can use the Change Reason drop-down window to select an alternative change reason. Also, you have the option to include an explanatory comment, which is saved with the audit record.

Refer to "Audit Change Reason Type Codes Window" for additional information on the usage of these windows.

Procedure

When you update an entry complete CRF, as described above, and attempt to save the CRF or navigate to a different field, the system displays an audit information window. To complete it and proceed with other tasks:

  1. In the audit information window, review the default change reason.

  2. If you want to select an alternative reason, use the LOV button to open the Audit Change Reason Type Codes Window.

  3. Select an alternative change reason and close the Type Codes window.

  4. In the audit information window, type a comment, if necessary, in the Comment text box.

  5. Click the OK or Save button, as appropriate, to close the audit information window and proceed with your update tasks.

Update CRF and/or CRF Section Header Data

The CRF header may contain required and optional data fields. All changes to CRF header fields, with the exception of Comment fields, are audited and require you to provide a change reason and optional comment. The Comment field may or may not be audited, based on the CRF definition in the protocol.

Procedure

When you update CRF or CRF section header information, RDC Classic displays the Audit Information for CRF Change window. Refer to "Complete the Audit Information Window" for information on completing this window.

  1. Use the RDC Classic Spreadsheet to locate and open the CRF in the Data Entry window.

  2. In the CRF header or the CRF section header area of the Data Entry window, place focus in the field you want to update.

  3. Modify the existing field.

  4. When you press the Tab or Enter key to navigate out of the field, or press the F10 key to save the new data, the system displays the Audit Information for CRF Change window.

  5. In the Audit Information Window, either use the default change reason or select another from the LOV.

  6. In the audit information window, type an optional comment that more fully explains the data update, if necessary.

  7. Close the audit information window.

Notes

If you make other changes to CRF or CRF section information before you save pending changes, the system uses the same change reason and comment that you supplied for the first update.

Update Response Data for a CRF

It is often necessary to modify a datapoint in a CRF that is in the "Entry Complete" entry status, either by changing existing response data or inserting data in a previously incomplete response field. RDC Classic terms this process "data update."

Procedure

To update response data in a CRF or CRF section:

  1. In the RDC Classic Spreadsheet, click the CRF icon associated with the CRF that contains the datapoint(s) you want to modify. The system opens the CRF in the Data Entry window.

  2. In the Question area of the Data Entry window, place focus in the response field you want to update.

    Note:

    Any field in the CRF that has an ATTACHMENT prefix represents an extended text field. Note that you can update data in an extended text field only in Oracle Clinical Remote Data Capture Onsite (RDC Onsite). For more information, refer to "View Data in Fields with an ATTACHMENT Prefix".
  3. Modify the existing response value or type a new value in the field.

  4. When you press the Tab or Enter key to navigate out of the field, or press the F10 key to save the new data, the system displays the Audit Information for Data Change window. The default change reason is automatically selected.

  5. In the Audit Information Window, either use the default change reason or select another from the LOV.

  6. In the Audit information window, type an optional comment that more fully explains the data update, if necessary.

  7. Click the Save button to close the Audit information window and save the reason and comment.

Auto progression is not available during data update. When you close the Audit information window, focus moves to the first datapoint in the CRF section.

Update an Existing Investigator Comment

As part of the data update process, you may find it necessary to augment an existing investigator comment for a given response field. This section describes the procedure to do this.

If an investigator comment is not associated with the response field, refer to "Initiate an Investigator Comment" for a description of how to associate a new investigator comment to a datapoint.

The background color of a response field that has an investigator comment associated with it is yellow. The text of the response is displayed in a green font.

If both an investigator comment and an operator comment are associated with a response field, the background color remains yellow, but the font of the response text is red.

Procedure

To update an existing investigator comment:

  1. In the Data Entry window, place focus in the response field that contains the investigator comment you want to update.

  2. Select Edit, then Investigator Comment from the option list, which opens the Investigator Comment Window. The text of the existing comment is displayed in the window.

  3. You can edit the text of the comment, as necessary, in the window.

  4. Click the OK button to close the Investigator Comment window. The system displays the Audit Information for Investigator Comment Change window.

  5. In the audit information window, either use the default change reason or use the LOV to select an alternative reason.

  6. If necessary, type an optional explanatory message in the Comment text box.

  7. Click the OK button to close the Change Reason window and revert focus to the response field.

Notes

When you modify both a response value and its associated investigator comment in the same transaction, that is both changes are included in the same save action, the system uses the change reason associated with the response change for both updates.

Mark a CRF or CRF Section Blank

When you mark a CRF blank, all response values are deleted and each section, as well as the CRF, is marked blank.

When you mark a CRF section blank, the system deletes only the response values in that section and marks the section blank if there are other non-blank sections in the CRF. If there are no other non-blank sections in the CRF, marking the last section blank is the same as marking the entire CRF blank.

To mark an entry complete CRF blank:

  1. In the CRF header, click the blank flag to select it. The system displays a confirmation window.

  2. In the confirmation window, click the OK button. The system displays the Audit Information for CRF Change window.

  3. Process and close the audit information window, as described in "Complete the Audit Information Window".

  4. The system displays the following message in the Question area of the Data Entry window of single-section CRFs:

    This page has been marked as blank

    In multi-section CRFs with at least one other non-blank section, the system displays the following message in the Question area of each section:

    This section has been marked as blank

Clear the Blank Flag and Proceed with Data Entry

This section describes the steps necessary to clear the blank flag for a CRF or a CRF section and proceed with data entry tasks.

To clear a blank flag and proceed with data entry:

  1. In the CRF or CRF section header area, click the relevant blank flag to clear it. The system displays the Audit Information for CRF Change window.

  2. Process and close the audit information window, as described in "Complete the Audit Information Window".

  3. The system clears the blank flag and places focus in the first response field in the section.

Manage Discrepancies

The section describes the procedures you use to manage discrepancies in RDC Classic. It discusses how to review, update, and take action on discrepancies.

This section includes the following subsections:

Review Discrepancies

You use the Discrepancy to review the list of discrepancies associated with a CRF. In that tab, the List of Discrepancies Tab lists all discrepancies. When you want to review a single discrepancy, either open its discrepancy window or use its Individual Discrepancy Tab.

View all Discrepancies

To review all of the discrepancies in a CRF:

  1. Open the CRF in the Data Entry window.

  2. Click the Discrepancy task tab.

  3. If there is at least one discrepancy in the CRF, it is displayed in the List of discrepancies tab. Note the sequence number assigned to the discrepancy of interest.

  4. Locate and click the individual discrepancy tab that corresponds to the discrepancy you noted in Step 3.

Access the Discrepancy Window

You can view, and update, a discrepancy record using its discrepancy window. The discrepancy window is accessible for all univariate, manual, and section discrepancies.

  1. Open the CRF in the Data Entry window.

  2. Place focus in the appropriate response field in the CRF:

    1. For univariate and manual discrepancies, focus must be in the related response field.

    2. For section discrepancies, focus must be in any response field in the section.

  3. In the Edit menu, select the appropriate command:

    • Discrepancy for a data discrepancy

    • Discrepancy (manual) for a manual discrepancy

    • Section Discrepancy for a section discrepancy

    The system opens the appropriate discrepancy window.

Update an Existing Discrepancy

You can work with an existing discrepancy in either discrepancy window, such as the or the Discrepancy. Use either interface to edit descriptive text and comments or to take an action on the discrepancy. The exception to this is multivariate discrepancy, for which you work with the Discrepancy task tab only.

Discrepancy Task Tab Procedure

To open and work with a discrepancy, you can either use with the List of Discrepancies Tab or the Individual Discrepancy Tab.

  1. Ensure that the relevant CRF is in focus.

  2. In the Discrepancy task tab, use the List of discrepancies to locate the discrepancy listing.

  3. Either work with the discrepancy in the List of discrepancies tab or use the sequence number to identify and open the relevant Individual discrepancy tab.

Discrepancy Window Procedure

Use the procedure described in "Review Discrepancies" to open the discrepancy window for a specific discrepancy. You can use the window to review and update the discrepancy. Note that if you want to modify the Error Message in a univariate discrepancy, you must do this in its discrepancy window.

Take Action on a Discrepancy

This topic covers the procedures that you follow to take an action on a discrepancy. To update a discrepancy, your user name must be assigned the update discrepancy, at a minimum.

Route a Discrepancy

To route a discrepancy to another role:

  1. Put the discrepancy in focus, either in the Discrepancy task tab or a discrepancy window.

  2. Use the Action drop-down list to select a routing action. For example, "Send to Site."

  3. Save pending changes.

Resolve a Discrepancy

To resolve a discrepancy:

  1. Put the discrepancy in focus, either in the Discrepancy task tab or a discrepancy window.

  2. Use the Action drop-down list to select a resolution. For example, "Closed - Resolved." The system opens the Resolution Reason Window.

  3. In the Resolution Reason window, use the Resolution drop-down list to select a reason. Note that you must select a resolution reason.

  4. If necessary, type a comment in the Comment text box.

  5. Click the Save button to save the resolution reason and the comment.

  6. If you are working in a discrepancy window, click the Save button to save pending changes and close the window.

CRF Verification Tasks

You use the Verification to review the verification history and to change the verification status of a CRF.

This section consists of the following tasks:

Review the Verification History

You can review the verification history of a CRF if its verification status has changed. Refer to Figure 9-1, "Example of the Verification Task Tab" for an illustration of the verification history for a CRF.

To review the verification of a CRF:

  1. Open the CRF in the Data Entry window.

  2. Click the Verification task tab. If the verification status of the CRF has changed from its original not verified, the system displays the verification history in the task tab.

Change the Verification Status of a CRF

There are three circumstances in which you can change the verification status of a CRF.

  1. If it is not verified or if verification is undone, you can verify the CRF.

  2. If it is verified, you can undo verification of the CRF.

  3. If it is awaiting re-verification, you can either re-verify it or undo verification.

Figure 9-1, "Example of the Verification Task Tab" shows an example of the Verification task tab of the CRF that was verified when a response datapoint was updated. This causes the system to change its status from verified to awaiting re-verification. The graphic also illustrates the verification history that is included in the task tab when its status changes to verified for the first time.

Figure 9-1 Example of the Verification Task Tab

Description of Figure 9-1 follows
Description of "Figure 9-1 Example of the Verification Task Tab"

Procedure

CRFs are assigned one of four verification statuses, one of which is "Verified." To verify a CRF that is in one of the three other statuses:

  1. Click the relevant CRF cell to put the document is focus.

  2. Click the Verification label to display its contents.

  3. If necessary, use the Comment field to type a message that describes your actions.

  4. If you are verifying multiple documents in sequence, you may want to select the "Keep comments between verifications" check box.

  5. Click the Verify button.

CRF Approval

This section includes the following tasks:

Approve a CRF

CRFs are assigned one of four approval statuses. To approve a CRF that is in one of the three eligible statuses:

  1. Click the relevant CRF cell to put it in focus.

  2. Click the Approval label to display its contents.

  3. If necessary, use the Comment field to type a message that describes your actions.

  4. If you are approving multiple documents, you may want to select the "Keep comments between approvals?" check box.

  5. In the Password text box, type the password that is associated with your user name.

  6. Press the Enter key. The "Approval" Password Confirmation Window is displayed.

    Note:

    If you are approving multiple CRFs within a short period of time, the Password confirmation window may not be displayed. It may be displayed after a certain period of time (e.g., 10 minutes) have elapsed.
  7. In the Password Confirmation window, type your user name (with the "OPS$" prefix) in the Username text box.

  8. Click the OK button.

Undo CRF Approval

CRFs are assigned one of four approval statuses.

To undo the approval of a CRF that is approved:

  1. Click the relevant CRF cell to put it in focus.

  2. Click the Approval label to display its contents.

  3. If necessary, use the Comment field to type a message that describes your actions.

  4. If you are undoing the approval of multiple documents, you may want to select the "Keep comments between approvals?" check box.

  5. Click the Undo Approval button. The Password Confirmation Window for Undo Approval is displayed.

  6. In the Password Confirmation window:

    1. Type your user name (with the "OPS$" prefix) in the Username text box.

    2. Type the password associated with your user name in the Password text box.

    3. Click the OK button.