05 — QT-001 Plan DOT (Supertrack E)

New read-only plan path designed; old dot-birth-backfill stays FROZEN.

dot-birth-qt001-plan (source: 04_dot_birth_qt001_plan_SOURCE.sql)

Read-only function fn_dot_birth_qt001_plan(p_collection):

1. assert policy = BIRTH_REQUIRED (via fn_birth_policy_decision)
2. assert identity ELIGIBLE (via fn_birth_resolve_identity preflight)
3. assert PG table exists
4. read exact anti-join delta from live view v_birth_qt001_dryrun_result
5. upsert a birth_backfill_ledger row status=planned, dry_run=true, planned_rows=delta
6. return JSON {src_rows, existing_births, expected_delta, identity, policy}

NEVER writes birth_registry. SOURCE ONLY this macro (not deployed live) — the equivalent plan output is already materialized as the 5 ledger PLAN rows + the dry-run views.

Machine-generatable plan surface

v_birth_qt001_plan_dot_readiness (6/6: register/resolve/policy fns present, ledger present, dryrun surface present, old backfill DOT frozen). v_birth_qt001_collection_plan_surface — per eligible collection: strategy, src_rows, existing_births, planned_new_births, already_covered, duplicate_risk, ledger linkage.

Ledger PLAN rows committed (5)

dot_domain_rules 67 · apr_approvals 42 · normative_relations 18 · apr_action_types 6 · field_type_equivalences 4 (all status=planned, dry_run=true). Apply gate stays fail-closed: no OPEN permit exists.