pears.NetCandidateTaxMethodDropdown [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.NetCandidateTaxMethodDropdown ======
<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"."NetCandidateTaxMethodDropdown"( in "pWebUserID" char(20),in "TaxMethod" char(20) default null ) 
result( "Value" char(20),"Descrip" char(100),"selected" char(1) ) 
begin
  select '1','PAYE',(if "isnull"("TaxMethod",'') = 1 then '1' else '0' endif) union
  select '2','Limited company',(if "isnull"("TaxMethod",'') = 2 then '1' else '0' endif) union
  select '3','self employed',(if "isnull"("TaxMethod",'') = 3 then '1' else '0' endif)
end /* DOC

2017-10-23 PC modify to return Selected parameter for dropdown on web page

*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidateTaxMethodDropdown" IS 
{create PROCEDURE pears."NetCandidateTaxMethodDropdown"(in pWebUserID char(20), in TaxMethod char(20) default null)
RESULT(Value char(20),Descrip char(100),selected char(1) )
BEGIN
	select '1','PAYE', (if isnull(TaxMethod,'')=1 then '1' else '0' endif)
  union
    select '2','Limited company', (if isnull(TaxMethod,'')=2 then '1' else '0' endif)
  union 
    select '3','self employed', (if isnull(TaxMethod,'')=3 then '1' else '0' endif)
END

/* DOC

2017-10-23 PC modify to return Selected parameter for dropdown on web page

*/
}
</code>