{
    "status": "PASS",
    "discovery_status": "CANDIDATES_FOUND",
    "candidate_count": 6,
    "evidence_file": "C:\\xampp\\htdocs\\ddb-new/storage/evidence/specialty-finance/SPECIALTY_FINANCE_SOURCE_REFRESH_DISCOVERY_20260726_063517.json",
    "producer_candidates": [
        {
            "source": "table_owner_and_type",
            "row": {
                "owner": "WATANY",
                "object_name": "KPI_DOCTOR_PERF_DETAIL_JOB",
                "object_type": "TABLE",
                "status": "VALID",
                "created": "12-FEB-23",
                "last_ddl_time": "05-JUL-26"
            }
        },
        {
            "source": "direct_dependencies_on_table",
            "row": {
                "owner": "WATANY",
                "name": "KPI_DOCTOR_PERFORMANCE_DETAIL",
                "type": "PROCEDURE",
                "referenced_owner": "WATANY",
                "referenced_name": "KPI_DOCTOR_PERF_DETAIL_JOB",
                "referenced_type": "TABLE"
            }
        },
        {
            "source": "source_references",
            "row": {
                "owner": "WATANY",
                "name": "KPI_DOCTOR_PERFORMANCE_DETAIL",
                "type": "PROCEDURE",
                "line": "285",
                "text": "FROM KPI_DOCTOR_PERF_DETAIL_JOB\n"
            }
        },
        {
            "source": "source_references",
            "row": {
                "owner": "WATANY",
                "name": "KPI_DOCTOR_PERFORMANCE_DETAIL",
                "type": "PROCEDURE",
                "line": "294",
                "text": "insert into KPI_DOCTOR_PERF_DETAIL_JOB\n"
            }
        },
        {
            "source": "scheduler_jobs",
            "row": {
                "owner": "WATANY",
                "job_name": "DOCTOR_PERFORMANCE_DETAIL",
                "enabled": "TRUE",
                "state": "SCHEDULED",
                "job_type": "PLSQL_BLOCK",
                "job_action": " DECLARE\n  P_SPECIALITY     VARCHAR2(200);\n  P_EMP_ID         NUMBER;\n  P_YEAR           NUMBER;\n  P_MONTH_FROM     NUMBER;\n  P_MONTH_TO       NUMBER;\n  P_OUTSIDE_DOCTOR NUMBER;\n  P_REFCUR SYS_REFCURSOR;\nBEGIN\n  P_SPECIALITY     := NULL;\n  P_EMP_ID         := 0;\n  P_YEAR           := 2026;\n  P_MONTH_FROM     := 1;\n  P_MONTH_TO       := 12;\n  P_OUTSIDE_DOCTOR := 99;\n  KPI_DOCTOR_PERFORMANCE_DETAIL( P_SPECIALITY => P_SPECIALITY, P_EMP_ID => P_EMP_ID, P_YEAR => P_YEAR, P_MONTH_FROM => P_MONTH_FROM, P_MONTH_TO => P_MONTH_TO, P_OUTSIDE_DOCTOR => P_OUTSIDE_DOCTOR, P_REFCUR => P_REFCUR );\n  \nEND;\n",
                "repeat_interval": "FREQ=DAILY;BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN",
                "start_date": "18-FEB-23 05.56.22.806566 PM ASIA/RIYADH",
                "last_start_date": "25-JUL-26 05.56.22.780291 PM ASIA/RIYADH",
                "last_run_duration": "+000000000 00:02:24.507995",
                "next_run_date": "26-JUL-26 05.56.22.800000 PM ASIA/RIYADH",
                "failure_count": "1"
            }
        },
        {
            "source": "scheduler_jobs",
            "row": {
                "owner": "WATANY",
                "job_name": "KPI_TOTAL_REVENUE_JOB",
                "enabled": "TRUE",
                "state": "SCHEDULED",
                "job_type": "PLSQL_BLOCK",
                "job_action": "begin\nkpi_total_revenue_autorun(null , null);\nend ;",
                "repeat_interval": "FREQ=DAILY;BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN",
                "start_date": "09-JAN-23 03.39.42.000000 AM ASIA/RIYADH",
                "last_start_date": "26-JUL-26 03.39.42.179221 AM ASIA/RIYADH",
                "last_run_duration": "+000000000 00:09:37.308255",
                "next_run_date": "27-JUL-26 03.39.42.200000 AM ASIA/RIYADH",
                "failure_count": "206"
            }
        }
    ]
}