CONTACT_DIMENSION

The Contact dimension stores data about contacts.

Note:If the EMAIL of a contact is updated or a contact is upgraded to a user and a device was mapped to the contact, this will not be reflected in reporting until there is an update for the device.

Contact Dimension Columns

Columns	Type	Length	Description
ID	numeric	19	This is the primary key.
FIRSTNAME	nvarchar	150	First Name of the contact.
LASTNAME	nvarchar	150	Last Name of the contact.
PHONE	nvarchar	50	Phone number of the contact.
EMAIL	nvarchar	100	Email ID of the contact.
DISPLAYNAME	nvarchar	255	Display Name of the contact.
STREET_ADDRESS	nvarchar	3000	Street Address of the contact.
CITY	nvarchar	150	City of the contact.
COUNTRY	nvarchar	75	Country of the contact.
TENANT_ID	nvarchar	255	The tenant ID data for the contact.

Note: