database:functions:pears_populatecompliancetable



pears.PopulateComplianceTable

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

Original 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
  • database/functions/pears_populatecompliancetable.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1