Address Profile Schema
An instance of this profile schema stores both user and organization addresses. The profile is mapped to the physical Addresses table. The Commerce Server 2002 User Import DTS Task extends and exports data into the Data Warehouse for properties with the Exported (Exp) attribute marked as True (1). The Data Warehouse class into which the Address profiles are exported is set through the DWClassName attribute of the Address profile, and defaults to Address. For information about the table entries, see Conventions.
| Property Name | Data Type |
Req | Exp | Group | Display Name/ Description |
| address_id
(primary and join key) |
GUID | T | T | General Info |
Address ID
Supplied by the system. Note that Commerce Server uses “{“ and “}” to surround GUID data types. |
| address_line1 | Unicode String |
T | F | General Info |
Address line 1 |
| address_line2 | Unicode String |
F | F | General Info |
Address line 2 |
| address_name | Unicode String |
F | T | General Info |
Address name |
| address_type | Integer | F | T | General Info |
Address type
0 – Address |
| city | Unicode String |
F | T | General Info |
City |
| country_code | Unicode String |
T | T | General Info |
Country/region (ISO) code |
| country_name | Unicode String |
F | T | General Info |
Country/region name |
| date_created | Date Time |
F | T | Profile System |
Date created
The default is getdate() |
| date_last_changed | Date Time |
F | T | Profile System |
Date last changed
The default is getdate() |
| description | Unicode String |
F | F | General Info |
Description |
| first_name | Unicode String |
F | T | General Info |
(User) first name |
| id | GUID | F | F | General Info |
ID of the organization/user to which this entry refers |
| last_name | Unicode String |
F | T | General Info |
(User) last name |
| locale | Integer | F | F | General Info |
Locale ID
Locale (character set) in which to render the address form |
| postal_code | Unicode String |
T | T | General Info |
Postal (ZIP) code |
| region_code | Unicode String |
T | T | General Info |
Country/region or state/province code |
| region_name | Unicode String |
F | T | General Info |
Country/region or state/province name |
| tel_extension | Unicode String |
F | T | General Info |
Telephone (number) extension |
| tel_number | Unicode String |
F | T | General Info |
Telephone number at this address |
| user_id_changed_by | Unicode String |
F | F | General Info |
Changed by
Person making the last change |
Copyright © 2005 Microsoft Corporation.
All rights reserved.