pears.NetCandidatePersonID [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.NetCandidatePersonID ======
<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"."NetCandidatePersonID"( in "pWebUserID" char(20) ) 
result( "PersonID" char(20) ) 
// IQXWeb
begin
  select "NetCandidateValidPersonID"("pWebUserID",null) as "PersonID" where "PersonID" is not null
end /* DOC
2016-12-02 PC test and doc
2018-10-22 MHS IW-456 multi-cand fix and tests

Inputs:
pWebUserID

Outputs:
PersonID

Tests:
invalid pWebUserID
valid pWebUserID

*/
/* TEST
call NetTestSetup('');
select * from NetCandidatePersonID(null);
expect EOF;
select * from NetCandidatePersonID('test.candidate');
expect PersonID=TEST;

*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidatePersonID" IS 
{create PROCEDURE pears."NetCandidatePersonID"( in pWebUserID char(20) ) 
result( PersonID char(20) ) 
// IQXWeb
begin
  select NetCandidateValidPersonID(pWebUserID,null) as PersonID where PersonID is not null;
end

/* DOC
2016-12-02 PC test and doc
2018-10-22 MHS IW-456 multi-cand fix and tests

Inputs:
    pWebUserID

Outputs:
    PersonID

Tests:
    invalid pWebUserID
    valid pWebUserID

*/

/* TEST
call NetTestSetup('');
select * from NetCandidatePersonID(null);
expect EOF;
select * from NetCandidatePersonID('test.candidate');
expect PersonID=TEST;

*/
}
</code>