USP_DATALIST_CHARITYCLAIMREFERENCENUMBER

Returns a list of all charity claim information

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEFILTERMODE	tinyint	IN	Sites
@SITESSELECTED	xml	IN

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CHARITYCLAIMREFERENCENUMBER
                (
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null
                )
                as
                    set nocount on;

                    select distinct
                        CHARITYCLAIMREFERENCENUMBER.ID,
                        '' as SITE,
                        CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER,
                        CHARITYCLAIMREFERENCENUMBER.DESCRIPTION,
                        CHARITYCLAIMREFERENCENUMBER.CLASSIFICATION,
                        CHARITYCLAIMREFERENCENUMBER.WAITINGPERIOD,
                        (
                            select dbo.UDA_BUILDLIST(SITE.NAME)
                            from dbo.SITE
                                inner join dbo.CHARITYCLAIMREFERENCENUMBERSITE on CHARITYCLAIMREFERENCENUMBERSITE.SITEID = SITE.ID
                            where CHARITYCLAIMREFERENCENUMBERSITE.CHARITYCLAIMREFERENCENUMBERID = CHARITYCLAIMREFERENCENUMBER.ID
                        ) as SITES                        
                    from
                        dbo.CHARITYCLAIMREFERENCENUMBER
            left join dbo.CHARITYCLAIMREFERENCENUMBERSITE on CHARITYCLAIMREFERENCENUMBER.ID = CHARITYCLAIMREFERENCENUMBERSITE.CHARITYCLAIMREFERENCENUMBERID
                        left join SITE on SITE.ID = CHARITYCLAIMREFERENCENUMBERSITE.SITEID
                    where
                        dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, CHARITYCLAIMREFERENCENUMBERSITE.SITEID)=1 
                    order by
                        SITES