Data Entry, Validation, and Access Control: Summary and Assessment
Practical Exercise: Designing a Data Entry and Access Control Plan
Exercise
5 / 7
Practical Exercise: Designing a Data Entry and Access Control Plan
Exercise
Practical Exercise: Designing a Data Entry and Access Control Plan
### Scenario
A multisite maternal health study is enrolling pregnant women at five county hospitals. At enrollment, nurses collect demographic data, obstetric history, blood pressure, hemoglobin, HIV status, and gestational age. Participants are followed at delivery and six weeks postpartum. Data are entered into REDCap. Two hospitals have reliable internet and enter data directly during clinic visits. Three hospitals complete paper worksheets first and enter data within three days. Each hospital should view only its own records. The central data manager needs access to all records. The statistician should receive de-identified exports only. Monitors will review consent, eligibility, blood pressure, hemoglobin, delivery outcome, and serious adverse events.
### Tasks
1. Describe the data entry workflow for direct-entry sites and paper-first sites.
2. Identify at least six source documents expected in this study.
3. Propose five validation rules for key variables.
4. Identify which fields should be required and explain why.
5. Define at least five REDCap user roles and their permissions.
6. Explain how Data Access Groups should be configured.
7. Describe what audit trail items should be reviewed during monitoring.
8. Prepare a short training and competency plan for new site users.
9. List at least five common data entry errors that could occur in this study and how to prevent them.
### Suggested Response Structure
Learners should prepare a brief data entry and access control plan with sections for workflow, source documents, validation, required fields, user roles, Data Access Groups, audit trail review, training, and common errors. The plan should distinguish between direct electronic capture and paper-first sites while maintaining a common data quality standard across all hospitals.
### Instructor Guidance
Strong responses should recognize that the study uses a hybrid workflow and therefore needs controls for both direct entry and delayed transcription. Source documents may include signed consent forms, antenatal clinic records, laboratory reports, delivery registers, postpartum follow-up forms, and adverse event documentation. Validation rules should address blood pressure ranges, hemoglobin ranges, gestational age, dates, and visit order. DAGs should be configured by hospital, with central access restricted to approved central users. The statistician should not receive identifiers unless explicitly approved. Training should include confidentiality, source verification, REDCap use, paper worksheet handling, query response, and competency practice records.