pears.NetDivisionList

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

Original SQL

CREATE PROCEDURE "pears"."NetDivisionList"( IN "pWebUserID" CHAR(20) ) 
RESULT( "DivisionID" CHAR(20),"DivisionName" CHAR(60) ) 
// IQXWeb
BEGIN
  SELECT top 10000
    "DivisionID",
    "isnull"("WebDescription","name") AS "DivisionName"
    FROM "division"
    WHERE "publishtoweb" = 1
    ORDER BY "DivisionName" ASC
END /*DOC
2017-08-09 PC create a list of divisions which are attached to departments which are enabled for web
2017-10-31 PC modify name to refer to web description column
2018-02-20 PC key join changed to left outer join, refer to VHS
2018-05-03 VHS/MHS remove deparment dependency. Departments chosen after division
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetDivisionList" IS 
{CREATE PROCEDURE pears."NetDivisionList"(IN pWebUserID CHAR(20))
RESULT(DivisionID CHAR(20),DivisionName CHAR(60))
// IQXWeb
BEGIN
	SELECT top 10000 
        DivisionID,
        isnull(WebDescription,name) AS DivisionName
    FROM 
        division
    WHERE 
        publishtoweb=1
    ORDER BY 
        DivisionName
END
 
/*DOC
2017-08-09 PC create a list of divisions which are attached to departments which are enabled for web
2017-10-31 PC modify name to refer to web description column
2018-02-20 PC key join changed to left outer join, refer to VHS
2018-05-03 VHS/MHS remove deparment dependency. Departments chosen after division
*/
}