pears.NetOwnerCandidateBankEdit

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

CREATE PROCEDURE "pears"."NetOwnerCandidateBankEdit"( IN "pWebUserID" CHAR(20),IN "pPersonID" CHAR(20) ) 
RESULT( "PersonID" CHAR(20),"ni" CHAR(10),"BankName" CHAR(30),"BankSortCode" CHAR(8),"BankAcName" CHAR(50),"BankAcNo" CHAR(8),"UniqueTaxReference" CHAR(20) ) 
BEGIN
  IF((SELECT "count"() FROM "person" WHERE "person"."personid" = "pPersonID") = 0) THEN
    SELECT '','','','','','',''
  ELSE
    SELECT "person"."personid",
      "person"."ni",
      "Pay_Employee"."BankName",
      "Pay_Employee"."BankSortCode",
      "Pay_Employee"."BankAcName",
      "string"("replicate"('*',"length"("bankacno")-2),"right"("bankacno",2)) AS "BankAcNo",
      "Pay_Employee"."UniqueTaxReference"
      FROM "person"
        KEY LEFT OUTER JOIN "Pay_Employee"
        ,"person"
      WHERE "person"."personid" = "pPersonID"
  END IF
END /* DOC
2018-05-07 PC IW-503 hide first characters of accouint code showing only last two
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerCandidateBankEdit" IS 
{CREATE PROCEDURE pears."NetOwnerCandidateBankEdit"( IN "pWebUserID" CHAR(20),IN "pPersonID" CHAR(20) ) 
RESULT( "PersonID" CHAR(20),"ni" CHAR(10),"BankName" CHAR(30),"BankSortCode" CHAR(8),"BankAcName" CHAR(50),"BankAcNo" CHAR(8),"UniqueTaxReference" CHAR(20) ) 
BEGIN
    IF((SELECT "count"() FROM "person" WHERE "person"."personid" = "pPersonID") = 0) THEN
        SELECT '','','','','','',''
    ELSE
        SELECT 
            "person"."personid",
            "person"."ni",
            "Pay_Employee"."BankName",
            "Pay_Employee"."BankSortCode",
            "Pay_Employee"."BankAcName",
            string(replicate('*',LENGTH(bankacno)-2),RIGHT(bankacno,2)) AS "BankAcNo"
            ,"Pay_Employee"."UniqueTaxReference"
        FROM 
            "person" 
                KEY LEFT OUTER JOIN "Pay_Employee",
            "person"
        WHERE 
            "person"."personid" = "pPersonID"
  END IF
END
 
/* DOC
2018-05-07 PC IW-503 hide first characters of accouint code showing only last two
 
*/
}