KB-6554

Topic Promotion Governed Activation — 03 entity_labels/taxonomy Reconcile (2026-06-03)

3 min read Revision 1
one-roof-governancenonprod-clonereconcileentity-labelstaxonomy2026-06-03

03 — Objective B: entity_labels / taxonomy Reconcile — PASS

Artifact: sql/B_reconcile.sql (committed: topic_taxonomy_map + 6 views).

Live label surfaces (clone)

entity_labels 803,955 (per-entity projection); taxonomy 58 (57 active, vocabulary); taxonomy_facets 10; label_rules 38 (collection→label driver, rule_type=collection); iu_metadata_tag 536. Key fact: entity_labels.label_code = taxonomy.code; all 23 distinct in-use labels are taxonomy-backed & active (0 vocabulary orphans).

Source-of-truth boundary (defined)

  1. AXIS/GRAPH TRUTH = axis_assignment + axis_object_ownership (governed collection→topic with owner). 2. LABEL RULES = label_rules (collection→LBL driver). 3. LABEL PROJECTION = entity_labels (~804k). 4. VOCABULARY = taxonomy. 5. UI PROJECTION = v_ui_/v_reconcile_ views. Both label_rules and the topic axis classify at collection grain — the natural reconcile join.

Mapping table topic_taxonomy_map

6 crosswalk rows seeded (ai-ops→LBL-006/061, workflow→LBL-004, registry-kg→LBL-101, observability→LBL-014, data-platform→LBL-002). governance & workflow-exec left unmapped (signal source).

Reconcile views — live results

  • v_reconcile_label_orphan = 0 (clean).
  • v_reconcile_topic_without_label = 2 (governance, workflow-exec).
  • v_reconcile_label_without_topic = 48 (labels not yet under topic governance).
  • v_reconcile_collection_topic_vs_label = 4 divergent + 1 no_label_rule.
  • v_reconcile_topic_projection_gap = 1 (governance_registry: owned topic registry-kg, no label_rule).
  • v_reconcile_summary = single-row roll-up.

Interpretation

0 label orphans → projection internally consistent. divergent(4): e.g. agents governed as ai-ops (LBL-006/061) but label_rules emit LBL-104 — a governance decision point, not necessarily an error. projection gap(1): governance_registry governance is ahead of label projection — the canonical "axis truth leads projection" condition.

Verdict

PASS. Reconcile substrate committed; boundary defined; real divergence & projection-gap signal surfaced from live data.

Back to Knowledge Hub knowledge/dev/reports/architecture/one-roof-nonprod-clone-topic-promotion-governed-activation-2026-06-02/03-entity-labels-taxonomy-reconcile.md