====== pears.NetCandidateProfileBank ======
<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"."NetCandidateProfileBank"( in "pWebUserID" char(20),in "pPersonID" char(20) default null ) 
result( "PersonID" char(20),"ni" char(10),"BankName" char(30),"BankSortCode" char(8),"BankAcName" char(50),"BankAcNo" char(8),"UniqueTaxReference" char(20) ) 
begin
  set "pPersonID" = "NetCandidateValidPersonID"("pWebUserID","pPersonID");
  select "person"."personid",
    "person"."ni",
    "Pay_Employee"."BankName",
    "Pay_Employee"."BankSortCode",
    "Pay_Employee"."BankAcName",
    "Pay_Employee"."BankAcNo",
    "string"("replicate"('*',"length"("Pay_Employee"."BankAcNo")-2),"right"("Pay_Employee"."BankAcNo",2)),
    "Pay_Employee"."UniqueTaxReference"
    from "person"
      key left outer join "Pay_Employee"
    where "person"."personid" = "pPersonID"
end /* DOC
2018-05-07 PC IW-503 replace bank account details with asterisks
2018-10-22 MHS IW-456 multi-cand fix
*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidateProfileBank" IS 
{create PROCEDURE pears."NetCandidateProfileBank"( in "pWebUserID" char(20), in pPersonID char(20) default null ) 
result( "PersonID" char(20),"ni" char(10),"BankName" char(30),"BankSortCode" char(8),"BankAcName" char(50),"BankAcNo" char(8),"UniqueTaxReference" char(20) ) 
begin
    set pPersonID=NetCandidateValidPersonID(pWebUserID,pPersonID);
    select 
        "person"."personid",
        "person"."ni",
        "Pay_Employee"."BankName",
        "Pay_Employee"."BankSortCode",
        "Pay_Employee"."BankAcName",
        "Pay_Employee"."BankAcNo",
        string(replicate('*',length("Pay_Employee"."BankAcNo")-2),right("Pay_Employee"."BankAcNo",2)),
        "Pay_Employee"."UniqueTaxReference"
    from 
        "person" 
            key left outer join "Pay_Employee"
    where 
        person.personid=pPersonID
end

/* DOC
2018-05-07 PC IW-503 replace bank account details with asterisks
2018-10-22 MHS IW-456 multi-cand fix
*/
}
</code>