namespace RecruitmentDAL.Query.Integration
{
    public static class UserLookupQB
    {
        // Index: PK (USERID). MUSER is resolved on the caller's own tenant connection
        // (LoginDTO.DatabaseName) — no explicit ClientId/TenantId filter needed, same convention
        // already used by CRMDAL.Query.Call.CallQB.GET_USER_CONTACT_INFO and
        // ECPDAL.Meeting.QueryBuilders.MeetingQB's MUSER joins.
        public const string GET_USER_EMAIL = @"
            SELECT
                USERID     AS UserId,
                PRIMARYMAIL AS PrimaryMail
            FROM   MUSER
            WHERE  USERID = @UserId";
    }
}