pears.ConsultantChangeAllowed

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

Original SQL

CREATE FUNCTION "pears"."ConsultantChangeAllowed"( 
  IN "recordtype" CHAR(1),IN "recordid" CHAR(20),IN "oldstaff" CHAR(20),IN "newstaff" CHAR(20) ) 
RETURNS long VARCHAR
-- If change is disallowed consultant change is blocked
-- C - company, P - person, V - Vacancy, P - Placement, R - Progress
BEGIN
  DECLARE "rv" long VARCHAR;
  SET "rv" = '';
  RETURN("rv")
END