USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTFUNDSRECEIVEDPAGEDATA

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(400)	INOUT
@ISINACTIVE	bit	INOUT
@DECEASED	bit	INOUT
@ISSELF	bit	INOUT
@ISORG	bit	INOUT
@ISPROSPECT	bit	INOUT
@ISFORMERPROSPECT	bit	INOUT
@ISFUNDRAISER	bit	INOUT
@ISFORMERFUNDRAISER	bit	INOUT
@ISVOLUNTEER	bit	INOUT
@ISFORMERVOLUNTEER	bit	INOUT
@ISCOMMUNITYMEMBER	bit	INOUT
@ISREGISTRANT	bit	INOUT
@ISVENDOR	bit	INOUT
@APPUSERID	uniqueidentifier	INOUT
@ATTRIBUTEDEFINED	bit	INOUT
@SMARTFIELDDEFINED	bit	INOUT
@UPDATEPENDING	bit	INOUT
@CONSTITUENTID	uniqueidentifier	INOUT
@HASSPOUSE	bit	INOUT
@AGE	int	INOUT
@ISALUMNUS	bit	INOUT
@ISSTUDENT	bit	INOUT
@ISFORMERSTUDENT	bit	INOUT
@VALIDSEARCHCRITERIASTRICT	bit	INOUT
@VALIDSEARCHCRITERIARELAXED	bit	INOUT
@EDUCATIONATTRIBUTEDEFINED	bit	INOUT
@ISGROUPMEMBER	bit	INOUT
@ISGROUP	bit	INOUT
@GROUPCANBEDONOR	bit	INOUT
@CURRENTMEMBERCOUNT	int	INOUT
@PREVIOUSMEMBERCOUNT	int	INOUT
@HASCOMMUNITYDATA	bit	INOUT
@ISHOUSEHOLD	bit	INOUT
@HOUSEHOLDID	uniqueidentifier	INOUT
@MAPPINGCREDENTIALSEXIST	bit	INOUT
@HASSTEWARDSHIPPLAN	bit	INOUT
@DECEASINGOPTIONSSET	bit	INOUT
@ISDISSOLVED	bit	INOUT
@SPOUSERELATIONSHIPID	uniqueidentifier	INOUT
@ISPLANNEDGIVER	bit	INOUT
@ISPATRON	bit	INOUT
@ISBANK	bit	INOUT
@HASIND2ORGRELATIONS	bit	INOUT
@ISCOMMITTEE	bit	INOUT
@ISGRANTOR	bit	INOUT
@ISSPONSOR	bit	INOUT
@SPONSORTYPECODE	tinyint	INOUT
@ISCOMMITTEEMEMBER	bit	INOUT
@HASMULTIPLEMGCONDITIONS	bit	INOUT
@ISFACULTY	bit	INOUT
@ISCONSTITUENT	bit	INOUT
@CANBEDONOR	bit	INOUT
@ISFORMERSPONSOR	bit	INOUT
@USER_GRANTED_IND_TO_IND_REL_ADD_FOR_CONSTIT	bit	INOUT
@USER_GRANTED_CONSTITNOTENOTIFICATION_ADD	bit	INOUT
@USER_GRANTED_CONSTITNOTENOTIFICATION_EDIT	bit	INOUT
@USER_GRANTED_CONSTITNOTE_ADD	bit	INOUT
@USER_GRANTED_CONSTITMEDIALINK_ADD	bit	INOUT
@USER_GRANTED_CONSTITATTACHMENT_ADD	bit	INOUT
@USER_GRANTED_CONSTITNOTE_EDIT_2	bit	INOUT
@USER_GRANTED_CONSTITMEDIALINK_EDIT	bit	INOUT
@USER_GRANTED_CONSTITATTACHMENT_EDIT	bit	INOUT
@USER_GRANTED_CONSTITATTACHMENT_VIEW	bit	INOUT
@USER_GRANTED_ADDRESS_GEOCODE	bit	INOUT
@USER_GRANTED_CONSTITNOTENOTIFICATION_DELETE	bit	INOUT
@USER_GRANTED_CONSTITNOTE_DELETE	bit	INOUT
@USER_GRANTED_CONSTITMEDIALINK_DELETE	bit	INOUT
@USER_GRANTED_CONSTITATTACHMENT_DELETE	bit	INOUT
@USER_GRANTED_ADDRESS_DELETE_FOR_CONSTIT	bit	INOUT
@USER_GRANTED_CONSTITUENT_MAPENTITY	bit	INOUT
@MARRIAGERULESSET	bit	INOUT
@ISADVOCATE	bit	INOUT
@HASRECEIVEDFUNDS	bit	INOUT
@ADDRESSATTRIBUTEDEFINED	bit	INOUT
@ISFAFREGISTRANT	bit	INOUT
@VIEWREVENUETEXTLINKTEXT	varchar(25)	INOUT
@USER_GRANTED_CONSTITPERSONALINFO_EDIT	bit	INOUT

