# Generated by Django 5.2.15 on 2026-07-14 04:52

from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ("mel_indicators", "0015_datapoint_clarification_note_and_more"),
    ]

    operations = [
        migrations.AddField(
            model_name="historicalindicatorvariance",
            name="rating",
            field=models.CharField(
                blank=True,
                choices=[
                    ("on_track", "On Track"),
                    ("needs_attention", "Needs Attention"),
                    ("critical", "Critical"),
                ],
                db_index=True,
                help_text="M&E SRS Table 66 — qualitative rating derived from variance_pct: On Track (≥ −15%), Needs Attention (−15% to −50%), Critical (≤ −50%).",
                max_length=16,
            ),
        ),
        migrations.AddField(
            model_name="historicalindicatorvariance",
            name="variance_abs",
            field=models.DecimalField(
                blank=True,
                decimal_places=4,
                help_text="M&E SRS Table 66 — absolute variance (actual − target).",
                max_digits=18,
                null=True,
            ),
        ),
        migrations.AddField(
            model_name="indicatorvariance",
            name="rating",
            field=models.CharField(
                blank=True,
                choices=[
                    ("on_track", "On Track"),
                    ("needs_attention", "Needs Attention"),
                    ("critical", "Critical"),
                ],
                db_index=True,
                help_text="M&E SRS Table 66 — qualitative rating derived from variance_pct: On Track (≥ −15%), Needs Attention (−15% to −50%), Critical (≤ −50%).",
                max_length=16,
            ),
        ),
        migrations.AddField(
            model_name="indicatorvariance",
            name="variance_abs",
            field=models.DecimalField(
                blank=True,
                decimal_places=4,
                help_text="M&E SRS Table 66 — absolute variance (actual − target).",
                max_digits=18,
                null=True,
            ),
        ),
    ]