Layout Tables

As with definitional data, the form layout tables are audited in case users delete or modify relevant layouts after CRFs are deleted. Data from the source table is not deleted during a batch data delete, but you may be inclined to retire or modify layouts if all related patient data is deleted. You can use this layout information to reconstruct the patient data report for hard-deleted patient data.

Table 7-12 LAYOUT Tables Used in Batch Data Deletion

Source Table Corresponding Audit Table
DCI_FORM_VERSIONS DCI_FORM_VERSIONS$BDD
DCM_LAYOUT_GRAPHICS DCM_LAYOUT_GRAPHICS$BDD
DCM_LAYOUT_TEXT DCM_LAYOUT_TEXT$BDD
DCM_LAYOUT_PAGES DCM_LAYOUT_PAGES$BDD
DCM_LAYOUT_ABS_PAGES DCM_LAYOUT_ABS_PAGES$BDD