pears.NetCandidateSourceSelect

CREATE PROCEDURE "pears"."NetCandidateSourceSelect"( IN "pWebUserID" CHAR(20) ) 
RESULT( "value" CHAR(20),"name" CHAR(100) ) 
BEGIN
  SELECT "OriginID" AS "value","descrip" FROM "origin" WHERE "type" = 'P' AND "isnull"("defunct",0) = 0 ORDER BY "sortorder" ASC
END /* DOC
2017-11-27 PC provide filter dropdown for candidate Source select box
2018-05-23 GJ Updated so it works while not authenticated
 
inputs:
pWebUserID
 
outputs:
value - select code
name - text for dropdown box
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidateSourceSelect" IS 
{CREATE PROCEDURE pears."NetCandidateSourceSelect"(IN pWebUserID CHAR(20))
RESULT(VALUE CHAR(20),name CHAR(100))
BEGIN
    SELECT OriginID AS VALUE,descrip  FROM origin WHERE TYPE='P' AND isnull(defunct,0) = 0 ORDER BY sortorder ASC
END
 
/* DOC
2017-11-27 PC provide filter dropdown for candidate Source select box
2018-05-23 GJ Updated so it works while not authenticated
 
inputs:
    pWebUserID
 
outputs:
    value - select code
    name - text for dropdown box
 
*/
}