USP_SIMPLEDATALIST_CHARITYCLAIMREFERENCENUMBERQUERY

Returns a list of charity claim reference numbers with the VALUE column set to the row ID.

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_CHARITYCLAIMREFERENCENUMBERQUERY
                (
                    @CURRENTAPPUSERID uniqueidentifier
                )
                as
                    select
                        CHARITYCLAIMREFERENCENUMBER.ID as VALUE, 
                        CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER 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))
                    order by CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER