====== pears.NetCandidateSourceSelect ======
<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"."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

*/
}
</code>