pears.ShiftBackColourOverride

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE FUNCTION "pears"."ShiftBackColourOverride"( IN "shiftid" CHAR(20),IN "planid" CHAR(20) ) 
RETURNS INTEGER
BEGIN
  -- return 1 to apply colour
  IF "isnull"("shiftid",'') > '' THEN
    -- shift logic
  END IF;
  IF "isnull"("planid",'') > '' THEN
    -- shiftplan logic
  END IF;
  RETURN 0
END