pears.GenerateContactEventWithEmailLog [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.GenerateContactEventWithEmailLog ======
<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 procedure "pears"."GenerateContactEventWithEmailLog"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  in "pcontacteventid" char(20),
  in "pstaffid" char(20),in "pcontactdate" date,in "pclasscode" char(2),in "ppersonid" char(20) default null,
  in "pvacancyid" char(20) default null,in "pemploymentid" char(20) default null,in "pprogressid" char(20) default null,
  in "pplacementid" char(20) default null,in "pcontacttime" time default null,
  in "pdescription" char(100) default null,in "poutcome" char(50) default null,in "pwho" char(1) default null,
  in "pnotes" long varchar default null,in "plettertext" long varchar default null,in "pfollowup" smallint default 0,
  in "pwpdoc" char(10) default null,in "pcallbackdate" date default null,in "pWhenEntered" timestamp default current timestamp,
  in "pWhoEntered" char(20) default null,in "pcallbacktime" time default null,
  in "ppriority" smallint default 5,in "pSynetyGUID" char(100) default null,
  in "pspeciality" char(50) default null,in "pforenames" char(30) default null,in "psurname" char(30) default null,
  in "pDirection" char(3) default 'OUT',in "pMethod" char(10) default 'EMAIL',in "pWhenSent" timestamp default current timestamp,
  in "pRecipients" long varchar default null,in "pAttachments" long varchar default null,in "pdivisionid" char(20) default null ) 
begin
  insert into "contactevent"( "contacteventid","personid","staffid","vacancyid","employmentid","progressid","placementid","contactdate","contacttime",
    "description","outcome","classcode","who","notes","lettertext","followup","wpdoc","callbackdate","divisionid","WhenEntered","WhoEntered",
    "callbacktime","priority","SynetyGUID","speciality","forenames","surname" ) values
    ( "pcontacteventid","ppersonid","pstaffid","pvacancyid","pemploymentid","pprogressid","pplacementid","pcontactdate","pcontacttime",
    "pdescription","poutcome","pclasscode","pwho","pnotes","plettertext","pfollowup","pwpdoc","pcallbackdate","pdivisionid","pWhenEntered","pWhoEntered",
    "pcallbacktime","ppriority","pSynetyGUID","pspeciality","pforenames","psurname" ) ;
  call "GenerateContactEventEmailLog"("pContactEventid","pWhenSent","pRecipients","pAttachments","pDirection","pMethod")
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."GenerateContactEventWithEmailLog" IS 
{create procedure GenerateContactEventWithEmailLog 

/* Application Maintained Function / Procedure - DO NOT EDIT*/

 (in "pcontacteventid" CHAR(20) ,
   in"pstaffid" CHAR(20) ,in"pcontactdate" DATE , in"pclasscode" CHAR(2), in"ppersonid" CHAR(20) Default NULL, 
   in"pvacancyid" CHAR(20) Default NULL, in"pemploymentid" CHAR(20)  Default NULL, in"pprogressid" CHAR(20) Default NULL, 
   in"pplacementid" CHAR(20) Default NULL,   in"pcontacttime" TIME Default NULL, 
   in"pdescription" CHAR(100) Default NULL, in"poutcome" CHAR(50)Default  NULL, in"pwho" CHAR(1) Default NULL, 
   in"pnotes" LONG VARCHAR Default NULL,in"plettertext" LONG VARCHAR Default NULL, in"pfollowup" SMALLINT DEFAULT 0, 
   in"pwpdoc" CHAR(10) Default NULL,  in"pcallbackdate" DATE Default NULL, in"pWhenEntered" TIMESTAMP DEFAULT CURRENT TIMESTAMP, 
   in"pWhoEntered" CHAR(20) Default NULL,  in"pcallbacktime" TIME Default NULL, 
   in"ppriority" SMALLINT DEFAULT 5,  in"pSynetyGUID" CHAR(100) Default NULL, 
   in"pspeciality" CHAR(50) Default NULL, in"pforenames" CHAR(30) Default NULL,in"psurname" CHAR(30) Default NULL, 
   in"pDirection" Char(3) default 'OUT',in"pMethod" char(10) Default 'EMAIL',in"pWhenSent" timestamp Default current timestamp, 
   in"pRecipients" long varchar default null,in"pAttachments" long varchar default null, in"pdivisionid" CHAR(20) Default NULL) 
begin 
  insert into contactevent ( contacteventid,personid,staffid,vacancyid,employmentid,progressid,placementid,contactdate,contacttime, 
  description,outcome,classcode,who,notes,lettertext,followup,wpdoc,callbackdate,divisionid,WhenEntered,WhoEntered, 
  callbacktime,priority,SynetyGUID,speciality,forenames,surname )  
  values(pcontacteventid,ppersonid,pstaffid,pvacancyid,pemploymentid,pprogressid,pplacementid,pcontactdate,pcontacttime, 
  pdescription,poutcome,pclasscode,pwho,pnotes,plettertext,pfollowup,pwpdoc,pcallbackdate,pdivisionid,pWhenEntered,pWhoEntered, 
  pcallbacktime,ppriority,pSynetyGUID,pspeciality,pforenames,psurname); 
  call GenerateContactEventEmailLog(pContactEventid, pWhenSent, pRecipients, pAttachments, pDirection, pMethod); 
end
}
</code>