Person Destination

Package Name

Logical datamodel example


Example entity for the data mapper and merger functionality


BusinessEntityIDString11Primary key for Person records.
PersonTypeString11Primary type of person: SC = Store Contact, IN = Individual (retail) customer, SP = Sales person, EM = Employee (non-sales), VC = Vendor contact, GC = General contact
NameStyleBoolean110 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.
TitleString11A courtesy title. For example, Mr. or Ms.
FullNameString11First name of the person.
SuffixString11Surname suffix. For example, Sr. or Jr.
EmailPromotionString110 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from AdventureWorks, 2 = Contact does wish to receive e-mail promotions from AdventureWorks and selected partners.
AdditionalContactInfoString11Additional contact information about the person stored in xml format.
DemographicsString11Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
rowguidString11ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDateString11Date and time the record was last updated.

Display in diagrams

Linked elements

Logical datamodel example