USP_DATALIST_CONSTITUENTPROFILEDASHBOARDPHONES

                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDPHONES
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @ISVISIBLE bit = 1
                    )
                    as
                        set nocount on;

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

                        if @ISVISIBLE = 1
                        begin
                            select
                                dbo.UFN_PHONE_GETINTERNATIONALNUMBER(PHONE.COUNTRYID, PHONE.NUMBER) as NUMBER,
                                TYPE = (SELECT DESCRIPTION from dbo.PHONETYPECODE WHERE ID=PHONE.PHONETYPECODEID),
                                case when PHONE.ISPRIMARY = 1 then 'Yes' else 'No' end ISPRIMARY,
                                PHONE.DONOTCALL,
                                PHONE.STARTTIME,
                                PHONE.ENDTIME,
                                PHONE.STARTDATE,
                                PHONE.ENDDATE,
                                PHONE.SEASONALSTARTDATE,
                                PHONE.SEASONALENDDATE
                            from
                                dbo.PHONE
                            where
                                PHONE.CONSTITUENTID = @CONSTITUENTID
                                and (PHONE.ENDDATE IS NULL OR PHONE.ENDDATE >= @CURRENTDATE)
                            order by
                                PHONE.ISPRIMARY desc, TYPE;
                        end