====== pears.AccordPayrollCode ======
<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"."AccordPayrollCode"( in "PersID" char(20) ) 
returns varchar(6)
begin
  -- Payroll codes must exist in Accord.
  declare "rv" varchar(6);
  declare "payfreq" integer;
  select "payfrequency" into "payfreq" from "pay_employee" where "personid" = "PersID";
  if "payfreq" = 12 then set "rv" = 'MONTH'
  else set "rv" = 'WEEKLY'
  end if;
  return "rv"
end
</code>