pears.NetAgencyVacancyNotes [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.NetAgencyVacancyNotes ======
<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"."NetAgencyVacancyNotes"( in "pWebUserID" char(20),in "pLineID" char(21) ) 
result( "pNotes" long varchar ) 
begin
  declare "LineType" char(1);
  declare "LineID" char(20);
  set "LineType" = "left"("pLineID",1);
  set "LineID" = "right"("pLineID",20);
  case "LineType"
  when 'V' then
    select top 1 "othernotes" from "vacancy" where "vacancyid" = "LineID"
  when 'P' then
    select top 1 "clientnote" from "tempshiftplan" where "tempshiftplanid" = "LineID"
  end case
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetAgencyVacancyNotes" IS 
{create PROCEDURE pears."NetAgencyVacancyNotes"(in pWebUserID char(20), in pLineID char(21))
RESULT(pNotes long varchar)
BEGIN
	declare LineType char(1);
    declare LineID char(20);
    set LineType=left(pLineID,1);
    set LineID = right(pLineID,20);
    case LineType
        when 'V' then 
            select top 1 othernotes from vacancy where vacancyid=LineID;
        when 'P' then
            select top 1 clientnote from tempshiftplan where tempshiftplanid=LineID
    end case;
END
}
</code>