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