pears.NetAgencyCandidateProgressHistory

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

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