====== pears.NetCandidateRegDetails ======
<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"."NetCandidateRegDetails"( in "pWebUserID" char(20),in "pPersonID" char(20) ) 
result( "PersonID" char(20),"DivisionID" char(20),"DivisionName" char(30),"DepartmentID" char(2),"DepartmentName" char(30),"DepartmentTemp" smallint,"DepartmentPerm" smallint ) 
// IQXWeb
begin
  select top 1
    "p"."PersonID",
    "p"."DivisionID",
    "d"."Name" as "DivisionName",
    "s"."DepartmentID",
    "dep"."Name" as "DepartmentName",
    "s"."temp" as "DepartmentTemp",
    "s"."permanent" as "DepartmentPerm"
    from "person" as "p" key left outer join "division" as "d"
      ,"person" as "p" key left outer join("search" as "s" key join "department" as "dep")
    where "p"."PersonID" = "NetCandidateValidPersonID"("pWebUserID","pPersonID")
    order by 1 asc,4 asc
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidateRegDetails" IS 
{create PROCEDURE pears."NetCandidateRegDetails"( in pWebUserID char(20), in pPersonID char(20) ) 
result( PersonID char(20), DivisionID char(20), DivisionName char(30), DepartmentID char(2), DepartmentName char(30), DepartmentTemp smallint, DepartmentPerm smallint ) 
// IQXWeb
begin
  select top 1
    p.PersonID, 
    p.DivisionID,
    d.Name as DivisionName,
    s.DepartmentID,
    dep.Name as DepartmentName,
    s.temp as DepartmentTemp,
    s.permanent as DepartmentPerm
  from 
    person p key left outer join division d,
    person p key left outer join (search s key join department dep)
  where
    p.PersonID=NetCandidateValidPersonID(pWebUserID,pPersonID)
  order by 1,4;
end
}
</code>