Database Design in REDCap

Validation Rules

Table 1

30-45 minutes Foundational Step 6 of 7

Table

Table 1

6 / 7

Table

Table 1

Variable	Field type	Suggested validation	Rationale
`age_years`	Numeric text	0-120	Prevent impossible ages
`weight_kg`	Numeric text	1-250	Capture plausible human weight
`temp_c`	Numeric text	30-45	Prevent unit and entry errors
`enrollment_date`	Date	YYYY-MM-DD	Standardize date format
`phone_number`	Text	Phone format or local pattern	Reduce contact information errors
`hb_g_dl`	Numeric text	2-25	Plausible hemoglobin range