Lookup_Person

Lookup interface for the person in the example model of adventureworks demo

Package Example FormFactory entities
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 String 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.

Mappings

NameSourceSource attributeTargetTarget attribute
BusinessEntityID Lookup_PersonBusinessEntityIDPersonBusinessEntityID
PersonType Lookup_PersonPersonTypePersonPersonType
NameStyle Lookup_PersonNameStylePersonNameStyle
Title Lookup_PersonTitlePersonTitle
FirstName Lookup_PersonFirstNamePersonFirstName
LastName Lookup_PersonLastNamePersonLastName
Suffix Lookup_PersonSuffixPersonSuffix

Diagrams

FormFactory

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

Linked elements

Logical datamodel example