====== pears.ShiftColourOverride ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create function "pears"."ShiftColourOverride"( 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
</code>