pears.GetTempName [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.GetTempName ======
<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"."GetTempName"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  in "persid" char(20) ) 
returns char(60)
begin
  declare "rv" char(60);
  select "string"(if exists(select * from "wpkglobalswitchsetting" where "wpkglobalswitchid" = 'USEFULLNAME' and "location" = 'Global' and "value" = 'Y') then "person"."name"
    else "ifnull"("person"."surname","person"."name","string"("person"."surname",', ',"firstword"("person"."forenames")))
    endif,(select "string"(' (',"name",')') from "company" where "companyid" = (select "secondaryagencyid" from "pay_employee" where "personid" = "persid")))
    into "rv" from "person" where "personid" = "persid";
  return "rv"
end
</code>