pears.PersonHeadline

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

Original SQL

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."PersonHeadline" IS 
{CREATE FUNCTION PersonHeadline( IN "RecordID" CHAR(20) ) 
RETURNS long VARCHAR
BEGIN
  DECLARE "RV" long VARCHAR;
  DECLARE "RS" long VARCHAR;
  DECLARE "Part" long VARCHAR;
  DECLARE "Shift" long VARCHAR;
  DECLARE "NewLine" CHAR(2);
  DECLARE "FRG" DECIMAL(10,1);
  SET "rv" = '';
  SET "rs" = '';
  SET "Part" = '';
  SET "Shift" = '';
  SELECT FIRST "company"."name" INTO "Part" FROM "employment" KEY JOIN("placement","company") WHERE "employment"."personid" = "recordid" AND "employment"."startdate" <= CURRENT DATE AND "isnull"("employment"."leavedate",CURRENT DATE) >= CURRENT DATE ORDER BY "employment"."startdate" DESC;
  SELECT FIRST "company"."name" INTO "Shift" FROM "TempShift" KEY LEFT OUTER JOIN("vacancy" KEY JOIN "employment" KEY JOIN "company") WHERE "tempshift"."personid" = "recordid" AND "TempShift"."ShiftDate" = CURRENT DATE;
  IF "isnull"("Shift",'') <> '' THEN SET "RV" = "RV"+'Shift today at: '+"Shift"
  ELSE IF "isnull"("Part",'') <> '' THEN SET "RV" = "RV"+'  Currently Placed at: '+"Part"
    END IF END IF;
  RETURN "rv"
END
}