The Purpose of Data Cleaning and Preparation

Imagine a REDCap export from a maternal health study with missing consent dates, duplicate participant IDs, invalid gestational ages, and inconsistent follow-up dates. Draft a workflow showing what R should do, what should be reviewed by the data manager, what should become a query to the site, and what should be corrected in REDCap.