====== pears.NetClientCandidateStatusUpdate ======
<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"."NetClientCandidateStatusUpdate"( in "pWebUserID" char(20) ) 
result( "value" char(20),"descrip" char(50),"IsFinal" char(1) ) 
// IQXNet
begin
  select "status","name","final" from "status" where "type" = 'R' and "allowsetonweb" = 1 order by "gridsortorder" asc
end /* DOC
2016-12-08 PC supply a reason to update the progress of a candidate in a placement

Inputs:
pWebUserID

Outputs:
value
descrip
IsFinal

Tests:
valid pWebUserID
*/
/* TEST
call NetTestSetup('');
insert into status (type,status,allowsetonweb,name,final,help,publishtoweb) on existing update values ('R','~',1,'test',1,'test',1);
select top 1 * from NetClientCandidateStatusUpdate('test.client') where value='~';
expect value=~,descrip=test,IsFinal=1;

*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetClientCandidateStatusUpdate" IS 
{create PROCEDURE pears."NetClientCandidateStatusUpdate"(in pWebUserID char(20))
RESULT(value char(20),descrip char(50),IsFinal char(1))
// IQXNet
BEGIN
	select status,name,final from status where type='R' and allowsetonweb=1 order by gridsortorder
END

/* DOC
2016-12-08 PC supply a reason to update the progress of a candidate in a placement

Inputs:
    pWebUserID

Outputs:
    value
    descrip
    IsFinal
    
Tests:
    valid pWebUserID
*/

/* TEST
call NetTestSetup('');
insert into status (type,status,allowsetonweb,name,final,help,publishtoweb) on existing update values ('R','~',1,'test',1,'test',1);
select top 1 * from NetClientCandidateStatusUpdate('test.client') where value='~';
expect value=~,descrip=test,IsFinal=1;

*/
}
</code>