pears.NetCandidateTaxCodeDropdown

CREATE PROCEDURE "pears"."NetCandidateTaxCodeDropdown"( IN "pWebUserID" CHAR(20),IN "TaxCode" CHAR(10) DEFAULT NULL ) 
RESULT( "Value" CHAR(20),"Descrip" CHAR(1024),"selected" CHAR(1) ) 
// IQXWeb
BEGIN
  DECLARE "CurrentTaxCode" CHAR(20);
  SET "CurrentTaxCode" = "trim"((SELECT "string"("TaxCode",(IF "Week1Ind" = 1 THEN 'Week 1' endif)) FROM "pay_employee" KEY JOIN "person" KEY JOIN "iqxnetuserlink" WHERE "iqxnetuserid" = "pWebUserID"));
  SELECT "tagchoiceid","isnull"("longdescription","description"),(IF "isnull"("CurrentTaxCode",'') = "description" THEN '1' ELSE '0' endif) FROM "tagchoice" WHERE "tagid" = 'PDE' AND "taglocation" = 'P' ORDER BY "sortorder" ASC
END /* DOC
 
2017-10-23 PC remove hard-coded questions and allow lookup from question
2018-11-08 ET This should be a soft procedure.
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidateTaxCodeDropdown" IS 
{CREATE PROCEDURE pears."NetCandidateTaxCodeDropdown"(IN pWebUserID CHAR(20),IN TaxCode CHAR(10) DEFAULT NULL)
RESULT(VALUE CHAR(20),Descrip CHAR(1024),selected CHAR(1) )
// IQXWeb
BEGIN
    DECLARE CurrentTaxCode CHAR(20);
    SET CurrentTaxCode=TRIM((SELECT string(TaxCode,(IF Week1Ind=1 THEN 'Week 1' endif)) FROM pay_employee KEY JOIN person KEY JOIN iqxnetuserlink WHERE iqxnetuserid=pWebUserID));
    SELECT tagchoiceid,isnull(longdescription,description),(IF isnull(CurrentTaxCode,'')=description THEN '1' ELSE '0' endif) FROM tagchoice WHERE tagid='PDE' AND taglocation='P'  ORDER BY sortorder ASC
END
 
/* DOC
 
2017-10-23 PC remove hard-coded questions and allow lookup from question
2018-11-08 ET This should be a soft procedure.
 
*/
}