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