USP_DATAFORMTEMPLATE_VIEW_DESIGNATIONLEVELRECIPIENT2

The load procedure used by the view dataform template "Fundraising Purpose Recipient View Form 2"

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.
@STATUS	nvarchar(100)	INOUT	Status
@COMMENTS	nvarchar(255)	INOUT	Comments
@PUBLISHEDNAME	nvarchar(50)	INOUT	Published name
@ISPRIMARYRECORD	bit	INOUT	Primary record
@EDUCATIONALINSTITUTION	nvarchar(150)	INOUT	Educational institution
@ACADEMICCATALOGPROGRAM	nvarchar(150)	INOUT	Program
@EDUCATIONALPROGRAM	nvarchar(150)	INOUT	Program
@CONSTITUENCYSTATUSCODE	tinyint	INOUT	Status code
@CONSTITUENCYSTATUS	nvarchar(150)	INOUT	Status
@DATEGRADUATED	UDT_FUZZYDATE	INOUT	Date graduated
@DATELEFT	UDT_FUZZYDATE	INOUT	Date left
@ACADEMICCATALOGDEGREE	nvarchar(150)	INOUT	Degree
@EDUCATIONALDEGREE	nvarchar(150)	INOUT	Degree
@EDUCATIONALAWARD	nvarchar(150)	INOUT	Awarded
@STARTDATE	UDT_FUZZYDATE	INOUT	Start date
@CLASSYEAR	UDT_YEAR	INOUT	Class year
@PREFERREDCLASSYEAR	UDT_YEAR	INOUT	Preferred class of
@EDUCATIONALSOURCE	nvarchar(150)	INOUT	Source
@EDUCATIONALSOURCEDATE	UDT_FUZZYDATE	INOUT	Source date
@COMMENT	nvarchar(500)	INOUT	Comments
@ISAFFILIATED	bit	INOUT	Affiliated
@AWARD	nvarchar(150)	INOUT	Honor awarded
@ADDITIONALINFORMATION	xml	INOUT	Additional information
@EDUCATIONALHISTORYLEVELCODE	nvarchar(150)	INOUT	Level
@EDUCATIONALHISTORYSTATUSID	uniqueidentifier	INOUT	StatusID

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DESIGNATIONLEVELRECIPIENT2 (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @STATUS nvarchar(100) = null output,
                    @COMMENTS nvarchar(255) = null output,
                    @PUBLISHEDNAME nvarchar(50) = null output,
                    @ISPRIMARYRECORD bit = null output,
                    @EDUCATIONALINSTITUTION nvarchar(150) = null output,
                    @ACADEMICCATALOGPROGRAM nvarchar(150) = null output,
                    @EDUCATIONALPROGRAM nvarchar(150) = null output,
                    @CONSTITUENCYSTATUSCODE tinyint = null output,
                    @CONSTITUENCYSTATUS nvarchar(150) = null output,
                    @DATEGRADUATED dbo.UDT_FUZZYDATE = null output,
                    @DATELEFT dbo.UDT_FUZZYDATE = null output,
                    @ACADEMICCATALOGDEGREE nvarchar(150) = null output,
                    @EDUCATIONALDEGREE nvarchar(150) = null output,
                    @EDUCATIONALAWARD nvarchar(150) = null output,
                    @STARTDATE dbo.UDT_FUZZYDATE = null output,
                    @CLASSYEAR dbo.UDT_YEAR = null output,
                    @PREFERREDCLASSYEAR dbo.UDT_YEAR = null output,
                    @EDUCATIONALSOURCE nvarchar(150) = null output,
                    @EDUCATIONALSOURCEDATE dbo.UDT_FUZZYDATE = null output,
                    @COMMENT nvarchar(500) = null output,
                    @ISAFFILIATED bit = null output,
                    @AWARD nvarchar(150) = null output,
                    @ADDITIONALINFORMATION xml = null output,
                    @EDUCATIONALHISTORYLEVELCODE nvarchar(150) = null output,
                    @EDUCATIONALHISTORYSTATUSID uniqueidentifier = null output
                ) 
                as 
                begin                    
                    set nocount on

                    set @DATALOADED = 0;

                    declare @EDUCATIONALHISTORYID uniqueidentifier;

                    select
                        @DATALOADED = 1,
                        @EDUCATIONALHISTORYID = RECIPIENT.EDUCATIONALHISTORYID,                                                 
                        @STATUS = coalesce(PURPOSERECIPIENTSTATUSCODE.DESCRIPTION,''),
                        @COMMENTS = RECIPIENT.COMMENTS,
                        @PUBLISHEDNAME = RECIPIENT.PUBLISHEDNAME
                    from  
                        dbo.DESIGNATIONLEVELRECIPIENT as RECIPIENT
                        inner join dbo.CONSTITUENT on CONSTITUENT.ID = RECIPIENT.CONSTITUENTID
                        left join dbo.PURPOSERECIPIENTSTATUSCODE on RECIPIENT.STATUSCODEID = PURPOSERECIPIENTSTATUSCODE.ID

                    where 
                        RECIPIENT.ID = @ID

                    exec dbo.USP_EDUCATIONALHISTORY_VIEWLIST @EDUCATIONALHISTORYID, @ISPRIMARYRECORD output, @EDUCATIONALINSTITUTION output, 
                        @ACADEMICCATALOGPROGRAM output, @EDUCATIONALPROGRAM output, @CONSTITUENCYSTATUSCODE output, @CONSTITUENCYSTATUS output, 
                        @DATEGRADUATED output, @DATELEFT output, @ACADEMICCATALOGDEGREE output, @EDUCATIONALDEGREE output, @EDUCATIONALAWARD output, 
                        @STARTDATE output, @CLASSYEAR output, @PREFERREDCLASSYEAR output, @EDUCATIONALSOURCE output, @EDUCATIONALSOURCEDATE output, 
                        @COMMENT output, @ISAFFILIATED output, @AWARD output, @ADDITIONALINFORMATION output, @EDUCATIONALHISTORYLEVELCODE output,
                        null, null, @EDUCATIONALHISTORYSTATUSID output, null, null;

                    return 0;
                end