USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTPAGEDATA_1_1

The load procedure used by the view dataform template "Constituent Page Expression View Form 1.1"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(400)	INOUT	NAME
@ISORG	bit	INOUT	ISORG
@ISCOMMUNITYMEMBER	bit	INOUT	ISCOMMUNITYMEMBER
@ATTRIBUTEDEFINED	bit	INOUT	ATTRIBUTEDEFINED
@SMARTFIELDDEFINED	bit	INOUT	SMARTFIELDDEFINED
@ISINACTIVE	bit	INOUT	ISINACTIVE
@DECEASED	bit	INOUT	DECEASED
@HASSPOUSE	bit	INOUT	HASSPOUSE
@ISPROSPECT	bit	INOUT	ISPROSPECT
@ISFUNDRAISER	bit	INOUT	ISFUNDRAISER
@ISVOLUNTEER	bit	INOUT	ISVOLUNTEER
@ISREGISTRANT	bit	INOUT	ISREGISTRANT
@ISVENDOR	bit	INOUT	ISVENDOR
@APPUSERID	uniqueidentifier	INOUT	APPUSERID
@ISALUMNUS	bit	INOUT	ISALUMNUS
@ISSTUDENT	bit	INOUT	ISSTUDENT
@EDUCATIONATTRIBUTEDEFINED	bit	INOUT	EDUCATIONATTRIBUTEDEFINED

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTPAGEDATA_1_1
                (
                    @ID uniqueidentifier,
                    @CURRENTAPPUSERID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(400) = null output,
                    @ISORG bit = null output,                    
                    @ISCOMMUNITYMEMBER bit = null output,
                    @ATTRIBUTEDEFINED bit = null output,
                    @SMARTFIELDDEFINED bit = null output,                    
                    @ISINACTIVE bit = null output,                    
                    @DECEASED bit = null output,                    
                    @HASSPOUSE bit = null output,                    
                    @ISPROSPECT bit = null output,                    
                    @ISFUNDRAISER bit = null output,                    
                    @ISVOLUNTEER bit = null output,                    
                    @ISREGISTRANT bit = null output,
                    @ISVENDOR bit = null output,
                    @APPUSERID uniqueidentifier = null output,
                    @ISALUMNUS bit = null output,
                    @ISSTUDENT bit = null output,
                    @EDUCATIONATTRIBUTEDEFINED bit = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;
                    set @DECEASED = 0;
                    set @ISPROSPECT = 0;
                    set @ISFUNDRAISER = 0;
                    set @ISVOLUNTEER = 0;
                    set @ISREGISTRANT = 0;
                    set @ISVENDOR = 0;
                    set @HASSPOUSE = 0;
                    set @ISALUMNUS = 0;
                    set @ISSTUDENT = 0;

                    select @APPUSERID = ID from dbo.APPUSER where CONSTITUENTID = @ID;

                    select
                        @DATALOADED = 1,
                        @ISINACTIVE = C.ISINACTIVE,        
                        @NAME = C.NAME,                        
                        @ISORG=C.ISORGANIZATION,        
                        @ISCOMMUNITYMEMBER = C.NETCOMMUNITYMEMBER,        
                        @ATTRIBUTEDEFINED = dbo.UFN_ATTRIBUTECATEGORY_DEFINEDFORRECORDTYPE_FORAPPUSER('CONSTITUENT',@CURRENTAPPUSERID),
                        @SMARTFIELDDEFINED = dbo.UFN_SMARTFIELD_DEFINEDFORRECORDTYPE('CONSTITUENT'),        
                        @EDUCATIONATTRIBUTEDEFINED = dbo.UFN_ATTRIBUTECATEGORY_DEFINEDFORRECORDTYPE_FORAPPUSER('EDUCATIONAL HISTORY',@CURRENTAPPUSERID)
                    from
                        dbo.CONSTITUENT AS C                        
                    where
                        C.ID = @ID;    

                    if exists(select ID from dbo.DECEASEDCONSTITUENT where DECEASEDCONSTITUENT.ID = @ID)
                        set @DECEASED = 1;

                    if exists(select ID from dbo.PROSPECT where PROSPECT.ID = @ID)
                        set @ISPROSPECT = 1;

                    if exists(select ID from dbo.FUNDRAISERDATERANGE where FUNDRAISERDATERANGE.ID = @ID)
                        set @ISFUNDRAISER = 1;

                    if exists(select ID from dbo.VOLUNTEER where VOLUNTEER.ID = @ID)
                        set @ISVOLUNTEER = 1;

                    if exists(select ID from dbo.REGISTRANT where CONSTITUENTID = @ID) 
                        set @ISREGISTRANT = 1;

                    if exists(select ID from dbo.EVENTEXPENSE where VENDORID = @ID)
                        set @ISVENDOR = 1;

                    if exists(select ID from dbo.RELATIONSHIP where RELATIONSHIPCONSTITUENTID = @ID and ISSPOUSE = 1)
                        set @HASSPOUSE = 1;

                    if exists(select EDUCATIONALHISTORY.ID from dbo.EDUCATIONALHISTORY inner join dbo.EDUCATIONALINSTITUTION on EDUCATIONALHISTORY.EDUCATIONALINSTITUTIONID = EDUCATIONALINSTITUTION.ID and EDUCATIONALINSTITUTION.ISAFFILIATED = 1 where EDUCATIONALHISTORY.CONSTITUENTID  = @ID and EDUCATIONALHISTORY.CONSTITUENCYSTATUSCODE > 1)
                        set @ISALUMNUS = 1;

                    if exists(select EDUCATIONALHISTORY.ID from dbo.EDUCATIONALHISTORY inner join dbo.EDUCATIONALINSTITUTION on EDUCATIONALHISTORY.EDUCATIONALINSTITUTIONID = EDUCATIONALINSTITUTION.ID and EDUCATIONALINSTITUTION.ISAFFILIATED = 1 where EDUCATIONALHISTORY.CONSTITUENTID  = @ID and EDUCATIONALHISTORY.CONSTITUENCYSTATUSCODE = 1)
                        set @ISSTUDENT = 1;

                    return 0;