ID

number

No

Identifier; primary key.

NCALL_ID

varchar

40

No

Natural ID for the call.

RECEIVED_DAY_ID

varchar

40

No

Day the call was received; foreign key to ARF_TIME_DAY.ID.

RECEIVED_TIME_ID

number

No

Time the call was received; foreign key to ARF_TIME_TOD.ID.

CUSTOMER_ID

number

No

Customer involved in the call; foreign key to ARF_USER.ID.

AGENT_ID

varchar

40

No

Agent involved in the call; foreign key to ARF_IU_USER.ID.

END_DAY_ID

varchar

40

No

Day the call ended; foreign key to ARF_TIME_DAY.ID.

END_TIME_ID

number

No

Time the call ended; foreign key to ARF_TIME_TOD.ID.

TOTAL_CALL_TIME_SECONDS

number

No

Duration of the call in seconds.