Table 774 User Details in 28

// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------

namespace System.Security.User;

using System.Security.AccessControl;

/// <summary>
/// Fetches user details information stored across multiple other tables.
/// </summary>
table 774 "User Details"
{
    Access = Public;
    Caption = 'User Details';
    DataClassification = SystemMetadata; // temporary table
    InherentEntitlements = X;
    InherentPermissions = X;
    TableType = Temporary;

    // Keeping field IDs aligned with the User table, so that transfer fields would work if at some point a page would switch source table from User to User Details
    fields
    {
        /// <summary>
        /// An ID that uniquely identifies the user.
        /// </summary>
        field(1; "User Security ID"; Guid)
        {
            Access = Internal;
        }
        /// <summary>
        /// User's name.
        /// </summary>
        field(2; "User Name"; Code[50])
        {
            Access = Internal;
            CalcFormula = lookup(User."User Name" where("User Security ID" = field("User Security ID")));
            Editable = false;
            FieldClass = FlowField;
        }
        /// <summary>
        /// User's full name.
        /// </summary>
        field(3; "Full Name"; Text[80])
        {
            Access = Internal;
            CalcFormula = lookup(User."Full Name" where("User Security ID" = field("User Security ID")));
            Editable = false;
            FieldClass = FlowField;
        }
        /// <summary>
        /// Specifies whether the user can access companies in the current environment.
        /// </summary>
        field(4; State; Option)
        {
            Access = Internal;
            CalcFormula = lookup(User.State where("User Security ID" = field("User Security ID")));
            Editable = false;
            FieldClass = FlowField;
            OptionCaption = 'Active,Inactive';
            OptionMembers = Enabled,Disabled;
        }
        /// <summary>
        /// The authentication email of the user.
        /// </summary>
        field(11; "Authentication Email"; Text[250])
        {
            Access = Internal;
            CalcFormula = lookup(User."Authentication Email" where("User Security ID" = field("User Security ID")));
            Editable = false;
            FieldClass = FlowField;
        }
        /// <summary>
        /// The contact email of the user.
        /// </summary>
        field(14; "Contact Email"; Text[250])
        {
            Access = Internal;
            CalcFormula = lookup(User."Contact Email" where("User Security ID" = field("User Security ID")));
            Editable = false;
            FieldClass = FlowField;
        }
        /// <summary>
        /// An ID that uniquely identifies the user for the purposes of sending telemetry.
        /// </summary>
        field(21; "Telemetry User ID"; Guid)
        {
            Access = Internal;
            CalcFormula = lookup("User Property"."Telemetry User ID" where("User Security ID" = field("User Security ID")));
            Caption = 'Telemetry ID';
            Editable = false;
            FieldClass = FlowField;
        }
        /// <summary>
        /// An ID assigned to the user in Microsoft Entra.
        /// </summary>
        field(22; "Authentication Object ID"; Text[80])
        {
            Access = Internal;
            CalcFormula = lookup("User Property"."Authentication Object ID" where("User Security ID" = field("User Security ID")));
            Caption = 'Entra Object ID';
            Editable = false;
            FieldClass = FlowField;
        }
        /// <summary>
        /// True if the user SUPER permission set in any company, false otherwise.
        /// </summary>
        field(23; "Has SUPER permission set"; Boolean)
        {
            Access = Internal;
            CalcFormula = exist("Access Control" where("User Security ID" = field("User Security ID"),
                                                  "Role ID" = const('SUPER'),
                                                  Scope = const(System),
                                                  "App ID" = const('{00000000-0000-0000-0000-000000000000}')));
            Editable = false;
            FieldClass = FlowField;
        }
    }

    keys
    {
        key(Key1; "User Security ID")
        {
            Clustered = true;
        }
    }

    fieldgroups
    {
        fieldgroup(DropDown; "User Name")
        {
        }
    }
}