Table: MASTER
This table contains all information specific to each contact.
Field Type Length Description
Entry Date
Text
8
This the date of initial entry into database
ID
Text
8
Contact ID#. Along with being the "Key" field, it is a relational field linked to the "Answers" and "Activity Updates" tables.
Company ID
Text
8
Contact's company number. It is a relational field linked to the "Answers" and "Activity Updates" tables.
SCompany ID
Text
8
Company ID by state
Operator
Text
3
Operator Initials
Change
Text
3
Not used
Delete Flag
Text
3
Yes if deleted
Reason
Text
23
Delete reason code/type for this contact
Change Date
Text
8
Date of Change
Mr.
Text
11
Mr./Mrs.
First
Text
25
First name
Last
Text
25
Last name
Sur
Text
5
Jr., Sr., II, III, etc.
Title
Text
45
Functional business title
Parent
Text
45
Holding/owning organization of the "Company"
Company
Text
45
Company name
Division
Text
45
Division name
Mailstop
Text
45
Mail stop
Address1
Text
45
Address
Address2
Text
45
Address
Address3
Text
45
Address
P. O. Box
Text
3
Yes if P. O. Box in Address3
City
Text
30
City
State
Text
2
State
ZIP
Text
10
ZIP code
Phone1
Text
14
Contact phone number
Ext1
Text
8
Contact phone extension
Phone2
Text
14
Contact phone number
Ext2
Text
8
Contact phone extension
Fax1
Text
14
Contact fax number
FaxExt1
Text
8
Contact fax number extension
Fax2
Text
14
Contact fax number
FaxExt2
Text
8
Contact fax number extension
E-mail
Text
40
E-mail address field
Source
Text
15
Source description of the original record
Merge Priority
Text
8
Priority used during duplicate elimination for the same contact from 2 or more sources
Source2
Text
15
Secondary source description of the original record
Type
Text
8
Type of contact: Customer, Prospect, Both, or blank
Program
Text
12
Fortune 2000, Seminar or blank
Region
Text
13
Region
Named Acct1
Text
3
Named Account
Site
Text
8
Key field to CI records (CISites2, CIModel)
Country
Text
30
Country
Foreign Phone
Text
20
Phone number if a foreign country
Internet
Text
40
Internet address
Source3
Text
25
Third source description of the original record
ListRec#
Text
8
Record key to original source
PrevID
Text
8
Previous ID if changed
Prev Company
Text
8
Previous CompanyID if changed
DupID
Text
8
ID of duplicate record in MasterDups
Reven
Text
6
Annual revenue
Rreven
Text
6
Complements Annual Revenue


Table: SOURCE
This table contains all source description of the original record.
Field Type Length Description
Source
Text
30
Source description of the original record

Table: CAMPAIGN PROMOTIONS
This table contains all Contact ID#s that received direct marketing promotions.
Field Type Length Description
ID
Text
8
Contact ID#. It is a relational field linked to the "Master" table
Batch
Text
3
Mail batch number
CompanyID
Text
8
Contact company number
DropDate
Date
8
The date when mail is dropped at post office
LetterDate
Date
8
The date on the actual letter
Process Date
Date
8
The date letters were processed


Table: RESPONDENTS
Prospects that have been contacted via telemarketing. These individuals have related records in the ANSWERS table.
Field Type Length Description
Seq
Num
6
Sequence Number
RKEY
Text
10
Indexed concatenation of survey code and respondent number
Spchecked
Text
3
Yes/No choice to identify whether a transcript has been spell-checked
D/EInitials
Text
2
Initials of data-entry personnel
Tminitials
Text
2
Initials of telemarketer
Site
Text
8
Unique identifier for the company from Master Table
Respondent
Text
8
Unique identifier for contact from Master Table
Leadterminaldigit
Num
1
Count of Activity Updates with Company ID = Site of this record
Hotlead
Text
3
Yes/No choice to identify hot leads
Entrydate
Text
8
Date of data-entry for transcript
Survey #
Text
2
Unique identifier for the survey that was conducted
Survey Name
Text
30
Title of Survey identified by Survey # - from Surveys Table
In Person
Text
3
Yes/No to identify whether or not person was interviewed in-person
Leadnumber
Text
10
Uniquely identifies lead - Concatenation of Respondent and LeadTerminalDigit
Prospect Text
Text
8
Virtual field for relational purposes
Newtext
Text
4
Identifies completed action of creating a new lead number
Newlead
Text
3
Yes/No choice for creating a new lead number
Add_Mod
Text
8
Latest date of addition or modification of record
Areyousure
Text
80
Textual field to ensure user wants to create a new lead number
Variable1
Text
1
Used for tabulation of responses
Variable2
Text
1
Used for tabulation of responses
Variable3
Text
1
Used for tabulation of responses
Variable4
Text
1
Used for tabulation of responses
Variable5
Text
1
Used for tabulation of responses
Variable6
Text
1
Used for tabulation of responses
Variable7
Text
1
Used for tabulation of responses
Variable8
Text
1
Used for tabulation of responses
Variable9
Text
1
Used for tabulation of responses
Variable10
Text
1
Used for tabulation of responses
Variable11
Text
1
Used for tabulation of responses
Variable12
Text
1
Used for tabulation of responses
Variable13
Text
1
Used for tabulation of responses
Variable14
Text
1
Used for tabulation of responses
Variable15
Text
1
Used for tabulation of responses


