Share this page
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
