database:functions:pears_awrentitygrade



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