USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUP2_LOAD

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUP2_LOAD (
                        @ID uniqueidentifier,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
            @RECORDTYPEID uniqueidentifier = null output,
                        @NAME nvarchar(100) = null output,
                        @DESCRIPTION nvarchar(255) = null output,
                    @IDSETREGISTERID uniqueidentifier = null output,
            @OWNERID uniqueidentifier = null output,
                    @OTHERSCANMODIFY bit = null output,
                    @OTHERSCANVIEW bit = null output,
            @ALLOWREFRESH bit = null output,
            @AUTOREFRESH bit = null output,
            @POPULATEMETHODCODE tinyint = null output,
            @CATEGORYCODEID uniqueidentifier = null output,
                    @SITES xml = null output,
            @RESEARCHGROUPCRITERIA xml = null output,
            @HASADMINRIGHTS bit = null output,
            @NIGHTLYREFRESHENABLED bit = null output,
            @INCLUDEATTRIBUTES bit = null output,
            @PARENTRESEARCHGROUPID uniqueidentifier = null output
                    ) as
                        set nocount on;

                        set @DATALOADED = 0;

                        select
                            @DATALOADED = 1,
                            @TSLONG = RG.TSLONG,
                            @NAME = RG.NAME,
                            @DESCRIPTION = RG.DESCRIPTION,
                      @IDSETREGISTERID = IDSETREGISTERID,
              @OWNERID = OWNERID,
                      @OTHERSCANMODIFY = OTHERSCANMODIFY,
                      @OTHERSCANVIEW = OTHERSCANVIEW,
              @ALLOWREFRESH = ALLOWREFRESH,
              @AUTOREFRESH = AUTOREFRESH,
              @POPULATEMETHODCODE = POPULATEMETHODCODE,
              @CATEGORYCODEID = CATEGORYCODEID,
                            @SITES = dbo.UFN_RESEARCHGROUP_GETSITES_TOITEMLISTXML(RG.ID),
              @RESEARCHGROUPCRITERIA = dbo.UFN_RESEARCHGROUP_GETCRITERIA_TOITEMLISTXML(RG.ID),
              @HASADMINRIGHTS = dbo.UFN_RESEARCHGROUP_USERHASADMINRIGHTS(@ID, @CURRENTAPPUSERID),
              @INCLUDEATTRIBUTES = INCLUDEATTRIBUTES,
              @PARENTRESEARCHGROUPID = RG.PARENTRESEARCHGROUPID

                        from
                            dbo.RESEARCHGROUP RG
                        where
                            RG.ID = @ID;

            if @HASADMINRIGHTS = 0 
              set @HASADMINRIGHTS = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID);

            if @HASADMINRIGHTS = 0 
              set @HASADMINRIGHTS = dbo.UFN_SECURITY_APPUSER_GRANTED_SYSTEMPRIVILEGE_IN_SYSTEMROLE(@CURRENTAPPUSERID,'5ff6322a-c325-40e3-8a20-320ca9365f5f');

                        select
                            @RECORDTYPEID = ID
                        from
                            dbo.RECORDTYPE
                        where
                            upper(NAME) = 'CONSTITUENT';

                        set @NIGHTLYREFRESHENABLED = dbo.UFN_RESEARCHGROUP_NIGHTLYREFRESHENABLED()

                        return 0;