pears.GetNotifyBehaviour

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

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
  • database/functions/pears_getnotifybehaviour.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1