{
    "schema_version": "1.0",
    "phase": "H11.0-P11.1-R45-P2",
    "release": "11.0.11.57",
    "generated_at": "2026-07-26T06:39:16+03:00",
    "hospital": "NJCH",
    "year": 2026,
    "compare_year": 2025,
    "from_date": null,
    "to_date": null,
    "iterations": 3,
    "legacy_revenue_query_calls_per_page": 4,
    "consolidated_revenue_query_calls_per_page": 1,
    "profit_loss_query_calls_per_page": 1,
    "total_primary_calls_before": 5,
    "total_primary_calls_after": 2,
    "legacy_four_query_path": {
        "samples_ms": [
            48.227
        ],
        "min_ms": 48.227,
        "avg_ms": 48.227,
        "max_ms": 48.227
    },
    "consolidated_one_query_path": {
        "samples_ms": [
            11.343,
            3.145,
            3.278
        ],
        "min_ms": 3.145,
        "avg_ms": 5.922,
        "max_ms": 11.343
    },
    "average_improvement_percent": 87.72,
    "numeric_parity": {
        "status": "UNAVAILABLE",
        "checks": 0,
        "passed": 0,
        "failed": 0,
        "differences": []
    },
    "errors": {
        "legacy_four_query_path": "SQLSTATE[HY000]: General error: 979 OCIStmtExecute: ORA-00979: not a GROUP BY expression\n (ext\\pdo_oci\\oci_statement.c:157)"
    },
    "status": "LIVE_UNAVAILABLE",
    "oracle_writes": "NONE"
}