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