USP_DATALIST_WEALTHINFORMATIONDASHBOARDPHONENUMBERS

This datalist returns WealthPiont phone number information that is used by the wealth information dashboard.

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_DATALIST_WEALTHINFORMATIONDASHBOARDPHONENUMBERS
                (
                    @CONSTITUENTID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    declare @ISADMIN bit;
                    declare @APPUSER_IN_NONRACROLE bit;
                    declare @APPUSER_IN_NOSECGROUPROLE bit;

                    set @ISADMIN = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID);
                    set @APPUSER_IN_NONRACROLE = dbo.UFN_SECURITY_APPUSER_IN_NONRACROLE(@CURRENTAPPUSERID);
                    set @APPUSER_IN_NOSECGROUPROLE = dbo.UFN_SECURITY_APPUSER_IN_NO_SECURITY_GROUP_ROLE(@CURRENTAPPUSERID);

          declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                  select 
              dbo.UFN_PHONE_GETINTERNATIONALNUMBER(PHONE.COUNTRYID, PHONE.NUMBER) as NUMBER,
                            TYPE = (SELECT DESCRIPTION from dbo.PHONETYPECODE WHERE ID=PHONE.PHONETYPECODEID)
                            from
                                dbo.PHONE
                            where
                                PHONE.CONSTITUENTID = @CONSTITUENTID
                and (PHONE.ENDDATE IS NULL OR PHONE.ENDDATE >= @CURRENTDATE)
                and PHONE.ISPRIMARY = 0
                and PHONE.DONOTCALL = 0
                and PHONE.ISCONFIDENTIAL = 0
                              and (@ISADMIN = 1 or 
                                  @APPUSER_IN_NONRACROLE = 1 or
                                  dbo.UFN_SECURITY_APPUSER_GRANTED_CONSTITID_FORREPORT(@CURRENTAPPUSERID, CONSTITUENTID, @APPUSER_IN_NOSECGROUPROLE) = 1)                                
              order by TYPE