Bewerken: Job

Sectie: Computed columns

Reden:

## Computed columns

- `JobExceedsOriginalTimeEstimate` — `(CONVERT([smallint],case when ([JobHoursCalc]-[JobUnapprovedHoursCalculated])<([JobPlanHours]-[JobUnapprovedHoursPlanned]) then (1) else (0) end))`
- `JobHoursToPlan` — `(CONVERT([decimal](21,2),case when ([JobHoursCalc]-[JobPlanHours])>[JobHoursToPlanFromResources] then (([JobHoursCalc]-[JobPlanHours])-[JobUnapprovedHoursCalculated])+[JobUnapprovedHoursPlanned] else ([JobHoursToPlanFromResources]-[JobUnapprovedHoursCalculated])+[JobUnapprovedHoursPlanned] end))`
- `JobNonServDeskServRequest` — `(CONVERT([smallint],case when [JobCreatedByServiceDesk]=(1) OR [JobSelfServiceRequest]=(1) then (0) else (1) end))`
- `JobPercCompleteRaw` — `(CONVERT([decimal](21,2),case when [JobHoursCalc]=(0) then (0) else ([JobHours]/case when [JobHoursCalc]<=(0) then (1) else [JobHoursCalc] end)*(100.0) end))`
- `JobPurchaseRequestCalc` — `(CONVERT([decimal](21,5),case when [JobPchrlTotBookCostExlVat]<(0) then (0) else [JobPchrlTotBookCostExlVat] end+case when [JobPchrlTotBookCostInclVat]<(0) then (0) else [JobPchrlTotBookCostInclVat] end))`
- `JobPurchCalc` — `(CONVERT([decimal](21,5),case when [JobPchTotalBookCostExlVat]<(0) then (0) else [JobPchTotalBookCostExlVat] end+case when [JobPchTotalBookCostInclVat]<(0) then (0) else [JobPchTotalBookCostInclVat] end))`
- `JobTotalCalc` — `(CONVERT([decimal](21,5),(((((([JobMatCalc]+[JobExtCalc])+[JobTlsCalc])+[JobResCalc])+case when [JobPchrlTotBookCostExlVat]<(0) then (0) else [JobPchrlTotBookCostExlVat] end)+case when [JobPchrlTotBookCostInclVat]<(0) then (0) else [JobPchrlTotBookCostInclVat] end)+case when [JobPchTotalBookCostExlVat]<(0) then (0) else [JobPchTotalBookCostExlVat] end)+case when [JobPchTotalBookCostInclVat]<(0) then (0) else [JobPchTotalBookCostInclVat] end))`
- `JobTotalCost` — `(CONVERT([decimal](21,5),(((([JobMatCost]+[JobExtCost])+[JobTlsCost])+[JobLabCost])+[JobPurchCost])+[JobMemorandumCost]))`
- `JobTotalInv` — `(CONVERT([decimal](21,5),((((([JobEqmInv]+[JobMatInv])+[JobExtInv])+[JobTlsInv])+[JobLabInv])+[JobPurchInv])+[JobIoTermInv]))`
- `JobFileExtension` — `(N'.html')`
- `JOBFEEDBACKTEXT_FT` — `(case when [JOBFEEDBACKTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([JOBFEEDBACKTEXT],(5))=N'<html' then [JOBFEEDBACKTEXT] else N'<html lang="nl">'+[JOBFEEDBACKTEXT] end) end)`
- `JOBREPORTTEXT_FT` — `(case when [JOBREPORTTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([JOBREPORTTEXT],(5))=N'<html' then [JOBREPORTTEXT] else N'<html lang="nl">'+[JOBREPORTTEXT] end) end)`
- `JOBTEXT_FT` — `(case when [JOBTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([JOBTEXT],(5))=N'<html' then [JOBTEXT] else N'<html lang="nl">'+[JOBTEXT] end) end)`
- `JobFinalFinishDate` — `(case when [JobExecutionDays]>(0) then dateadd(day,([JobExecutionDays]+[JobExtensionDays])-(1),[JobOriginalSchStartDate])  end)`
- `JobOriginalFinalFinishDate` — `(case when [JobExecutionDays]>(0) then dateadd(day,[JobExecutionDays]-(1),[JobOriginalSchStartDate])  end)`