Databases > WideWorldImporters > Tables > Application.People

WideWorldImporters

Application.People

People known to the application (staff, customer contacts, supplier contacts)

SYSTEM VERSIONED

Created: 6/2/2016 Modified: 6/2/2016

Columns

//

${escapify(column.description)}

PersonID

[int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[PersonID])
//

${escapify(column.description)}

FullName

[nvarchar](50) NOT NULL
//

${escapify(column.description)}

PreferredName

[nvarchar](50) NOT NULL
//

${escapify(column.description)}

SearchName

[nvarchar](101) NOT NULL
//

${escapify(column.description)}

IsPermittedToLogon

[bit] NOT NULL
//

${escapify(column.description)}

LogonName

[nvarchar](50) NULL
//

${escapify(column.description)}

IsExternalLogonProvider

[bit] NOT NULL
//

${escapify(column.description)}

HashedPassword

[varbinary](MAX) NULL
//

${escapify(column.description)}

IsSystemUser

[bit] NOT NULL
//

${escapify(column.description)}

IsEmployee

[bit] NOT NULL
//

${escapify(column.description)}

IsSalesperson

[bit] NOT NULL
//

${escapify(column.description)}

UserPreferences

[nvarchar](MAX) NULL
//

${escapify(column.description)}

PhoneNumber

[nvarchar](20) NULL
//

${escapify(column.description)}

FaxNumber

[nvarchar](20) NULL
//

${escapify(column.description)}

EmailAddress

[nvarchar](256) NULL
//

${escapify(column.description)}

Photo

[varbinary](MAX) NULL
//

${escapify(column.description)}

CustomFields

[nvarchar](MAX) NULL
//

${escapify(column.description)}

OtherLanguages

[nvarchar](MAX) NULL
LastEditedBy

[int] NOT NULL
ValidFrom

[datetime2](8) NOT NULL
ValidTo

[datetime2](8) NOT NULL

Indexes

PK_Application_People

UNIQUE CLUSTERED

PersonID
//

Allows quickly locating employees

IX_Application_People_IsEmployee

NONCLUSTERED

IsEmployee
//

Allows quickly locating salespeople

IX_Application_People_IsSalesperson

NONCLUSTERED

IsSalesperson
//

Improves performance of name-related queries

IX_Application_People_FullName

NONCLUSTERED

FullName
//

Improves performance of order picking and invoicing

IX_Application_People_Perf_20160301_05

NONCLUSTERED

IsPermittedToLogon , PersonID , FullName , EmailAddress

Foreign Keys

FK_Application_People_Application_People

Application.People

LastEditedBy ⥱ PersonID

Sample Data

PersonID

FullName

PreferredName

SearchName

IsPermittedToLogon

LogonName

IsExternalLogonProvider

HashedPassword

IsSystemUser

IsEmployee

IsSalesperson

UserPreferences

PhoneNumber

FaxNumber

EmailAddress

Photo

CustomFields

OtherLanguages

LastEditedBy

ValidFrom

ValidTo

Data Conversion Only

Data Conversion Only Data Conversion Only

NULL

NO LOGON

NULL

[varbinary]

NULL

{"theme":"blitzer","dateFormat":"yy-mm-dd","timeZone": "PST","table":{"pagingType":"full_numbers","pageLength": 25},"favoritesOnDashboard":true}

NULL

[varbinary]

NULL

5/31/2016 12/31/9999

Kayla Woodcock

Kayla

Kayla Kayla Woodcock

true

kaylaw@wideworldimporters.com

NULL

[varbinary]

true

