pears.TempVacancyShiftMatch

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

Original SQL

CREATE FUNCTION "pears"."TempVacancyShiftMatch"( IN @PersonID CHAR(20),IN @VacancyID CHAR(20) ) 
RETURNS DOUBLE
BEGIN
  DECLARE "rv" DOUBLE;
  SET "rv"
     = "DistanceBetweenPostCodes"(
    (SELECT "Person"."PostCode" FROM "Person" WHERE "Person"."PersonID" = @PersonID),
    (SELECT "isnull"("vacancy"."postcode","company"."postcode") FROM "Vacancy" KEY JOIN "Employment" KEY JOIN "Company" WHERE "Vacancy"."VacancyID" = @VacancyID),'Mi');
  IF "rv" < 1 THEN
    RETURN "round"("rv",1)
  ELSE RETURN "round"("rv",0)
  END IF
END