UserObject Profile Schema

Commerce Server 2007
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

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 2007 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.

ms961033.alert_note(en-US,CS.70).gifNote:

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

Show: