UFN_PEOCLIENTUSERS_GETIDFROMLINKEDUSERID

create function dbo.UFN_PEOCLIENTUSERS_GETIDFROMLINKEDUSERID(@UserID int)
returns int
with execute as caller
as begin

        DECLARE @PEORecordID  int
        select  TOP 1 @PEORecordID = cue.Identifier
        from dbo.ClientUsersExtension cue
        inner join dbo.ClientUsers cu on cue.ClientUserID = cu.ID
        where cu.ID = @UserID and cue.ProviderName='PatronEdgeOnline'

        return @PEORecordID

end