USP_DATAFORMTEMPLATE_VIEW_WPPHILANTHROPICGIFT

The load procedure used by the view dataform template "WealthPoint Philanthropic Gift View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@CNOTES	nvarchar(1024)	INOUT	Notes
@CDATE	datetime	INOUT	BBA confirmed date
@CVALUE	money	INOUT	BBA confirmed value
@ORGANIZATION	nvarchar(200)	INOUT	Organization
@LOCATION	nvarchar(100)	INOUT	Location
@GIFTYEAR	UDT_YEAR	INOUT	Gift year
@TYPE	nvarchar(75)	INOUT	Gift type
@CATEGORY	nvarchar(201)	INOUT	Category
@LO	money	INOUT	Amount range
@HI	money	INOUT	High amount
@NAME	nvarchar(200)	INOUT	Name
@ORGANIZATIONWEBADDRESS	nvarchar(2000)	INOUT	Web address
@SOURCEMATERIAL	nvarchar(2000)	INOUT	Source material
@GIFTYEARHI	UDT_YEAR	INOUT	End year
@GIFTYEARLO	UDT_YEAR	INOUT	Start year
@TYPECODE	int	INOUT	Type
@EIN	nvarchar(50)	INOUT	EIN
@SOURCE	nvarchar(100)	INOUT	Source
@PHILANTHROPICGIFTID	int	INOUT	Philanthropic gift ID
@HOUSEHOLDID	nvarchar(30)	INOUT	Household ID
@TASCORE	int	INOUT	Match level
@MATCHADDRESS	nvarchar(100)	INOUT	Matched address
@MATCHCITY	nvarchar(20)	INOUT	Matched city
@MATCHSTATE	nvarchar(2)	INOUT	Matched state
@MATCHZIP	nvarchar(5)	INOUT	Matched zip
@ACCOUNTTYPECODE	smallint	INOUT	Account type code

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WPPHILANTHROPICGIFT (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @CNOTES nvarchar(1024) = null output,
                    @CDATE datetime = null output,
                    @CVALUE money = null output,
                    @ORGANIZATION nvarchar(200) = null output,
                    @LOCATION nvarchar(100) = null output,
                    @GIFTYEAR dbo.UDT_YEAR = null output,
                    @TYPE nvarchar(75) = null output,
                    @CATEGORY nvarchar(201) = null output,
                    @LO money = null output,
                    @HI money = null output,
                    @NAME nvarchar(200) = null output,
                    @ORGANIZATIONWEBADDRESS nvarchar(2000) = null output,
                    @SOURCEMATERIAL nvarchar(2000) = null output,
                    @GIFTYEARHI dbo.UDT_YEAR = null output,
                    @GIFTYEARLO dbo.UDT_YEAR = null output,
                    @TYPECODE int = null output,
                    @EIN nvarchar(50) = null output,
                    @SOURCE nvarchar(100) = null output,
                    @PHILANTHROPICGIFTID int = null output,
                    @HOUSEHOLDID nvarchar(30) = null output,
                    @TASCORE int = null output,
                    @MATCHADDRESS nvarchar(100) = null output,
                    @MATCHCITY nvarchar(20) = null output,
                    @MATCHSTATE nvarchar(2) = null output,
                    @MATCHZIP nvarchar(5) = null output,
                    @ACCOUNTTYPECODE smallint = null output
                ) as begin

                    set nocount on;

                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @CDATE = CDATE,
                        @CVALUE = CVALUE,
                        @CNOTES = CNOTES,
                        @ORGANIZATION = ORGANIZATION,
                        @LOCATION = LOCATION,
                        @GIFTYEAR = GIFTYEAR,
                        @TYPE = TYPE,
                        @CATEGORY = CATEGORY,
                        @LO = LO,
                        @HI = HI,
                        @NAME = NAME,
                        @ORGANIZATIONWEBADDRESS = ORGANIZATIONWEBADDRESS,
                        @SOURCEMATERIAL = SOURCEMATERIAL,
                        @GIFTYEARHI = GIFTYEARHI,
                        @GIFTYEARLO = GIFTYEARLO,
                        @TYPECODE = TYPECODE,
                        @EIN = EIN,
                        @SOURCE = SOURCE,
                        @PHILANTHROPICGIFTID = PHILANTHROPICGIFTID,
                        @HOUSEHOLDID = HOUSEHOLDID,
                        @TASCORE = TASCORE,
                        @MATCHADDRESS = MATCHADDRESS,
                        @MATCHCITY = MATCHCITY,
                        @MATCHSTATE = MATCHSTATE,
                        @MATCHZIP = MATCHZIP
                    from
                        dbo.WPPHILANTHROPICGIFT
                    where
                        ID=@ID;

                    select @ACCOUNTTYPECODE = ACCOUNTTYPECODE from dbo.WEALTHPOINTCONFIGURATION;

                    return 0;

                end;