Table: SURVEYS
Survey name and number.
Field Type Length Description
Survey Name
Text
25
Title of Survey identified by Survey # - from Surveys Table
Survey #
Text
2
Unique identifier for the survey that was conducted


Table: ACTIVITY UPDATES
Log of activity associated with each contact.
Field Type Length Description
ID
Text
8
Contact ID#; it is a relational field linked to the Master table
Company ID
Text
8
Company ID, linked with Master table
Date
Text
8
Date of activity
Lead Number
Text
10
Concatenation of contact ID and a terminal digit
Comment of
Text
11
Comment by either the contact or the sales force
Company Name
Text
45
Name of company, look up from Master table
Last
Text
20
Contact Last name, look up from Master table
Long:C
Text
70
First line of comments
Long:C2
Text
70
Second line of comments
Long:C3
Text
70
Third line of comments
Long:C4
Text
70
Fourth line of comments
Long:C5
Text
70
Fifth line of comments
Long:C6
Text
70
Sixth line of comments
Long:C7
Text
70
Seventh line of comments
Long:C8
Text
70
Eighth line of comments
Rating
Text
1
"A," "B," or "C" rating
Rating2
Text
1
"1" lower range, "2" upper range
Status
Text
12
Undetermined, Active, etc.
for Reason
Text
1
Field used to ensure that all disqualified leads have reasons provided for their disqualification
Reason
Text
24
Reason for disqualification
Other Literature
Text
6
Literature Request number
Other Lit Fulfilled
Text
8
Date on which extra literature was fulfilled


Table: QUESTIONS
This table contains questions used in telemarketing.
Field Type Length Description
Keyfield
Text
6
Concatenation of survey code and question number
Add Mod
Text
8
Add/modify date
Question #
Text
3
The question number. This is related to the like field in the ANSWERS table
Question Ext
Text
1
Used for variations of same question
Survey Code
Text
2
Survey code number
Survey Name
Text
20
Name or survey conducted
Long: question
Text
46
Text field containing first line of question
Long: question2
Text
60
Text field containing second line of question
Long: question3
Text
60
Text field containing third line of question
Long: question4
Text
60
Text field containing fourth line of question
Long: question5
Text
60
Text field containing fifth line of question
Question Type
Text
35
Question type
Summary
Text
70
Text field containing summary of question, to display in answer record
A
Text
25
Text field containing first line of first response choice
A2
Text
25
Text field containing second line of first response choice
A3
Text
25
Text field containing third line of first response choice
B
Text
25
Text field containing first line of second response choice
B2
Text
25
Text field containing second line of second response choice
B3
Text
25
Text field containing third line of second choice
C
Text
25
Text field containing first line of third response choice
C2
Text
25
Text field containing second line of third response choice
C3
Text
25
Text field containing third line of third response choice
D
Text
25
Text field containing first line of fourth response choice
D2
Text
25
Text field containing second line of fourth response choice
D3
Text
25
Text field containing third line of fourth response choice
E
Text
25
Text field containing first line of fifth response choice
E2
Text
25
Text field containing second line of fifth response choice
E3
Text
25
Text field containing third line of fifth response choice
F
Text
25
Text field containing first line of sixth response choice
F2
Text
25
Text field containing second line of sixth response choice
F3
Text
25
Text field containing third line of sixth response choice
G
Text
25
Text field containing first line of seventh response choice
G2
Text
25
Text field containing second line of seventh response choice
G3
Text
25
Text field containing third line of seventh response choice
H
Text
25
Text field containing first line of eighth response choice
H2
Text
25
Text field containing second line of eighth response choice
H3
Text
25
Text field containing third line of eighth response choice
I
Text
25
Text field containing first line of ninth response choice
I2
Text
25
Text field containing second line of ninth response choice
I3
Text
25
Text field containing third line of ninth response choice


Table: ANSWERS
This table contains the respondents' answers to questions obtained during telemarketing.
Field Type Length Description
Survey Code
Num
2
Unique identifier for the survey that was conducted
RKey
Text
10
Indexed concatenation of survey code and respondent number
Respondent #
Num
8
Unique identifier for contact from Master
Site
Num
8
Unique identifier for the company from Master
Question #
Num
3
Identifier for Question (001, 002, 003, etc.)
Question Ext
Text
1
Question Extension (a, b, c, etc.)
Keyfield
Text
6
Concatenation of Survey Code, Question #, and Question Ext. - used for indexing questions
Respondent Key
Text
14
Concatenation of Respondent # and Keyfield - used for identifying a particular respondent's answers
Summary
Text
70
First line of question from Questions
Long:A1
Text
60
First line of transcript answer for this question
Long:A2
Text
60
Second line of transcript answer for this question
Long:A3
Text
60
Third line of transcript answer for this question
Long:A4
Text
60
Fourth line of transcript answer for this question
Long:A5
Text
60
Fifth line of transcript answer for this question
Code
Num
9
Used for tabulating responses to answers
Blank answer
Text
1
"X" if no answer or code is entered
Add Mod
Date
8
Latest date of addition or modification of record


Table: LEAD GENERATION
Members of the direct sales force and resellers teams to whom leads are distributed.
Field Type Length Description
ID
Text
8
Uniquely identifies contact from Master Table
Date
Text
8
Leads Distribution Date
Leadnumber
Text
15
Uniquely identifies lead from Respondents Table


