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