pears.NetClientPreviousEmployeeJobs [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.NetClientPreviousEmployeeJobs ======
<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"."NetClientPreviousEmployeeJobs"( in "pWebUserID" char(20),in "pPersonID" char(20) ) 
result( "Position" char(250),"StartDate" date,"FinishDate" date ) 
// IQXWeb
begin
  select "e"."position",
    "e"."startdate",
    "e"."leavedate" as "finishdate"
    from "employment" as "e"
    where "e"."personid" = "pPersonID"
    and "e"."startdate" >= "IQXNetCompanyStartDate"("e"."companyid")
    and "e"."companyid" = any(select "companyid" from "employment" key join "iqxnetuserlink" where "iqxnetuserid" = "pWebUserID")
    order by "e"."startdate" desc
end /* DOC

2019-02-21 PC IW-830 display candidates previous employments as popup

*/
/* TEST
call NetTestSetup('');
select * from NetClientPreviousEmployeeJobs('TEST','TEST');
expect EOF;
update employment set startdate=current date where personid='test';
update iqxnetuserlink set employmentid='TEST' where iqxnetuserlinkid='TEST';
select * from NetClientPreviousEmployeeJobs('TEST','TEST');
expect position=TestPosition;
update iqxnetuserlink set employmentid=null where iqxnetuserlinkid='TEST';
*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetClientPreviousEmployeeJobs" IS 
{create PROCEDURE pears."NetClientPreviousEmployeeJobs"( in "pWebUserID" char(20),in "pPersonID" char(20) ) 
result( "Position" char(250),"StartDate" date,"FinishDate" date ) 
// IQXWeb
begin
    select 
        e.position,
        e.startdate,
        e.leavedate as finishdate
    from 
        employment e 
    where
        e.personid = pPersonID 
        and e.startdate >= IQXNetCompanyStartDate(e.companyid)
        and e.companyid = any(select companyid from employment key join iqxnetuserlink where iqxnetuserid = pWebUserID)
    order by 
        e.startdate desc
end

/* DOC

2019-02-21 PC IW-830 display candidates previous employments as popup

*/

/* TEST
call NetTestSetup('');
select * from NetClientPreviousEmployeeJobs('TEST','TEST');
expect EOF;
update employment set startdate=current date where personid='test';
update iqxnetuserlink set employmentid='TEST' where iqxnetuserlinkid='TEST';
select * from NetClientPreviousEmployeeJobs('TEST','TEST');
expect position=TestPosition;
update iqxnetuserlink set employmentid=null where iqxnetuserlinkid='TEST';
*/
}
</code>