Definition

Copy


                create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTFUNDSRECEIVEDPAGEDATA
                (
                    @ID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(400) = null output,
                    @ISINACTIVE bit = null output,
                    @DECEASED bit = null output,
                    @ISSELF bit = null output,
                    @ISORG bit = null output,
                    @ISPROSPECT bit = null output,
                    @ISFORMERPROSPECT bit = null output,
                    @ISFUNDRAISER bit = null output,
                    @ISFORMERFUNDRAISER bit = null output,
                    @ISVOLUNTEER bit = null output,
                    @ISFORMERVOLUNTEER bit = null output,
                    @ISCOMMUNITYMEMBER bit = null output,
                    @ISREGISTRANT bit = null output,
                    @ISVENDOR bit = null output,
                    @APPUSERID uniqueidentifier = null output,
                    @ATTRIBUTEDEFINED bit = null output,
                    @SMARTFIELDDEFINED bit = null output,
                    @UPDATEPENDING bit = null output,
                    @CONSTITUENTID uniqueidentifier = null output,
                    @HASSPOUSE bit = null output,
                    @AGE int = null output,
                    @ISALUMNUS bit = null output,
                    @ISSTUDENT bit = null output,
                    @ISFORMERSTUDENT bit = null output,
                    @VALIDSEARCHCRITERIASTRICT bit = null output,
                    @VALIDSEARCHCRITERIARELAXED bit = null output,
                    @EDUCATIONATTRIBUTEDEFINED bit = null output,
                    @ISGROUPMEMBER bit = null output,
                    @ISGROUP bit = null output,
                    @GROUPCANBEDONOR bit = null output,
                    @CURRENTMEMBERCOUNT integer = null output,
                    @PREVIOUSMEMBERCOUNT integer = null output,
                    @HASCOMMUNITYDATA bit = null output,
                    @ISHOUSEHOLD bit = null output,
                    @HOUSEHOLDID uniqueidentifier = null output,
                    @MAPPINGCREDENTIALSEXIST bit = null output,
                    @HASSTEWARDSHIPPLAN bit = null output,
                    @DECEASINGOPTIONSSET bit = null output,
                    @ISDISSOLVED bit = null output,
                    @SPOUSERELATIONSHIPID uniqueidentifier = null output,
                                @ISPLANNEDGIVER bit = null output,
                    @ISPATRON bit = null output,
                    @ISBANK bit = null output,
                    @HASIND2ORGRELATIONS bit = null output,
                    @ISCOMMITTEE bit = null output,
                    @ISGRANTOR bit = null output,
                    @ISSPONSOR bit = null output,
                    @SPONSORTYPECODE tinyint = null output,
                    @ISCOMMITTEEMEMBER bit = null output,
                    @HASMULTIPLEMGCONDITIONS bit = null output,
                    @ISFACULTY bit = null output,
                    @ISCONSTITUENT bit = null output,
                    @CANBEDONOR bit = null output,
                    @ISFORMERSPONSOR bit = null output,
                    @USER_GRANTED_IND_TO_IND_REL_ADD_FOR_CONSTIT bit = null output,
                    @USER_GRANTED_CONSTITNOTENOTIFICATION_ADD bit = null output,
                    @USER_GRANTED_CONSTITNOTENOTIFICATION_EDIT bit = null output,
                    @USER_GRANTED_CONSTITNOTE_ADD bit = null output,
                    @USER_GRANTED_CONSTITMEDIALINK_ADD bit = null output,
                    @USER_GRANTED_CONSTITATTACHMENT_ADD bit = null output,
                    @USER_GRANTED_CONSTITNOTE_EDIT_2 bit = null output,
                    @USER_GRANTED_CONSTITMEDIALINK_EDIT bit = null output,
                    @USER_GRANTED_CONSTITATTACHMENT_EDIT bit = null output,
                    @USER_GRANTED_CONSTITATTACHMENT_VIEW bit = null output,
                    @USER_GRANTED_ADDRESS_GEOCODE bit = null output,
                    @USER_GRANTED_CONSTITNOTENOTIFICATION_DELETE bit = null output,
                    @USER_GRANTED_CONSTITNOTE_DELETE bit = null output,
                    @USER_GRANTED_CONSTITMEDIALINK_DELETE bit = null output,
                    @USER_GRANTED_CONSTITATTACHMENT_DELETE bit = null output,
                    @USER_GRANTED_ADDRESS_DELETE_FOR_CONSTIT bit = null output,
                    @USER_GRANTED_CONSTITUENT_MAPENTITY bit = null output,
                    @MARRIAGERULESSET bit = null output,
                    @ISADVOCATE  bit = null output,
                    @HASRECEIVEDFUNDS bit = null output,
          @ADDRESSATTRIBUTEDEFINED bit = null output,
          @ISFAFREGISTRANT bit = null output,
          @VIEWREVENUETEXTLINKTEXT varchar(25) = null output,
          @USER_GRANTED_CONSTITPERSONALINFO_EDIT bit = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    exec dbo.USP_CONSTITUENTGETEXPRESSIONDATA @ID, @CURRENTAPPUSERID output, @DATALOADED output, @NAME output, @ISINACTIVE output, @DECEASED output, @ISSELF output, @ISORG output, @ISPROSPECT output, @ISFORMERPROSPECT output, @ISFUNDRAISER output, @ISFORMERFUNDRAISER output, @ISVOLUNTEER output, @ISFORMERVOLUNTEER output, @ISCOMMUNITYMEMBER output, @ISREGISTRANT output, @ISVENDOR output, @APPUSERID output, @ATTRIBUTEDEFINED output, @SMARTFIELDDEFINED output, @UPDATEPENDING output, @CONSTITUENTID output, @HASSPOUSE output, @AGE output, @ISALUMNUS output, @ISSTUDENT output, @ISFORMERSTUDENT output, @VALIDSEARCHCRITERIASTRICT output, @VALIDSEARCHCRITERIARELAXED output, @EDUCATIONATTRIBUTEDEFINED output, @HASCOMMUNITYDATA output, @ISGROUPMEMBER output, @ISGROUP output, @GROUPCANBEDONOR output, @CURRENTMEMBERCOUNT output, @PREVIOUSMEMBERCOUNT output, @ISHOUSEHOLD output, @HOUSEHOLDID output, @MAPPINGCREDENTIALSEXIST output, @HASSTEWARDSHIPPLAN output, @DECEASINGOPTIONSSET output, @ISDISSOLVED output, @SPOUSERELATIONSHIPID output, @ISPLANNEDGIVER output, @ISPATRON output, @ISBANK output, default, @HASIND2ORGRELATIONS output, @ISCOMMITTEE output, @ISGRANTOR = @ISGRANTOR output, @ISSPONSOR = @ISSPONSOR output, @SPONSORTYPECODE = @SPONSORTYPECODE output, @ISCOMMITTEEMEMBER = @ISCOMMITTEEMEMBER output, @HASMULTIPLEMGCONDITIONS = @HASMULTIPLEMGCONDITIONS output, @ISFACULTY = @ISFACULTY output, @ISCONSTITUENT=@ISCONSTITUENT output, @CANBEDONOR = @CANBEDONOR output, @ISFORMERSPONSOR = @ISFORMERSPONSOR output, @HASRECEIVEDFUNDS = @HASRECEIVEDFUNDS output, @ADDRESSATTRIBUTEDEFINED = @ADDRESSATTRIBUTEDEFINED output, @USER_GRANTED_CONSTITPERSONALINFO_EDIT = @USER_GRANTED_CONSTITPERSONALINFO_EDIT output;

                    select @MARRIAGERULESSET = RULESSET from dbo.UFN_MARRIAGEOPTION_GETRULES();

                    Set @ISADVOCATE = dbo.UFN_CONSTITUENT_ISADVOCATE(@ID)

          --check if FAF registrants
          Set @ISFAFREGISTRANT = 0
          Set @VIEWREVENUETEXTLINKTEXT = 'Revenue and recognition'

          Set @ISFAFREGISTRANT = dbo.UFN_FAF_ISPARTICIPANTS(@ID)
          if @ISFAFREGISTRANT = 1
             Begin
                Set @VIEWREVENUETEXTLINKTEXT = 'Gifts & registrations'
             End


                    --TWG 09/28/2010
                    --Adding permission checks for features that are conditionally shown on the page. Not including in the common procedure because these will differ from page to page
                    if dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 begin
                        set @USER_GRANTED_IND_TO_IND_REL_ADD_FOR_CONSTIT = 1;
                        set @USER_GRANTED_CONSTITNOTENOTIFICATION_ADD = 1;
                        set @USER_GRANTED_CONSTITNOTENOTIFICATION_EDIT = 1;
                        set @USER_GRANTED_CONSTITNOTE_ADD = 1;
                        set @USER_GRANTED_CONSTITMEDIALINK_ADD = 1;
                        set @USER_GRANTED_CONSTITATTACHMENT_ADD = 1;
                        set @USER_GRANTED_CONSTITNOTE_EDIT_2 = 1;
                        set @USER_GRANTED_CONSTITMEDIALINK_EDIT = 1;
                        set @USER_GRANTED_CONSTITATTACHMENT_EDIT = 1;
                        set @USER_GRANTED_CONSTITATTACHMENT_VIEW = 1;
                        set @USER_GRANTED_ADDRESS_GEOCODE = 1;
                        set @USER_GRANTED_CONSTITNOTENOTIFICATION_DELETE = 1;
                        set @USER_GRANTED_CONSTITNOTE_DELETE = 1;
                        set @USER_GRANTED_CONSTITMEDIALINK_DELETE = 1;
                        set @USER_GRANTED_CONSTITATTACHMENT_DELETE = 1;
                        set @USER_GRANTED_ADDRESS_DELETE_FOR_CONSTIT = 1;
                        set @USER_GRANTED_CONSTITUENT_MAPENTITY = 1;
                    end
                    else begin
                        set @USER_GRANTED_IND_TO_IND_REL_ADD_FOR_CONSTIT = case
                            when
                                dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'50D61839-6DB9-4c33-8080-69FAD56B533D') = 1 and
                                dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_FORCONSTIT(@CURRENTAPPUSERID,'50D61839-6DB9-4c33-8080-69FAD56B533D',@CONSTITUENTID) = 1 and
                                (select
                                    count(*)
                                from
                                    dbo.UFN_SITEID_MAPFROM_CONSTITUENTID(@CONSTITUENTID) as SITES
                                where
                                    dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_FORSITE(@CURRENTAPPUSERID, '50D61839-6DB9-4c33-8080-69FAD56B533D', SITEID) = 1) > 0
                            then 1
                            else 0
                            end;
                        set @USER_GRANTED_CONSTITNOTENOTIFICATION_ADD = dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'8e43e74b-cd0a-4e4e-b02b-f130639b1ae6');
                        set @USER_GRANTED_CONSTITNOTENOTIFICATION_EDIT = dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'0a91f5b8-15c9-41fc-b76b-f1004586e95a');
                        set @USER_GRANTED_CONSTITNOTE_ADD = dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'AC0ECD28-AF8A-469b-A5F0-03034D9D9A70');
                        set @USER_GRANTED_CONSTITMEDIALINK_ADD = dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'E9843191-4CDF-4018-974F-4ECD61201A58');
                        set @USER_GRANTED_CONSTITATTACHMENT_ADD = dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'5F7F892C-74FC-4783-A327-25EA0D23E89F');
                        set @USER_GRANTED_CONSTITNOTE_EDIT_2 = dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'6F6980CD-9189-4590-BF55-12BC2AB99FFD');
                        set @USER_GRANTED_CONSTITMEDIALINK_EDIT = dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'23E6F3CB-2EF6-4CBE-BEF5-28D099627E94');
                        set @USER_GRANTED_CONSTITATTACHMENT_EDIT = dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'4D478F30-74E0-418A-893F-2622BC89767F');
                        set @USER_GRANTED_CONSTITATTACHMENT_VIEW = dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID,'7126725A-12F2-4A37-A992-10891CEEA336');
                        set @USER_GRANTED_ADDRESS_GEOCODE = dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_IN_SYSTEMROLE(@CURRENTAPPUSERID,'1783224D-E771-437F-AAE4-A3981AE84543');
                        set @USER_GRANTED_CONSTITNOTENOTIFICATION_DELETE = dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_IN_SYSTEMROLE(@CURRENTAPPUSERID,'ad442665-44f3-4d73-a5e1-722757ee69e8');
                        set @USER_GRANTED_CONSTITNOTE_DELETE = dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_IN_SYSTEMROLE(@CURRENTAPPUSERID,'E135A349-2F3C-44ba-9C14-557E1AD02A4D');
                        set @USER_GRANTED_CONSTITMEDIALINK_DELETE = dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_IN_SYSTEMROLE(@CURRENTAPPUSERID,'DBA025EF-6507-455B-887F-F1D66B2A13DC');
                        set @USER_GRANTED_CONSTITATTACHMENT_DELETE = dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_IN_SYSTEMROLE(@CURRENTAPPUSERID,'3E7278FB-46D4-401E-8E7E-ADF794C54D4F');
                        set @USER_GRANTED_ADDRESS_DELETE_FOR_CONSTIT = case
                            when
                                dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_IN_SYSTEMROLE(@CURRENTAPPUSERID,'0C2D6552-EC7F-4923-A4AF-AFC53114C32B') = 1 and
                                dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_FORCONSTIT(@CURRENTAPPUSERID,'0C2D6552-EC7F-4923-A4AF-AFC53114C32B',@CONSTITUENTID) = 1 and
                                (select
                                    count(*)
                                from
                                    dbo.UFN_SITEID_MAPFROM_CONSTITUENTID(@CONSTITUENTID) as SITES
                                where
                                    dbo.UFN_SECURITY_APPUSER_GRANTED_RECORDOPERATION_FORSITE(@CURRENTAPPUSERID, '0C2D6552-EC7F-4923-A4AF-AFC53114C32B', SITEID) = 1) > 0
                            then 1
                            else 0
                            end;
                        set @USER_GRANTED_CONSTITUENT_MAPENTITY = dbo.UFN_SECURITY_APPUSER_GRANTED_MAPENTITY_IN_SYSTEMROLE(@CURRENTAPPUSERID,'645E6BE7-459C-402b-A03C-67587CA72B94');
                    end

                    return 0;