database:functions:pears_personvacancyshiftmatch2



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
  • database/functions/pears_personvacancyshiftmatch2.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1