Person.vAdditionalContactInfo

View: 'Person.vAdditionalContactInfo', Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person.

Field Name	Type and Size
ContactID	int identity NOT NULL
FirstName	Name NOT NULL
MiddleName	Name NULL
LastName	Name NOT NULL
TelephoneNumber	nvarchar(50) NULL
TelephoneSpecialInstructions	nvarchar(max) NULL
Street	nvarchar(50) NULL
City	nvarchar(50) NULL
StateProvince	nvarchar(50) NULL
PostalCode	nvarchar(50) NULL
CountryRegion	nvarchar(50) NULL
HomeAddressSpecialInstructions	nvarchar(max) NULL
EMailAddress	nvarchar(128) NULL
EMailSpecialInstructions	nvarchar(max) NULL
EMailTelephoneNumber	nvarchar(50) NULL
rowguid	uniqueidentifier NOT NULL
ModifiedDate	datetime NOT NULL