USP_DATAFORMTEMPLATE_VIEW_ADDREQUESTSFORMULTIPLESTUDENTSBUSINESSPROCESSSTATUS

The load procedure used by the view dataform template "Globally Add Requests Business Process Status 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
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	BUSINESSPROCESSCATALOGID
@PARAMETERSETID	uniqueidentifier	INOUT	PARAMETERSETID
@DESCRIPTION	nvarchar(255)	INOUT	Description
@INCLUDESELECTION	nvarchar(255)	INOUT	Include selection
@SELECTEDCORECURRICULA	nvarchar(1000)	INOUT	Selected core curricula
@CREATESTUDENTSIDSET	bit	INOUT	Create output selection
@OVERWRITESTUDENTSSELECTION	bit	INOUT	Overwrite existing selection
@STUDENTSSELECTIONNAME	nvarchar(100)	INOUT	Output selection name
@SELECTIONTYPENAME	nvarchar(300)	INOUT	Output selection type

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ADDREQUESTSFORMULTIPLESTUDENTSBUSINESSPROCESSSTATUS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100) = null output,
                    @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                    @PARAMETERSETID uniqueidentifier = null output,
                    @DESCRIPTION nvarchar(255) = null output,
                    @INCLUDESELECTION nvarchar(255) = null output,
                    @SELECTEDCORECURRICULA nvarchar(1000) = null output,
                    @CREATESTUDENTSIDSET bit = null output,
                    @OVERWRITESTUDENTSSELECTION bit = null output,
                    @STUDENTSSELECTIONNAME nvarchar(100) = null output,
                    @SELECTIONTYPENAME nvarchar(300) = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @NAME = AP.NAME, 
                        @BUSINESSPROCESSCATALOGID = '5a8f1271-b682-440f-92f1-5e9af30a820c',
                        @PARAMETERSETID = @ID,
                        @DESCRIPTION = AP.DESCRIPTION,
                        @INCLUDESELECTION = IDSETREGISTER.NAME,
                        @SELECTEDCORECURRICULA = dbo.UFN_ADDREQUESTSFORMULTIPLESTUDENTS_GETCORELIST(AP.ID),
                        @CREATESTUDENTSIDSET = AP.CREATESTUDENTSIDSET,
                        @OVERWRITESTUDENTSSELECTION = AP.OVERWRITESTUDENTSSELECTION,
                        @STUDENTSSELECTIONNAME = AP.STUDENTSSELECTIONNAME,
                        @SELECTIONTYPENAME = RECORDTYPE.NAME
                    from 
                        dbo.ADDREQUESTSFORMULTIPLESTUDENTSPROCESS AP
                        left outer join dbo.IDSETREGISTER on AP.IDSETREGISTERID = IDSETREGISTER.ID
                        left outer join dbo.RECORDTYPE on AP.SELECTIONTYPEID = RECORDTYPE.ID
                    where
                        AP.ID = @ID;

                    return 0;