ALTER VIEW cmrpt_overdue_wo
SELECT
    wo.wo_id,
    wo.description,
    wo.date_added,
    wo.date_scheduled,
    wo.date_completed,
    GETDATE() AS Today,
    DATEDIFF(dd, GETDATE(),  wo.date_scheduled) AS Past_Due,
    DATEDIFF(dd, wo.date_scheduled, wo.date_completed) AS Comp_Ontime,
    wo.status,
    ws.id AS Status_ID,
    ws.description AS Status_Desc,
    wt.id AS Type_ID,
    wt.description AS Type_Desc,
    CASE WHEN DATEDIFF(dd, date_scheduled, date_completed) > 0 THEN 1 ELSE 0 END AS OverDue
FROM
    imtbl_work_order         wo LEFT OUTER JOIN
    imtbl_work_type          wt ON wo.work_order_type = wt.pkey LEFT OUTER JOIN
    imtbl_work_order_status  ws ON wo.status = ws.pkey
WHERE
    wo.status = 4