pears.NetClientShiftCancelReasons

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

Original SQL

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetClientShiftCancelReasons" IS 
{CREATE FUNCTION pears."NetClientShiftCancelReasons"( IN "WebUser" CHAR(20),IN "NeedsRefill" INTEGER DEFAULT 0 ) 
RETURNS long VARCHAR
-- 20111012 create ComboBox option list for cancel reasons on Client -> Current Shift Status status box
-- 20111128 modify to allow filter on reject or cancel reasons where refill=true
-- 20130213 created from GenevaNetClientShiftCancelReasons
BEGIN
  DECLARE "rv" long VARCHAR;
  SELECT "list"("string"('<option value="',"TempShiftCancelReasonID",'">',"Name"),'</option>' ORDER BY "SortOrder" ASC) INTO "rv" FROM "TempShiftCancelReason" WHERE "PublishToWeb" = '1' AND "isnull"("Refill",0) >= "NeedsRefill";
  RETURN "rv"
END
}