Person Destination

Example entity for the data mapper and merger functionality

Name	Type	Cardinality	Description
BusinessEntityID	String	1 - 1	Primary key for Person records.
PersonType	String	1 - 1	Primary type of person: SC = Store Contact, IN = Individual (retail) customer, SP = Sales person, EM = Employee (non-sales), VC = Vendor contact, GC = General contact
NameStyle	Boolean	1 - 1	0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.
Title	String	1 - 1	A courtesy title. For example, Mr. or Ms.
FullName	String	1 - 1	First name of the person.
Suffix	String	1 - 1	Surname suffix. For example, Sr. or Jr.
EmailPromotion	String	1 - 1	0 = 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.
AdditionalContactInfo	String	1 - 1	Additional contact information about the person stored in xml format.
Demographics	String	1 - 1	Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
rowguid	String	1 - 1	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	String	1 - 1	Date and time the record was last updated.

Name	Source	Source attribute	Target	Target attribute
AdditionalContactInfo	Person Destination	AdditionalContactInfo	Person	AdditionalContactInfo
BusinessEntityID	Person Destination	BusinessEntityID	Person	BusinessEntityID
Demographics	Person Destination	Demographics	Person	Demographics
EmailPromotion	Person Destination	EmailPromotion	Person	EmailPromotion
NameStyle	Person Destination	NameStyle	Person	NameStyle
PersonType	Person Destination	PersonType	Person	PersonType
FullName	Merger FullName	FullName	Person Destination	FullName

Diagrams