pears.NetReference

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original 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
*/
}