The ARF_CALL_MV view provides aggregated data about calls received by the Commerce Service Center. The calculated values are based on information in the ARF_CALL table. The values in each row are constrained to a particular day and customer service agent.

Column Name

Type

Length

Null Allowed

Description

NUM_CALLS

numeric

Yes

The number of customer service calls that correspond to the day and customer service agent. This value counts rows in the ARF_QUERY table.

DAY_ID

varchar

40

No

A reference to a value in the ARF_TIME_DAY.ID column.

DAY_TIMESTAMP

timestamp

No

A reference to a value in the ARF_TIME_DAY.DAY_TIMESTAMP column.

AGENT_ID

varchar

40

No

A reference to a value in the ARF_IU_USER.ID column.

TOTAL_CALL_TIME_SECONDS

numeric

Yes

The total length, in seconds, of the customer service calls for the day and customer service agent. This value sums ARF_QUERY.RESPONSE_TIME column values that correspond to the grouping column values.


Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices