USP_DATAFORMTEMPLATE_VIEW_EXTENDEDNETWORK_EXPRESSIONS

The load procedure used by the view dataform template "Extended Network Page Expression View Form"

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.
@NAME	nvarchar(100)	INOUT	NAME
@ISINACTIVE	bit	INOUT	ISINACTIVE
@LOOKUPID	nvarchar(20)	INOUT	LOOKUPID
@VALIDSEARCHCRITERIASTRICT	bit	INOUT	VALIDSEARCHCRITERIASTRICT
@VALIDSEARCHCRITERIARELAXED	bit	INOUT	VALIDSEARCHCRITERIARELAXED
@ISFUNDRAISER	bit	INOUT	ISFUNDRAISER
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ISORG	bit	INOUT	ISORG
@DECEASED	bit	INOUT	DECEASED
@ISSELF	bit	INOUT	ISSELF
@ISPROSPECT	bit	INOUT	ISPROSPECT
@ISFORMERPROSPECT	bit	INOUT	ISFORMERPROSPECT
@ISFORMERFUNDRAISER	bit	INOUT	ISFORMERFUNDRAISER
@ISVOLUNTEER	bit	INOUT	ISVOLUNTEER
@ISFORMERVOLUNTEER	bit	INOUT	ISFORMERVOLUNTEER
@ISCOMMUNITYMEMBER	bit	INOUT	ISCOMMUNITYMEMBER
@ISREGISTRANT	bit	INOUT	ISREGISTRANT
@ISVENDOR	bit	INOUT	ISVENDOR
@APPUSERID	uniqueidentifier	INOUT	APPUSERID
@ATTRIBUTEDEFINED	bit	INOUT	ATTRIBUTEDEFINED
@SMARTFIELDDEFINED	bit	INOUT	SMARTFIELDDEFINED
@UPDATEPENDING	bit	INOUT	UPDATEPENDING
@CONSTITUENTID	uniqueidentifier	INOUT	CONSTITUENTID
@HASSPOUSE	bit	INOUT	HASSPOUSE
@AGE	int	INOUT	AGE
@ISALUMNUS	bit	INOUT	ISALUMNUS
@ISSTUDENT	bit	INOUT	ISSTUDENT
@ISFORMERSTUDENT	bit	INOUT	ISFORMERSTUDENT
@ISGROUP	bit	INOUT	ISGROUP
@ISHOUSEHOLD	bit	INOUT	ISHOUSEHOLD
@ISGROUPMEMBER	bit	INOUT	ISGROUPMEMBER
@HASSTEWARDSHIPPLAN	bit	INOUT	HASSTEWARDSHIPPLAN
@ISPLANNEDGIVER	bit	INOUT	ISPLANNEDGIVER
@ISBANK	bit	INOUT	ISBANK
@ISCOMMITTEE	bit	INOUT	ISCOMMITTEE
@ISGRANTOR	bit	INOUT	ISGRANTOR
@ISSPONSOR	bit	INOUT	ISSPONSOR
@ISCOMMITTEEMEMBER	bit	INOUT	ISCOMMITTEEMEMBER
@SPONSORTYPECODE	tinyint	INOUT	SPONSORTYPECODE
@ISFACULTY	bit	INOUT	ISFACULTY
@ISFORMERSPONSOR	bit	INOUT	ISFORMERSPONSOR
@HASRECEIVEDFUNDS	bit	INOUT	HASRECEIVEDFUNDS
@USER_GRANTED_CONSTITPERSONALINFO_EDIT	bit	INOUT
@ISNATIONALFUNDRAISINGGROUP	bit	INOUT

Definition

Copy


                    CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_EXTENDEDNETWORK_EXPRESSIONS]
                    (
                        @ID                         uniqueidentifier,
                        @CURRENTAPPUSERID            uniqueidentifier,
                        @NAME                        nvarchar(100) =    null output,
                        @ISINACTIVE                 bit =              null output,
                        @LOOKUPID                   nvarchar(20) =     null output,
                        @VALIDSEARCHCRITERIASTRICT  bit =              null output,
                        @VALIDSEARCHCRITERIARELAXED bit =              null output,
                        @ISFUNDRAISER               bit =              null output,
                        @DATALOADED                 bit =              0 output,
                        @ISORG                        bit =               null output,
                        @DECEASED                    bit =               null output,
                        @ISSELF                        bit =               null output,
                        @ISPROSPECT                    bit =               null output,
                        @ISFORMERPROSPECT            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,
                        @ISGROUP                    bit =               null output,
                        @ISHOUSEHOLD                bit =               null output,
                        @ISGROUPMEMBER                bit =               null output,
                        @HASSTEWARDSHIPPLAN            bit =               null output,
                        @ISPLANNEDGIVER             bit =              null output,
                        @ISBANK                     bit =                null output,
                        @ISCOMMITTEE                 bit =                null output,
                        @ISGRANTOR                     bit =                null output,
                        @ISSPONSOR                  bit =              null output,
                        @ISCOMMITTEEMEMBER            bit =               null output,
                        @SPONSORTYPECODE            tinyint =           null output,
                        @ISFACULTY                    bit =               null output,
                        @ISFORMERSPONSOR            bit =               null output,
                        @HASRECEIVEDFUNDS            bit =               null output,
            @USER_GRANTED_CONSTITPERSONALINFO_EDIT bit = null output,
                      @ISNATIONALFUNDRAISINGGROUP  bit = null output    
                    )
                    as
                        set NOCOUNT on;
                        set @DATALOADED = 0;

                    Set @ISNATIONALFUNDRAISINGGROUP = dbo.UFN_CONSTITUENT_ISNATIONALFUNDRAISINGGROUP(@ID)

                    select
                        @DATALOADED =  1,
                        @NAME =        CONSTITUENT.NAME,
                        @ISINACTIVE =  CONSTITUENT.ISINACTIVE,
                        @LOOKUPID =    CONSTITUENT.LOOKUPID,
                        @ISORG =       CONSTITUENT.ISORGANIZATION,
                        @ISGROUP =       CONSTITUENT.ISGROUP
                    from
                        dbo.CONSTITUENT
                    where
                        CONSTITUENT.ID = @ID;

                    --CONSTITUENCY FIELDS
                    set @ISFUNDRAISER = dbo.UFN_CONSTITUENT_ISFUNDRAISER(@ID);

                    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,
                        @ISHOUSEHOLD = @ISHOUSEHOLD output,
                        @ISGROUPMEMBER = @ISGROUPMEMBER output,
                        @HASSTEWARDSHIPPLAN = @HASSTEWARDSHIPPLAN output,
                        @ISPLANNEDGIVER = @ISPLANNEDGIVER output,
                        @ISBANK = @ISBANK output,
                        @ISCOMMITTEE = @ISCOMMITTEE output,
                        @ISGRANTOR = @ISGRANTOR output,
                        @ISSPONSOR = @ISSPONSOR output,
                        @ISCOMMITTEEMEMBER = @ISCOMMITTEEMEMBER output,
                        @SPONSORTYPECODE = @SPONSORTYPECODE output,
                        @ISFACULTY = @ISFACULTY output,
                        @ISFORMERSPONSOR = @ISFORMERSPONSOR output, 
                        @HASRECEIVEDFUNDS = @HASRECEIVEDFUNDS output,
            @USER_GRANTED_CONSTITPERSONALINFO_EDIT = @USER_GRANTED_CONSTITPERSONALINFO_EDIT output;

                    return 0;