====== pears.NetAgencyCandidateProgressHistory ======
<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"."NetAgencyCandidateProgressHistory"( in "pWebUserID" char(20),in "pProgressID" char(20) ) 
result( "ActionName" char(100),"ActionDate" char(10),"ActionTime" char(10),"StaffName" char(60) ) 
-- 20120817 modified for NetOleProgress
begin
  select "s"."name" as "ActionName",
    "HistoryDate" as "ActionDate",
    "HistoryTime" as "ActionTime",
    "st"."name" as "StaffName"
    from "progress" as "p"
      left outer join "progressHistory" as "ph"
      join "status" as "s" on "ph"."status" = "s"."status"
      join "staff" as "st" on "ph"."staffid" = "st"."staffid"
    where "s"."type" = 'R'
    and "s"."publishtoweb" = '1'
    and "p"."progressid" = "pProgressID"
    order by "Historydate" desc,"HistoryTime" desc
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetAgencyCandidateProgressHistory" IS 
{create procedure pears."NetAgencyCandidateProgressHistory"( in "pWebUserID" char(20),in "pProgressID" char(20) ) 
result( "ActionName" char(100),"ActionDate" char(10),"ActionTime" char(10),"StaffName" char(60) ) 
-- 20120817 modified for NetOleProgress
begin
  select "s"."name" as "ActionName",
    "HistoryDate" as "ActionDate",
    "HistoryTime" as "ActionTime",
    "st"."name" as "StaffName"
    from "progress" as "p"
      left outer join "progressHistory" as "ph"
      join "status" as "s" on "ph"."status" = "s"."status"
      join "staff" as "st" on "ph"."staffid" = "st"."staffid"
    where "s"."type" = 'R'
    and "s"."publishtoweb" = '1'
    and "p"."progressid" = "pProgressID"
    order by "Historydate" desc,"HistoryTime" desc
end
}
</code>