{ "status": "PASS", "json_file": "C:\\xampp\\htdocs\\ddb-new/storage/evidence/specialty-finance/SPECIALTY_FINANCE_MONTHLY_GRAIN_DISCOVERY_20260726_063925.json", "csv_file": "C:\\xampp\\htdocs\\ddb-new/storage/evidence/specialty-finance/SPECIALTY_FINANCE_COLUMN_CANDIDATES_20260726_063925.csv", "fair_comparison_readiness": { "status": "READY", "recommended_column": "MONTHID", "recommended_mode": "MONTH_ID", "reason": "A numeric month-grain column with values 1..12 was proven." }, "candidate_profiles": [ { "column": "MONTHID", "data_type": "NUMBER", "score": 8, "reasons": [ "month_identifier" ], "status": "PASS", "elapsed_ms": 3.48, "profile": { "mode": "value", "rows": [ { "yearid": "2025", "candidate_value": "1", "row_count": "171" }, { "yearid": "2025", "candidate_value": "10", "row_count": "206" }, { "yearid": "2025", "candidate_value": "11", "row_count": "206" }, { "yearid": "2025", "candidate_value": "12", "row_count": "225" }, { "yearid": "2025", "candidate_value": "2", "row_count": "182" }, { "yearid": "2025", "candidate_value": "3", "row_count": "164" }, { "yearid": "2025", "candidate_value": "4", "row_count": "196" }, { "yearid": "2025", "candidate_value": "5", "row_count": "198" }, { "yearid": "2025", "candidate_value": "6", "row_count": "185" }, { "yearid": "2025", "candidate_value": "7", "row_count": "208" }, { "yearid": "2025", "candidate_value": "8", "row_count": "199" }, { "yearid": "2025", "candidate_value": "9", "row_count": "211" }, { "yearid": "2026", "candidate_value": "1", "row_count": "226" }, { "yearid": "2026", "candidate_value": "2", "row_count": "183" }, { "yearid": "2026", "candidate_value": "3", "row_count": "182" }, { "yearid": "2026", "candidate_value": "4", "row_count": "197" }, { "yearid": "2026", "candidate_value": "5", "row_count": "201" }, { "yearid": "2026", "candidate_value": "6", "row_count": "194" }, { "yearid": "2026", "candidate_value": "7", "row_count": "186" } ] }, "error": null }, { "column": "CONTRACTSTDATE", "data_type": "DATE", "score": 5, "reasons": [ "date_type" ], "status": "PASS", "elapsed_ms": 15.95, "profile": { "mode": "date", "rows": [ { "yearid": "2025", "min_value": "21-MAR-94", "max_value": "21-DEC-25", "distinct_months": "71", "row_count": "2351", "null_count": "0" }, { "yearid": "2026", "min_value": "21-MAR-94", "max_value": "21-JUL-26", "distinct_months": "72", "row_count": "1369", "null_count": "0" } ] }, "error": null }, { "column": "MONTH_NAME", "data_type": "VARCHAR2", "score": 4, "reasons": [ "name_match" ], "status": "PASS", "elapsed_ms": 3.99, "profile": { "mode": "value", "rows": [ { "yearid": "2025", "candidate_value": "APR", "row_count": "196" }, { "yearid": "2025", "candidate_value": "AUG", "row_count": "199" }, { "yearid": "2025", "candidate_value": "DEC", "row_count": "225" }, { "yearid": "2025", "candidate_value": "Feb", "row_count": "182" }, { "yearid": "2025", "candidate_value": "JAN", "row_count": "171" }, { "yearid": "2025", "candidate_value": "JUL", "row_count": "208" }, { "yearid": "2025", "candidate_value": "JUN", "row_count": "185" }, { "yearid": "2025", "candidate_value": "MAR ", "row_count": "164" }, { "yearid": "2025", "candidate_value": "MAY", "row_count": "198" }, { "yearid": "2025", "candidate_value": "NOV", "row_count": "206" }, { "yearid": "2025", "candidate_value": "OCT", "row_count": "206" }, { "yearid": "2025", "candidate_value": "SEP", "row_count": "211" }, { "yearid": "2026", "candidate_value": "APR", "row_count": "197" }, { "yearid": "2026", "candidate_value": "Feb", "row_count": "183" }, { "yearid": "2026", "candidate_value": "JAN", "row_count": "226" }, { "yearid": "2026", "candidate_value": "JUL", "row_count": "186" }, { "yearid": "2026", "candidate_value": "JUN", "row_count": "194" }, { "yearid": "2026", "candidate_value": "MAR ", "row_count": "182" }, { "yearid": "2026", "candidate_value": "MAY", "row_count": "201" } ] }, "error": null }, { "column": "AVG_OP_PER_VISIT", "data_type": "NUMBER", "score": 4, "reasons": [ "name_match" ], "status": "PASS", "elapsed_ms": 5.62, "profile": { "mode": "value", "rows": [ { "yearid": "2025", "candidate_value": "0", "row_count": "8" }, { "yearid": "2025", "candidate_value": "100", "row_count": "15" }, { "yearid": "2025", "candidate_value": "102", "row_count": "5" }, { "yearid": "2025", "candidate_value": "104", "row_count": "3" }, { "yearid": "2025", "candidate_value": "1075", "row_count": "1" }, { "yearid": "2025", "candidate_value": "108", "row_count": "1" }, { "yearid": "2025", "candidate_value": "109", "row_count": "9" }, { "yearid": "2025", "candidate_value": "110", "row_count": "1" }, { "yearid": "2025", "candidate_value": "116", "row_count": "12" }, { "yearid": "2025", "candidate_value": "117", "row_count": "1" }, { "yearid": "2025", "candidate_value": "1210", "row_count": "2" }, { "yearid": "2025", "candidate_value": "125", "row_count": "1" }, { "yearid": "2025", "candidate_value": "126", "row_count": "5" }, { "yearid": "2025", "candidate_value": "128", "row_count": "1" }, { "yearid": "2025", "candidate_value": "129", "row_count": "4" }, { "yearid": "2025", "candidate_value": "131", "row_count": "1" }, { "yearid": "2025", "candidate_value": "133", "row_count": "1" }, { "yearid": "2025", "candidate_value": "1356", "row_count": "2" }, { "yearid": "2025", "candidate_value": "138", "row_count": "4" }, { "yearid": "2025", "candidate_value": "139", "row_count": "2" }, { "yearid": "2025", "candidate_value": "141", "row_count": "1" }, { "yearid": "2025", "candidate_value": "142", "row_count": "1" }, { "yearid": "2025", "candidate_value": "143", "row_count": "2" }, { "yearid": "2025", "candidate_value": "144", "row_count": "3" }, { "yearid": "2025", "candidate_value": "146", "row_count": "13" }, { "yearid": "2025", "candidate_value": "150", "row_count": "4" }, { "yearid": "2025", "candidate_value": "151", "row_count": "5" }, { "yearid": "2025", "candidate_value": "153", "row_count": "6" }, { "yearid": "2025", "candidate_value": "154", "row_count": "10" }, { "yearid": "2025", "candidate_value": "157", "row_count": "7" }, { "yearid": "2025", "candidate_value": "158", "row_count": "1" }, { "yearid": "2025", "candidate_value": "159", "row_count": "5" }, { "yearid": "2025", "candidate_value": "160", "row_count": "3" }, { "yearid": "2025", "candidate_value": "161", "row_count": "3" }, { "yearid": "2025", "candidate_value": "162", "row_count": "8" }, { "yearid": "2025", "candidate_value": "164", "row_count": "7" }, { "yearid": "2025", "candidate_value": "165", "row_count": "12" }, { "yearid": "2025", "candidate_value": "167", "row_count": "11" }, { "yearid": "2025", "candidate_value": "169", "row_count": "1" }, { "yearid": "2025", "candidate_value": "170", "row_count": "1" }, { "yearid": "2025", "candidate_value": "171", "row_count": "3" }, { "yearid": "2025", "candidate_value": "172", "row_count": "1" }, { "yearid": "2025", "candidate_value": "173", "row_count": "13" }, { "yearid": "2025", "candidate_value": "174", "row_count": "3" }, { "yearid": "2025", "candidate_value": "175", "row_count": "2" }, { "yearid": "2025", "candidate_value": "176", "row_count": "11" }, { "yearid": "2025", "candidate_value": "177", "row_count": "1" }, { "yearid": "2025", "candidate_value": "178", "row_count": "2" }, { "yearid": "2025", "candidate_value": "179", "row_count": "8" }, { "yearid": "2025", "candidate_value": "180", "row_count": "2" }, { "yearid": "2025", "candidate_value": "181", "row_count": "18" }, { "yearid": "2025", "candidate_value": "182", "row_count": "6" }, { "yearid": "2025", "candidate_value": "183", "row_count": "5" }, { "yearid": "2025", "candidate_value": "184", "row_count": "7" }, { "yearid": "2025", "candidate_value": "185", "row_count": "2" }, { "yearid": "2025", "candidate_value": "186", "row_count": "7" }, { "yearid": "2025", "candidate_value": "187", "row_count": "25" }, { "yearid": "2025", "candidate_value": "189", "row_count": "6" }, { "yearid": "2025", "candidate_value": "190", "row_count": "1" }, { "yearid": "2025", "candidate_value": "191", "row_count": "1" }, { "yearid": "2025", "candidate_value": "192", "row_count": "1" }, { "yearid": "2025", "candidate_value": "193", "row_count": "3" }, { "yearid": "2025", "candidate_value": "194", "row_count": "11" }, { "yearid": "2025", "candidate_value": "195", "row_count": "4" }, { "yearid": "2025", "candidate_value": "196", "row_count": "2" }, { "yearid": "2025", "candidate_value": "197", "row_count": "5" }, { "yearid": "2025", "candidate_value": "200", "row_count": "6" }, { "yearid": "2025", "candidate_value": "201", "row_count": "13" }, { "yearid": "2025", "candidate_value": "202", "row_count": "10" }, { "yearid": "2025", "candidate_value": "203", "row_count": "4" }, { "yearid": "2025", "candidate_value": "204", "row_count": "6" }, { "yearid": "2025", "candidate_value": "205", "row_count": "4" }, { "yearid": "2025", "candidate_value": "206", "row_count": "10" }, { "yearid": "2025", "candidate_value": "207", "row_count": "3" }, { "yearid": "2025", "candidate_value": "208", "row_count": "6" }, { "yearid": "2025", "candidate_value": "209", "row_count": "6" }, { "yearid": "2025", "candidate_value": "210", "row_count": "2" }, { "yearid": "2025", "candidate_value": "211", "row_count": "8" }, { "yearid": "2025", "candidate_value": "212", "row_count": "8" }, { "yearid": "2025", "candidate_value": "213", "row_count": "5" }, { "yearid": "2025", "candidate_value": "215", "row_count": "13" }, { "yearid": "2025", "candidate_value": "216", "row_count": "6" }, { "yearid": "2025", "candidate_value": "217", "row_count": "2" }, { "yearid": "2025", "candidate_value": "218", "row_count": "4" }, { "yearid": "2025", "candidate_value": "219", "row_count": "1" }, { "yearid": "2025", "candidate_value": "220", "row_count": "9" }, { "yearid": "2025", "candidate_value": "221", "row_count": "4" }, { "yearid": "2025", "candidate_value": "222", "row_count": "1" }, { "yearid": "2025", "candidate_value": "223", "row_count": "4" }, { "yearid": "2025", "candidate_value": "224", "row_count": "3" }, { "yearid": "2025", "candidate_value": "225", "row_count": "15" }, { "yearid": "2025", "candidate_value": "227", "row_count": "22" }, { "yearid": "2025", "candidate_value": "228", "row_count": "1" }, { "yearid": "2025", "candidate_value": "229", "row_count": "20" }, { "yearid": "2025", "candidate_value": "230", "row_count": "6" }, { "yearid": "2025", "candidate_value": "231", "row_count": "3" }, { "yearid": "2025", "candidate_value": "232", "row_count": "10" }, { "yearid": "2025", "candidate_value": "233", "row_count": "6" }, { "yearid": "2025", "candidate_value": "235", "row_count": "1" }, { "yearid": "2025", "candidate_value": "236", "row_count": "2" } ] }, "error": null }, { "column": "AVG_IP_PER_VISIT", "data_type": "NUMBER", "score": 4, "reasons": [ "name_match" ], "status": "PASS", "elapsed_ms": 5.74, "profile": { "mode": "value", "rows": [ { "yearid": "2025", "candidate_value": "0", "row_count": "542" }, { "yearid": "2025", "candidate_value": "100266", "row_count": "2" }, { "yearid": "2025", "candidate_value": "100480", "row_count": "3" }, { "yearid": "2025", "candidate_value": "100554", "row_count": "1" }, { "yearid": "2025", "candidate_value": "100616", "row_count": "1" }, { "yearid": "2025", "candidate_value": "100681", "row_count": "3" }, { "yearid": "2025", "candidate_value": "10082", "row_count": "1" }, { "yearid": "2025", "candidate_value": "100897", "row_count": "5" }, { "yearid": "2025", "candidate_value": "100915", "row_count": "2" }, { "yearid": "2025", "candidate_value": "100918", "row_count": "2" }, { "yearid": "2025", "candidate_value": "101458", "row_count": "1" }, { "yearid": "2025", "candidate_value": "101647", "row_count": "1" }, { "yearid": "2025", "candidate_value": "101671", "row_count": "1" }, { "yearid": "2025", "candidate_value": "101809", "row_count": "1" }, { "yearid": "2025", "candidate_value": "101866", "row_count": "2" }, { "yearid": "2025", "candidate_value": "102183", "row_count": "2" }, { "yearid": "2025", "candidate_value": "102432", "row_count": "1" }, { "yearid": "2025", "candidate_value": "102531", "row_count": "3" }, { "yearid": "2025", "candidate_value": "102612", "row_count": "1" }, { "yearid": "2025", "candidate_value": "103070", "row_count": "3" }, { "yearid": "2025", "candidate_value": "103408", "row_count": "2" }, { "yearid": "2025", "candidate_value": "10382", "row_count": "1" }, { "yearid": "2025", "candidate_value": "10399", "row_count": "1" }, { "yearid": "2025", "candidate_value": "104175", "row_count": "3" }, { "yearid": "2025", "candidate_value": "104427", "row_count": "1" }, { "yearid": "2025", "candidate_value": "10455", "row_count": "1" }, { "yearid": "2025", "candidate_value": "10491", "row_count": "1" }, { "yearid": "2025", "candidate_value": "10535", "row_count": "1" }, { "yearid": "2025", "candidate_value": "105406", "row_count": "2" }, { "yearid": "2025", "candidate_value": "10560", "row_count": "1" }, { "yearid": "2025", "candidate_value": "105638", "row_count": "3" }, { "yearid": "2025", "candidate_value": "105717", "row_count": "1" }, { "yearid": "2025", "candidate_value": "105938", "row_count": "1" }, { "yearid": "2025", "candidate_value": "10610", "row_count": "1" }, { "yearid": "2025", "candidate_value": "106400", "row_count": "2" }, { "yearid": "2025", "candidate_value": "106464", "row_count": "1" }, { "yearid": "2025", "candidate_value": "106534", "row_count": "1" }, { "yearid": "2025", "candidate_value": "106705", "row_count": "2" }, { "yearid": "2025", "candidate_value": "10694", "row_count": "1" }, { "yearid": "2025", "candidate_value": "107368", "row_count": "2" }, { "yearid": "2025", "candidate_value": "10788", "row_count": "1" }, { "yearid": "2025", "candidate_value": "108089", "row_count": "2" }, { "yearid": "2025", "candidate_value": "108537", "row_count": "1" }, { "yearid": "2025", "candidate_value": "109052", "row_count": "1" }, { "yearid": "2025", "candidate_value": "10963", "row_count": "1" }, { "yearid": "2025", "candidate_value": "10972", "row_count": "1" }, { "yearid": "2025", "candidate_value": "109964", "row_count": "2" }, { "yearid": "2025", "candidate_value": "11008", "row_count": "1" }, { "yearid": "2025", "candidate_value": "110122", "row_count": "1" }, { "yearid": "2025", "candidate_value": "110126", "row_count": "1" }, { "yearid": "2025", "candidate_value": "1102", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11020", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11023", "row_count": "1" }, { "yearid": "2025", "candidate_value": "1103", "row_count": "1" }, { "yearid": "2025", "candidate_value": "110537", "row_count": "2" }, { "yearid": "2025", "candidate_value": "110902", "row_count": "7" }, { "yearid": "2025", "candidate_value": "110928", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11110", "row_count": "1" }, { "yearid": "2025", "candidate_value": "111511", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11193", "row_count": "1" }, { "yearid": "2025", "candidate_value": "111996", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11210", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11214", "row_count": "1" }, { "yearid": "2025", "candidate_value": "112335", "row_count": "1" }, { "yearid": "2025", "candidate_value": "112705", "row_count": "6" }, { "yearid": "2025", "candidate_value": "11284", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11323", "row_count": "2" }, { "yearid": "2025", "candidate_value": "11340", "row_count": "1" }, { "yearid": "2025", "candidate_value": "113652", "row_count": "1" }, { "yearid": "2025", "candidate_value": "114024", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11428", "row_count": "1" }, { "yearid": "2025", "candidate_value": "114671", "row_count": "3" }, { "yearid": "2025", "candidate_value": "114925", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11496", "row_count": "1" }, { "yearid": "2025", "candidate_value": "114984", "row_count": "1" }, { "yearid": "2025", "candidate_value": "115051", "row_count": "2" }, { "yearid": "2025", "candidate_value": "1151649", "row_count": "1" }, { "yearid": "2025", "candidate_value": "115165", "row_count": "2" }, { "yearid": "2025", "candidate_value": "115525", "row_count": "1" }, { "yearid": "2025", "candidate_value": "115569", "row_count": "3" }, { "yearid": "2025", "candidate_value": "115596", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11567", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11571", "row_count": "1" }, { "yearid": "2025", "candidate_value": "115891", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11610", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11653", "row_count": "1" }, { "yearid": "2025", "candidate_value": "1166", "row_count": "2" }, { "yearid": "2025", "candidate_value": "116626", "row_count": "1" }, { "yearid": "2025", "candidate_value": "117079", "row_count": "2" }, { "yearid": "2025", "candidate_value": "117300", "row_count": "1" }, { "yearid": "2025", "candidate_value": "117552", "row_count": "2" }, { "yearid": "2025", "candidate_value": "11901", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11905", "row_count": "1" }, { "yearid": "2025", "candidate_value": "11951", "row_count": "1" }, { "yearid": "2025", "candidate_value": "12007", "row_count": "1" }, { "yearid": "2025", "candidate_value": "12016", "row_count": "1" }, { "yearid": "2025", "candidate_value": "120654", "row_count": "1" }, { "yearid": "2025", "candidate_value": "120762", "row_count": "2" }, { "yearid": "2025", "candidate_value": "120844", "row_count": "2" }, { "yearid": "2025", "candidate_value": "12189", "row_count": "1" } ] }, "error": null } ] }