UserObject Profile Schema
An instance of this profile schema stores information about both registered and anonymous users. The profile is mapped to the physical UserObject table. The Commerce Server Core Systems 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.
Note
Credit card IDs and address IDs are stored in a list within the UserObject. These lists have a default data type of nvarchar(255). To be able to store more than six, you will need to modify the size of these columns in the database and the maxlength property in the profile definition in Commerce Server Manager. You use Commerce Server Manager to maintain the profile definitions. In the left pane view expand Global resources, the Profiles for your site, the profile catalog and Profile Definitions until you get to the UserObject. In the right pane, under General Information, you will find the properties that you need to change. The maximum size for the profile properties are under custom attributes of the properties. If you have multiple copies of your site you will want to apply the same schema changes and profile changes to these other sites as well. You can also export the profile definition and import it into the other sites. The schema changes will have to be applied in both approaches
Property Name |
Data Type |
Req |
Exp |
Group |
Display Name/ Description |
|---|---|---|---|---|---|
user_id (primary key and join key) |
GUID |
T |
T |
GeneralInfo |
Unique ID of this user |
user_security_password |
Unicode String |
T |
F |
GeneralInfo |
Password of this user |
email_address |
Unicode String |
T |
T |
GeneralInfo |
E-mail address of this user |
preferred_address |
GUID |
F |
F |
GeneralInfo |
Name of preferred address from this user's address book |
address_list |
GUID |
F |
F |
GeneralInfo |
List of addresses associated with this user |
preferred_credit_card |
GUID |
F |
F |
GeneralInfo |
Name of preferred credit card from this user's credit card list |
credit_card_list |
GUID |
F |
F |
GeneralInfo |
List of credit cards associated with this user |
user_type |
Integer |
F |
T |
GeneralInfo |
Type of this user |
last_name |
Unicode String |
F |
T |
GeneralInfo |
Last name of this user |
first_name |
Unicode String |
F |
T |
GeneralInfo |
First name of this user |
tel_number |
Unicode String |
F |
T |
GeneralInfo |
Contact telephone number of this user |
tel_extension |
Unicode String |
F |
F |
GeneralInfo |
Contact telephone extension of this user |
fax_number |
Unicode String |
F |
F |
GeneralInfo |
Contact fax number of this user |
fax_extension |
Unicode String |
F |
F |
GeneralInfo |
Contact fax extension of this user |
language |
Unicode String |
F |
F |
GeneralInfo |
Language in which this user prefers to receive content |
password_question |
Unicode String |
T |
F |
GeneralInfo |
The question that will be asked if you forgot your password |
password_answer |
Unicode String |
T |
F |
GeneralInfo |
Answer to the password question specified by this user |
direct_mail_opt_out |
Boolean |
F |
F |
GeneralInfo |
Specifies the user's interest in direct mailings |
express_checkout |
Boolean |
F |
F |
GeneralInfo |
Species the user wants to use express checkout |
org_id |
GUID |
F |
F |
AccountInfo |
ID of the organization this user is associated with |
account_status |
Integer |
T |
F |
AccountInfo |
Status of this user's account |
user_catalog_set |
Unicode String |
F |
F |
AccountInfo |
Catalog set specific for the user |
date_registered |
Date Time |
F |
T |
AccountInfo |
Date and time the user registered on the site |
access_level |
Integer |
F |
F |
AccountInfo |
Active directory access level identifier for this user |
campaign_history |
Unicode String |
F |
F |
Advertising |
Campaign history for this user |
date_last_changed |
Date Time |
F |
T |
ProfileSystem |
Date that this user was last changed |
date_created |
Date Time |
F |
T |
ProfileSystem |
Date that this user was created |
user_id_changed_by |
GUID |
F |
F |
ProfileSystem |
ID of the user that last changed this address |
KeyIndex |
Integer |
F |
F |
ProfileSystem |
Key index for encryption |
date_last_password_changed |
Date Time |
F |
F |
ProfileSystem |
Date and time when the password was last changed by the user |
change_password |
Boolean |
F |
F |
ProfileSystem |
Flag that indicates whether user's password needs to be changed |
date_last_logon |
Date Time |
F |
F |
ProfileSystem |
Date and time of the last logon by this user |
logon_error_dates |
Unicode String |
F |
F |
ProfileSystem |
List of dates that logon errors occurred |
password_answer_error_dates |
Unicode String |
F |
F |
ProfileSystem |
List of dates that an incorrect password answer was entered |
csadapter_date_last_changed |
Date Time |
F |
F |
ProfileSystem |
Reserved for BizTalk adapter functionality |
application_name |
Unicode String |
F |
F |
ProfileSystem |
Application name |
last_activity_date |
Date Time |
F |
F |
ProfileSystem |
Last activity date |
last_lockedout_date |
Date Time |
F |
F |
ProfileSystem |
Date that this user was last locked out |
date_address_list_last_changed |
Date Time |
F |
F |
ProfileSystem |
Specifies the time that the address list was last changed |
date_credit_card_list_last_changed |
Date Time |
F |
F |
ProfileSystem |
Specifies the time that the credit card list was last changed |
user_live_id |
Unicode String |
T |
F |
GeneralInfo |
Unique ID provided by Windows Live ID Authentication. |
default_shopper_list |
GUID |
F |
F |
GeneralInfo |
Default Shopping List. |
preferred_shipping_method |
GUID |
F |
F |
GeneralInfo |
Preferred shipping method for this user. |