pears.GetTimeSheetDescription

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE FUNCTION "pears"."GetTimeSheetDescription"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "usesecags" tinyint,IN "persid" CHAR(20),IN "secagid" CHAR(20),IN "sdescrip" long VARCHAR ) 
RETURNS long VARCHAR
BEGIN
  IF "isnull"("usesecags",0) = 0 OR "persid" IS NULL THEN
    RETURN "isnull"("sdescrip",'')
  END IF;
  IF "secagid" IS NULL THEN
    SELECT FIRST "secondaryagencyid" INTO "secagid" FROM "pay_employee" WHERE "personid" = "persid"
  END IF;
  IF "secagid" IS NOT NULL THEN
    SET "sdescrip" = "string"((SELECT FIRST "name" FROM "company" WHERE "companyid" = "secagid"),' ',"sdescrip")
  END IF;
  RETURN "isnull"("sdescrip",'')
END