{ "schema": "R45_P3_REVENUE_SUMMARY_FOUNDATION", "status": "PASS", "command": "status", "hospital": "njch", "branch_id": 1, "from_date": "2023-07-01", "to_date": "2026-07-31", "objects": [ { "object_name": "DASH_REFRESH_REV_MONTH_SUM", "object_type": "PROCEDURE", "status": "VALID" }, { "object_name": "DASH_REVENUE_SUMMARY_RUN_SEQ", "object_type": "SEQUENCE", "status": "VALID" }, { "object_name": "DASH_REVENUE_MONTHLY_STAGE", "object_type": "TABLE", "status": "VALID" }, { "object_name": "DASH_REVENUE_MONTHLY_SUMMARY", "object_type": "TABLE", "status": "VALID" }, { "object_name": "DASH_REVENUE_SUMMARY_RUN", "object_type": "TABLE", "status": "VALID" } ], "latest_run": { "run_id": "14", "branch_id": "1", "status": "READY", "from_date": "01-JUL-23", "to_date": "31-JUL-26", "source_row_count": "3620977", "summary_row_count": "3620977", "source_total": "375577940.1632", "summary_total": "375577940.1632", "source_cash": "54289499.6573", "summary_cash": "54289499.6573", "source_insurance": "321288440.5059", "summary_insurance": "321288440.5059", "source_moh": "117204105.13", "summary_moh": "117204105.13", "started_at": "26-JUL-26 04.29.49.605230 AM", "finished_at": "26-JUL-26 04.31.33.817981 AM", "error_message": null }, "parity": null, "oracle_writes": "NONE" }