FEDSM
Flag events with missing start date/time
The starting date/time for a fishing event can be missing. This check flags those records but no attempt is made to impute the date/time.
-- © Copyright 2026 The Kahawai Collective
-- SPDX-License-Identifier: MIT
INSERT INTO grooming_rules
VALUES ('FESDM', 'edw', 'effort', 'Flag', 'Flag events with missing start date/time');
CREATE OR REPLACE FUNCTION FESDM()
RETURNS VOID AS $$
UPDATE groomed.effort SET checks = checks || '{FESDM}'
WHERE start_datetime IS NULL;
$$ LANGUAGE SQL;
SELECT FESDM();