pears.NetReportCombo_department

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original 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
}