dUser

Provides a record of all Users who have been part of or have had activity in a digital workplace. Adding a User to a digital workplace or changing an existing User's last name or email address will add a row to this table.

URL

/odata/dUser

Attributes

Name Data Type Connects to:
user_key Edm.Int32
Key Attributes
Name Data Type Description
first_name Edm.String A User's first name as found on their profile.
last_name Edm.String A User's last name as found on their profile.
source_system_id Edm.Guid A unique identifier for a User's account. 
email_address Edm.String

A User's unique email address.

If a user has entered a preferred email, this value will be that email rather than their account email. Both emails can be found in the member export.

row_active_date Edm.DateTimeOffset The date the User's account was created. 
row_inactive_date Edm.DateTimeOffset  The date the User's account disabled. A data of 9999-12-31 indicate that the account is still active. 
has_image Edm.Boolean TRUE if a custom image has been uploaded to their profile. FALSE if no image has been uploaded to their profile.
community_key Edm.Int32 A unique identifier for a digital workplace.
Table Attributes