# Validation report — run 20260509T141951Z

Generated: 2026-05-09T14:19:54.216230+00:00  ·  strictness: **strict**

**Overall: FAIL**  ·  PASS=57  FAIL=2  WARN=0

## Failures

- **C1_categorical_reason_for_visiting** — High BP: expected 1, got 0 | Other: expected 0, got 1
- **C1_categorical_physical_activity_level_at_first_visit** — Other: expected 0, got 1 | Vigorous: expected 1, got 0

## Warnings

_(none)_

## Detailed checks

| check | status | detail |
|---|---|---|
| S1_row_count | PASS | raw=342, cleaned=342 |
| S2_row_id_integrity | PASS | unique integer 1..342 |
| S3_column_traceability | PASS | all cleaned columns traceable |
| N1_numeric_age_years | PASS | exact match |
| N1_numeric_weight_at_first_visit | PASS | exact match |
| N1_numeric_weight_at_3_months | PASS | exact match |
| N1_numeric_weight_at_6_months | PASS | exact match |
| N1_numeric_height_at_first_visit | PASS | exact match |
| N1_numeric_height_at_3_months | PASS | exact match |
| N1_numeric_height_at_6_months | PASS | exact match |
| N1_numeric_bmi_at_first_visit | PASS | exact match |
| N1_numeric_bmi_at_3_months | PASS | exact match |
| N1_numeric_bmi_at_6_months | PASS | exact match |
| N1_numeric_waist_circumference_first_visit | PASS | exact match |
| N1_numeric_waist_circumference_3_months | PASS | exact match |
| N1_numeric_waist_circumference_6_months | PASS | exact match |
| N1_numeric_systolic_bp_at_first_visit | PASS | exact match |
| N1_numeric_systolic_bp_at_3_months | PASS | exact match |
| N1_numeric_systolic_bp_at_6_months | PASS | exact match |
| N1_numeric_diastolic_bp_at_first_visit | PASS | exact match |
| N1_numeric_diastolic_bp_at_3_months | PASS | exact match |
| N1_numeric_diastolic_bp_at_6_months | PASS | exact match |
| N1_numeric_hba1c_at_first_visit | PASS | exact match |
| N1_numeric_hba1c_at_3_months | PASS | exact match |
| N1_numeric_hba1c_at_6_months | PASS | exact match |
| N1_numeric_total_cholesterol_at_first_visit | PASS | exact match |
| N1_numeric_total_cholesterol_at_3_months | PASS | exact match |
| N2_coerce_total_cholesterol_at_6_months | PASS | parsed=88, unparseable→999=1, outliers_flagged=0 |
| N1_numeric_ldl_at_first_visit | PASS | exact match |
| N1_numeric_ldl_at_3_months | PASS | exact match |
| N2_coerce_ldl_at_6_months | PASS | parsed=85, unparseable→999=1, outliers_flagged=0 |
| N1_numeric_hdl_at_first_visit | PASS | exact match |
| N1_numeric_hdl_at_3_months | PASS | exact match |
| N2_coerce_hdl_at_6_months | PASS | parsed=86, unparseable→999=1, outliers_flagged=0 |
| N1_numeric_triglycerides_at_first_visit | PASS | exact match |
| N1_numeric_triglycerides_at_3_months | PASS | exact match |
| N2_coerce_triglycerides_at_6_months | PASS | parsed=87, unparseable→999=1, outliers_flagged=1 |
| N1_numeric_sessions_attended_number_of_sessions | PASS | exact match |
| N1_numeric_sessions_scheduled_number | PASS | exact match |
| C1_categorical_gender | PASS | all bucketed frequencies match |
| C1_categorical_nationality | PASS | all bucketed frequencies match |
| C1_categorical_education_level | PASS | all bucketed frequencies match |
| C1_categorical_employment_status | PASS | all bucketed frequencies match |
| C1_categorical_diabetes_status | PASS | all bucketed frequencies match |
| C1_categorical_hypertention_status | PASS | all bucketed frequencies match |
| C1_categorical_dyslipidemia_status | PASS | all bucketed frequencies match |
| C1_categorical_history_of_cvd | PASS | all bucketed frequencies match |
| C1_categorical_reason_for_visiting | FAIL | High BP: expected 1, got 0 | Other: expected 0, got 1 |
| C1_categorical_smoking_status_at_first_visit | PASS | all bucketed frequencies match |
| C1_categorical_smoking_status_at_3_months | PASS | all bucketed frequencies match |
| C1_categorical_smoking_status_at_6_months | PASS | all bucketed frequencies match |
| C1_categorical_physical_activity_level_at_first_visit | FAIL | Other: expected 0, got 1 | Vigorous: expected 1, got 0 |
| C1_categorical_physical_activity_level_at_3_months | PASS | all bucketed frequencies match |
| C1_categorical_physical_activity_level_at_6_months | PASS | all bucketed frequencies match |
| C1_categorical_dietary_habits_at_first_visit | PASS | all bucketed frequencies match |
| C1_categorical_dietary_habits_at_3_months | PASS | all bucketed frequencies match |
| C1_categorical_dietary_habits_at_6_months | PASS | all bucketed frequencies match |
| C1_categorical_type_of_intervention | PASS | all bucketed frequencies match |
| C1_categorical_program_completion | PASS | all bucketed frequencies match |