Open Cases By Type - CI_CSEOPN
Parameters
Parameter |
Parameter Code |
Description |
Start Date |
P_FROM_DT |
See the report's description for how this field is used. If start date is not specified, it is defaulted to 7 days prior to the end date. |
End Date |
P_TO_DT |
See the report's description for how this field is used. If end date is not specified, it is defaulted to the current processing date. |
Case Type |
P_CASE_TYPE_CD |
If specified, only cases of this type are included in the report. |
Responsible User |
P_CASE_OWNER |
If specified, only cases with this responsible user are included in the report. |
First Bucket High Limit |
P_B1_LIMIT |
Cases that are open for less than or equal to this number of days will be grouped together for statistical reporting. |
Second Bucket High Limit |
P_B2_LIMIT |
Cases that are open less than or equal to this number of days but more than the first bucket high limit will be grouped together for statistics reporting. |
Third Bucket High Limit |
P_B3_LIMIT |
Cases that are open less than or equal to this number of days but more than the second bucket high limit will be grouped together for statistics reporting. Cases that took more than this number of days are included in another group. |
Report Description
This is a report on open cases that were created between a given date range.
The report can be limited to a specific type and/or responsible user.
For each case type, the report shows the following:
- Number of open cases by age bucket (the last 3 parameters control the size (in days) of each bucket)
- Percentage of open cases by age bucket
- Details of the open cases