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 |