USP_DATAFORMTEMPLATE_VIEW_RATESCALE_SUMMARY

The load procedure used by the view dataform template "Rate Scale Summary 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
@ISDEFAULT	bit	INOUT	Default rate scale
@DESCRIPTION	nvarchar(255)	INOUT	Description
@ISACTIVE	bit	INOUT	Status
@GROUPSALESGROUPTYPE	nvarchar(100)	INOUT	Group type

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RATESCALE_SUMMARY
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @NAME nvarchar(100) = null output,
                @ISDEFAULT bit = null output,
                @DESCRIPTION nvarchar(255) = null output,
                @ISACTIVE bit = null output,
                @GROUPSALESGROUPTYPE nvarchar(100) = null output
            )
            as
                set nocount on;

                set @DATALOADED = 0;

                select @DATALOADED = 1,
                       @NAME = RATESCALE.NAME,
                       @ISDEFAULT = RATESCALE.ISDEFAULT,
                       @DESCRIPTION = RATESCALE.DESCRIPTION,
                       @ISACTIVE = RATESCALE.ISACTIVE,
                       @GROUPSALESGROUPTYPE = GROUPSALESGROUPTYPECODE.DESCRIPTION
                from dbo.RATESCALE
                    left join dbo.GROUPSALESGROUPTYPECODE on RATESCALE.GROUPSALESGROUPTYPECODEID = GROUPSALESGROUPTYPECODE.ID
                where RATESCALE.ID = @ID

                return 0;