Person.vAdditionalContactInfo

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

Field NameType and Size
ContactIDint identity NOT NULL
FirstNameName NOT NULL
MiddleNameName NULL
LastNameName NOT NULL
TelephoneNumbernvarchar(50) NULL
TelephoneSpecialInstructionsnvarchar(max) NULL
Streetnvarchar(50) NULL
Citynvarchar(50) NULL
StateProvincenvarchar(50) NULL
PostalCodenvarchar(50) NULL
CountryRegionnvarchar(50) NULL
HomeAddressSpecialInstructionsnvarchar(max) NULL
EMailAddressnvarchar(128) NULL
EMailSpecialInstructionsnvarchar(max) NULL
EMailTelephoneNumbernvarchar(50) NULL
rowguiduniqueidentifier NOT NULL
ModifiedDatedatetime NOT NULL