pears.AWREntityGrade

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

Original SQL

CREATE FUNCTION "pears"."AWREntityGrade"( IN "VacID" CHAR(20),IN "PersID" CHAR(20),IN "PlacID" CHAR(20),IN "ShiftID" CHAR(20) ) 
RETURNS CHAR(4)
BEGIN
  DECLARE "rv" CHAR(4);
  -- Grade for AWR purposes, not stored with shift or timesheet line
  SET "rv" = "EntityGrade"("VacID","PersID","PlacID","ShiftID");
  RETURN "rv"
END