USP_SIMPLEDATALIST_CHARITYCLAIMREFERENCENUMBER

Returns a list of charity claim reference numbers.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_CHARITYCLAIMREFERENCENUMBER
                (
                    @CURRENTAPPUSERID uniqueidentifier
                ) 
                as
                    select distinct
                        CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER as VALUE, 
                        case when CHARITYCLAIMREFERENCENUMBER.DESCRIPTION = '' then CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER
                             else CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER + coalesce(' - ' + min(CHARITYCLAIMREFERENCENUMBER.DESCRIPTION),'')
                        end as LABEL
                    from dbo.CHARITYCLAIMREFERENCENUMBER
                    left join dbo.CHARITYCLAIMREFERENCENUMBERSITE CCRNS on CCRNS.CHARITYCLAIMREFERENCENUMBERID = CHARITYCLAIMREFERENCENUMBER.ID
                    left join dbo.SITE on CCRNS.SITEID = SITE.ID
                    where 
                        exists 
                        (
                            select 1 from dbo.UFN_APPUSER_HASPERMISSIONFORDECLARATION(@CURRENTAPPUSERID, CHARITYCLAIMREFERENCENUMBER.ID)
                        )
                    group by CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER, CHARITYCLAIMREFERENCENUMBER.DESCRIPTION
                    order by CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER