USP_APPUSER_GETAPPUSERINFO_FROM_ID

CREATE procedure dbo.USP_APPUSER_GETAPPUSERINFO_FROM_ID
(
  @ID uniqueidentifier
)
as
begin
  select
    APPUSER.ID,
    APPUSER.ISSYSADMIN,
    APPUSER.USERNAME,
    APPUSER.DISPLAYNAME,
    isnull(APPUSERTHIRDPARTYAUTH.INACTIVE, 0) as INACTIVE,
    APPUSER.EMAILADDRESS,
    coalesce(APPUSERCLAIMS.NAMEIDENTIFIER, APPUSERCLAIMSLINK.NAMEIDENTIFIER) [CLAIMSNAMEIDENTIFIER],
    isnull(APPUSER.ISACTIVE, 1) as ISACTIVE,
    APPUSER.LASTLOGINDATE,
    APPUSER.HASRUNASRIGHTS
  from dbo.APPUSER
    left join dbo.APPUSERTHIRDPARTYAUTH on APPUSER.ID = APPUSERTHIRDPARTYAUTH.ID
    left join dbo.APPUSERCLAIMS on APPUSERCLAIMS.APPUSERID = APPUSER.ID
    left join dbo.APPUSERCLAIMSLINK on APPUSER.ID = APPUSERCLAIMSLINK.APPUSERID
  where APPUSER.ID = @ID;

  return 0;
end