====== pears.PopulateComplianceTable ======
<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"."PopulateComplianceTable"( in "persid" char(20),in "oldstatus" char(1),in "newstatus" char(1),in "datetocheck" date,in "vacid" char(20),in "shiftplanid" char(20),in "deptid" char(2) ) 
returns char(20)
begin
  -- returns a instance id for later use
  -- will need to allow for null inputs
  -- this could look at document packs as well
  return 1
end
</code>