Table: SALES DISTRIBUTION LIST
Members of the direct sales force and resellers teams to whom leads are distributed.
Field Type Length Description
Leadnumber
Text
10
Uniquely identifies lead from Respondents Table
ID
Text
8
Uniquely identifies contact from Master Table
Company ID
Text
8
Uniquely identifies company from Master Table
Add Mod
Date
8
Identifies changes or additions of records by date for export purposes
READYFORDISTRIBUTION
Text
17
"DISTRIBUTABLE" or "NOT DISTRIBUTABLE"
Assigned Choice
3
Defaulted Yes field
RDLOOKUP
Text
5
Regional Director, relationship lookup RDS name
REPLOOKUP
Text
5
Rep, relationship lookup rep name
TMLOOKUP
Text
5
TML, relationship lookup field
ADLOOKUP
Text
5
AD, relationship lookup field
VARLOOKUP
Text
5
VAR, relationship lookup field
TELCOLOOKUP
Text
5
TELCO, relationship lookup field
SILOOKUP
Text
5
SI, relationship lookup field
OEMLOOKUP
Text
5
OEM, relationship lookup field
VARMGRLOOKUP
Text
5
VARMGR, relationship lookup field
TELCOMGRLOOKUP
Text
5
TELCOMGR, relationship lookup field
SIMGRLOOKUP
Text
5
SIMGR, relationship lookup field
OEMMGRLOOKUP
Text
5
OEMMGR, relationship lookup field
NROLOOKUP
Text
5
NRO, relationship lookup field
C1
Text
5
Relational key to DistributionLibrary for RD
C2
Text
5
Relational key to DistributionLibrary for REP
C3
Text
5
Relational key to DistributionLibrary for IRM
C4
Text
5
Relational key to DistributionLibrary for AD
C5
Text
5
Relational key to DistributionLibrary for VAR
C6
Text
5
Relational key to DistributionLibrary for SI
C7
Text
5
Relational key to DistributionLibrary for TELCO
C8
Text
5
Relational key to DistributionLibrary for OEM
C52
Text
5
Relational key to DistributionLibrary for VARMGR
C62
Text
6
Relational key to DistributionLibrary for SIMGR
C72
Text
5
Relational key to DistributionLibrary for TELCOMGR
C82
Text
5
Relational key to DistributionLibrary for OEMMGR
RD
Text
40
RD Name
Rdphone
Text
14
RD Phone
Rdinternet
Text
45
RD Internet Address
Rdfax
Text
14
RD Fax
DistributeRD
Text
3
Yes/No choice to discern distributed entities
RedistributeRD
Text
3
Yes/No choice to discern redistributed entities
Repname
Text
40
REP Name
Repphone
Text
14
REP Phone
Repinternet
Text
45
REP Internet Address
Rep
Text
3
REP Number
Repfax
Text
14
REP Fax
DistributeRep
Text
3
Yes/No choice to discern distributed entities
RedistributeRep
Text
3
Yes/No choice to discern redistributed entities
AD
Text
40
AD Name
Adphone
Text
14
AD Phone
Adcontact
Text
45
AD Contact
Adfax
Text
14
AD Fax
Adinternet
Text
45
AD Internet Address
DistributeA/D
Text
3
Yes/No choice to discern distributed entities
RedistributeAD
Text
3
Yes/No choice to discern redistributed entities
VARContactID
Num
8
This is the VARContactID
VAR
Text
40
VAR Name
VARphone
Text
14
VAR Phone
VARContact
Text
45
VAR Contact
VARfax
Text
14
VAR Fax
VARinternet
Text
45
VAR Internet Address
DistributeVAR
Text
3
Yes/No choice to discern distributed entities
RedistributeVAR
Text
3
Yes/No choice to discern redistributed entities
ID2
Text
8
2ND PAGE ID - SAME AS ID
Company ID2
Text
8
2ND PAGE COMPANY ID - SAME AS COMPANY ID
Leadnumber2
Text
10
2ND PAGE LEADNUMBER - SAME AS LEADNUMBER
VARmgr
Text
40
VAR Manager Name
VARmgrphone
Text
14
VAR Manager Phone
VARmgrinternet
Text
45
VAR Manager Internet Address
VARmgrfax
Text
14
VAR Manager Fax
DistributeVARMGR
Text
3
Yes/No choice to discern distributed entities
RedistributeVARMGR
Text
3
Yes/No choice to discern redistributed entities
Telco
Text
40
TELCO Name
Telcophone
Text
14
TELCO Phone
Telcointernet
Text
45
TELCO Internet Address
Telcofax
Text
14
TELCO Fax
DistributeTELCO
Text
3
Yes/No choice to discern distributed entities
RedistributeTELCO
Text
3
Yes/No choice to discern redistributed entities
Telcomgr
Text
40
TELCO Manager Name
Telcomgrphone
Text
14
TELCO Manager Phone
Telcomgrinternet
Text
45
TELCO Manager Internet Address
Telcomgrfax
Text
14
TELCO Manager Fax
DistributeTELCOMGR
Text
3
Yes/No choice to discern distributed entities
RedistributeTELCOMGR
Text
3
Yes/No choice to discern redistributed entities
CC
Text
40
Addition rep for more than 1 rep names
CCPHONE
Text
14
Addition phone for more than 1 rep phone number
CCINTERNET
Text
45
Addition Internet for more than 1 Internet number
CCFAX
Text
14
Addition Fax for more than 1 Fax number
DISTRIBUTECC
Text
3
Addition yes/no to discern distributed entity
REDISTRIBUTECC
Text
3
Addition yes/no field to discern redistributed entity
SI
Text
40
SI Manager Name
Siphone
Text
14
SI Manager Phone
Siinternet
Text
45
SI Manager Internet Address
Sifax
Text
14
SI Manager Fax
DistributeSI
Text
3
Yes/No choice to discern distributed entities
RedistributeSI
Text
3
Yes/No choice to discern redistributed entities
SIMGR
Text
40
System Integrator Manager
SIMGRPHONE
Text
14
System Integrator Phone Number
SIMGRINTERNET
Text
45
System Integrator Internet Address
SIMGRFAX
Text
14
System Integrator Fax Number
DistributeSIMGR
Text
3
Yes/No choice to discern distributed entities
REDISTRIBUTESIMGR
Text
3
Yes, No, blank
OEM
Text
40
OEM Name
OEMphone
Text
14
OEM Phone
OEMinternet
Text
45
OEM Internet Address
OEMfax
Text
14
OEM Fax
DistributeOEM
Text
3
Yes/No choice to discern distributed entities
RedistributeOEM
Text
3
Yes/No choice to discern redistributed entities
OEMMgr
Text
40
OEM Name
OEMMgrphone
Text
14
OEM Phone
OEMMgrinternet
Text
45
OEM Internet Address
OEMMgrfax
Text
14
OEM Fax
DistributeOEMMGR
Text
3
Yes/No choice to discern distributed entities
RedistributeOEMMGR
Text
3
Yes/No choice to discern redistributed entities
NATIONALSALESMGR
Text
40
System Integrator Manager
NATSALESMGRPHONE
Text
14
System Integrator Phone Number
NATSALESMGRINTERNET
Text
45
System Integrator Internet Address
NATSALESMGRFAX
Text
14
System Integrator Fax Number
DistributeNATMGR
Text
3
Yes/No choice to discern distributed entities
REDISTRIBUTENATMGR
Text
3
Yes, No, blank
NRO
Text
40
National Reseller Organization
NROPHONE
Text
14
National Reseller Organization Phone Number
NROINTERNET
Text
45
National Reseller Organization Internet Address
NROFAX
Text
14
National Reseller Organization Fax Number
DISTRIBUTENRO
Text
3
Yes/No choice to discern NRO distributed entities
REDISTRIBUTENRO
Text
3
Yes/No choice to discern NRO redistributed entities
IRM
Text
40
IRM Name
IRMphone
Text
14
IRM Phone
IRMinternet
Text
45
IRM Internet Address
IRMfax
Text
14
IRM Fax
DistributeIRM
Text
3
Yes/No choice to discern distributed entities
RedistributeIRM
Text
3
Yes/No choice to discern redistributed entities
APAM
Text
45
Virtual lookup field, account manager and NRO has authorize
Long:Notes
Text
80
Notes - line 1
Long:Notes2
Text
80
Notes - line 2


