pears.NetCandidatePayslipList

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original 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
 
*/
}