CLiREN-LMS
Data Quality Management and Query Resolution

Database Freeze and Database Lock

Table 1

30-45 minutes Foundational Step 6 of 7
Table

Table 1

6 / 7
Table

Table 1

AreaReadiness question
CompletenessAre expected forms and critical variables complete or explained?
QueriesAre critical queries closed or documented?
OutcomesAre primary and secondary outcomes reviewed?
SafetyAre adverse events and serious adverse events reconciled?
External dataAre laboratory and other external datasets reconciled?
DuplicatesHave duplicate participants or records been resolved?
CodingAre categorical codes and derived variables finalized?
Audit trailHave critical late changes and deletions been reviewed?
DocumentationAre data dictionary, metadata, and cleaning logs complete?
ApprovalHave PI, data manager, and statistician approved lock?