MREQ_OPENED_CLOSED_BY_TYPE_D/M

The Reporting Meta Layer views MREQ_OPENED_CLOSED_BY_TYPE_D and MREQ_OPENED_CLOSED_BY_TYPE M provide summary information for request submission and completion activity, broken down by request type and by calendar day or month.

Use to assess daily or monthly request throughput, and to help indicate trends in request processing over time.

These views contain columns such as:

  • the net change in number of open requests during that day or month

  • the number of requests still open at the end of the day or month

  • the average time to completion, in days or months

for requests opened in that day or month and which have already been closed.

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

Sample

The following SQL query can be used as a basis for a report that summarizes all request submission and completion activity, per month, over a range of dates:

SELECT *
FROM   mreq_opened_closed_by_type_m
WHERE  activity_month BETWEEN '01-MAR-01' AND '01-APR-01'
ORDER BY activity_month;

To get a breakdown by day, replace activity_month and mreq_opened_closed_by_type_m with activity_date and mreq_opened_closed_by_type_d.

Results 

                                                                     Avg     Avg
                                                             Num    Comp    Comp
                                       Tot   Total     Net Still    Time    Time

REQUEST_TYPE_NAME          Month      Open  Closed  Change  Open    Open  Closed
------------------------------ --------- ----- ------- ------- ----- ------- ---
Customer Access            01-MAR-01    53      52       1     0     .07     .01
HR Job Requisition         01-MAR-01    16      17      -1     6   38.84   48.93
HR New Hire Process        01-MAR-01    13      10       3     1   40.35   25.61
Product Bug                01-MAR-01    83     232    -149    60    7.64  299.71
Product Patch              01-MAR-01     8       0       8     8
Purchase Request           01-MAR-01    18      24      -6     0   13.72    9.13
Services Work Order        01-MAR-01    17       3      14    17     .00   33.59
Training Approval Request  01-MAR-01   336     369     -33     9    8.46   19.59
Vacation Request           01-MAR-01   115      72      43    33   25.87   27.84
Customer Access            01-APR-01    15       6       9    12   11.63  150.55
HR Job Requisition         01-APR-01     5       6      -1     0     .81   36.94
HR New Hire Process        01-APR-01    27       6      21    27    9.87  255.96
Product Bug                01-APR-01    36      35       1     2     .21     .29
...

For more detailed request information filtered by common request header fields like Application, Department, Priority, and Assigned-to User, use the detail summary views MREQ_OPENED_CLOSED_BY_DETAIL_D and MREQ_OPENED_CLOSED_BY_DETAIL_M.