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 - 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	String	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.
FirstName	String	1 - 1	First name of the person.
MiddleName	String	1 - 1	Middle name or middle initial of the person.
LastName	String	1 - 1	Last name of the person.
Suffix	String	1 - 1	Surname suffix. For example, Sr. or Jr.

Mappings

Name	Source	Source attribute	Target	Target attribute
BusinessEntityID	Lookup_Person	BusinessEntityID	Person	BusinessEntityID
PersonType	Lookup_Person	PersonType	Person	PersonType
NameStyle	Lookup_Person	NameStyle	Person	NameStyle
Title	Lookup_Person	Title	Person	Title
FirstName	Lookup_Person	FirstName	Person	FirstName
LastName	Lookup_Person	LastName	Person	LastName
Suffix	Lookup_Person	Suffix	Person	Suffix

Diagrams

FormFactory

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

Linked elements

Logical datamodel example

Person