Contents

I3PENETRATIONDATA Schema

This table contains the actual penetration data, specifically two rows per contact column (one for all values and one for unique values) plus one row per contact list to account for all contacts.

Column	Details	Description
UPLOADID	PK, FK, int, not null	Foreign key references I3PenetrationRange
RANGEID	PK, FK, int, not null	Foreign key references I3PenetrationRange
PENETRATIONTYPE	PK, nvarchar(80), not null	Whether it's for all contacts, a given contact column or a given unique contact column. Possible values include: Contacts, Phone Number, Unique Phone Number.
PENETRATIONSUBTYPE	PK, nvarchar(80), not null	Contains 'Total' or a phone number column. Possible values include: Total, Home, Mobile, Fax, etc.
PENETRATIONNAME	nvarchar(80), null	Optional name.
NUMBERITEMS	int, null	The number of uploaded items.