pears.NetPopulateComplianceTable

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

Original SQL

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetPopulateComplianceTable" IS 
{CREATE FUNCTION pears."NetPopulateComplianceTable"(IN personid CHAR(20),IN oldstatus CHAR(1),IN newstatus CHAR(1),IN datetocheck DATE,IN vacancyid CHAR(20),IN tempshiftplanid CHAR(20),IN departmentid CHAR(2))
RETURNS CHAR(20)
BEGIN
  DECLARE @instanceid CHAR(20);
 
  SET @instanceid=uniquekey('1');
 
  -- returns a instance id for later use
  -- will need to allow for null inputs
  -- this could look at document packs as well 
 
  RETURN @instanceid;
END
}