pears.NetOwnerRegistration

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

CREATE PROCEDURE "pears"."NetOwnerRegistration"( IN "pWebUserID" CHAR(20),IN "pDepartmentID" CHAR(10),IN "pCandidateID" CHAR(20) ) 
RESULT( "departmentid" CHAR(10),"personid" CHAR(20),"departmentname" CHAR(100),"temp" SMALLINT,"perm" SMALLINT ) 
//IQXNet
BEGIN
  SELECT "department"."departmentid",
    "pCandidateID" AS "personid",
    "department"."name",
    "search"."temp",
    "search"."permanent"
    FROM "department"
      KEY JOIN "search"
    WHERE "search"."personid" = "pCandidateID"
    AND "department"."searchable" = 1
    AND "department"."publishtoweb" = 1
    AND "department"."departmentid" = "pDepartmentID"
    AND("department"."divisionid" IS NULL OR "department"."divisionid" = any(SELECT "p"."divisionid" FROM "person" AS "p" WHERE "p"."personid" = "pCandidateID"))
    AND("department"."divisionid" IS NULL OR "department"."divisionid" = any(SELECT "DivisionID" FROM "DashboardStaffDivisions"()))
END /* DOC
2018-10-05 GJ Created Proc
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerRegistration" IS 
{CREATE PROCEDURE pears."NetOwnerRegistration"( IN pWebUserID CHAR(20),IN pDepartmentID CHAR(10), IN pCandidateID CHAR(20) ) 
RESULT( departmentid CHAR(10),personid CHAR(20),departmentname CHAR(100),temp SMALLINT,perm SMALLINT ) 
//IQXNet
BEGIN
    SELECT 
        department.departmentid,
        pCandidateID AS personid,
        department.[name],
        [SEARCH].[temp],
        [SEARCH].permanent
    FROM 
        department 
        KEY JOIN [SEARCH] 
    WHERE 
           [SEARCH].personid = pCandidateID 
       AND department.searchable = 1 
       AND department.publishtoweb = 1
       AND department.departmentid = pDepartmentID
       AND (department.divisionid IS NULL OR department.divisionid IN (SELECT p.divisionid FROM person p WHERE p.personid=pCandidateID)) 
       AND (department.divisionid IS NULL OR department.divisionid IN (SELECT DivisionID FROM DashboardStaffDivisions()))
END
 
/* DOC
2018-10-05 GJ Created Proc
*/
}