====== pears.NetReference ======
<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"."NetReference"( 
  /* DOC

*/
  in "pWebUserID" char(20),in "pReferenceRequestCode" char(250) ) 
result(  -- 24-09-2015 Created
  "ReferenceRequestID" char(20),"DepartmentID" char(20),"Position" char(100),"PositionNotes" long varchar,"RefereeAddressName" char(60),"personName" char(30),"StartDate" timestamp,"EndDate" timestamp ) 
-- IQXNet
begin
  select "ReferenceRequestID",
    "DepartmentID",
    "Position",
    "PositionNotes",
    "RefereeAddressName",
    "Person"."name",
    "StartDate",
    "EndDate"
    from "pears"."ReferenceRequest" key join "Person"
    where "URLRequestCode" = "pReferenceRequestCode"
    and "WhenCompleted" is null
    and "ReferenceRefused" is null
end /* DOC
Created: 24-09-2015
Details: Fetches the reference request
Author: Gareth
Version: 1.1

2020-07-06 GJ IW-1194 - Updated to allow withdrawl of reference
*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetReference" IS 
{create PROCEDURE pears."NetReference"
/* DOC

*/
( in "pWebUserID" char(20), in "pReferenceRequestCode" char(250) ) 
result(  -- 24-09-2015 Created
 ReferenceRequestID char(20), DepartmentID char(20), Position char(100), PositionNotes long varchar, RefereeAddressName char(60), personName char(30), StartDate timestamp, EndDate timestamp ) 
-- IQXNet
begin
  SELECT 
  	ReferenceRequestID, 
  	DepartmentID, 
  	Position, 
  	PositionNotes, 
  	RefereeAddressName,
  	Person.name,
    StartDate,
    EndDate
  FROM "pears"."ReferenceRequest" KEY JOIN Person
  WHERE "URLRequestCode" = "pReferenceRequestCode" 
  AND WhenCompleted is null
  AND ReferenceRefused is null
end

/* DOC
Created: 24-09-2015
Details: Fetches the reference request
Author: Gareth
Version: 1.1

2020-07-06 GJ IW-1194 - Updated to allow withdrawl of reference
*/
}
</code>