How does clearing data may impact my study?
Clearing saved data on a form differs from simply deleting data in a question. Clearing data has different effects on the different study areas.
Note:
Even if you clear a question's data, its whole answer history is retained. All actions performed on a question are listed on the Answer & Visit History sidebar and in the audit trail.Impact on data collection
If you are a Clinical Research Associate (CRA), a data manager, or any other sponsor user involved in maintaining data integrity, you should know how clearing form data impacts the data collection process. Understanding the impacts on data collection is important as it may affect data review and the Source Data Verification (SDV) processes.
- When you clear or remove a required question, a form's status is set to Incomplete. However, , when you clear or remove an optional question, a form's status is not impacted.
- If you update a question that has an open manual query (either by updating, removing or clearing data), the query status is updated to Answered. For the case of automated queries, it always depends on the rule logic, see Impact on custom rules.
- When a site user updates a question that was previously cleared, a reason for change is not provided.
- All icons next to a cleared question disappear. However, the respective actions on the question (such as unsign, unverify or unlock) are listed on the Answer & Visit History sidebar.
- When a site user clears a verified or signed question, it becomes unverified or unsigned, respectively. As mentioned, the Unsigned and Unverified icons do not display for the question, but the action is listed on the Answer & Visit History sidebar.
- When you clear a completed visit date, the visit's status is updated to Incomplete.
- When you clear a date that is used to determine lab normal ranges, the system date at the time of the update is used instead to populate the calculated values. For calculations using the visit date (like age questions), clearing the visit date results in a failed calculation and an incomplete question.
Impact on custom rules
Tip:
You can view the resulting actions in the Answer & Visit History sidebar, each stated as the result of rule execution.- For rules that populate calculated values, if a question used
as an input for the calculation is removed or cleared, the rule re-runs with
an empty value as the input. This would typically result in the calculated
value also getting removed or cleared (respectively). However, you should
keep in mind that the output always depends on what the rule logic
dictates.
Note:
Clearing or removing a value makes it null and it is not the same as making it zero. - If a question with an opened automated query is cleared or removed, either directly or as a result of calculation rule, the query will behave according to what the rule dictates. Typically, the automated query would get Closed, but this is only if the condition for the query no longer applies and as long as the rule logic doesn't dictate differently.
- For rules that raise queries or send notifications, the result of clearing the input depends on how an empty input would trigger the rule. So, only for the case of rules that raise queries or send notifications when detecting empty values, clearing a value results on a notification being sent or a query being raised against the question.
Impact on reports and data extracts
- The Subject Data Extract does not include
records of forms for which all data has been removed (either deleted using the
Backspace key, reset or cleared).
- This also applies to when the Not Answered data flag populates for form items as a result of Source Data Verification (SDV), sign, freeze or lock actions.
- The Subject Data report has an option to include or exclude cleared data available in the Settings pane on the right.
- In the Subject Events Report, for the event of clearing a visit date in Oracle Clinical One Platform, a Visit Date Cleared value displays under the Event Type column.
Impact on integrations
Integration with | Impacts of data clear |
---|---|
Oracle InForm | Upon data being cleared in Oracle Clinical One Platform, a clear data action is issued in Oracle InForm along with the specified reason for change. |
Oracle Central Coding | When a site user clears a Verbatim or coding context item (Route of Administration or Indication) Oracle Central Coding operates as though a user has removed or updated the value in that field. The update is properly reflected in Oracle Central Coding and the new data that is entered for a Verbatim, Route of Administration, or Indication is coded as new data. |
Any other third-party electronic data capture (EDC) system | Upon data being cleared in Oracle Clinical One Platform, a null value is sent through Oracle Clinical One Digital Gateway to the third-party system. |
For more information, reach out to your Oracle point of contact.