Other Reference Tables

Records from the tables listed below are not deleted during batch data delete. However, these tables will also be audited to preserve status at the time the patient data was deleted. You may be inclined to delete data from these tables if all related patient data is deleted. With auditing, if you delete all the data for a patient and then delete the patient, you can still find the patient enrollment data from the PATIENT_POSITIONS$BDD table.

Table 7-13 Reference Tables Used in Batch Data Deletion

Source Table	Corresponding Audit Table
CLINICAL_PLANNED_EVENTS	CLINICAL_PLANNED_EVENTS$BDD
PATIENT_POSITIONS	PATIENT_POSITIONS$BDD
OCL_STUDY_SITES	OCL_STUDY_SITES$BDD
OCL_SITES	OCL_SITES$BDD
STUDY_SITE_PATIENT_POSITIONS	STUDY_SITE_PATIENT_POSITIONS$BDD