USP_SIMPLEDATALIST_CONSTITUENTNAMEFORMATS

Returns a list of all formatted names for a given constituent.
Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
Definition

Copy


                CREATE procedure dbo.USP_SIMPLEDATALIST_CONSTITUENTNAMEFORMATS
                (
                    @CONSTITUENTID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier
                )
                as
                    set nocount on;

                    declare @ISORGANIZATION bit;
                    declare @ISGROUP bit;

                    select
                        @ISORGANIZATION = CONSTITUENT.ISORGANIZATION,
                        @ISGROUP = CONSTITUENT.ISGROUP
                    from
                        dbo.CONSTITUENT
                    where
                        CONSTITUENT.ID = @CONSTITUENTID;

                    if @ISORGANIZATION = 1 or @ISGROUP = 1
                    begin
                        select
                            CONSTITUENT.ID as VALUE,
                            CONSTITUENT.NAME as LABEL,
                            CONSTITUENT.NAME as DESCRIPTION
                        from
                            dbo.CONSTITUENT
                        where 
                            CONSTITUENT.ID = @CONSTITUENTID;
                    end
                    else
                    begin
                        select
                            NAMEFORMAT.ID as VALUE,
                            dbo.UFN_NAMEFORMATTYPECODE_GETDESCRIPTION(NAMEFORMAT.NAMEFORMATTYPECODEID) + ' - ' + NAMEFORMAT.FORMATTEDNAME as LABEL,
                            FORMATTEDNAME as DESCRIPTION
                        from
                            dbo.NAMEFORMAT
                        where
                            NAMEFORMAT.CONSTITUENTID = @CONSTITUENTID
                            and
                            (
                                NAMEFORMAT.SITEID is null
                                or dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, NAMEFORMAT.SITEID) = 1
                            )
                        order by
                            NAMEFORMAT.SEQUENCE;
                    end