GPT Review — B3-F1a Revision Prompt — Approved for Recompile — 2026-05-13

Scope reviewed

Reviewed Opus revision artifacts:

• knowledge/dev/laws/dieu44-trien-khai/prompts/p3d-birth-system-b3f1a-soft-gate-shape-probe-and-sql-artifact-prompt-DRAFT.md
• knowledge/dev/laws/dieu44-trien-khai/reports/p3d-birth-system-b3f1a-compiled-sql-revision-directive-report.md

Related blocking review:

• knowledge/dev/laws/dieu44-trien-khai/reviews/gpt-review-b3f1a-compiled-sql-blocked-revision-required-2026-05-13.md

Verdict

Status: APPROVED_FOR_AGENT_RECOMPILE_WITH_GPT_PATCHES

Opus addressed the critical revision direction. GPT patched several wording/guardrail issues in the prompt before approval. Agent may rerun B3-F1a in read-only/compile-only mode to regenerate the four SQL artifacts and report.

Opus fixes accepted

1. CREATE OR REPLACE forbidden; compiled artifact must use CREATE FUNCTION only.
2. Helper renamed to task-specific fn_b3f1_log_collection_onboarding_gap and must be conflict-checked.
3. Severity is gap-specific; helper accepts severity parameter.
4. Physical/species/trigger checks are scoped to BIRTH_REQUIRED ∩ IN_SCOPE.
5. All 11 checks are required.
6. birth_registry recursive risk is checked before skipping other onboarding checks.
7. Trigger detection uses separate booleans and function OID / tgtype validation.
8. Full-scan query must be regenerated with the same corrected logic.

GPT patches applied to prompt

• Clarified allowed read-only sources include approved PG-native tables needed for compilation, not only catalog/information_schema.
• Required live re-probe of system_health_checks and helper/function/trigger conflicts; do not reuse rev1 probe results blindly.
• Reworded managed policy universe to avoid static governed-role list-as-truth.
• Reworded full-scan scope to scan all collection_registry rows and derive subsets live.
• Added explicit final fields for gate function/helper/trigger conflict status.
• Standardized no_pg_mutation_performed=true and required report path.

Required prompt revision

Use:

• knowledge/dev/laws/dieu44-trien-khai/prompts/p3d-birth-system-b3f1a-soft-gate-shape-probe-and-sql-artifact-prompt-DRAFT.md revision 13 or latest.

Execution constraints

This is a recompile only:

• No DDL.
• No CREATE FUNCTION.
• No CREATE TRIGGER.
• No INSERT/UPDATE/DELETE in PG.
• No system_issues writes.
• No hard gate.
• KB artifact/report upload required.

Required output

Agent must overwrite or upsert these four artifact documents with corrected compiled SQL:

• knowledge/dev/laws/dieu44-trien-khai/artifacts/p3d-birth-system-b3f1a-soft-gate-compiled-function.sql.md
• knowledge/dev/laws/dieu44-trien-khai/artifacts/p3d-birth-system-b3f1a-soft-gate-compiled-trigger.sql.md
• knowledge/dev/laws/dieu44-trien-khai/artifacts/p3d-birth-system-b3f1a-soft-gate-rollback.sql.md
• knowledge/dev/laws/dieu44-trien-khai/artifacts/p3d-birth-system-b3f1a-soft-gate-full-scan-query.sql.md

Agent must write the recompile report:

• knowledge/dev/laws/dieu44-trien-khai/reports/p3d-birth-system-b3f1a-soft-gate-shape-probe-and-sql-artifact-report.md

Governance status

b3f1a_revision_prompt_review_status=APPROVED_FOR_AGENT_RECOMPILE_WITH_GPT_PATCHES
b3f1a_recompile_allowed=true
b3f1b_execution_allowed=false_until_recompiled_sql_review
create_function_allowed=false
create_trigger_allowed=false
pg_mutation_allowed=false
hard_gate_allowed=false
phase5c2_migration_allowed=false
next_recommended_action=AGENT_RECOMPILE_B3F1A_ARTIFACTS_WITH_REV13_OR_LATEST