pears.NetAgencyRejectCandidateReason

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;
 
*/
}