Table: WIN/LOSS
This table contains all information specific to each contact.
Field Type Length Description
SEQ
Text
4
Record unique field
Add_Mod
Text
8
Add/Modify date
Date
Text
8
Date of Activity
WIN/LOSS
Text
4
WIN/LOSS choice field
Company ID
Text
8
Contact's company number. It is a relational field linked to the "Answers" and "Activity Updates" tables
LAST
Text
25
Lookup Last name field from Master table
COMPANY
Text
35
Lookup Company field from Master table
SALESFORCETYPE
Text
17
A choice field to determine whether a prospect/customer, VAR, Other
SALES3
Text
40
Lookup field from VAR Contacts table
STYPE
Text
10
Formulated field to determine the status: PROS/CUST or SALE
SALES2
Text
40
Lookup field, DISTRIBUTIONLIBRARY NAME
ACCORDINGTO
Text
12
If sales status not = blank then input "According to"
SALES
Text
40
Field calculation formula
1
Text
75
Answer for question #1. Whose product did they evaluate?
CODE
Text
5
Code field for question #1
2
Text
75
Answer for question #2. Whose product did they select?
CODE2
Text
5
Code field for question #2
3
Text
75
Answer for question #3. What was the dollar value of the purchase?
CODE3
Text
5
Code question #3, consist of : 1=Unknown 2=<$10K 3=$10K-$100K 4=$100-$500K 5=>$500K
LONG:4
Text
75
First answer field for question #4. What were the criteria on which the purchase decision was made?
LONG:42
Text
75
Second answer field for question #4
CODE4
Text
5
A code field for question #4.
1 = Applications fit - right product
2 = Price, price performance
3 = Existing relations, existing investment, it's the standard
4 = Ease of use
5 = Recommendations, word-of-mouth
6 = Special features
7 = Good support, local company
8 = Good product, reliable, quality, comfort
9 = Good work, good support by salesman
RATE PRICE
Text
2
A field allows a interviewee to rate the importance of "price" in the decision scale from 1-10
5
Text
75
Answer field for question #5.
Was the product perceived to be less expensive?
CODE5
Text
5
Code field for question #5. Choices indicate below:
1 = yes 2 = no Rate on 1 - 10 Scale:
RATE_FIT
Text
2
A field allows the interviewee to rate the importance of "fit with previous investments" in your decision on a 1-10 scale
6
Text
75
Answer field for question #6
CODE6
Text
5
Code field of question #6.
1 = yes 2 = no
RATE_FEATURES
Text
2
A field allows the interviewee to rate the importance of "features" in your decision on a 1-10 scale
7
Text
75
An answer field for question #7
CODE7
Text
5
A code field for question #7, including choices:
1 = yes 2 = no
RATE_RELIABILITY
Text
2
A field allows the interviewee to rate the importance of "reliability" in your decision on a 1-10 scale
8
Text
75
An answer field for question #8
CODE8
Text
5
A code field for question #8, including choices:
1 = yes 2 = no
RATE_STRENGTH
Text
2
A field allows the interviewee to rate the importance of "strength" in your decision on a 1-10 scale
9
Text
75
Answer field for question #9
CODE9
Text
5
Code field for question #9, including choices:
1 = yes 2 = no
10
Text
75
Answer field for question #10.
What sales channels were employed to make the sale?
CODE10
Text
5
A code field for question #10, including choices:
1 = Telco 2 = VAR 3 = Dist 4 = Manufacturer/direct/none
LONG:11
Text
75
First answer field for question #11
LONG:112
Text
75
Second answer field for question #11
LONG:113
Text
75
Third answer field for question #11
CODE11
Text
5
A code field for question #11
LONG:12
Text
75
First answer field for question #12.
Was there some action-or actions-that they took that won them the deal?
LONG:122
Text
75
Second answer field for question #12
LONG:13
Text
75
First answer field for question #13.
Was there some action/or actions that the losing vendor took that cost them the deal?
LONG:132
Text
75
Second answer field for question #13
CODE13
Text
5
Code field for question #13
LONG:14
Text
75
First answer field for question #14.
Who were all the decision makers (by title) that were involved in the decision making process?
LONG:142
Text
75
Second answer field for question #14
LONG:143
Text
75
Third answer field for question #14
CODE14
Text
5
Code field for question #14
15
Text
75
Answer field for question #15. What was the title of the final decision maker on the purchase?
CODE15
Text
5
Code field for question #15, consisting the following choices:
1 = CIO, IT Exec
2 = Networking Manager/Director
3 = Telecom Manager/Director
4 = Analysts, Supervisors, Etc.
5 = Other
LONG:C
Text
75
First comment field
LONG:C2
Text
75
Second comment field
LONG:C3
Text
75
Third comment field
LONG:C4
Text
75
Fourth comment field
LONG:C5
Text
75
Fifth comment field
LONG:C6
Text
75
Sixth comment field


