pears.DashboardStaffDivisions [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.DashboardStaffDivisions ======
<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"."DashboardStaffDivisions"()
result( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  "DivisionID" char(20),"Name" char(100) ) 
begin
  declare "pStaffID" char(20);
  declare "pDivAccess" smallint;
  declare "pOwnDivID" char(20);
  select first "staffid","divisionaccess","divisionid" into "pStaffID","pDivAccess","pOwnDivID" from "staff" where "staffid" = "userstaffid";
  case "pDivAccess"
  when 1 then
    select "divisionid","name" from "division" where "divisionid" = "pOwnDivID" union select '','No Division'
  when 2 then
    select "a"."divisionid","d"."name" from "divisionaccess" as "a" key join "division" as "d" where "a"."staffid" = "pStaffID" union select '','No Division'
  else
    select "divisionid","name" from "division" union select '','No Division'
  end case
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."DashboardStaffDivisions" IS 
{create procedure DashboardStaffDivisions 

/* Application Maintained Function / Procedure - DO NOT EDIT*/

()
result( DivisionID char(20),Name char(100) ) 
begin
  declare pStaffID char(20);
  declare pDivAccess smallint;
  declare pOwnDivID char(20);
  select first staffid,divisionaccess,divisionid into pStaffID,pDivAccess,pOwnDivID from staff where staffid = userstaffid;
  case pDivAccess
  when 1 then
    select divisionid,name from division where divisionid = pOwnDivID union select '','No Division'
  when 2 then
    select a.divisionid,d.name from divisionaccess as a key join division as d where a.staffid = pStaffID union select '','No Division'
  else
    select divisionid,name from division union select '','No Division'
  end case
end
}
</code>