USP_SIMPLEDATALIST_CHARITYCLAIMREFERENCENUMBERBYID

                CREATE procedure dbo.USP_SIMPLEDATALIST_CHARITYCLAIMREFERENCENUMBERBYID
                (
                    @CURRENTAPPUSERID uniqueidentifier
                )
                as
                    select
                        CHARITYCLAIMREFERENCENUMBER.ID as VALUE, 
                        case when CHARITYCLAIMREFERENCENUMBER.DESCRIPTION = '' then CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER
                             else CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER + coalesce(' - ' + min(CHARITYCLAIMREFERENCENUMBER.DESCRIPTION),'')
                        end as LABEL
                    from dbo.CHARITYCLAIMREFERENCENUMBER
                    where
                        -- Ensure the user has permission to at least one of the sites on the reference number

                        exists (select PERMISSIONGRANTED from dbo.UFN_APPUSER_HASPERMISSIONFORDECLARATION(@CURRENTAPPUSERID, CHARITYCLAIMREFERENCENUMBER.ID))
                    group by CHARITYCLAIMREFERENCENUMBER.ID,CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER,CHARITYCLAIMREFERENCENUMBER.DESCRIPTION
                    order by CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER