pears.NetOwnerGetContactEventOutcome [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.NetOwnerGetContactEventOutcome ======
<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"."NetOwnerGetContactEventOutcome"( in "pWebUserID" char(20) ) 
/* RESULT( column_name column_type, ... ) */
begin
  select "contactoutcomeid" as "Value",
    "description" as "Descrip",
    "callbackdays" as "callback"
    from "pears"."contactoutcome"
    order by "sortorder" asc
end /* DOC
2016-08-31 PC test and doc

inputs:
pWebUserID

outputs:
Value - Primary Key
Descrip - text description

tests:
ensure a list is returned. There is no filtering

*/
/* TEST

select (if (select count(*) from "pears"."NetOwnerGetContactEventOutcome"("pWebUserID" = null)) != 0 then 'y' else 'n' endif);
expect y;
select (if (select count(*) from "pears"."NetOwnerGetContactEventOutcome"("pWebUserID" = null)) = (select count(*) from contactoutcome) then 'y' else 'n' endif);
expect y;

*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerGetContactEventOutcome" IS 
{create PROCEDURE pears."NetOwnerGetContactEventOutcome"( in pWebUserID char(20) )
/* RESULT( column_name column_type, ... ) */
BEGIN
    SELECT 
        contactoutcomeid as Value, 
        description as Descrip, 
        callbackdays as callback 
    FROM 
        "pears"."contactoutcome"
    ORDER BY 
        sortorder
END

/* DOC
2016-08-31 PC test and doc

inputs:
    pWebUserID

outputs:
    Value - Primary Key
    Descrip - text description

tests:
    ensure a list is returned. There is no filtering
    
*/

/* TEST

select (if (select count(*) from "pears"."NetOwnerGetContactEventOutcome"("pWebUserID" = null)) != 0 then 'y' else 'n' endif);
expect y;
select (if (select count(*) from "pears"."NetOwnerGetContactEventOutcome"("pWebUserID" = null)) = (select count(*) from contactoutcome) then 'y' else 'n' endif);
expect y;

*/
}
</code>