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