USP_DATAFORMTEMPLATE_VIEW_DESIGNATIONLEVELRECIPIENT

The load procedure used by the view dataform template "Fundraising Purpose Recipient 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.
@AWARDAMOUNT	money	INOUT	Amount
@TYPE	nvarchar(255)	INOUT	Type
@DEGREE	nvarchar(255)	INOUT	Degree
@CLASSOF	UDT_YEAR	INOUT	Class of
@MAJOR	nvarchar(255)	INOUT	Major
@MINOR	nvarchar(255)	INOUT	Minor
@GPA	nvarchar(5)	INOUT	GPA

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DESIGNATIONLEVELRECIPIENT (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @AWARDAMOUNT money = null output,
                    @TYPE nvarchar(255) = null output,                                   
                    @DEGREE nvarchar(255) = null output,                                   
                    @CLASSOF dbo.UDT_YEAR = null output,
                    @MAJOR nvarchar(255) = null output,
                    @MINOR nvarchar(255) = null output,
                    @GPA nvarchar(5) = null output                                                           
                ) 
                as 
                begin                    
                    set nocount on

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @AWARDAMOUNT = DESIGNATIONLEVELRECIPIENT.AMOUNT,
                        @TYPE = TYPE.DESCRIPTION,
                        @DEGREE = DEGREE.DESCRIPTION,
                        @CLASSOF =     case when HISTORY.CLASSOF = 0 then '' else cast(HISTORY.CLASSOF as nvarchar(4))    end,
                        @MAJOR = dbo.UFN_EDUCATIONALMAJOR_GETNAME(HISTORY.ID),
                        @MINOR = dbo.UFN_EDUCATIONALMINOR_GETNAME(HISTORY.ID),
                        @GPA =     case when HISTORY.GPA = 0 then '' else cast(HISTORY.GPA as nvarchar(5)) end                                          

                    from dbo.DESIGNATIONLEVELRECIPIENT
                        inner join dbo.CONSTITUENT on dbo.DESIGNATIONLEVELRECIPIENT.CONSTITUENTID = dbo.CONSTITUENT.ID
                        left join dbo.EDUCATIONALHISTORY as HISTORY on dbo.CONSTITUENT.ID = HISTORY.CONSTITUENTID
                        left join dbo.EDUCATIONALINSTITUTION as INSTITUTION on HISTORY.EDUCATIONALINSTITUTIONID = INSTITUTION.ID
                        left join dbo.EDUCATIONALDEGREECODE as DEGREE on HISTORY.EDUCATIONALDEGREECODEID = DEGREE.ID
                        left join dbo.EDUCATIONALHISTORYTYPECODE as TYPE on HISTORY.EDUCATIONALHISTORYTYPECODEID = TYPE.ID
                        left join dbo.EDUCATIONALHISTORYSTATUSCODE as STATUS on HISTORY.EDUCATIONALHISTORYSTATUSCODEID = STATUS.ID                                                   

                    where 
                        HISTORY.ID = DESIGNATIONLEVELRECIPIENT.EDUCATIONALHISTORYID and
                        DESIGNATIONLEVELRECIPIENT.ID = @ID

                    return 0;
                end