drizzle/0005_mature_the_professor.sql

Linked repository file from this build.

CREATE TABLE "snap_policy_tables" (
	"id" text PRIMARY KEY NOT NULL,
	"effective_from" text NOT NULL,
	"policy" jsonb NOT NULL,
	"published_by" text NOT NULL,
	"published_at" timestamp with time zone NOT NULL,
	CONSTRAINT "snap_policy_tables_effective_from_unique" UNIQUE("effective_from")
);

--> statement-breakpoint
-- Approval alone no longer grants reporting access. Rebuild on demand or with the backfill script.
UPDATE "review_index" SET "report" = NULL;

--> statement-breakpoint
INSERT INTO "snap_policy_tables" ("id", "effective_from", "policy", "published_by", "published_at") VALUES ('snap-negative-ffy2026-v1', '2025-10', '{"id":"snap-negative-ffy2026-v1","effectiveFrom":"2025-10","source":"FS Negative Template Workbook.xlsm: AD65:AE84, V65:AA84, AB17:AC21, T89, W11, B55","verification":"Workbook values transcribed; operational policy remains unverified.","grossLimits":[2610,3526,4442,5360,6276,7192,8110,9026,9944,10862,11780,12698,13616,14534,15452,16370,17288,18206,19124,20042],"netLimits":[1305,1763,2221,2680,3138,3596,4055,4513,4972,5434,5893,6352,6811,7270,7729,8188,8647,9106,9565,10024],"standardDeductions":[209,209,209,223,261,299,299,299,299,299,299,299,299,299,299,299,299,299,299,299],"allotments":[298,546,785,994,1183,1421,1571,1789,2007,2225,2443,2661,2879,3097,3315,3533,3751,3969,4187,4405],"sua":{"heating":857,"non_heating":488,"limited":128,"telephone":107,"none":0},"shelterCap":744,"minimumBenefit":24,"homelessDeduction":199,"earnedDeductionPercent":20,"shelterDeductionPercent":50,"farmExpenseAllowancePercent":100,"nonFarmExpenseAllowancePercent":100,"errorThreshold":58,"memoResponseDays":null}'::jsonb, 'workbook-seed', '2026-09-13T00:00:00Z');