MREQ_OPENED_CLOSED_BY_DETAIL_D/M

Use this view to assess daily request throughput, and to help indicate trends in open requests over time. These views provide information for request submission and completion activity (throughput), broken down by:

  • day or month

  • combinations of request type, application, department, priority, and assigned-to user

Thus allowing access to more information than MREQ_OPENED_CLOSED_BY_DETAIL_D/M or MREQ_OPENED_CLOSED_BY_TYPE_D/M .

Results from a query of this view contain records only for days or months on which there were requests opened or closed.

Sample

This creates a report to examine throughput of all work order request types for the IT development department:

SELECT activity_date,
       application,
       priority,
       total_opened,
       total_closed,
       num_still_open,
       avg_comp_time_opened,
       avg_comp_time_closed
FROM   mreq_opened_closed_by_detail_d
WHERE  activity_date BETWEEN '01-APR-01' AND '05-APR-01'
AND    request_type_name = 'Work Order'
AND    department = 'Development'
ORDER BY activity_date;

To get a breakdown by month, replace activity_date with activity_month and mreq_opened_closed_by_detail_d with mreq_opened_closed_by_detail_m.

Results

                                                         Avg     Avg
                                                         Num    Comp    Comp
                                         Total   Total Still    Time    Time
Date               Application Priority   Open  Closed  Open    Open  Closed
--------- -------------------- -------- ------ ------- ----- ------- -------
01-APR-01 Manufacturing        Normal        0       2     0           26.06
01-APR-01 Financials           Normal        0       2     0           31.07
01-APR-01 Work-in-process      Normal        0       2     0           22.74
02-APR-01 Documentation        Normal        0       1     0           21.78
03-APR-01 Bill-of-materials    Low           0       1     0           41.01
03-APR-01 Bill-of-materials    Normal        0       1     0           26.09
04-APR-01 Bill-of-materials    Low           0       1     0           47.35
04-APR-01 Bill-of-materials    Normal        0       2     0           20.60
04-APR-01 Configuration        Normal        0       1     0           63.18
04-APR-01 Workflow             Low           0       2     0           20.70
05-APR-01 Manufacturing        Low           0       2     0           36.90
05-APR-01 Work-in-process      Normal        0       1     0            4.35