database:functions:pears_pshealthcansendshift



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