Table: CI MODEL
This table contains computer hardware and software information provided by Computer Intelligence.
Field Type Length Description
xrecid
Text
2
Contact record ID
xsite
Text
8
Site ID
xclass
Text
3
Model class abbreviation
xmanuf
Text
11
Manufacturer
xmodel
Text
12
Model designation
xgroup
Text
12
Group designation
xseries
Text
12
Series designation
xdesc
Text
12
Description of model depending on class
xtype
Text
4
Type of model depending on class
xfeat
Text
4
Additional info/features of model
xkind
Text
2
More information about the model
xstatus
Text
1
Status
xacq
Text
1
Acquisition basis of model
xidate
Text
4
Date the model was installed or planned
xaltref
Text
2
Depending on class, contains link ID information
xlinks
Text
8
Model relationship
xinfo
Text
1
Class information
xfiller
Text
1
Blank space reserved for future use
xqid
Text
5
Question ID code
xfiller2
Text
1
Blank space
xupdate
Text
4
Most recent date information was updated
xfiller3
Text
1
Blank space
xqty
Text
5
Quantity of model
xremqty
Text
5
Quantity of model located remotely
xcapacity
Text
6
Capacity of this model
xmark
Text
1
* Indicates the end of record


Table: CI MODEL CLASS
This table is used for reporting only and uses the Class to obtain information for the reports.
Field Type Length Description
Class
Text
3
Same as CIModel class abbreviation
Description
Text
50
Description of this class
Model
Text
3
Yes if has a model description
Desc
Text
3
Yes if description only
RemQtyD
Text
50
Description, if used for this Class
CapacityD
Text
50
Description, if used for this Class


Table: PRODUCT INTEREST
Types of products in which the prospect is interested.
Field Type Length Description
Add_Mod
Text
8
Date of record add or last modification
ID
Text
8
Contact ID, from Master
Company ID
Text
8
Company ID, from Master
Date
Text
8
Date of entry of record
Lead Number
Text
10
Concatenation of contact ID and terminal digit
Business Unit
Text
25
SBU of product interest
Product
Text
30
Product category of interest
Quantity
Text
9
Quantity purchased
Product Price
Text
9
Price of product purchased
Expected Volume
Text
13
Total potential volume over two years
Comments of
Text
11
Is this based on the comments of prospect or the sales force/resellers?


