CLiREN-LMS
Database Design in REDCap

Testing and User Acceptance Testing

Table 1

30-45 minutes Foundational Step 6 of 7
Table

Table 1

6 / 7
Table

Table 1

Testing areaExample test
Instrument completenessConfirm all approved CRF fields are present
Field validationEnter invalid values and confirm warnings appear
Branching logicTest all relevant response pathways
Calculated fieldsCompare calculated values with manual calculations
Longitudinal eventsConfirm instruments appear at correct events
Repeating instrumentsEnter multiple adverse events or medications
User rightsConfirm users can access only permitted actions
Data Access GroupsConfirm site users see only their records
ReportsConfirm monitoring reports show correct fields
ExportsConfirm exported data match expected structure
Edge casesTest missed visits, withdrawals, deaths, and unusual values