UserObject Profile Schema
An instance of this profile schema stores information about both registered and anonymous users. 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 UserObject profiles are exported is set through the DWClassName attribute of the UserObject profile, and defaults to RegisteredUser. For information about the table entries, see Conventions.
| Property Name | Data Type |
Req | Exp | Group | Display Name/ Description |
| user_id
(join key) |
GUID | T | T | General Info |
User ID
Supplied by the system by default. Note that Commerce Server uses “{“ and “}” to surround GUID data types. |
| logon_name
(primary key) |
Unicode String |
T | T | General Info |
Logon name
User principal name (Commerce Server Business Desk/Partner Desk sets to e-mail by default) |
| account_status | Integer | F | T | Account Info |
Account status
Windows account status bitmask (including active/inactive) |
| date_created | Date Time |
F | T | Profile System |
Date created
The default is getdate() |
| date_last_changed | Date Time |
F | T | Profile System |
Date changed
The default is getdate() |
| date_registered | Date Time |
F | T | Account Info |
Date (and time) registered on the site |
| email_address | Unicode String |
F | T | General Info |
E-mail (address) |
| fax_extension | Unicode String |
F | F | General Info |
Fax (number) extension |
| fax_number | Unicode String |
F | F | General Info |
Fax number |
| first_name | Unicode String |
F | T | General Info |
First name |
| last_name | Unicode String |
F | T | General Info |
Last name |
| org_id | GUID | F | F | Account Info |
Organization ID to which the user belongs |
| partner_desk_role | Integer | F | F | Business Desk |
PartnerDeskRoleFlags
Role ID for the user |
| tel_extension | Unicode String |
F | F | General Info |
Telephone extension |
| tel_number | Unicode String |
F | T | General Info |
Telephone number |
| user_catalog_set | Unicode String |
F | F | Account Info |
User catalog set |
| user_id_changed_by | GUID | F | F | General Info |
Changed by
Person making the last change |
| user_security_password | Unicode String |
F | F | General Info |
User password
To identify and authenticate the user |
| user_title | Unicode String |
F | F | General Info |
User title
(For example, "Purchase Manager") |
| user_type | Integer | F | T | General Info |
User type
0 = Anonymous |
Copyright © 2005 Microsoft Corporation.
All rights reserved.