====== 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>
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>