{
    "phase": "H11.0-P11.1-R10F",
    "release": "11.0.11.13",
    "title": "Daily Inpatient Revenue Native Chart Drawing Repair Closure",
    "checks": [
        {
            "name": "njch_national_payer_mapping_365",
            "status": "PASS",
            "detail": "365"
        },
        {
            "name": "njch_tcs_mapping_170",
            "status": "PASS",
            "detail": "170"
        },
        {
            "name": "njch_gosi_mapping_406",
            "status": "PASS",
            "detail": "406"
        },
        {
            "name": "mnh_national_payer_mapping_9002",
            "status": "PASS",
            "detail": "9002"
        },
        {
            "name": "mnh_tcs_mapping_2009",
            "status": "PASS",
            "detail": "2009"
        },
        {
            "name": "mnh_gosi_mapping_3005",
            "status": "PASS",
            "detail": "3005"
        },
        {
            "name": "icu_type_contract_exact_four_values",
            "status": "PASS",
            "detail": "Intr ICU|ICU|NICU|PICU"
        },
        {
            "name": "mnh_icu_type_contract_exact_four_values",
            "status": "PASS",
            "detail": "Intr ICU|ICU|NICU|PICU"
        },
        {
            "name": "national_short_stay_threshold_strictly_less_than_30",
            "status": "PASS",
            "detail": "service uses total_los < threshold"
        },
        {
            "name": "national_short_stay_icu_rate_4746_87",
            "status": "PASS",
            "detail": "4746.87"
        },
        {
            "name": "national_standard_rate_2373",
            "status": "PASS",
            "detail": "2373"
        },
        {
            "name": "national_nicu_type_exact_nicu",
            "status": "PASS",
            "detail": "NICU"
        },
        {
            "name": "national_nicu_day_limit_14_inclusive",
            "status": "PASS",
            "detail": "14"
        },
        {
            "name": "national_nicu_rate_days_1_14_5232_15",
            "status": "PASS",
            "detail": "5232.15"
        },
        {
            "name": "national_nicu_rate_after_14_3251_77",
            "status": "PASS",
            "detail": "3251.77"
        },
        {
            "name": "mnh_nicu_rule_matches_branch_equivalent_national_payer",
            "status": "PASS",
            "detail": "MNH 9002 uses the same approved NICU schedule"
        },
        {
            "name": "shared_tier_1_3_2250",
            "status": "PASS",
            "detail": "2250"
        },
        {
            "name": "shared_tier_4_8_1950",
            "status": "PASS",
            "detail": "1950"
        },
        {
            "name": "shared_tier_9_plus_1750",
            "status": "PASS",
            "detail": "1750"
        },
        {
            "name": "njch_365_nicu_day_1_uses_5232_15",
            "status": "PASS",
            "detail": "5232.15"
        },
        {
            "name": "njch_365_nicu_day_14_inclusive_uses_5232_15",
            "status": "PASS",
            "detail": "5232.15"
        },
        {
            "name": "njch_365_nicu_day_15_uses_3251_77",
            "status": "PASS",
            "detail": "3251.77"
        },
        {
            "name": "njch_365_short_stay_icu_uses_4746_87",
            "status": "PASS",
            "detail": "4746.87"
        },
        {
            "name": "njch_365_short_stay_intr_icu_uses_4746_87",
            "status": "PASS",
            "detail": "4746.87"
        },
        {
            "name": "njch_365_short_stay_picu_uses_4746_87",
            "status": "PASS",
            "detail": "4746.87"
        },
        {
            "name": "njch_365_short_stay_non_icu_uses_2373",
            "status": "PASS",
            "detail": "2373"
        },
        {
            "name": "njch_365_day_30_icu_uses_2373",
            "status": "PASS",
            "detail": "2373"
        },
        {
            "name": "njch_tcs_1_3",
            "status": "PASS",
            "detail": "2250"
        },
        {
            "name": "njch_tcs_4_8",
            "status": "PASS",
            "detail": "1950"
        },
        {
            "name": "njch_tcs_9_plus",
            "status": "PASS",
            "detail": "1750"
        },
        {
            "name": "njch_gosi_406_uses_tcs_tier_1_3",
            "status": "PASS",
            "detail": "2250"
        },
        {
            "name": "njch_gosi_406_uses_tcs_tier_4_8",
            "status": "PASS",
            "detail": "1950"
        },
        {
            "name": "njch_gosi_406_uses_tcs_tier_9_plus",
            "status": "PASS",
            "detail": "1750"
        },
        {
            "name": "cash_patient_share_per_continuous_los",
            "status": "PASS",
            "detail": "1966.17"
        },
        {
            "name": "other_insurance_company_share_per_continuous_los",
            "status": "PASS",
            "detail": "2567.3"
        },
        {
            "name": "mnh_9002_nicu_day_14_uses_5232_15",
            "status": "PASS",
            "detail": "5232.15"
        },
        {
            "name": "mnh_9002_nicu_day_15_uses_3251_77",
            "status": "PASS",
            "detail": "3251.77"
        },
        {
            "name": "mnh_9002_short_stay_icu_4746_87",
            "status": "PASS",
            "detail": "4746.87"
        },
        {
            "name": "mnh_9002_short_stay_non_icu_2373",
            "status": "PASS",
            "detail": "2373"
        },
        {
            "name": "mnh_tcs_2009_uses_shared_tiers",
            "status": "PASS",
            "detail": "2250"
        },
        {
            "name": "mnh_gosi_3005_uses_shared_tier_4_8",
            "status": "PASS",
            "detail": "1950"
        },
        {
            "name": "mnh_gosi_3005_uses_shared_tier_9_plus",
            "status": "PASS",
            "detail": "1750"
        },
        {
            "name": "oracle_icu_type_join_present",
            "status": "PASS",
            "detail": "STP_NURSINGUNIT_TYPE.DESC_EN"
        },
        {
            "name": "oracle_icu_type_reaches_final_result_set",
            "status": "PASS",
            "detail": "nursing_unit_type is selected for the calculation service"
        },
        {
            "name": "mnh_missing_static_branch_id_no_longer_blocks_runtime",
            "status": "PASS",
            "detail": "repository uses deterministic branch resolver"
        },
        {
            "name": "branch_resolver_uses_hospital_main_data_read_only_identity",
            "status": "PASS",
            "detail": "read-only hospital identity resolution"
        },
        {
            "name": "branch_resolver_has_mnh_name_aliases",
            "status": "PASS",
            "detail": "MNH aliases included"
        },
        {
            "name": "branch_resolver_has_single_active_inpatient_fallback",
            "status": "PASS",
            "detail": "deterministic active-branch fallback"
        },
        {
            "name": "branch_resolver_contains_no_oracle_write_dml",
            "status": "PASS",
            "detail": "Oracle writes NONE"
        },
        {
            "name": "oracle_los_applies_to_all_payers_without_company_specific_bind",
            "status": "PASS",
            "detail": "one continuous LOS source for every payer"
        },
        {
            "name": "oracle_active_census_and_patient_keys_materialized_for_performance",
            "status": "PASS",
            "detail": "active census and active patient keys are materialization candidates"
        },
        {
            "name": "oracle_continuous_los_scans_only_current_active_patient_keys",
            "status": "PASS",
            "detail": "performance guard limits RCP_VISIT history to current census"
        },
        {
            "name": "oracle_continuous_los_uses_rcp_visit_classcode_sequence",
            "status": "PASS",
            "detail": "ordered visit sequence with CLASSCODE=1"
        },
        {
            "name": "oracle_non_inpatient_visit_breaks_inpatient_chain",
            "status": "PASS",
            "detail": "any prior non-inpatient class starts a new inpatient run"
        },
        {
            "name": "oracle_current_run_start_uses_first_visit_start_date",
            "status": "PASS",
            "detail": "first date in current uninterrupted inpatient run"
        },
        {
            "name": "oracle_all_patient_los_and_total_los_use_continuous_start",
            "status": "PASS",
            "detail": "LOS and Total LOS share the same continuous inpatient start"
        },
        {
            "name": "oracle_no_hardcoded_365_los_logic",
            "status": "PASS",
            "detail": "payer-independent LOS engine"
        },
        {
            "name": "no_direct_legacy_revenue_procedure_call",
            "status": "PASS",
            "detail": "repository execution path"
        },
        {
            "name": "residence_package_flag_still_uses_r_alias",
            "status": "PASS",
            "detail": "PACC_PAT_RES_TRAN alias r"
        },
        {
            "name": "oracle_runtime_query_is_read_only",
            "status": "PASS",
            "detail": "Oracle writes NONE"
        },
        {
            "name": "database_reference_sql_matches_runtime_continuous_los_contract",
            "status": "PASS",
            "detail": "reference SQL aligned with runtime continuous LOS engine"
        },
        {
            "name": "live_oracle_read_only_proof_tool_present",
            "status": "PASS",
            "detail": "live current inpatient query + read-only declaration"
        },
        {
            "name": "live_oracle_proof_tool_contains_no_write_dml",
            "status": "PASS",
            "detail": "no write DML in live proof tool"
        },
        {
            "name": "live_oracle_proof_requires_njch_and_mnh_nonzero_rows",
            "status": "PASS",
            "detail": "both ready branches must prove live data"
        },
        {
            "name": "live_oracle_proof_validates_continuous_los_for_every_row",
            "status": "PASS",
            "detail": "every live row must have positive equal LOS/Total LOS from the shared continuous stay source"
        },
        {
            "name": "live_oracle_proof_records_query_performance_telemetry",
            "status": "PASS",
            "detail": "records live query elapsed time without arbitrary pass/fail threshold"
        },
        {
            "name": "settings_screen_route_registered",
            "status": "PASS",
            "detail": "GET + POST route"
        },
        {
            "name": "settings_save_is_csrf_protected",
            "status": "PASS",
            "detail": "CSRF validation"
        },
        {
            "name": "settings_edit_requires_finance_role",
            "status": "FAIL",
            "detail": "existing finance permission"
        },
        {
            "name": "settings_storage_is_local_not_oracle",
            "status": "PASS",
            "detail": "local atomic settings persistence"
        },
        {
            "name": "settings_atomic_write_backup_and_audit",
            "status": "PASS",
            "detail": "atomic save + backup + audit"
        },
        {
            "name": "settings_windows_safe_swap_and_audit_rollback",
            "status": "PASS",
            "detail": "same-directory swap with rollback on activation/audit failure"
        },
        {
            "name": "settings_view_has_all_required_business_sections",
            "status": "PASS",
            "detail": "national + NICU + shared tiers + payer mappings + ICU types + other insurance policy"
        },
        {
            "name": "settings_navigation_visible_only_to_finance_manager_role",
            "status": "PASS",
            "detail": "not exposed to general executive users"
        },
        {
            "name": "settings_nicu_rule_is_configurable_and_persisted",
            "status": "PASS",
            "detail": "NICU threshold and both rates are managed in the protected settings screen"
        },
        {
            "name": "settings_all_payer_los_source_is_continuous_inpatient_chain",
            "status": "PASS",
            "detail": "national + tiered + cash + other insurance"
        },
        {
            "name": "service_nicu_rule_precedes_general_icu_rule",
            "status": "PASS",
            "detail": "NICU special rate has explicit priority"
        },
        {
            "name": "executive_screen_rule_panel_removed",
            "status": "PASS",
            "detail": "no rule panel"
        },
        {
            "name": "executive_screen_calculation_method_column_removed",
            "status": "PASS",
            "detail": "no calculation method shown"
        },
        {
            "name": "executive_screen_contains_no_fixed_rule_values",
            "status": "PASS",
            "detail": "results only"
        },
        {
            "name": "error_state_uses_na_not_false_zero",
            "status": "PASS",
            "detail": "N/A on load error"
        },
        {
            "name": "xlsx_contains_no_calculation_rules_section",
            "status": "PASS",
            "detail": "no calculation-rule content in workbook export path"
        },
        {
            "name": "xlsx_hybrid_exporter_is_default",
            "status": "PASS",
            "detail": "hybrid_final is the default export mode"
        },
        {
            "name": "xlsx_hybrid_uses_code_driven_summary_and_daily",
            "status": "PASS",
            "detail": "Summary and Daily Revenue use the proven code-driven generator"
        },
        {
            "name": "xlsx_hybrid_cell_chart_no_drawing_enabled",
            "status": "PASS",
            "detail": "Revenue Chart uses Excel-safe worksheet cells with no drawing or chart package parts"
        },
        {
            "name": "xlsx_hybrid_no_drawing_package_parts",
            "status": "PASS",
            "detail": "no drawing XML is emitted, preventing Excel Desktop repair"
        },
        {
            "name": "xlsx_hybrid_cell_bars_are_visible_without_support_table",
            "status": "PASS",
            "detail": "cell-based proportional bars remain visible without hidden drawing dependencies"
        },
        {
            "name": "xlsx_summary_has_unit_average_column",
            "status": "PASS",
            "detail": "summary care-area average remains dynamically populated"
        },
        {
            "name": "xlsx_detail_has_unit_average_below_each_unit",
            "status": "PASS",
            "detail": "average remains below every unit subtotal"
        },
        {
            "name": "xlsx_rollback_modes_preserved",
            "status": "PASS",
            "detail": "legacy and both template rollback modes remain available"
        },
        {
            "name": "xlsx_template_rollback_assets_present",
            "status": "PASS",
            "detail": "template rollback assets remain present"
        },
        {
            "name": "xlsx_old_national_rule_text_removed",
            "status": "PASS",
            "detail": "old <=30 rule absent"
        },
        {
            "name": "php74_compatibility_runtime_files",
            "status": "PASS",
            "detail": "no PHP 8-only syntax markers"
        },
        {
            "name": "xlsx_runtime_created",
            "status": "PASS",
            "detail": "6982"
        },
        {
            "name": "xlsx_runtime_three_requested_sheets",
            "status": "FAIL",
            "detail": "Summary + Daily Revenue + Revenue Chart"
        },
        {
            "name": "xlsx_runtime_obsolete_audit_sheets_absent",
            "status": "PASS",
            "detail": "obsolete sheets remain absent"
        },
        {
            "name": "xlsx_runtime_calculation_rules_absent_everywhere",
            "status": "PASS",
            "detail": "no calculation-rule content in workbook parts"
        },
        {
            "name": "xlsx_runtime_summary_unit_average_present",
            "status": "PASS",
            "detail": "summary care-area daily revenue average column"
        },
        {
            "name": "xlsx_runtime_detail_unit_average_present",
            "status": "PASS",
            "detail": "average below each unit subtotal"
        },
        {
            "name": "xlsx_runtime_hybrid_populated_all_current_units",
            "status": "PASS",
            "detail": "one subtotal for every current unit from the code-driven detail generator"
        },
        {
            "name": "xlsx_runtime_chart_uses_excel_safe_cells_only",
            "status": "FAIL",
            "detail": "Revenue Chart is a worksheet-cell visual, not a drawing object"
        },
        {
            "name": "xlsx_runtime_no_drawing_xml_part",
            "status": "PASS",
            "detail": "no drawing1.xml can be removed by Excel Desktop"
        },
        {
            "name": "xlsx_runtime_no_chart_xml_part",
            "status": "PASS",
            "detail": "no chart1.xml dependency remains"
        },
        {
            "name": "xlsx_runtime_no_sheet3_drawing_relationship",
            "status": "PASS",
            "detail": "sheet3 has no drawing relationship"
        },
        {
            "name": "xlsx_runtime_hybrid_architecture_preserves_legacy_sheets_and_has_no_drawing_parts",
            "status": "FAIL",
            "detail": "code-driven Summary/Daily plus Excel-safe cell chart preserved"
        }
    ],
    "pass_gates": 101,
    "fail_gates": 4,
    "oracle_writes": "NONE",
    "status": "FAIL"
}