Share via


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
1 = Registered (default)

Copyright © 2005 Microsoft Corporation.
All rights reserved.