Customer Contacts by Type - CI_​CUSTCN

Parameters

Parameter

Parameter Code

Description

Start Date

P_​FROM_​DT

Start date to use for reporting customer contacts. If not defined, the start date is set to the current date minus 7 days.

End Date

P_​TO_​DT

End date to use for reporting customer contacts. If not defined, End Date is set to the current date.

Customer Contact Class / Type

P_​CC_​TYPE_​CD

Specify a Customer Contact Class / Type to restrict the report output to a specific class / type.

Report Description

This report lists all customer contacts in the system created within the input date range. You may optionally restrict the report to customer contacts for a given Customer Contact Class / Type (parameter 3).

Note:

Graphs. The information on this report is shown in both textual and graphical formats.

Performance Consideration. If your implementation chooses to use this report, you may consider adding an index to the CI_​CC table on CC_​DTTM to aid in performance. When making this decision, carefully weigh the benefit of improving report performance against the possible degradation to the performance of day-to-day processing as a result of defining a new index. In addition, many companies opt to create a reporting database that is a shadow of production to ensure that indexes defined to benefit reports may be created without any affect on the production environment.