====== pears.ValidatePayroll ======
<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"."ValidatePayroll"( in "recordid" varchar(20),in @BankName varchar(30),in @BankAddr1 varchar(30),in @BankAddr2 varchar(30),in @BankSortCode varchar(8),in @BankAcName varchar(50),in @BankAcNo varchar(15),in @BankRef varchar(20),in @PayMethod tinyint,in @PayFrequency tinyint,in @TaxMethod tinyint,in @CompanyName varchar(50),in @RegNo varchar(20),in @VATRegistered tinyint,in @VATNumber varchar(20),in @TaxCode varchar(5),in @NILetter varchar(1),in @UniqueTaxReference varchar(20),in @Payrollnumber varchar(15),in @HMRCEngagementDetail char(1) ) 
returns long varchar
begin
  declare "RV" long varchar;
  declare "pcount" integer;
  if "isnull"(@payrollnumber,'') <> '' then
    select "count"() into "pcount" from "person" where "personid" <> "recordid" and "isnull"("payrollnumber",'') = @payrollnumber;
    if "pcount" > 0 then
      return('Payroll number already used')
    end if end if;
  return("RV")
end
</code>