pears.NetCandidatePayslipList [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.NetCandidatePayslipList ======
<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"."NetCandidatePayslipList"( in "pWebUserID" char(20) ) 
result( "PayrollNumber" char(20),"PayslipDate" date,"NetPay" char(10),"ConsultantID" char(20),"PayslipPath" char(255) ) 
begin
  // IQXWeb
  if exists(select * from "sysobjects" where "name" = 'SoftNetDummyCandidatePayslipList') then
    select "PayrollNumber","PayslipDate","NetPay","ConsultantID","PayslipPath" from "SoftNetDummyCandidatePayslipList"("pWebUserID") order by "PayslipDate" desc
  else if exists(select * from "sysobjects" where "name" = 'SoftNetCandidatePayslipList') then
      select "PayrollNumber","PayslipDate","NetPay","ConsultantID","PayslipPath" from "SoftNetCandidatePayslipList"("pWebUserID") order by "PayslipDate" desc
    else
      select null,null,null,null,null from "dummy" where 1 = 0
    end if
  end if
end /* DOC

2016-10-13 PC Generate list of Payslip and pay advice documents for download
2018-01-23 PC IW-92
2018-05-02 PC IW-477 switchboard for different payslip methods
2018-05-18 MHS IW-506 provide fallback null result if neither soft proc is present

*/
/* TEST

*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidatePayslipList" IS 
{create PROCEDURE pears."NetCandidatePayslipList"( in pWebUserID char(20) )
RESULT(PayrollNumber char(20), PayslipDate date, NetPay char(10), ConsultantID char(20), PayslipPath char(255))
BEGIN
  // IQXWeb
    if exists(select * from sysobjects where name='SoftNetDummyCandidatePayslipList') then
        select PayrollNumber, PayslipDate, NetPay, ConsultantID , PayslipPath from SoftNetDummyCandidatePayslipList(pWebUserID) order by PayslipDate desc
    else if exists(select * from sysobjects where name='SoftNetCandidatePayslipList') then
        select PayrollNumber, PayslipDate, NetPay, ConsultantID , PayslipPath from SoftNetCandidatePayslipList(pWebUserID) order by PayslipDate desc
    else
        select null,null,null,null,null from dummy where 1=0
    end if;
    end if;

END

/* DOC

2016-10-13 PC Generate list of Payslip and pay advice documents for download
2018-01-23 PC IW-92
2018-05-02 PC IW-477 switchboard for different payslip methods
2018-05-18 MHS IW-506 provide fallback null result if neither soft proc is present

*/

/* TEST

*/
}
</code>