KB-2C81

P3D Pack 1 Phase 5C2B — Authority Vocab Seed — Design & Prompt Report

4 min read Revision 1
p3dpack1phase5c2breportdesignprompt-draft

P3D Pack 1 Phase 5C2B — Authority Vocab Seed — Design & Prompt Report

Date: 2026-05-12 Author: Opus (Claude) Mode: DESIGN + PROMPT DRAFT ONLY — no execution


Artifacts created

Artifact Path
Design note knowledge/dev/laws/dieu44-trien-khai/design/p3d-pack1-phase5c2b-publication-authority-vocab-seed-design.md
Prompt DRAFT knowledge/dev/laws/dieu44-trien-khai/prompts/p3d-pack1-phase5c2b-publication-authority-vocab-seed-prompt-DRAFT.md
This report knowledge/dev/laws/dieu44-trien-khai/reports/p3d-pack1-phase5c2b-authority-vocab-seed-design-and-prompt-report.md

Top 5 decisions

  1. Scope = exactly 1 INSERT into dot_config. No TAC, no IU, no DDL, no function patch. Smallest possible mutation to unblock 5C2.

  2. 7-phase execution with 4 STOP gates. Schema introspection → column resolution → pre-insert check → advisory lock → seed transaction (with in-transaction re-check for race protection) → post-insert verify → vocab landscape.

  3. Advisory lock using hashtext(). Pack-scope key string p3d_pack1_phase5c2b_publication_authority_vocab_seed → deterministic lock ID. Non-blocking (pg_try_advisory_lock): if lock unavailable → STOP, don't retry.

  4. Idempotent handling. If row already exists (Phase 2 or in-transaction re-check) → skip INSERT, proceed to verify, report ALREADY_EXISTS. Not an error — allows safe re-run.

  5. Rollback = exact-key DELETE. DELETE FROM dot_config WHERE key = 'vocab.publication_authority.incomex_council'. No LIKE, no wildcard. No cascade risk (no FK points to this row).


Design review notes

  • §A–C follow directly from probe evidence and GPT decision — no interpretation added.
  • §D (why not owner): heterogeneous values confirmed by probe (S178-FIX23 / incomex_council / INCOMEX). Using owner would embed operator tags into identity_profile.
  • §E (why not patch fn_iu_create): scope discipline. Pilot migration will set publication_authority_ref via direct JSON construction in the same transaction. fn_iu_create extension deferred to post-pilot.
  • §F–H: standard vocab seed pattern consistent with existing vocab.publication_type.* entries.
  • §I: chain is clear — 5C2B seeds vocab → 5C2 reads vocab → 5C2 sets identity_profile → birth gate validates.

Prompt review notes

  • Column resolution enforced: concepts config_key, config_value, config_description, config_updated_at resolved from Phase 0 introspection before use. Consistent with rev2 probe discipline.
  • In-transaction re-check (Phase 4) protects against race condition between Phase 2 check and INSERT.
  • Post-insert verify (Phase 5) checks all 4 fields including updated_at recency.
  • Phase 7 (vocab landscape) is informational — confirms the seed sits correctly alongside existing publication_type vocab.
  • Hard boundaries listed explicitly: 7 categories of prohibited mutation.

Status

phase5c2b_status=PASS
mode=DESIGN_AND_PROMPT_DRAFT_ONLY
authority_strategy_locked=Option_C_incomex_council
design_created=true
prompt_created=true
agent_dispatch_allowed=false
seed_allowed=false_until_GPT_FINAL_REVIEW_AND_USER_GO
migration_allowed=false
fn_iu_create_patch_now=false
next_action=GPT_REVIEW_DESIGN_AND_PROMPT_DRAFT

Phase 5C2B Report | Design + Prompt DRAFT | 2026-05-12

Back to Knowledge Hub knowledge/dev/laws/dieu44-trien-khai/reports/p3d-pack1-phase5c2b-authority-vocab-seed-design-and-prompt-report.md