pears.GetNotifyBehaviour

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

Original SQL

CREATE FUNCTION "pears"."GetNotifyBehaviour"( IN "persid" CHAR(20),IN "vacid" CHAR(20),IN "ClientOrTemp" CHAR(1) ) 
RETURNS CHAR(10)
BEGIN
  DECLARE "RVal" CHAR(10);
  -- return values set of E - email P - print S - SMS
  -- blank/null do nothing
  -- ClientOrTemp C - client T - temp
  RETURN "RVal"
END