pears.NetPopulateComplianceTable

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