Calling List Fields

[Tang]

Hi there,

We recently installed OCS 6.1. Pl. advice how to add fields to a calling list.. what are the steps to be followed in configmanger

[vic]

Do you mean custom fields?

[Tang]

Exactly it is userdefined fields to add to the existing fields.

[Macca]

I don't know if I'm answering your questions but ...

We create the tables manually using SQL scripts and then just add the user defined field definitions to the FIELDS section of Configuration Manager.

We then create a FORMAT definition in Configuration Manager containing all the required and user defined fields.

We then call this format when creating the Table Access.
An example of the SQL scipt would be :

create table [table name]
(
RECORD_ID NUMBER not null,
RECORD_TYPE NUMBER not null,
RECORD_STATUS NUMBER not null,
CAMPAIGN_ID NUMBER,
CHAIN_ID NUMBER not null,
CHAIN_N NUMBER not null,
PHONE_TYPE NUMBER not null,
PHONE VARCHAR2(64) not null,
ATTEMPT NUMBER not null,
AGENT_ID VARCHAR2(32),
CALL_RESULT NUMBER,
CALL_TIME NUMBER,
DAILY_FROM NUMBER not null,
DAILY_TILL NUMBER not null,
TZ_DBID NUMBER not null,
DIAL_SCHED_TIME NUMBER,
LODGE_INTERACT NUMBER not null,
LOAD_DATE DATE not null,
CONTACT_ID VARCHAR2(64) not null,
CONTACT_NAME VARCHAR2(255),
OPT_PLAN VARCHAR2(30),
OPT_MIGRATION VARCHAR2(30),
PLAYBACK VARCHAR2(30),
SMS VARCHAR2(30),
FFL VARCHAR2(30),
SEGMENT_TYPE VARCHAR2(30),
CALL_OUTCOME VARCHAR2(255)
)
tablespace DATA03;