USP_DATAFORMTEMPLATE_VIEW_WEALTHDETAILS_AFFLUENCEINDICATORS_EXPRESSIONS

The load procedure used by the view dataform template "WealthPoint Affluence Indicators 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.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(400)	INOUT	NAME
@ISINACTIVE	bit	INOUT	ISINACTIVE
@CONSTITUENTID	uniqueidentifier	INOUT	CONSTITUENTID
@WEALTHUPDATEPENDING	bit	INOUT	WEALTHUPDATEPENDING
@DISABLEDWEALTHUPDATES	bit	INOUT	DISABLEDWEALTHUPDATES
@VALIDSEARCHCRITERIASTRICT	bit	INOUT	VALIDSEARCHCRITERIASTRICT
@VALIDSEARCHCRITERIARELAXED	bit	INOUT	VALIDSEARCHCRITERIARELAXED
@BIOGRAPHICALSUFFIX	nvarchar(8)	INOUT	BIOGRAPHICALSUFFIX
@POLITICALDONATIONSSUFFIX	nvarchar(8)	INOUT	POLITICALDONATIONSSUFFIX
@PRIVATEFOUNDATIONSSUFFIX	nvarchar(8)	INOUT	PRIVATEFOUNDATIONSSUFFIX
@INCOMECOMPENSATIONSUFFIX	nvarchar(8)	INOUT	INCOMECOMPENSATIONSUFFIX
@AFFLUENCEINDICATORSSUFFIX	nvarchar(8)	INOUT	AFFLUENCEINDICATORSSUFFIX
@NONPROFITAFFILIATIONSSUFFIX	nvarchar(8)	INOUT	NONPROFITAFFILIATIONSSUFFIX
@PHILANTHROPICGIFTSSUFFIX	nvarchar(8)	INOUT	PHILANTHROPICGIFTSSUFFIX
@BUSINESSOWNERSHIPSUFFIX	nvarchar(8)	INOUT	BUSINESSOWNERSHIPSUFFIX
@REALESTATESUFFIX	nvarchar(8)	INOUT	REALESTATESUFFIX
@SECURITIESSUFFIX	nvarchar(8)	INOUT	SECURITIESSUFFIX
@OTHERASSETSSUFFIX	nvarchar(8)	INOUT	OTHERASSETSSUFFIX
@NEWBIOGRAPHICAL	bit	INOUT	NEWBIOGRAPHICAL
@NEWPOLITICALDONATIONS	bit	INOUT	NEWPOLITICALDONATIONS
@NEWPRIVATEFOUNDATIONS	bit	INOUT	NEWPRIVATEFOUNDATIONS
@NEWINCOMECOMPENSATION	bit	INOUT	NEWINCOMECOMPENSATION
@NEWAFFLUENCEINDICATORS	bit	INOUT	NEWAFFLUENCEINDICATORS
@NEWNONPROFITAFFILIATIONS	bit	INOUT	NEWNONPROFITAFFILIATIONS
@NEWPHILANTHROPICGIFTS	bit	INOUT	NEWPHILANTHROPICGIFTS
@NEWBUSINESSOWNERSHIP	bit	INOUT	NEWBUSINESSOWNERSHIP
@NEWREALESTATE	bit	INOUT	NEWREALESTATE
@NEWSECURITIES	bit	INOUT	NEWSECURITIES
@NEWOTHERASSETS	bit	INOUT	NEWOTHERASSETS
@HASWEALTHPOINTCREDENTIALS	bit	INOUT	HASWEALTHPOINTCREDENTIALS
@ISORG	bit	INOUT	ISORG
@ISGROUP	bit	INOUT	ISGROUP
@ISHOUSEHOLD	bit	INOUT	ISHOUSEHOLD
@WEALTHPOINTREGISTERED	bit	INOUT	WEALTHPOINTREGISTERED
@WEALTHPOINTACCOUNTTYPECODE	int	INOUT	WEALTHPOINTACCOUNTTYPECODE

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WEALTHDETAILS_AFFLUENCEINDICATORS_EXPRESSIONS
                (
                    @ID                          uniqueidentifier,
                    @CURRENTAPPUSERID            uniqueidentifier,
                    @DATALOADED                  bit =              0 output,
                    @NAME                        nvarchar(400) =    null output,
                    @ISINACTIVE                  bit =              null output,
                    @CONSTITUENTID               uniqueidentifier = null output,
                    @WEALTHUPDATEPENDING         bit =              null output,
                    @DISABLEDWEALTHUPDATES       bit =              null output,
                    @VALIDSEARCHCRITERIASTRICT   bit =              null output,
                    @VALIDSEARCHCRITERIARELAXED  bit =              null output,

                    @BIOGRAPHICALSUFFIX          nvarchar(8) = null output,
                    @POLITICALDONATIONSSUFFIX    nvarchar(8) = null output,
                    @PRIVATEFOUNDATIONSSUFFIX    nvarchar(8) = null output,
                    @INCOMECOMPENSATIONSUFFIX    nvarchar(8) = null output,
                    @AFFLUENCEINDICATORSSUFFIX   nvarchar(8) = null output,
                    @NONPROFITAFFILIATIONSSUFFIX nvarchar(8) = null output,
                    @PHILANTHROPICGIFTSSUFFIX    nvarchar(8) = null output,
                    @BUSINESSOWNERSHIPSUFFIX     nvarchar(8) = null output,
                    @REALESTATESUFFIX            nvarchar(8) = null output,
                    @SECURITIESSUFFIX            nvarchar(8) = null output,
                    @OTHERASSETSSUFFIX           nvarchar(8) = null output,

                    @NEWBIOGRAPHICAL             bit = null output,
                    @NEWPOLITICALDONATIONS       bit = null output,
                    @NEWPRIVATEFOUNDATIONS       bit = null output,
                    @NEWINCOMECOMPENSATION       bit = null output,
                    @NEWAFFLUENCEINDICATORS      bit = null output,
                    @NEWNONPROFITAFFILIATIONS    bit = null output,
                    @NEWPHILANTHROPICGIFTS       bit = null output,
                    @NEWBUSINESSOWNERSHIP        bit = null output,
                    @NEWREALESTATE               bit = null output,
                    @NEWSECURITIES               bit = null output,
                    @NEWOTHERASSETS              bit = null output,
                    @HASWEALTHPOINTCREDENTIALS     bit = null output,
                    @ISORG                         bit = null output,
                    @ISGROUP                     bit = null output,
                    @ISHOUSEHOLD                 bit = null output,
                    @WEALTHPOINTREGISTERED       bit = null output,
                    @WEALTHPOINTACCOUNTTYPECODE  integer = null output
                )
                as                  
                    set nocount on;

                    declare @USERNAME nvarchar(128);
                    select
                        @USERNAME = APPUSER.USERNAME
                    from
                        dbo.APPUSER
                    where
                        ID = @CURRENTAPPUSERID;

                    declare @CHANGEAGENTID uniqueidentifier;
                    if @CHANGEAGENTID is null
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @ID = @CHANGEAGENTID output, @USERNAME = @USERNAME;

                    declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                    set @DATALOADED = 0;

                    --Update to set all records on page to "Viewed"

                    update 
                        dbo.WPAFFLUENCEINDICATOR
                    set
                        VIEWED = 1,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where
                        VIEWED = 0 and
                        WEALTHID = @ID;

                    --Collect common Wealth Details data

                    exec dbo.USP_WEALTHDETAILS_PAGEEXPRESSIONS_COMMON
                        @ID,                     
                        @DATALOADED                        output,
                        @NAME                            output,                     
                        @ISINACTIVE                     output,  
                        @CONSTITUENTID                     output,  
                        @WEALTHUPDATEPENDING             output,  
                        @DISABLEDWEALTHUPDATES             output,  
                        @VALIDSEARCHCRITERIASTRICT         output,  
                        @VALIDSEARCHCRITERIARELAXED     output,  

                        @BIOGRAPHICALSUFFIX             output,  
                        @POLITICALDONATIONSSUFFIX         output,  
                        @PRIVATEFOUNDATIONSSUFFIX         output,  
                        @INCOMECOMPENSATIONSUFFIX         output,  
                        @AFFLUENCEINDICATORSSUFFIX         output,  
                        @NONPROFITAFFILIATIONSSUFFIX     output,  
                        @PHILANTHROPICGIFTSSUFFIX         output,  
                        @BUSINESSOWNERSHIPSUFFIX         output,  
                        @REALESTATESUFFIX                 output,  
                        @SECURITIESSUFFIX                 output,  
                        @OTHERASSETSSUFFIX                 output,  

                        @NEWBIOGRAPHICAL                 output,  
                        @NEWPOLITICALDONATIONS          output,  
                        @NEWPRIVATEFOUNDATIONS             output,  
                        @NEWINCOMECOMPENSATION             output,  
                        @NEWAFFLUENCEINDICATORS           output,  
                        @NEWNONPROFITAFFILIATIONS         output,  
                        @NEWPHILANTHROPICGIFTS             output,  
                        @NEWBUSINESSOWNERSHIP             output,  
                        @NEWREALESTATE                     output,  
                        @NEWSECURITIES                    output,  
                        @NEWOTHERASSETS                    output,
                        @ISORG                            output,
                        @ISGROUP                        output,
                        @ISHOUSEHOLD                    output,
                        @WEALTHPOINTREGISTERED          output,
                        @WEALTHPOINTACCOUNTTYPECODE     output;

                    if @ISORG = 1
                         set @DATALOADED = 0;

                    return 0;