{
  "case_id": "map_f1570aedc6a190ba42fe5078eff14b57",
  "case_version": 1,
  "current_candidates": [
    {
      "candidate_id": "candidate_02cb0ac49943a2e4d6d6d2d5216af10b",
      "nomination_method": "qualified_name",
      "properties": {
        "description": "Deterministic fixture variance. Expected 2000.00.",
        "formatString": "$#,0.00;($#,0.00)",
        "name": "Net Variance",
        "tableName": "Metrics"
      },
      "proposed_relationship": "exact",
      "qualified_name": "Metrics.Net Variance",
      "score": 1.0,
      "sources": [
        {
          "artifact_id": "ev_sha256_a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e",
          "observed": {
            "description": "Deterministic fixture variance. Expected 2000.00.",
            "formatString": "$#,0.00;($#,0.00)",
            "name": "Net Variance"
          },
          "original_name": "python-powerbi-discovery.json",
          "purpose": "observed by deterministic MCP audit",
          "selector": {
            "kind": "json_pointer",
            "pointer": "/inventory/measures/data/0/measures/3"
          },
          "sha256": "a11f31dfefa7810703c3ae3ff271a0b73fcebc2086787da89d17b58544c43d6e"
        }
      ]
    }
  ],
  "depth": 1,
  "finding": "Current candidates and their primary audit evidence are attached for consultant review.",
  "input_fingerprint": "ee51428c0049199f47c54f24117442f27dca96b2617f9a79a93cde9ce2335df6",
  "limitations": [
    "This packet descends only into already captured evidence.",
    "No candidate observed does not prove that the field is absent outside the audited access boundary."
  ],
  "packet_id": "evidence_packet_48b1b3d76f089a344ec88762f780ebe2",
  "reason": "deterministic mapping evidence descent",
  "target": {
    "element_id": "element_bc19f856983aded6fb0cc2aaef0ce5d9",
    "properties": {
      "business_definition": "Actual net less budget net.",
      "current_hint": "Metrics.Net Variance",
      "data_type": "Decimal",
      "formula": "[Actual Net] - [Budget Net]",
      "object_type": "measure",
      "required": "Yes",
      "source": "Existing Power BI semantic model",
      "source_row": 15,
      "source_sheet": "Target Fields",
      "workbook_id": "workbook_55d53340ad188bf8b20b867f577f5654"
    },
    "qualified_name": "Metrics.Net Variance",
    "sources": [
      {
        "artifact_id": "ev_sha256_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95",
        "observed": {
          "cells": [
            {
              "coordinate": "A15",
              "data_type": "s",
              "number_format": "General",
              "value": "measure"
            },
            {
              "coordinate": "B15",
              "data_type": "s",
              "number_format": "General",
              "value": "Metrics"
            },
            {
              "coordinate": "C15",
              "data_type": "s",
              "number_format": "General",
              "value": "Net Variance"
            },
            {
              "coordinate": "D15",
              "data_type": "s",
              "number_format": "General",
              "value": "Decimal"
            },
            {
              "coordinate": "E15",
              "data_type": "s",
              "number_format": "General",
              "value": "Actual net less budget net."
            },
            {
              "coordinate": "F15",
              "data_type": "s",
              "number_format": "General",
              "value": "Yes"
            },
            {
              "coordinate": "G15",
              "data_type": "s",
              "number_format": "General",
              "value": "Metrics.Net Variance"
            },
            {
              "coordinate": "H15",
              "data_type": "s",
              "number_format": "General",
              "value": "[Actual Net] - [Budget Net]"
            },
            {
              "coordinate": "I15",
              "data_type": "s",
              "number_format": "General",
              "value": "Existing Power BI semantic model"
            },
            {
              "coordinate": "J15",
              "data_type": "inlineStr",
              "number_format": "General",
              "value": null
            }
          ],
          "range": "A15:J15",
          "sheet": "Target Fields"
        },
        "original_name": "TargetArchitecture_Match.xlsx",
        "purpose": "declared in target workbook",
        "selector": {
          "kind": "xlsx_range",
          "range": "A15:J15",
          "sheet": "Target Fields"
        },
        "sha256": "55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95"
      }
    ]
  }
}