pears.NetAgencyProvTimesheets [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.NetAgencyProvTimesheets ======
<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"."NetAgencyProvTimesheets"( in "pWebUserID" char(20) ) 
result( "tempprovtimesheetid" char(20),"serialnumber" char(20),"tempname" char(60),"position" char(60),"companyname" char(60),"weekenddate" date,"timesheettype" char(1),"completed" smallint ) 
begin
  select "t"."tempprovtimesheetid","t"."serialnumber","string"("person"."surname",', ',"person"."forenames") as "tempname","vacancy"."position","company"."name" as "companyname",
    "NetTimesheetEndDate"(1,1,"t"."tempprovtimesheetid") as "weekenddate",
    if "NetVacancyHasRateScript"("t"."tempjobtypeid","t"."vacancyid") = 0 then 'C'
    else if "tempdesk"."desktype" = 'S' then 'S' else if "tempdesk"."desktype" = 'W'
        and exists(select * from "placement" where "placementid" = "t"."placementid" and "worknormalhours" is not null and "workstarttime" is not null
          and("isnull"("workmonday",0) = 1 or "isnull"("worktuesday",0) = 1 or "isnull"("workwednesday",0) = 1 or "isnull"("workthursday",0) = 1 or "isnull"("workfriday",0) = 1
          or "isnull"("worksaturday",0) = 1 or "isnull"("worksunday",0) = 1)) then 'T'
        else 'C'
        endif endif
    endif as "timesheettype",
    if "t"."extnumber" = 2 then 1 else 0 endif as "completed"
    from "tempprovtimesheet" as "t" key join "vacancy" key join "employment" key join "company","tempprovtimesheet" as "t"
      key join "tempdesk","tempprovtimesheet" as "t" key join "person" key join "pay_employee" key join "company" as "agcomp" key join "employment" as "agemp" key join "iqxnetuserlink"
    where "iqxnetuserlink"."iqxnetuserid" = "pWebUserID"
    and "t"."extnumber" > 0
    and "weekenddate" > current date-60
    order by "weekenddate" asc,"t"."serialnumber" asc,"tempname" asc
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetAgencyProvTimesheets" IS 
{create procedure pears."NetAgencyProvTimesheets"( in "pWebUserID" char(20) ) 
result( "tempprovtimesheetid" char(20),"serialnumber" char(20),"tempname" char(60),"position" char(60),"companyname" char(60),"weekenddate" date,"timesheettype" char(1),"completed" smallint ) 
begin
  select "t"."tempprovtimesheetid","t"."serialnumber","string"("person"."surname",', ',"person"."forenames") as "tempname","vacancy"."position","company"."name" as "companyname",
    "NetTimesheetEndDate"(1,1,"t"."tempprovtimesheetid") as "weekenddate",
    if "NetVacancyHasRateScript"("t"."tempjobtypeid","t"."vacancyid") = 0 then 'C'
    else if "tempdesk"."desktype" = 'S' then 'S' else if "tempdesk"."desktype" = 'W'
        and exists(select * from "placement" where "placementid" = "t"."placementid" and "worknormalhours" is not null and "workstarttime" is not null
          and("isnull"("workmonday",0) = 1 or "isnull"("worktuesday",0) = 1 or "isnull"("workwednesday",0) = 1 or "isnull"("workthursday",0) = 1 or "isnull"("workfriday",0) = 1
          or "isnull"("worksaturday",0) = 1 or "isnull"("worksunday",0) = 1)) then 'T'
        else 'C'
        endif endif
    endif as "timesheettype",
    if "t"."extnumber" = 2 then 1 else 0 endif as "completed"
    from "tempprovtimesheet" as "t" key join "vacancy" key join "employment" key join "company","tempprovtimesheet" as "t"
      key join "tempdesk","tempprovtimesheet" as "t" key join "person" key join "pay_employee" key join "company" as "agcomp" key join "employment" as "agemp" key join "iqxnetuserlink"
    where "iqxnetuserlink"."iqxnetuserid" = "pWebUserID"
    and "t"."extnumber" > 0
    and "weekenddate" > current date-60
    order by "weekenddate" asc,"t"."serialnumber" asc,"tempname" asc
end
}
</code>