pears.NetReportCombo_department [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.NetReportCombo_department ======
<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"."NetReportCombo_department"( in "pWebUserID" char(20) ) 
result( "Description" char(250),"Value" char(250) ) 
begin
  select "name","departmentid" from "department" where "searchable" = 1 and "publishtoweb" = 1 order by "sortorder" asc,"departmentid" asc
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetReportCombo_department" IS 
{create procedure pears.NetReportCombo_department(in pWebUserID char(20))
result(Description char(250),Value char(250))
begin
  select name,departmentid from department where searchable = 1 and publishtoweb = 1 order by sortorder asc,departmentid asc
end
}
</code>