User

Prev Next

R365 user accounts and access settings, with one row per user.

Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructions.

Column reference

Column

Type

Description

tenant_id

NUMBER(38,0)

Customer's account identifier within the R365 platform.

id

VARCHAR

Unique identifier for the R365 platform user.

name

VARCHAR

User name.

first_name

VARCHAR

User's first name.

middle_name

VARCHAR

User's middle name.

last_name

VARCHAR

User's last name.

full_name

VARCHAR

Full display name of the R365 platform user.

nick_name

VARCHAR

User's nickname.

salutation

VARCHAR

User's salutation (Mr., Ms., Dr., etc.).

title

VARCHAR

User's title.

job_title

VARCHAR

User's job title.

internal_email_address

VARCHAR

Email address on record for the user.

mobile_alert_email

VARCHAR

Mobile alert email address.

domain_name

VARCHAR

Domain name associated with the user.

is_disabled

BOOLEAN

Flag indicating if the user account is disabled.

employee_id

VARCHAR

Employee identifier.

skills

VARCHAR

User's skills description.

is_available_to_all_locations

BOOLEAN

Flag indicating if user is available to all locations.

location_id

VARCHAR

Associated location identifier.

has_full_access

BOOLEAN

Flag indicating if user has full access.

is_available_to_all_external_locations

BOOLEAN

Flag indicating if user is available to all external locations.

created_on

TIMESTAMP_NTZ

Record creation timestamp.

created_by_id

VARCHAR

ID of user who created this record.

modified_on

TIMESTAMP_NTZ

Record modification timestamp.

modified_by_id

VARCHAR

ID of user who last modified this record.

is_deleted

BOOLEAN

Indicates whether this user account has been deactivated and is no longer in active use.

is_active

BOOLEAN

Flag indicating if the user is active (inverse of dm_inactive).