pears.EntityGrade

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."EntityGrade" IS 
{CREATE FUNCTION EntityGrade( IN "VacID" CHAR(20),IN "PersID" CHAR(20),IN "PlacID" CHAR(20),IN "ShiftID" CHAR(20) ) 
RETURNS CHAR(4)
BEGIN
  DECLARE "rv" CHAR(4);
  -- Return Null to match all grades. Null grades are always matched, whatever is returned
  -- If Grades set up for minimum wage for Age range the AWR grade needs to be amended to return NULL in AWR Entity Grade function
  SET "rv" = NULL;
  IF "shiftid" IS NOT NULL THEN
    SELECT FIRST "essentialskillgradeid" INTO "rv" FROM "tempshift" WHERE "tempshiftid" = "shiftid"
  END IF;
  RETURN "rv"
END
}