Share via


Address

The Address class stores user and organization addresses. By default, the User Profile Data Import Data Transformation Services (DTS) task imports profile data into this class.

Data Members

Data member name

Data type

Default value

Description

AddressName

nvarchar(255)

null

None.

AddressType

int

null

0 – Address

1 – ShipTo address

2 – BillTo address.

City

nvarchar(255)

null

None.

CountryCode

nvarchar(255)

null

Stores the country/region (ISO) code.

CountryName

nvarchar(255)

null

None.

DateCreated

datetime

null

None.

DateLastChanged

datetime

null

None.

FirstName

nvarchar(255)

null

Stores the first name of the user.

Id

uniqueidentifier

{00000000-0000-0000-0000-000000000000}

Stores the unique key for the object.

LastName

nvarchar(255)

null

Stores the last name of the user.

PostalCode

nvarchar(255)

null

Stores the postal or ZIP code.

RegionCode

nvarchar(255)

null

None.

RegionName

nvarchar(255)

null

Stores the state/province or country/region name.

TelephoneExtension

nvarchar(255)

null

None.

TelephoneNumber

nvarchar(255)

null

None.

Class Key

AddressKey is composed of a single data member, Id.

Relations

For a description of the relation type, see Data Warehouse Classes.

Relation name

Parent

Child

Type

AddressUserRel

Address

RegisteredUser

2

See Also

Other Resources

Data Warehouse Classes