File Structure - Telemarketing Entries
File Name:
TELEMARK
File
Contents: Contains information on each scheduled and completed
phone contact or telemarketing call.
Table Legend
The column
headings in the table include the following.
-
Position - The ordinal
position of the field in the table.
-
Field Name - The column
name used in programming the information transferred. It serves to
classify data kept in this field.
-
Type - Can be one of 6
types:
Char - Text type data
Text- a field with a large character limit.
Numeric - numbers
Int- a whole number
Datetime - a date
Bit- a logical
field. 0=False, 1=True
-
Character Length- For
Character fields only. The maximum number of character that the
field element can occupy.
-
Numeric Precision - For
numeric fields only. The maximum length for a numeric value before
the radix point.
-
Numeric Scale- For
numeric fields only. The maximum length for a decimal value after
the radix point.
-
Description of Field - A
definition of the field's contents. RESERVED signifies for M.O.M.
use only. FUTURE USE signifies that the field may be used in a
future release. UK Only signifies a field used for the UK edition
of M.O.M.
|
POSITION
|
FIELD NAME
|
TYPE
|
CHARACTER LENTH
|
NUMERIC PRECISION
|
NUMERIC SCALE
|
DESCRIPTION
|
|
1
|
CALL_DATE
|
Datetime
|
N/A
|
23
|
3
|
Date call was made/Date call is scheduled
|
|
2
|
CUSTNUM
|
Numeric
|
N/A
|
10
|
0
|
Customer number.
|
|
3
|
SALES_ID
|
Char
|
N/A
|
3
|
0
|
Salesperson ID code.
|
|
4
|
SUMMARY
|
Text
|
2147483647
|
N/A
|
N/A
|
Detailed information of call.
|
|
5
|
SCRIPT
|
Char
|
2
|
N/A
|
N/A
|
RESERVED.
|
|
6
|
INTEREST
|
Numeric
|
N/A
|
2
|
0
|
Interest level of customer.
|
|
7
|
RATING
|
Numeric
|
N/A
|
2
|
0
|
Rating of call.
|
|
8
|
CALL_MADE
|
Logical
|
N/A
|
1
|
0
|
Identifies that this call was made.
|
|
9
|
CTIME
|
Char
|
5
|
N/A
|
N/A
|
Time of call in HH:MM format.
|
|
10
|
DURATION
|
Numeric
|
N/A
|
5
|
0
|
Time (in minutes) that call took to
|
|
11
|
WHO
|
Char
|
15
|
N/A
|
N/A
|
Person contacted/to contact in this call.
|
|
12
|
CEXTRACT
|
Char
|
35
|
N/A
|
N/A
|
First line of call detail.
|
|
13
|
STATE
|
Char
|
3
|
N/A
|
N/A
|
State identifier.
|
|
14
|
CONTACT_ID
|
Numeric
|
N/A
|
12
|
0
|
The system tracking number of the phone contact record.
|
|
15
|
CL_KEY
|
Char
|
9
|
N/A
|
N/A
|
Source key for the phone contact.
|
|
16
|
ENTRYTIME
|
Datetime
|
N/A
|
23
|
3
|
Date/Time of entry.
|
|
17
|
EVENT_ID
|
Numeric
|
N/A
|
10
|
0
|
RESERVED.
|
|
18
|
TELEMARK_ID
|
Numeric
|
N/A
|
18
|
0
|
RESERVED.
|
|