Table: SEMINAR ACTIVITY
Information on prospect's interest in and attendance of seminars.
Field Type Length Description
Add Mod
Text
8
Date of record add or last modification
Contact ID
Text
8
ID number of contact (from Master)
Last
Text
30
Last name of contact (look up from Master)
Date of request
Text
8
Date contact requested literature on seminar
Requests Literature
Text
2
Type of literature requested
Date Literature Fulf
Text
8
Date on which literature was fulfilled by Mueller International
Seminar Date
Text
8
Date of seminar in which contact is interested (or attended, if "attended" = yes)
Seminar
Text
20
Name/location of seminar
Registered
Text
3
Is the contacted registered to go?
Confirmed
Text
9
Has the contact been confirmed? (Reminded?)
Attended
Text
3
Did the contact attend?
Long:b
Text
23
First line of company name for production of badges
Long:b2
Text
23
Second line of company name for production of badges
Company
Text
60
Name of company (look up from Master)
Long:C
Text
60
First line of comments
Long:C2
Text
60
Second line of comments
Long:C3
Text
60
Third line of comments
Long:C4
Text
60
Fourth line of comments
Classification
Text
6
Field to capture prospect's comments from seminar evaluation form
Industry
Text
30
Field to capture prospect's comments from seminar evaluation form
Low-Cost bandwidth
Text
2
Field to capture prospect's comments from seminar evaluation form
Connecting the Home
Text
2
Field to capture prospect's comments from seminar evaluation form
Multimedia
Text
2
Field to capture prospect's comments from seminar evaluation form
Current/Emerging Technology
Text
2
Field to capture prospect's comments from seminar evaluation form
Overall opinion
Text
70
Field to capture prospect's comments from seminar evaluation form
Most valuable
Text
70
Field to capture prospect's comments from seminar evaluation form
Least valuable
Text
70
Field to capture prospect's comments from seminar evaluation form
Could be improved
Text
70
Field to capture prospect's comments from seminar evaluation form
Involvement re: WAN
Text
3
Field to capture prospect's comments from seminar evaluation form
More information
Text
8
Field to capture prospect's comments from seminar evaluation form
Other
Text
40
Field to capture prospect's comments from seminar evaluation form
Channels
Text
5
Field to capture prospect's comments from seminar evaluation form
Other channels
Text
40
Field to capture prospect's comments from seminar evaluation form
Budget
Text
19
Field to capture prospect's comments from seminar evaluation form
Sales rep
Text
3
Field to capture prospect's comments from seminar evaluation form
Answered Survey
Text
3
Field to capture prospect's comments from seminar evaluation form
Comments
Text
65
Field to capture prospect's comments from seminar evaluation form
Entered as Lead
Text
3
Field to capture prospect's comments from seminar evaluation form


Table: DEALER MASTER
This table contains all information specific to each dealer contact.
Field Type Length Description
ID
Text
8
This is the Contact ID#. Along with being the "Key" field, it is a relational field linked to the "Answers" and "Activity Updates" tables
Company ID
Text
8
This is the contact's company number. It is a relational field linked to the "Answers" and "Activity Updates" tables
Gcompany ID
Text
8
Company ID by state
Mr.
Text
11
Mr./Mrs.
First
Text
35
First name
Last
Text
25
Last name
Sur
Text
5
Jr., Sr., II, III, etc.
Title
Text
45
Functional business title
Title2
Text
45
Functional business title
Company
Text
45
Company name
Company2
Text
45
Company name
Division
Text
45
Division name
Mailstop
Text
45
Mail stop
Address1
Text
50
Address
Address2
Text
45
Address
Address3
Text
45
Address
City
Text
30
City
State
Text
2
State
ZIP
Text
10
ZIP code
County
Text
40
County
Country
Text
30
Country
Phone1
Text
14
Contact phone number
Ext1
Text
8
Contact phone extension
Phone2
Text
14
Contact phone number
Ext2
Text
8
Contact phone extension
Int. Phone
Text
20
International phone number
Int. Phone2
Text
20
International phone number
Fax1
Text
14
Contact fax number
FaxExt1
Text
8
Contact fax number extension
Int. Fax
Text
20
Contact fax number extension
E-mail
Text
40
E-mail address field
Web site
Text
40
Web site address
Source
Text
30
Source description of the original record


Table: DEALER RESPONDENTS
Resellers that have been contacted via telemarketing.
Field Type Length Description
Seq
Text
6
Sequence Number
Respondent #
Text
8
Unique identifier for contact from Master Table
Entrydate
Date
8
Date of data-entry for transcript
Survey #
Text
2
Unique identifier for the survey that was conducted
Survey Name
Text
30
Title of Survey identified by Survey # - from Surveys Table
Leadnumber
Text
15
Uniquely identifies lead - Concatenation of Respondent and LeadTerminalDigit
RKEY
Text
10
Indexed concatenation of survey code and respondent number


Table: DEALER SURVEYS
Dealer survey name and number.
Field Type Length Description
Survey Name
Text
25
Title of Survey identified by Survey # - from Surveys Table
Survey #
Text
2
Unique identifier for the survey that was conducted


Table: DEALER ACTIVITY UPDATES
Log of activity associated with each reseller contact.
Field Type Length Description
CompanyID
Text
8
This is the Company ID#
Date
Date
8
Date of activity
Comments of
Text
15
Comment by either the contact or the sales force
Company Name
Text
35
Dealer company name
Status
Text
29
Current status
Long:C
Text
70
First line of comments
Long:C2
Text
70
Second line of comments
Long:C3
Text
70
Third line of comments
Long:C4
Text
70
Fourth line of comments
Long:C5
Text
70
Fifth line of comments
Long:C6
Text
70
Sixth line of comments
Long:C7
Text
70
Seventh line of comments
Long:C8
Text
70
Eighth line of comments
SpellCheck
Text
3
"Yes" or "No"


Table: DEALER QUESTIONS
This table contains questions used in telemarketing.
Field Type Length Description
Keyfield
Text
6
Concatenation of survey code and question number
Question #
Text
3
The question number. This is related to the like field in the ANSWERS table
Question Ext
Text
1
Used for variations of same question
Survey Code
Text
2
Survey code number
Survey Name
Text
20
Name or survey conducted
Long: question
Text
46
Text field containing first line of question
Long: question2
Text
60
Text field containing second line of question
Long: question3
Text
60
Text field containing third line of question
Long: question4
Text
60
Text field containing fourth line of question
Long: question5
Text
60
Text field containing fifth line of question


