====== pears.NetPopulateComplianceTable ======
<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>
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
}
</code>