====== pears.NetAgencyRejectCandidateReason ======
<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"."NetAgencyRejectCandidateReason"( in "pWebUserID" char(20) ) 
result( "value" char(20),"descrip" char(50) ) 
// IQXNet
begin
  select "rejectreasonid","reason" from "rejectionreason" order by "sortorder" asc
end /* DOC
2017-01-30 PC supply a reason for rejecting a candidate from a placement
2018-06-05 PC revise tests

Inputs:
pWebUserID

Outputs:
value
descrip

Tests:
invalid pWebUserID
valid pWebUserID
*/
/* TEST
call NetTestSetup('');
insert into rejectionreason on existing skip values ('TEST','test',0);
select top 1 * from NetAgencyRejectCandidateReason(null) where value='TEST';
expect value=TEST,descrip=test;
select top 1 * from NetAgencyRejectCandidateReason('test.client') where value='TEST';
expect value=TEST,descrip=test;

*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetAgencyRejectCandidateReason" IS 
{create PROCEDURE pears."NetAgencyRejectCandidateReason"(in pWebUserID char(20))
RESULT(value char(20),descrip char(50))
// IQXNet
BEGIN
	select rejectreasonid,reason from rejectionreason order by sortorder asc;
END

/* DOC
2017-01-30 PC supply a reason for rejecting a candidate from a placement
2018-06-05 PC revise tests

Inputs:
    pWebUserID

Outputs:
    value
    descrip
    
Tests:
    invalid pWebUserID
    valid pWebUserID
*/

/* TEST
call NetTestSetup('');
insert into rejectionreason on existing skip values ('TEST','test',0);
select top 1 * from NetAgencyRejectCandidateReason(null) where value='TEST';
expect value=TEST,descrip=test;
select top 1 * from NetAgencyRejectCandidateReason('test.client') where value='TEST';
expect value=TEST,descrip=test;

*/
}
</code>