USP_DATAFORMTEMPLATE_VIEW_TAXCLAIMELIGIBILITY

Returns a list of tax declaration eligibility for a given constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@DATE	datetime	IN	Date
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_TAXCLAIMELIGIBILITY (
                    @CONSTITUENTID uniqueidentifier,
                    @DATE datetime,
                    @CURRENTAPPUSERID uniqueidentifier = null
                ) as
                    set nocount on;

                    declare @count integer;    

                    select 
                        case  
                            when count(*) > 0 then 1
                            else 0
                        end as DECLARATIONSONFILE
                    from 
                        dbo.TAXDECLARATION
                    where 
                        TAXDECLARATION.CONSTITUENTID=@CONSTITUENTID and 
                        (
                            (DECLARATIONSTARTS <= @DATE and DECLARATIONENDS >= @DATE)
                            or (DECLARATIONSTARTS <= @DATE and DECLARATIONENDS is null)
                        ) and 
                        exists (select 1 from dbo.UFN_APPUSER_HASPERMISSIONFORDECLARATION(@CURRENTAPPUSERID, TAXDECLARATION.CHARITYCLAIMREFERENCENUMBERID))