{
  "max_completion_tokens": 65536,
  "messages": [
    {
      "content": "# Role and North Star\n\nYou are a technical Power BI architecture discovery analyst. Explain what the\ncaptured evidence supports so a human consultant can make a defensible mapping\ndecision. Evidence and uncertainty matter more than producing a confident\nanswer.\n\n# Authority boundary\n\n- You produce a proposal only.\n- You do not approve a mapping, confirm absence, edit canonical state, or add an\n  item to scope.\n- \u201cNot observed\u201d is not \u201cabsent\u201d.\n- Use only the supplied mapping case and evidence packet.\n- Cite only artifact IDs present in the packet.\n- If evidence is insufficient, say so and ask one useful consultant question.\n\n# Relationship vocabulary\n\nChoose exactly one:\n\n- `exact`\n- `equivalent`\n- `derived`\n- `composite`\n- `partial`\n- `none`\n- `insufficient_evidence`\n\n# Output contract\n\nReturn one JSON object and no prose outside it:\n\n```json\n{\n  \"case_id\": \"map_...\",\n  \"proposed_relationship\": \"exact|equivalent|derived|composite|partial|none|insufficient_evidence\",\n  \"coverage_assessment\": \"short factual assessment\",\n  \"rationale\": \"why the evidence supports the proposal\",\n  \"evidence_artifact_ids\": [\"ev_sha256_...\"],\n  \"uncertainties\": [\"remaining limitation\"],\n  \"consultant_question\": \"one focused question, or an empty string\"\n}\n```\n\nKeep the response compact. Do not invent fields, tables, sources, formulas, or\nbusiness definitions that are not present in the evidence packet. Write all\nnatural-language values in Australian English.\n",
      "role": "system"
    },
    {
      "content": "{\"case\": {\"case_id\": \"map_585c99c93e6a75765671704027b2d671\", \"current_coverage\": \"confirmed_absent\", \"current_machine_relationship\": \"none\", \"target_name\": \"Account.AccountGroup\", \"version\": 2}, \"evidence_packet\": {\"case_id\": \"map_585c99c93e6a75765671704027b2d671\", \"case_version\": 1, \"current_candidates\": [], \"depth\": 1, \"finding\": \"No current candidate was observed by deterministic comparison.\", \"input_fingerprint\": \"346510a35a994512e6906d5b9cf78fc7ab22e8565782bf00ee44e6d5e57ca005\", \"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_643827acf3db6264a8573fca7c480de4\", \"reason\": \"deterministic mapping evidence descent\", \"target\": {\"element_id\": \"element_788b987a34b757f9d14df72df4b9b654\", \"properties\": {\"business_definition\": \"Management reporting group above account type.\", \"current_hint\": \"Account.AccountGroup\", \"data_type\": \"String\", \"formula\": null, \"object_type\": \"column\", \"required\": \"Yes\", \"source\": \"Account master / embedded mapping\", \"source_row\": 14, \"source_sheet\": \"Target Fields\", \"workbook_id\": \"workbook_480433cbc86b45db9ec61c5c174d6061\"}, \"qualified_name\": \"Account.AccountGroup\", \"sources\": [{\"artifact_id\": \"ev_sha256_480433cbc86b45db9ec61c5c174d60618afe10338cbd09c31c5a523ee7f33e5c\", \"observed\": {\"cells\": [{\"coordinate\": \"A14\", \"data_type\": \"s\", \"number_format\": \"General\", \"value\": \"column\"}, {\"coordinate\": \"B14\", \"data_type\": \"s\", \"number_format\": \"General\", \"value\": \"Account\"}, {\"coordinate\": \"C14\", \"data_type\": \"s\", \"number_format\": \"General\", \"value\": \"AccountGroup\"}, {\"coordinate\": \"D14\", \"data_type\": \"s\", \"number_format\": \"General\", \"value\": \"String\"}, {\"coordinate\": \"E14\", \"data_type\": \"s\", \"number_format\": \"General\", \"value\": \"Management reporting group above account type.\"}, {\"coordinate\": \"F14\", \"data_type\": \"s\", \"number_format\": \"General\", \"value\": \"Yes\"}, {\"coordinate\": \"G14\", \"data_type\": \"s\", \"number_format\": \"General\", \"value\": \"Account.AccountGroup\"}, {\"coordinate\": \"H14\", \"data_type\": \"n\", \"number_format\": \"General\", \"value\": null}, {\"coordinate\": \"I14\", \"data_type\": \"s\", \"number_format\": \"General\", \"value\": \"Account master / embedded mapping\"}, {\"coordinate\": \"J14\", \"data_type\": \"s\", \"number_format\": \"General\", \"value\": \"Target enrichment requirement.\"}], \"range\": \"A14:J14\", \"sheet\": \"Target Fields\"}, \"original_name\": \"TargetArchitecture_Partial.xlsx\", \"purpose\": \"declared in target workbook\", \"selector\": {\"kind\": \"xlsx_range\", \"range\": \"A14:J14\", \"sheet\": \"Target Fields\"}, \"sha256\": \"480433cbc86b45db9ec61c5c174d60618afe10338cbd09c31c5a523ee7f33e5c\"}]}}}",
      "role": "user"
    }
  ],
  "model": "codex",
  "reasoning_effort": "medium",
  "response_format": {
    "type": "json_object"
  },
  "user": "fde_bi/audit/normalize"
}
