File
Contents: Contains information on each scheduled and completed
phone contact or telemarketing call.
The column
headings in the table include the following.
|
POSITION
|
FIELD NAME
|
TYPE
|
WIDTH
|
DEC
|
DESCRIPTION
|
|
1
|
CL_KEY
|
Character
|
9
|
N/A
|
Source key for the phone contact.
|
|
1
|
CALL_DATE
|
Date
|
8
|
N/A
|
Date call was made/Date call is scheduled
|
|
2
|
CUSTNUM
|
Numeric
|
10
|
N/A
|
Customer number.
|
|
3
|
SALES_ID
|
Character
|
3
|
N/A
|
Salesperson ID code.
|
|
4
|
SUMMARY
|
Memo
|
4
|
N/A
|
Detailed information of call.
|
|
5
|
SCRIPT
|
Character
|
2
|
N/A
|
RESERVED.
|
|
6
|
INTEREST
|
Numeric
|
2
|
N/A
|
Interest level of customer.
|
|
7
|
RATING
|
Numeric
|
2
|
N/A
|
Rating of call.
|
|
8
|
CALL_MADE
|
Logical
|
1
|
N/A
|
Identifies that this call was made.
|
|
9
|
TIME
|
Character
|
5
|
N/A
|
Time of call in HH:MM format.
|
|
10
|
DURATION
|
Numeric
|
5
|
N/A
|
Time (in minutes) that call took to
|
|
11
|
WHO
|
Character
|
15
|
N/A
|
Person contacted/to contact in this call.
|
|
12
|
EXTRACT
|
Character
|
35
|
N/A
|
First line of call detail.
|
|
13
|
STATE
|
Character
|
3
|
N/A
|
State identifier.
|
|
14
|
CONTACT_ID
|
Numeric
|
10
|
N/A
|
The system tracking number of the phone contact record.
|
|
15
|
CL_KEY
|
Character
|
9
|
N/A
|
Source key for the phone contact.
|
|
16
|
ENTRYTIME
|
Time
|
8
|
N/A
|
Date/Time of entry.
|
|
17
|
TELEMARK_ID
|
Integer
(Auto Increment)
|
4
|
N/A
|
RESEVED.
|
|
18
|
EVENT_ID
|
Numeric
|
10
|
N/A
|
RESERVED.
|
