USP_DATALIST_CONSTITUENTPROFILEDASHBOARDHEADER

                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDHEADER
                    (
                        @CONSTITUENTID uniqueidentifier
                    )
                    as
                        set nocount on;

                        select 
                            NF.NAME,
                            dbo.UFN_BUILDFULLADDRESS(a.ID, a.ADDRESSBLOCK, a.CITY, a.STATEID, a.POSTCODE, a.COUNTRYID) ADDRESS,
                            dbo.UFN_PHONE_GETINTERNATIONALNUMBER(p.COUNTRYID, p.NUMBER) as NUMBER,
                            e.EMAILADDRESS,
                            gd.DESCRIPTION as GROUPDESCRIPTION,
                            gt.NAME as GROUPTYPENAME,
                            case 
                                when GD.GROUPTYPECODE = 0 then cast(dbo.UFN_INSTALLATIONINFO_GETHOUSEHOLDSCANBEDONORS() as bit)
                                else GT.CANBEDONOR 
                            end as GROUPCANBEDONOR,
                            case 
                                when GD.GROUPTYPECODE = 0 then cast(1 as bit)
                                else gt.INCLUDEMEMBERGIVING 
                            end as GROUPINCLUDEMEMBERGIVING,
                            case
                                when DG.ID is null then 'No'
                                else 'Yes'
                            end as GROUPISDISSOLVED
                        from
                            dbo.CONSTITUENT c
                        left outer join dbo.ADDRESS a
                            on c.ID = a.CONSTITUENTID
                            and a.ISPRIMARY = 1
                        left outer join dbo.PHONE p
                            on c.ID = p.CONSTITUENTID
                            and p.ISPRIMARY = 1
                        left outer join dbo.EMAILADDRESS e
                            on c.ID = e.CONSTITUENTID
                            and e.ISPRIMARY = 1
                        left outer join dbo.GROUPDATA gd
                            on c.ID = gd.ID
                        left outer join dbo.GROUPTYPE gt
                            on gd.GROUPTYPEID = gt.ID
                        left outer join dbo.DISSOLVEDGROUP dg
                            on dg.ID = c.ID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(C.ID) NF
                        where
                            c.ID = @CONSTITUENTID;