USP_DATAFORMTEMPLATE_VIEW_PLEDGEREMINDERPROCESS

The load procedure used by the view dataform template "Pledge Reminder Process 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.
@NAME	nvarchar(100)	INOUT	Name
@IDSETREGISTERNAME	nvarchar(100)	INOUT	Include selection
@DESCRIPTION	nvarchar(255)	INOUT	Description
@CREATEOUTPUTIDSET	bit	INOUT	Create output selection
@OUTPUTIDSETRECORDTYPENAME	nvarchar(100)	INOUT	Output selection type
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Output selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@DATE	datetime	INOUT	Process date
@MARKREMINDERSSENT	nvarchar(3)	INOUT	Mark reminders sent
@OUTPUTFORMAT	nvarchar(255)	INOUT	Output format
@LETTERFILENAME	nvarchar(255)	INOUT	Letter template
@LABELFILENAME	nvarchar(255)	INOUT	Label template
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	BUSINESSPROCESSCATALOGID
@PARAMETERSID	uniqueidentifier	INOUT	PARAMETERSID
@OUTPUTGROUPINGCODE	tinyint	INOUT	Output Grouping
@EXPORTDEFINITION	nvarchar(200)	INOUT	Export definition
@OUTPUTGROUPING	nvarchar(50)	INOUT

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PLEDGEREMINDERPROCESS
                (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @NAME nvarchar(100)= null output, 
                @IDSETREGISTERNAME nvarchar(100) = null output, 
                @DESCRIPTION nvarchar(255) = null output, 
                @CREATEOUTPUTIDSET bit = null output,
                @OUTPUTIDSETRECORDTYPENAME nvarchar(100) = null output, 
                @OUTPUTIDSETNAME nvarchar(100) = null output, 
                @OVERWRITEOUTPUTIDSET bit = null output,                
                @DATE datetime = null output,
                @MARKREMINDERSSENT nvarchar(3) = null output,
                @OUTPUTFORMAT nvarchar(255) = null output,
                @LETTERFILENAME nvarchar(255) = null output,
                @LABELFILENAME nvarchar(255) = null output,
                @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                @PARAMETERSID uniqueidentifier = null output,
                @OUTPUTGROUPINGCODE tinyint = null output,
                @EXPORTDEFINITION nvarchar(200) = null output,
                @OUTPUTGROUPING nvarchar(50) = null output
                )
            as            
                set nocount on

                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @NAME = PLEDGEREMINDERPROCESS.NAME, 
                    @IDSETREGISTERNAME =  dbo.UFN_IDSET_GETNAME(PLEDGEREMINDERPROCESS.IDSETREGISTERID), 
                    @DESCRIPTION = PLEDGEREMINDERPROCESS.DESCRIPTION, 
                    @CREATEOUTPUTIDSET = PLEDGEREMINDERPROCESS.CREATEOUTPUTIDSET,
                    @OUTPUTIDSETRECORDTYPENAME = dbo.UFN_TRANSLATIONFUNCTION_RECORDTYPE_GETNAME(PLEDGEREMINDERPROCESS.OUTPUTIDSETRECORDTYPEID),
                    @OUTPUTIDSETNAME = PLEDGEREMINDERPROCESS.OUTPUTIDSETNAME, 
                    @OVERWRITEOUTPUTIDSET = PLEDGEREMINDERPROCESS.OVERWRITEOUTPUTIDSET,                    
                    @DATE = case PLEDGEREMINDERPROCESS.DATETYPECODE when 0 then getdate() else DATE end,
                    @MARKREMINDERSSENT = case PLEDGEREMINDERPROCESS.MARKREMINDERSSENT when 0 then 'No' else 'Yes' end,
                    @OUTPUTFORMAT = dbo.UFN_BUSINESSPROCESSVIEW_GETNAME(PLEDGEREMINDERPROCESS.BUSINESSPROCESSVIEWID),
                    @LETTERFILENAME = PLEDGEREMINDERPROCESS.LETTERFILENAME,
                    @LABELFILENAME = PLEDGEREMINDERPROCESS.LABELFILENAME,
                    @BUSINESSPROCESSCATALOGID = '84414BD2-3196-4697-998A-2493C29A302A',
                    @PARAMETERSID = @ID,
                    @OUTPUTGROUPINGCODE = PLEDGEREMINDERPROCESS.OUTPUTGROUPINGCODE,
                    @EXPORTDEFINITION = EXPORTDEFINITION.NAME,
                    @OUTPUTGROUPING = PLEDGEREMINDERPROCESS.OUTPUTGROUPING
                from
                    dbo.PLEDGEREMINDERPROCESS
                left join 
                    dbo.EXPORTDEFINITION on EXPORTDEFINITION.ID = PLEDGEREMINDERPROCESS.EXPORTDEFINITIONID
                where
                    PLEDGEREMINDERPROCESS.ID = @ID;

                return 0;