USP_DATAFORMTEMPLATE_VIEW_STUDENTINTERACTIONPAGEDATA

The load procedure used by the view dataform template "Student Interaction 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.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@CONSTITUENT	nvarchar(154)	INOUT	CONSTITUENT
@CONSTITUENTID	uniqueidentifier	INOUT	CONSTITUENTID
@TYPE	nvarchar(100)	INOUT	TYPE
@DATE	datetime	INOUT	DATE
@ISMOVE	bit	INOUT	ISMOVE
@ATTRIBUTEDEFINED	bit	INOUT	ATTRIBUTEDEFINED

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_STUDENTINTERACTIONPAGEDATA
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @CONSTITUENT nvarchar(154) = null output,
                    @CONSTITUENTID uniqueidentifier = null output,
                    @TYPE nvarchar(100) = null output,
                    @DATE datetime = null output,
                    @ISMOVE bit = null output,
                    @ATTRIBUTEDEFINED bit = null output
                as begin

                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @CONSTITUENT = C.NAME,
                        @CONSTITUENTID = C.ID,
                        @TYPE = ITC.DESCRIPTION,
                        @DATE = I.DATE,
                        @ISMOVE = case when I.PROSPECTPLANID is null then 0 else 1 end,
                        @ATTRIBUTEDEFINED = dbo.UFN_ATTRIBUTECATEGORY_DEFINEDFORRECORDTYPE('Interaction')            
                    from
                        dbo.INTERACTION I
                        inner join dbo.CONSTITUENT C on C.ID=I.CONSTITUENTID
                        inner join dbo.INTERACTIONTYPECODE ITC on ITC.ID=I.INTERACTIONTYPECODEID
                    where
                        I.ID = @ID;

                    return 0;
                end