spLoadRecord_ClientUsers

            CREATE     PROCEDURE [dbo].[spLoadRecord_ClientUsers]
                    (
                        @PKID int
                    )
                AS
                BEGIN
                    set nocount on;

                    select     [ID], [Password], [UserName], [EMail], [Active], [LastName], [FirstName], [MiddleInitial], 
                            [InternalUser], [Guid], [Deleted], [ClientsID], 
                            [RegistrationNumber], [ReminderPhrase], [DateLastLogin], 
                            [NumFailedAttempts], [IsSupervisor], [MembershipRefreshedOn],  [IsProvisional],
                            [TimeZoneID], [CreateDate], [CreateID], [UpdateDate], [UpdateID], [LockedOutTime], [DefaultSiteID], [LinkedInProfileID],[LASTMFALOGINDATETIME],isnull(ISEMAILVERIFIED,0) as ISEMAILVERIFIED, isnull(ISGPCENABLED,0) as ISGPCENABLED
                    FROM [dbo].[ClientUsers] WHERE ID = @PKID;

                    select     BackOfficeRecordID BackOfficeID, 
                            BackOfficeSystemName [name], 
                        BackOfficeGuid [GUID],
                        BackOfficePeopleID,
                        BackOfficeSystemID
                    from [vwBackOfficeLinkedUsers] 
                    WHERE UserID=@PKID;
                END