pears.PersonVacancyShiftMatch2

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

Original SQL

CREATE FUNCTION "pears"."PersonVacancyShiftMatch2"( IN @PersonID CHAR(20),IN @VacancyID CHAR(20) ) 
RETURNS CHAR(50)
BEGIN
  DECLARE "rv" CHAR(50);
  SET "rv" = (SELECT FIRST "sitename" FROM "vacancy" WHERE "vacancyid" = @VacancyID);
  RETURN "rv"
END