Table: DEALER ANSWERS
This table contains the dealer respondents' answers to questions obtained during telemarketing.
Field Type Length Description
Survey Code
Text
2
Unique identifier for the survey that was conducted
Respondent #
Text
8
Unique identifier for contact from Master
RKey
Text
10
Indexed concatenation of survey code and respondent number
Question #
Text
3
Identifier for Question (001, 002, 003, etc.)
QuestionExt
Text
1
Question Extension (a, b, c, etc.)
Keyfield
Text
6
Concatenation of Survey Code, Question #, and Question Ext. - used for indexing questions
Respondent Key
Text
14
Concatenation of Respondent # and Keyfield - used for identifying a particular respondent's answers
Long:A1
Text
60
First line of transcript answer for this question
Long:A2
Text
60
Second line of transcript answer for this question
Long:A3
Text
60
Third line of transcript answer for this question
Long:A4
Text
60
Fourth line of transcript answer for this question
Long:A5
Text
60
Fifth line of transcript answer for this question


Table: DEALER INFORMATION
This table contains reseller company information.
Field Type Length Description
CompanyID
Text
8
Dealer company ID
Company Name
Text
40
Dealer company name
Recommend
Text
3
Recommended
Approved
Text
3
Approved
Main/ Satellite
Text
1
Main Office or Satellite Office
YearStarted
Num
5
Years in Business
Regions/Territories
Text
70
Regions or Territories Covered
NumberEmps
Num
5
Total Number of Employees
OutsideSales
Num
5
Total Number of Outside Sales Employees
TechSupport
Num
5
Total Number of Technical Support Employees
CustService
Num
5
Total Number of Customer Service Employees
MainMarkets
Text
50
Main Markets Served or Targeted
MainMarket
Text
50
Same as Above
MainMarkets Code
Text
8
Code for Above
AnnualSales Total
Num
13
Total of Product Lines
CreditTerms
Text
40
Credit Terms and Limits
Payment Performance
Text
40
Payment Performance
Poor
Text
3
Poor Credit
Recent Credit Report
Text
45
Credit Report
Long:Special Problem
Text
70
Credit Problems
Long:Special Problem2
Text
70
Credit Problems
Long:Special Problem3
Text
70
Credit Problems
Long:Special Caps
Text
70
Special Capabilities
Long:Special Caps2
Text
70
Special Capabilities
Long:Special Caps3
Text
70
Special Capabilities
Long:Special Caps4
Text
70
Special Capabilities
GoodLocal Stock
Text
3
Do they keep a good local stock of all products
Stock Comments
Text
30
Comments of Above
Overall Technical
Num
2
Overall technical ability
Technical AbilityKey
Num
2
Technical ability of key contacts
Responsiveness
Num
2
Responsiveness to customer requests
AbilityTo Close
Num
2
Ability to close sales
LeadHandling Speed
Num
2
Speed of lead handling
Thoroughness
Num
2
Thoroughness of lead handling
Persistence
Num
2
Following up on leads
Business Develop
Num
2
Lead handling in terms of business development
Long: Additional
Text
70
Comments
Long: Additional2
Text
70
Comments
Long: Additional3
Text
70
Comments
Long: Additional4
Text
70
Comments
Long: Additional5
Text
70
Comments
Long: Additional6
Text
70
Comments
Long: Additional7
Text
70
Comments
Long: Additional8
Text
70
Comments
Long: Additional9
Text
70
Comments
Long: Additional10
Text
70
Comments
Long: Additional11
Text
70
Comments
Notes
Text
3
Notes
AK
Text
3
State Dealer Covers ( Yes or No )
AB
Text
3
State Dealer Covers ( Yes or No )
AL
Text
3
State Dealer Covers ( Yes or No )
BC
Text
3
State Dealer Covers ( Yes or No )
AR
Text
3
State Dealer Covers ( Yes or No )
MB
Text
3
State Dealer Covers ( Yes or No )
AZ
Text
3
State Dealer Covers ( Yes or No )
NB
Text
3
State Dealer Covers ( Yes or No )
CA
Text
3
State Dealer Covers ( Yes or No )
NF
Text
3
State Dealer Covers ( Yes or No )
CO
Text
3
State Dealer Covers ( Yes or No )
NS
Text
3
State Dealer Covers ( Yes or No )
CT
Text
3
State Dealer Covers ( Yes or No )
NT
Text
3
State Dealer Covers ( Yes or No )
DC
Text
3
State Dealer Covers ( Yes or No )
ON
Text
3
State Dealer Covers ( Yes or No )
DE
Text
3
State Dealer Covers ( Yes or No )
PQ
Text
3
State Dealer Covers ( Yes or No )
FL
Text
3
State Dealer Covers ( Yes or No )
SK
Text
3
State Dealer Covers ( Yes or No )
GA
Text
3
State Dealer Covers ( Yes or No )
YT
Text
3
State Dealer Covers ( Yes or No )
HI
Text
3
State Dealer Covers ( Yes or No )
ID
Text
3
State Dealer Covers ( Yes or No )
IL
Text
3
State Dealer Covers ( Yes or No )
IN
Text
3
State Dealer Covers ( Yes or No )
IA
Text
3
State Dealer Covers ( Yes or No )
KS
Text
3
State Dealer Covers ( Yes or No )
KY
Text
3
State Dealer Covers ( Yes or No )
LA
Text
3
State Dealer Covers ( Yes or No )
MA
Text
3
State Dealer Covers ( Yes or No )
MD
Text
3
State Dealer Covers ( Yes or No )
ME
Text
3
State Dealer Covers ( Yes or No )
MI
Text
3
State Dealer Covers ( Yes or No )
MN
Text
3
State Dealer Covers ( Yes or No )
MO
Text
3
State Dealer Covers ( Yes or No )
MS
Text
3
State Dealer Covers ( Yes or No )
MT
Text
3
State Dealer Covers ( Yes or No )
NC
Text
3
State Dealer Covers ( Yes or No )
ND
Text
3
State Dealer Covers ( Yes or No )
NE
Text
3
State Dealer Covers ( Yes or No )
NH
Text
3
State Dealer Covers ( Yes or No )
NJ
Text
3
State Dealer Covers ( Yes or No )
NM
Text
3
State Dealer Covers ( Yes or No )
NV
Text
3
State Dealer Covers ( Yes or No )
NY
Text
3
State Dealer Covers ( Yes or No )
OH
Text
3
State Dealer Covers ( Yes or No )
OK
Text
3
State Dealer Covers ( Yes or No )
OR
Text
3
State Dealer Covers ( Yes or No )
PA
Text
3
State Dealer Covers ( Yes or No )
RI
Text
3
State Dealer Covers ( Yes or No )
SC
Text
3
State Dealer Covers ( Yes or No )
SD
Text
3
State Dealer Covers ( Yes or No )
TN
Text
3
State Dealer Covers ( Yes or No )
TX
Text
3
State Dealer Covers ( Yes or No )
UT
Text
3
State Dealer Covers ( Yes or No )
VA
Text
3
State Dealer Covers ( Yes or No )
VI
Text
3
State Dealer Covers ( Yes or No )
VT
Text
3
State Dealer Covers ( Yes or No )
WA
Text
3
State Dealer Covers ( Yes or No )
WI
Text
3
State Dealer Covers ( Yes or No )
WV
Text
3
State Dealer Covers ( Yes or No )
WY
Text
3
State Dealer Covers ( Yes or No )
CountLeads
Num
6
Lead Count
GID
Text
8
Global ID


