monroe_mcesearch_legacy_plus_oracle_reports

{
  "firm_count": 1,
  "scope_layer": "county_permitting_authority",
  "source_type": "legacy_datatables_plus_oracle_pdf_reports",
  "identity_count": 237461,
  "proof_artifact": "artifacts/source-probes/monroe-mcesearch/2026-06-05/monroe_mcesearch_legacy_plus_oracle_reports/source-probe-summary.json",
  "authority_level": "county",
  "high_confidence": "1",
  "import_run_count": 0,
  "source_run_count": 2,
  "business_priority": "medium_high",
  "last_sync_seen_at": "2026-06-05T21:30:31Z",
  "running_run_count": 0,
  "jurisdiction_scope": "Monroe County legacy MCeSearch permits (dense 1985-2022, sparse tail through 2026) plus current Oracle Public Sector permit reports from 2022-10-01 forward; Florida Keys municipalities (Key West, Marathon, Islamorada, Key Colony Beach, Layton) run separate AHJs and are out of scope; Monroe County current Oracle Public Sector online-permit report (report-derived status; no work date/value in source)",
  "blockers_or_caveats": "Legacy and current systems are split. Legacy API rows do not expose contractor, license, or value fields. Current Oracle report/PDF evidence is partial. Fresh contractor API drill-down proves a separate registry with state_reg and cty_reg values, but the permit-to-contractor linkage remains indirect.",
  "field_parity_status": "pass_legacy_permit_core_current_reports_partial_no_contractor",
  "reported_rows_found": 237467,
  "first_sync_started_at": "2026-06-05T21:30:31Z",
  "proven_date_span_days": 15128,
  "proven_last_work_date": "2026-06-03",
  "continuous_sync_status": "pass_legacy_datatables_adaptive_date_windows_current_oracle_reports_partial",
  "contractor_join_status": "state_registration_number_present_in_registry",
  "field_coverage_summary": "{\"continuous_sync_status\": \"pass_legacy_datatables_adaptive_date_windows_current_oracle_reports_partial\", \"dbpr_join_key_status\": \"state_registration_number_present_in_registry\", \"field_parity_status\": \"pass_legacy_permit_core_current_reports_partial_no_contractor\", \"historical_backfill_status\": \"pass_live_legacy_api_imported_1985-01-01_to_2022-09-30_plus_current_oracle_reports\", \"job_value_present\": false, \"legacy_records_total\": 224685, \"legacy_roof_type_rows\": 20736, \"list_backfill_real_date_floor\": \"1985-01-01\", \"observed_first_work_date\": \"1985-01-01\", \"observed_last_work_date\": \"2026-06-03\", \"remaining_blockers\": [\"Legacy MCeSearch and current Oracle permit rows expose no contractor name or license; every permit is retained as an unattributed work event under one sentinel firm. DBPR/Sunbiz license joins require a separate contractor source.\", \"Current Oracle Public Sector tier is published only as PDF/text 'permits by parcel' reports; parsed rows carry permit type, description, parcel, and address but no per-record application date or project value, and status is the report bucket (Completed/Expired).\", \"No project value field is exposed by either tier, so Monroe cannot yet contribute to value-ranked analytics.\", \"Legacy MCeSearch is frozen at 2022-09-30; permits issued from 2022-10-01 forward live only in the weaker Oracle report tier until a structured current API is onboarded.\"], \"rows_returned_across_sampled_queries\": 80, \"sample_status\": \"live_legacy_mcesearch_datatables_pass_current_oracle_reports_partial\", \"source_rows\": 237467}",
  "proven_first_work_date": "1985-01-01",
  "observed_date_span_days": 15128,
  "observed_last_work_date": "2026-06-03",
  "proven_source_row_count": 237467,
  "observed_first_work_date": "1985-01-01",
  "historical_backfill_status": "pass_live_legacy_api_imported_1985-01-01_to_2022-09-30_plus_current_oracle_reports",
  "reported_identities_upserted": 237467,
  "reported_work_events_upserted": 237467
}