{
    "schema": "DDB_SPECIALTY_FINANCE_ACTIVITY_PARITY_V1_1",
    "captured_at": "2026-07-26T06:41:27+03:00",
    "hospital": "NJCH",
    "year": 2026,
    "compare_year": 2025,
    "start_month": 1,
    "end_month": 6,
    "source_contract": {
        "current": {
            "table": "KPI_DOCTOR_PERF_DETAIL_JOB",
            "columns": {
                "YEARID": true,
                "MONTHID": true,
                "SPECIAL_SPEC_ID": true,
                "SPECIAL_SPEC_EN_NAME": true,
                "TOTAL_OP_VISITS": true,
                "TOTAL_INPAT_VISITS": true
            },
            "doctor_identity_column": "EMP_ID",
            "missing": [],
            "ready": true,
            "aggregation": "SPECIALTY + DOCTOR deduplication before specialty totals",
            "oracle_writes": "NONE"
        },
        "reference": {
            "table": "KPI_DOCTOR_PERF_DETAIL_JOB",
            "columns": {
                "YEARID": true,
                "MONTHID": true,
                "SPECIAL_SPEC_ID": true,
                "SPECIAL_SPEC_EN_NAME": true,
                "TOTAL_OP_VISITS": true,
                "TOTAL_INPAT_VISITS": true
            },
            "doctor_identity_column": "EMP_ID",
            "missing": [],
            "ready": true,
            "oracle_writes": "NONE"
        }
    },
    "counts": {
        "combined_period_specialties": 29,
        "combined_monthly_rows": 169,
        "normalized_current_period_specialties": 29,
        "normalized_compare_period_specialties": 28,
        "normalized_current_monthly_rows": 162,
        "normalized_compare_monthly_rows": 166,
        "reference_current_specialties": 29,
        "reference_compare_specialties": 28
    },
    "normalization": {
        "rule": "A row with zero Admissions and zero Outpatient Visits is excluded only from that year-side parity identity set. The combined comparison row remains available for new or discontinued specialty detection.",
        "zero_only_rows": {
            "period": {
                "current": [],
                "compare": [
                    "101"
                ]
            },
            "monthly": {
                "current": [
                    "103|1",
                    "103|2",
                    "103|3",
                    "103|4",
                    "103|5",
                    "99|4",
                    "99|5"
                ],
                "compare": [
                    "101|6",
                    "103|6",
                    "10|3"
                ]
            }
        }
    },
    "period_parity": {
        "current": {
            "actual_rows": 29,
            "reference_rows": 29,
            "identity_mismatches": [],
            "value_differences": [],
            "max_difference": 0,
            "status": "PASS"
        },
        "compare": {
            "actual_rows": 28,
            "reference_rows": 28,
            "identity_mismatches": [],
            "value_differences": [],
            "max_difference": 0,
            "status": "PASS"
        }
    },
    "monthly_parity": {
        "current": {
            "actual_rows": 162,
            "reference_rows": 162,
            "identity_mismatches": [],
            "value_differences": [],
            "max_difference": 0,
            "status": "PASS"
        },
        "compare": {
            "actual_rows": 166,
            "reference_rows": 166,
            "identity_mismatches": [],
            "value_differences": [],
            "max_difference": 0,
            "status": "PASS"
        }
    },
    "reconciliation": {
        "current": {
            "specialty_totals": {
                "outpatient_visits": 62983,
                "admissions": 1149
            },
            "doctor_totals": {
                "outpatient_visits": 62983,
                "admissions": 1149
            },
            "difference": {
                "outpatient_visits": 0,
                "admissions": 0
            }
        },
        "compare": {
            "specialty_totals": {
                "outpatient_visits": 64166,
                "admissions": 1351
            },
            "doctor_totals": {
                "outpatient_visits": 64166,
                "admissions": 1351
            },
            "difference": {
                "outpatient_visits": 0,
                "admissions": 0
            }
        }
    },
    "checks": {
        "source_contract_ready": true,
        "specialty_period_rows_present": true,
        "specialty_month_rows_present": true,
        "current_period_exact": true,
        "compare_period_exact": true,
        "current_monthly_exact": true,
        "compare_monthly_exact": true,
        "current_specialty_total_reconciles_to_doctor_total": true,
        "compare_specialty_total_reconciles_to_doctor_total": true,
        "both_metrics_have_activity": true,
        "monthly_grain_within_contract": true,
        "zero_only_side_rows_normalized": true
    },
    "failed": [],
    "status": "PASS",
    "oracle_writes": "NONE",
    "comparison_contract": {
        "current_calendar_year": 2026,
        "current_calendar_month": 7,
        "includes_current_year": true,
        "fair_current_year_comparison": true,
        "last_complete_month": 6,
        "start_month": 1,
        "end_month": 6,
        "from_date": "2026-01-01",
        "to_date": "2026-06-30",
        "months_count": 6,
        "current_month_excluded": 7
    },
    "evidence_file": "C:\\xampp\\htdocs\\ddb-new/storage/evidence/specialty_finance/SPECIALTY_FINANCE_R45_P12_0_ACTIVITY_LIVE_ACCEPTANCE_20260726_064127.json"
}