{"theme":"humanity","dateFormat":"dd/mm/yy","timeZone": "PST","table":{"pagingType":"full","pageLength": 50},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

kaylaw@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Polish","Chinese","Japanese"] ,"HireDate":"2008-04-19T00:00:00","Title":"Team Member","PrimarySalesTerritory":"Plains","CommissionRate":"0.98"}

["Polish","Chinese","Japanese"]

5/31/2016 12/31/9999

Hudson Onslow

Hudson

Hudson Hudson Onslow

true

hudsono@wideworldimporters.com

NULL

[varbinary]

true

{"theme":"dark-hive","dateFormat":"DD, MM d, yy","timeZone": "PST","table":{"pagingType":"simple_numbers","pageLength": 10},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

hudsono@wideworldimporters.com

[varbinary]

{ "OtherLanguages": [] ,"HireDate":"2012-03-05T00:00:00","Title":"Team Member","PrimarySalesTerritory":"New England","CommissionRate":"3.62"}

[]

5/31/2016 12/31/9999

Isabella Rupp

Isabella

Isabella Isabella Rupp

true

isabellar@wideworldimporters.com

NULL

[varbinary]

true

NULL

{"theme":"ui-darkness","dateFormat":"dd/mm/yy","timeZone": "PST","table":{"pagingType":"simple","pageLength": 10},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

isabellar@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Turkish","Slovenian"] ,"HireDate":"2010-08-24T00:00:00","Title":"Team Member"}

["Turkish","Slovenian"]

5/31/2016 12/31/9999

Eva Muirden

Eva

Eva Eva Muirden

NULL

evam@wideworldimporters.com

NULL

[varbinary]

true

NULL

{"theme":"le-frog","dateFormat":"dd/mm/yy","timeZone": "PST","table":{"pagingType":"numbers","pageLength": 10},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

evam@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Lithuanian"] ,"HireDate":"2012-01-22T00:00:00","Title":"Team Member"}

["Lithuanian"]

5/31/2016 12/31/9999

Sophia Hinton

Sophia

Sophia Sophia Hinton

true

sophiah@wideworldimporters.com

NULL

[varbinary]

true

{"theme":"black-tie","dateFormat":"mm/dd/yy","timeZone": "PST","table":{"pagingType":"full_numbers","pageLength": 25},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

sophiah@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Swedish"] ,"HireDate":"2007-05-14T00:00:00","Title":"Team Member","PrimarySalesTerritory":"Southeast","CommissionRate":"4.55"}

["Swedish"]

5/31/2016 12/31/9999

Amy Trefl

Amy

Amy Amy Trefl

true

amyt@wideworldimporters.com

NULL

[varbinary]

true

{"theme":"ui-darkness","dateFormat":"mm/dd/yy","timeZone": "PST","table":{"pagingType":"full","pageLength": 50},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

amyt@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Slovak","Spanish","Polish"] ,"HireDate":"2009-02-15T00:00:00","Title":"Team Member","PrimarySalesTerritory":"Southeast","CommissionRate":"0.58"}

["Slovak","Spanish","Polish"]

5/31/2016 12/31/9999

Anthony Grosse

Anthony

Anthony Anthony Grosse

true

anthonyg@wideworldimporters.com

NULL

[varbinary]

true

{"theme":"blitzer","dateFormat":"mm/dd/yy","timeZone": "PST","table":{"pagingType":"simple_numbers","pageLength": 10},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

anthonyg@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Croatian","Dutch","Bokmål"] ,"HireDate":"2010-07-23T00:00:00","Title":"Team Member","PrimarySalesTerritory":"Mideast","CommissionRate":"0.11"}

["Croatian","Dutch","Bokmål"]

5/31/2016 12/31/9999

Alica Fatnowna

Alica

Alica Alica Fatnowna

true

alicaf@wideworldimporters.com

NULL

[varbinary]

true

NULL

{"theme":"humanity","dateFormat":"mm/dd/yy","timeZone": "PST","table":{"pagingType":"simple","pageLength": 10},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

alicaf@wideworldimporters.com

[varbinary]

{ "OtherLanguages": [] ,"HireDate":"2007-12-07T00:00:00","Title":"General Manager"}

[]

5/31/2016 12/31/9999

Stella Rosenhain

Stella

Stella Stella Rosenhain

true

stellar@wideworldimporters.com

NULL

[varbinary]

true

NULL

{"theme":"dark-hive","dateFormat":"mm/dd/yy","timeZone": "PST","table":{"pagingType":"numbers","pageLength": 10},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

stellar@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Dutch","Finnish","Lithuanian"] ,"HireDate":"2007-11-17T00:00:00","Title":"Warehouse Supervisor"}

["Dutch","Finnish","Lithuanian"]

5/31/2016 12/31/9999

Ethan Onslow

Ethan

Ethan Ethan Onslow

true

ethano@wideworldimporters.com

NULL

[varbinary]

true

NULL

{"theme":"ui-darkness","dateFormat":"yy-mm-dd","timeZone": "PST","table":{"pagingType":"full_numbers","pageLength": 25},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

ethano@wideworldimporters.com

[varbinary]

{ "OtherLanguages": [] ,"HireDate":"2011-12-17T00:00:00","Title":"Warehouse Supervisor"}

[]

5/31/2016 12/31/9999

Henry Forlonge

Henry

Henry Henry Forlonge

true

henryf@wideworldimporters.com

NULL

[varbinary]

true

NULL

{"theme":"le-frog","dateFormat":"dd/mm/yy","timeZone": "PST","table":{"pagingType":"full","pageLength": 50},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

henryf@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Greek","Slovak"] ,"HireDate":"2009-03-18T00:00:00","Title":"Team Member"}

["Greek","Slovak"]

5/31/2016 12/31/9999

Hudson Hollinworth

Hudson

Hudson Hudson Hollinworth

true

hudsonh@wideworldimporters.com

NULL

[varbinary]

true

{"theme":"black-tie","dateFormat":"DD, MM d, yy","timeZone": "PST","table":{"pagingType":"simple_numbers","pageLength": 10},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

hudsonh@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Croatian"] ,"HireDate":"2010-11-27T00:00:00","Title":"Team Member","PrimarySalesTerritory":"New England","CommissionRate":"0.24"}

["Croatian"]

5/31/2016 12/31/9999

Lily Code

Lily

Lily Lily Code

true

lilyc@wideworldimporters.com

NULL

[varbinary]

true

{"theme":"ui-darkness","dateFormat":"dd/mm/yy","timeZone": "PST","table":{"pagingType":"simple","pageLength": 10},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

lilyc@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Finnish","Bulgarian"] ,"HireDate":"2010-06-06T00:00:00","Title":"Team Member","PrimarySalesTerritory":"Southeast","CommissionRate":"3.98"}

["Finnish","Bulgarian"]

5/31/2016 12/31/9999

Taj Shand

Taj

Taj Taj Shand

true

tajs@wideworldimporters.com

NULL

[varbinary]

true

{"theme":"blitzer","dateFormat":"dd/mm/yy","timeZone": "PST","table":{"pagingType":"numbers","pageLength": 10},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

tajs@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Arabic","Greek"] ,"HireDate":"2009-03-14T00:00:00","Title":"Manager","PrimarySalesTerritory":"Far West","CommissionRate":"2.29"}

["Arabic","Greek"]

5/31/2016 12/31/9999

Archer Lamble

Archer

Archer Archer Lamble

NULL

archerl@wideworldimporters.com

NULL

[varbinary]

true

{"theme":"humanity","dateFormat":"mm/dd/yy","timeZone": "PST","table":{"pagingType":"full_numbers","pageLength": 25},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

archerl@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Greek"] ,"HireDate":"2009-05-13T00:00:00","Title":"Team Member","PrimarySalesTerritory":"Plains","CommissionRate":"1.88"}

["Greek"]

5/31/2016 12/31/9999

Piper Koch

Piper

Piper Piper Koch

true

piperk@wideworldimporters.com

NULL

[varbinary]

true

NULL

{"theme":"dark-hive","dateFormat":"mm/dd/yy","timeZone": "PST","table":{"pagingType":"full","pageLength": 50},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

piperk@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Romanian","Portuguese"] ,"HireDate":"2011-10-15T00:00:00","Title":"Manager"}

["Romanian","Portuguese"]

5/31/2016 12/31/9999

Katie Darwin

Katie

Katie Katie Darwin

true

katied@wideworldimporters.com

NULL

[varbinary]

true

NULL

{"theme":"ui-darkness","dateFormat":"mm/dd/yy","timeZone": "PST","table":{"pagingType":"simple_numbers","pageLength": 10},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

katied@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Estonian","Romanian"] ,"HireDate":"2008-07-12T00:00:00","Title":"Team Member"}

["Estonian","Romanian"]

5/31/2016 12/31/9999

Jai Shand

Jai

Jai Jai Shand

true

jais@wideworldimporters.com

NULL

[varbinary]

true

NULL

{"theme":"le-frog","dateFormat":"mm/dd/yy","timeZone": "PST","table":{"pagingType":"simple","pageLength": 10},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

jais@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Finnish","Dutch"] ,"HireDate":"2011-11-13T00:00:00","Title":"Team Member"}

["Finnish","Dutch"]

5/31/2016 12/31/9999

Jack Potter

Jack

Jack Jack Potter

true

jackp@wideworldimporters.com

NULL

[varbinary]

true

{"theme":"black-tie","dateFormat":"mm/dd/yy","timeZone": "PST","table":{"pagingType":"numbers","pageLength": 10},"favoritesOnDashboard":true}

(415) 555-0102

(415) 555-0103

jackp@wideworldimporters.com

[varbinary]

{ "OtherLanguages": ["Arabic"] ,"HireDate":"2009-05-29T00:00:00","Title":"General Manager","PrimarySalesTerritory":"Southeast","CommissionRate":"3.97"}

["Arabic"]

5/31/2016 12/31/9999

Reio Kabin

Reio

Reio Reio Kabin

NULL

NO LOGON

NULL

[varbinary]

NULL

{"theme":"ui-darkness","dateFormat":"yy-mm-dd","timeZone": "PST","table":{"pagingType":"full_numbers","pageLength": 25},"favoritesOnDashboard":true}

(847) 555-0100

(847) 555-0101

reio@adatum.com

[varbinary]

NULL

5/31/2016 12/31/9999

Oliver Kivi

Olly

Olly Oliver Kivi

NULL

NO LOGON

NULL

[varbinary]

NULL

{"theme":"blitzer","dateFormat":"dd/mm/yy","timeZone": "PST","table":{"pagingType":"full","pageLength": 50},"favoritesOnDashboard":true}

(847) 555-0100

(847) 555-0101

olly@adatum.com

[varbinary]

NULL

5/31/2016 12/31/9999

Hanna Mihhailov

Hanna

Hanna Hanna Mihhailov

NULL

NO LOGON

NULL

[varbinary]

NULL

{"theme":"humanity","dateFormat":"DD, MM d, yy","timeZone": "PST","table":{"pagingType":"simple_numbers","pageLength": 10},"favoritesOnDashboard":true}

(360) 555-0100

(360) 555-0101

hannam@contoso.com

[varbinary]

NULL

5/31/2016 12/31/9999

Paulus Lippmaa

Paulus

Paulus Paulus Lippmaa

NULL

NO LOGON

NULL

[varbinary]

NULL

{"theme":"dark-hive","dateFormat":"dd/mm/yy","timeZone": "PST","table":{"pagingType":"simple","pageLength": 10},"favoritesOnDashboard":true}

(360) 555-0100

(360) 555-0101

paulusl@contoso.com

[varbinary]

NULL

5/31/2016 12/31/9999

Kerstin Parn

Kerstin

Kerstin Kerstin Parn

NULL

NO LOGON

NULL

[varbinary]

NULL

{"theme":"ui-darkness","dateFormat":"dd/mm/yy","timeZone": "PST","table":{"pagingType":"numbers","pageLength": 10},"favoritesOnDashboard":true}

(415) 555-0100

(415) 555-0101

kerstin@consolidatedmessenger.com

[varbinary]

NULL

5/31/2016 12/31/9999