USP_DATALIST_TAXDECLARATION

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

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@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_TAXDECLARATION
                (
                    @CONSTITUENTID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null
                )
                as
                    set nocount on;

                    select
                        TAXDECLARATION.ID,
                        '' as SITE,
                        TAXDECLARATION.DECLARATIONSTARTS,
                        TAXDECLARATION.DECLARATIONENDS,
                        TAXDECLARATION.PAYSTAX,
                        TAXDECLARATION.DECLARATIONINDICATOR,
                        DECLARATIONSOURCECODE.DESCRIPTION as SOURCE,
                        TAXDECLARATION.DECLARATIONMADE,
                        TAXDECLARATION.CONFIRMATIONSENT,
                        TAXDECLARATION.CONFIRMATIONRETURNED,
                        TAXSTATUSCODE.DESCRIPTION as STATUS,
                        TAXDECLARATION.SCANNEDDOCSEXIST,
                        TAXDECLARATION.COMMENTS,
                        CHARITYCLAIMREFERENCENUMBER.REFERENCENUMBER,
                        CHARITYCLAIMREFERENCENUMBER.DESCRIPTION
                    from
                        dbo.TAXDECLARATION
                    inner join
                        dbo.CHARITYCLAIMREFERENCENUMBER
                    on
                        TAXDECLARATION.CHARITYCLAIMREFERENCENUMBERID = CHARITYCLAIMREFERENCENUMBER.ID
                    left join
                        dbo.DECLARATIONSOURCECODE
                    on
                        dbo.DECLARATIONSOURCECODE.ID = dbo.TAXDECLARATION.DECLARATIONSOURCECODEID
                    left join
                        dbo.TAXSTATUSCODE
                    on
                        dbo.TAXSTATUSCODE.ID = dbo.TAXDECLARATION.TAXSTATUSCODEID                        
                    where
                        CONSTITUENTID = @CONSTITUENTID and
                        (
                            exists (select PERMISSIONGRANTED from dbo.UFN_APPUSER_HASPERMISSIONFORDECLARATION(@CURRENTAPPUSERID, CHARITYCLAIMREFERENCENUMBER.ID))
                        )