USP_DATAFORMTEMPLATE_EDITLOAD_WEALTHCAPACITY

The load procedure used by the edit dataform template "Wealth Capacity Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@ESTIMATEDWEALTHID	uniqueidentifier	INOUT	Estimated wealth
@OVERALLRATINGCODEID	uniqueidentifier	INOUT	Overall rating
@MAJORGIVINGCAPACITYID	uniqueidentifier	INOUT	Major giving capacity
@MAJORGIVINGCAPACITYVALUE	money	INOUT	Major giving capacity value
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_WEALTHCAPACITY
                (
                        @ID                       uniqueidentifier,
                        @ESTIMATEDWEALTHID        uniqueidentifier = null output,
                        @OVERALLRATINGCODEID      uniqueidentifier=  null output,
                        @MAJORGIVINGCAPACITYID    uniqueidentifier = null output, 
                        @MAJORGIVINGCAPACITYVALUE money =            null output,
                        @TSLONG                      bigint =             0 output,
                        @DATALOADED               bit =              0 output

                ) as 
                    set nocount on;                    
                    select 
                        @DATALOADED    = 1,
                        @TSLONG = WEALTHCAPACITY.[TSLONG],
                        @ESTIMATEDWEALTHID =        WEALTHCAPACITY.[ESTIMATEDWEALTHID],
                        @OVERALLRATINGCODEID =      WEALTHCAPACITY.[OVERALLRATINGCODEID],
                        @MAJORGIVINGCAPACITYID  =   WEALTHCAPACITY.[MAJORGIVINGCAPACITYID],
                        @MAJORGIVINGCAPACITYVALUE = WEALTHCAPACITY.[MAJORGIVINGCAPACITYVALUE]

                    from
                        dbo.[CONSTITUENT]
                    left join
                        dbo.[WEALTHCAPACITY] on
                            CONSTITUENT.[ID] = WEALTHCAPACITY.[ID]
                    where
                        CONSTITUENT.[ID] = @ID;