FASAM
Flag events with missing statistical areas
-- © Copyright 2026 The Kahawai Collective
-- SPDX-License-Identifier: MIT
INSERT INTO grooming_rules
VALUES ('FESAM', 'edw', 'effort', 'Flag', 'Flag events with missing statistical areas');
CREATE OR REPLACE FUNCTION FESAM()
RETURNS VOID AS $$
UPDATE groomed.effort SET checks = checks || '{FESAM}'
WHERE start_stats_area_code IS NULL;
$$ LANGUAGE SQL;
SELECT FESAM();