Export (0) Print
Expand All

UserObject Profile Schema

Commerce Server 2002

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 NameData
Type
ReqExpGroupDisplay Name/
Description
user_id

(join key)

GUIDTTGeneral
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
TTGeneral
Info
Logon name

User principal name (Commerce Server Business Desk/Partner Desk sets to e-mail by default)

account_statusIntegerFTAccount
Info
Account status

Windows account status bitmask (including active/inactive)

date_createdDate
Time
FTProfile
System
Date created

The default is getdate()

date_last_changedDate
Time
FTProfile
System
Date changed

The default is getdate()

date_registeredDate
Time
FTAccount
Info
Date (and time) registered on the site
email_addressUnicode
String
FTGeneral
Info
E-mail (address)
fax_extensionUnicode
String
FFGeneral
Info
Fax (number) extension
fax_numberUnicode
String
FFGeneral
Info
Fax number
first_nameUnicode
String
FTGeneral
Info
First name
last_nameUnicode
String
FTGeneral
Info
Last name
org_idGUIDFFAccount
Info
Organization ID to which the user belongs
partner_desk_roleIntegerFFBusiness
Desk
PartnerDeskRoleFlags

Role ID for the user

tel_extensionUnicode
String
FFGeneral
Info
Telephone extension
tel_numberUnicode
String
FTGeneral
Info
Telephone number
user_catalog_setUnicode
String
FFAccount
Info
User catalog set
user_id_changed_byGUIDFFGeneral
Info
Changed by

Person making the last change

user_security_passwordUnicode
String
FFGeneral
Info
User password

To identify and authenticate the user

user_titleUnicode
String
FFGeneral
Info
User title

(For example, "Purchase Manager")

user_typeIntegerFTGeneral
Info
User type

0 = Anonymous
1 = Registered (default)

Copyright © 2005 Microsoft Corporation.
All rights reserved.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft