Data Validation Process

What is Data Validation?

Data Validation is the process of checking uploaded data for errors, inconsistencies, and compliance with expected formats.

Checks Performed

Format Validation

  • Correct column headers
  • Proper data types (numbers, dates, text)
  • Required fields present

Value Validation

  • Valid CMMI IDs (participant exists)
  • Values within expected ranges
  • Consistent units

Integrity Validation

  • No duplicates
  • Dates in logical order
  • References exist

Error Messages

  • Clear descriptions of issues
  • Row/column locations
  • Suggestions for fixes

Related Terms

  • Bulk Upload: Where validation occurs
  • Data Quality: Goal of validation