pears.psHealthCanSendShift

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

Original SQL

CREATE FUNCTION "pears"."psHealthCanSendShift"( 
  IN "ShiftID" CHAR(20),IN "ShiftPlanID" CHAR(20) ) 
RETURNS SMALLINT
BEGIN
  -- check divisions etc
  -- 1 to send, anything else won't
  -- plan possible future use
  IF "ShiftID" IS NOT NULL THEN RETURN 1
  END IF
END