Table: Sales Conversion
This table contains data on the progress being made on sales conversion issues.
Field Type Length Description
SCI
Text
3
Asking for the Order
SC2
Text
3
Board of Directors Breakthrough
SC3
Text
3
Brand Recognition (Establishment of)
SC4
Text
3
Case Studies (Techniques for Handling)
SC5
Text
3
Collateral Fulfillment Programs
SC6
Text
3
Compensation Plans
SC7
Text
3
Competitive Selling Strategies
SC8
Text
3
Competitors' Sales Practices
SC9
Text
3
Continuous Sales Representative/Administrator Interface
SCI0
Text
3
Correct Distribution Channel
SCI1
Text
3
Customer References (Techniques for Handling)
SCI2
Text
3
Decision Maker Breakthrough
SCI3
Text
3
Decision Maker Identification
SCI4
Text
3
Defining the Optimum Selling Processes (Unique for Each Client)
SCI5
Text
3
Early Entry in the Sales Process
SCI6
Text
3
Early Prediction of New Markets
SCI7
Text
3
Establishing Market Leadership in Targeted Accounts
SCI8
Text
3
Executive Breakthrough Strategies (By Percentage)
SCI9
Text
3
Executive Presentations
SC20
Text
3
Handling the Gatekeepers (Administrators/Executive/Assistants/ Secretaries)
SC21
Text
3
Identification and Development of a Champion in the Account
SC22
Text
3
Identification and Development of Unique Selling Propositions
SC23
Text
3
Increasing the Value Proposition
SC24
Text
3
Information Gathering Processes for Proposal Preparation
SC25
Text
3
Making the Transition from Closing the Deal to Effective Delivery
SC26
Text
3
Market Awareness Programs
SC27
Text
3
Meeting Strategy Planning Sessions
SC28
Text
3
Mega Deal "SWAT Team" Approach
SC29
Text
3
On-site Proposal Managers
SC30
Text
3
Positioning (Creating New Brand Identities/Overcoming Established Brand Positions & Mindset)
SC31
Text
3
Pricing Programs
SC32
Text
3
Product Design (Feature, Function, Fit, Quality)
SC33
Text
3
Proper Sales Support Infrastructure
SC34
Text
3
Prospect Profiling and Needs Assessment
SC35
Text
3
Public Relations Programs
SC36
Text
3
Purchasing Dynamics and Organizational Flowcharts by Account
SC37
Text
3
Recruiting Plans, Programs and Requirements
SC38
Text
3
ROI Schedules/Cost Justifications
SC39
Text
3
Sales Training
SC40
Text
3
Scheduling Appointments
SC41
Text
3
Scheduling Next Steps
SC42
Text
3
Selling Process Planning Guides
SC43
Text
3
Selling/Presentation Aids
SC44
Text
3
Seminars/Events
SC45
Text
3
Single Account Penetration Programs
SC46
Text
3
Specifying and Driving the RFP Process
SC47
Text
3
Standards (Creating, Establishing, Adoption of)
SC48
Text
3
Taking Responsibility for What New Decision Makers Think
SC49
Text
3
Techniques for Getting Through Voice Mail
SC50
Text
3
Techniques to Reach Executives
SC51
Text
3
Win/Loss Analysis/Sales Optimization Actions



Back
Copyright © 1997-2005, Mueller International
Post Office Box 51386
Irvine, CA 92619
Telephone: (949) 851-7777
Facsimile: (800) 878-8524
webmaster@muellerinternational.com