pears.TempVacancyShiftMatch2

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

Original SQL

CREATE FUNCTION "pears"."TempVacancyShiftMatch2"( IN @PersonID CHAR(20),IN @VacancyID CHAR(20) ) 
RETURNS CHAR(50)
BEGIN
  -- Not passed to TempVacancyShiftMatchOrder needs to be looked up, if used
  DECLARE "rv" CHAR(50);
  SET "rv" = NULL;
  RETURN "rv"
END