====== pears.NetClientVacancyTemplate ======
<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"."NetClientVacancyTemplate"( in "pWebUserID" char(20),in "pTemplateVacancyID" char(20) ) 
result( "VacancyID" char(20),"Position" char(50),"CompanyName" char(60),"ContactName" char(30),"Department" char(30),"VacDescription" long varchar ) 
begin
  select "v"."VacancyID",
    "v"."Position" as "Position",
    "Company"."Name" as "CompanyName",
    "Person"."Name" as "ContactName",
    (select "Name" from "Department" where "Department"."DepartmentID" = "v"."DepartmentID") as "Department",
    "v"."othernotes" as "VacDescription"
    from "Vacancy" as "v" key join "Employment" key join("Company","Person")
    where "Company"."CompanyID" = any(select "companyid" from "employment" key join "iqxnetuserlink" where "iqxnetuserid" = "pWebUserID")
    and "v"."vacancyid" = "pTemplateVacancyID" and "v"."temp" = 1 and "v"."Status" = '[' and "isnull"((select "desktype" from "tempdesk" where "tempdeskid" = "v"."tempdeskid"),'') <> 'S'
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetClientVacancyTemplate" IS 
{create procedure pears."NetClientVacancyTemplate"( in "pWebUserID" char(20),in "pTemplateVacancyID" char(20) ) 
result( "VacancyID" char(20),"Position" char(50),"CompanyName" char(60),"ContactName" char(30),"Department" char(30),"VacDescription" long varchar ) 
begin
  select "v"."VacancyID",
    "v"."Position" as "Position",
    "Company"."Name" as "CompanyName",
    "Person"."Name" as "ContactName",
    (select "Name" from "Department" where "Department"."DepartmentID" = "v"."DepartmentID") as "Department",
    "v"."othernotes" as "VacDescription"
    from "Vacancy" as "v" key join "Employment" key join("Company","Person")
    where "Company"."CompanyID" = any(select "companyid" from "employment" key join "iqxnetuserlink" where "iqxnetuserid" = "pWebUserID")
    and "v"."vacancyid" = "pTemplateVacancyID" and "v"."temp" = 1 and "v"."Status" = '[' and "isnull"((select "desktype" from "tempdesk" where "tempdeskid" = "v"."tempdeskid"),'') <> 'S'
end
}
</code>