====== pears.TempShiftConfirmationAllowed ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create function "pears"."TempShiftConfirmationAllowed"( in "shiftid" char(20),in "TempOrClient" char(1),in "NewVal" smallint ) 
returns long varchar
begin
  declare "rv" long varchar;
  if "NewVal" = 1 then
    set "rv" = '';
    -- Return nothing if allowed
    -- TempOrClient T - Temp C - Client
    -- NewVal 1 - Confirm 0 - Unconfirm 
    -- Return is prevalidation style not state change
    return "rv"
  end if
end
</code>