====== pears.PersonUnavailabilityAlert ======
<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"."PersonUnavailabilityAlert"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  in "pid" char(20),in "PorT" char(1),in "dfrom" date,in "dto" date ) 
returns char(200)
begin
  declare "ua" char(100);
  declare "al" char(100);
  select "personunavailability"("pid","port","dfrom","dto") into "ua";
  select "trim"("isnull"("alert",'')) into "al" from "person" where "personid" = "pid";
  if "ua" <> '' and "al" <> '' then
    set "ua" = "ua"+' / '
  end if;
  return("ua"+"al")
end
</code>