USP_DATAFORMTEMPLATE_VIEW_PEOGETCMSUSERFROMPEOID

Parameters

Parameter	Parameter Type	Mode
@ID	nvarchar(max)	IN
@DATALOADED	bit	INOUT
@USERNAME	nvarchar(max)	INOUT
@EMAIL	nvarchar(max)	INOUT
@CLIENTUSERSID	int	INOUT
@CLIENTUSERSEXTENSIONID	uniqueidentifier	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PEOGETCMSUSERFROMPEOID
(
    @ID nvarchar(max),
    @DATALOADED bit = 0 output,
    @USERNAME nvarchar(max) = null output,
    @EMAIL nvarchar(max) = null output,
    @CLIENTUSERSID int = null output,
  @CLIENTUSERSEXTENSIONID uniqueidentifier = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that
    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
    -- will display a "no data loaded" message.
    select @DATALOADED = 1,
           @USERNAME = cu.UserName,
           @EMAIL = cu.EMail,
           @CLIENTUSERSID = cu.ID,
       @CLIENTUSERSEXTENSIONID = cue.ID
    from dbo.ClientUsers cu
  inner join dbo.ClientUsersExtension cue on cue.ClientUserID = cu.ID
    where cue.Identifier = convert(int,@ID) and cue.ProviderName='PatronEdgeOnline'

    return 0;