Person

Copy from table to class by script

Package Logical datamodel example
Author Bert Dingemans
Alias --
Stereotypes --

Attributes

Name Type Cardinality Description
BusinessEntityID String 1 - 1Primary key for Person records.
PersonType String 1 - 1Primary 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 - 10 = 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 - 1A courtesy title. For example, Mr. or Ms.
FirstName String 1 - 1First name of the person.
MiddleName String 1 - 1Middle name or middle initial of the person.
LastName String 1 - 1Last name of the person.
Suffix String 1 - 1Surname suffix. For example, Sr. or Jr.
EmailPromotion String 1 - 10 = 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 - 1Additional contact information about the person stored in xml format.
Demographics String 1 - 1Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
rowguid String 1 - 1ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate String 1 - 1Date and time the record was last updated.

Mappings

NameSourceSource attributeTargetTarget attribute
BusinessEntityID PersonBusinessEntityIDPersonBusinessEntityID
PersonType PersonPersonTypePersonPersonType
NameStyle PersonNameStylePersonNameStyle
Title PersonTitlePersonTitle
FirstName PersonFirstNamePersonFirstName
MiddleName PersonMiddleNamePersonMiddleName
LastName PersonLastNamePersonLastName
Suffix PersonSuffixPersonSuffix
EmailPromotion PersonEmailPromotionPersonEmailPromotion
AdditionalContactInfo PersonAdditionalContactInfoPersonAdditionalContactInfo
Demographics PersonDemographicsPersonDemographics
rowguid PersonrowguidPersonrowguid
ModifiedDate PersonModifiedDatePersonModifiedDate
BusinessEntityID Lookup_PersonBusinessEntityIDPersonBusinessEntityID
PersonType Lookup_PersonPersonTypePersonPersonType
NameStyle Lookup_PersonNameStylePersonNameStyle
Title Lookup_PersonTitlePersonTitle
FirstName Lookup_PersonFirstNamePersonFirstName
LastName Lookup_PersonLastNamePersonLastName
Suffix Lookup_PersonSuffixPersonSuffix
AdditionalContactInfo Person DestinationAdditionalContactInfoPersonAdditionalContactInfo
BusinessEntityID Person DestinationBusinessEntityIDPersonBusinessEntityID
Demographics Person DestinationDemographicsPersonDemographics
EmailPromotion Person DestinationEmailPromotionPersonEmailPromotion
NameStyle Person DestinationNameStylePersonNameStyle
PersonType Person DestinationPersonTypePersonPersonType
FirstName Merger FullNameFirstNamePersonFirstName
LastName Merger FullNameLastNamePersonLastName
MiddleName Merger FullNameMiddleNamePersonMiddleName

Diagrams

Data Mapping

Data mapping is an example diagram of a data mapping in the IDEA implementation This implementation can be used in for example an ETL process but also for documenting the data flows and transformations in message transformation process or component.

FormFactory

Mapping example of formfactory entities connected via mappings to the logical entities in the example repository

Data modeling overview example

This diagram shows the associations via traces over the three modeling layers. It is thus an overview for the data modeling.

Logical model example project

--

Person User Interface

Example of a simple user interface generated by an IDEA script including the relevant mappings from the logical data model.

Data Mapper and Merger example

--

Linked elements

Conceptual datamodel example

Example FormFactory entities

Example of a User Interface

Logical datamodel example

Physical datamodel example