UserObject Profile Schema
An instance of this profile schema stores information about both registered and anonymous users. The Commerce Server 2000 User Import DTS Task extends and exports data into the Data Warehouse for properties with the Exported (Exp) attribute marked as True (1). The corresponding class in the Data Warehouse that the UserObject profiles are exported into is set via 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 |
logon_name
(Primary Key) |
Unicode String |
T | T | General Info |
Logon Name
User principle name (Commerce Server Business Desk/Partnerdesk 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 |
Email (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 | General 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 |