pears.AccordPayrollCode

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