USP_DATAFORMTEMPLATE_EDITLOAD_WEBFORMSUSERREGISTRATIONPARTSETTING

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_WEBFORMSUSERREGISTRATIONPARTSETTING (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @SITECONTENTID integer = null output,
                        @ALLOWREGISTRATION bit = null output,
                        @REQUIREFIRSTNAME bit = null output,
                        @REQUIRETITLE bit = null output,
                        @REQUIREPHONE bit = null output,
                        @SENDEMAIL bit = null output
                    )
                    as

                        set nocount on;

                        -- setting @DATALOADED because it's okay if the ID returns nothing
                        set @DATALOADED = 1
                        set @TSLONG = 0

                        select
                            @DATALOADED = 1,
                            @TSLONG = TSLONG,
                            @SITECONTENTID = SITECONTENTID, 
                            @ALLOWREGISTRATION = ALLOWREGISTRATION,
                            @REQUIREFIRSTNAME = REQUIREFIRSTNAME,
                            @REQUIRETITLE = REQUIRETITLE,
                            @REQUIREPHONE = REQUIREPHONE,
                            @SENDEMAIL = SENDEMAIL
                        from dbo.WEBFORMSUSERREGISTRATIONPARTSETTING
                        where ID = @ID

                        --Getting default from payment part
                        declare 
                            @PAYMENTPARTALLOWREGISTRATION bit = null,
                            @PAYMENTPARTREQUIREFIRSTNAME bit = null,
                            @PAYMENTPARTREQUIRETITLE bit = null,
                            @PAYMENTPARTREQUIREPHONE bit = null

                        select 
                            @PAYMENTPARTALLOWREGISTRATION = [SHOPPINGCARTSETTINGS].[ALLOWINLINEREGISTRATION],
                            @PAYMENTPARTREQUIREFIRSTNAME = [SHOPPINGCARTSETTINGS].[REQUIREFIRSTNAME],
                            @PAYMENTPARTREQUIRETITLE = [SHOPPINGCARTSETTINGS].[REQUIRETITLE],
                            @PAYMENTPARTREQUIREPHONE = [SHOPPINGCARTSETTINGS].[REQUIREPHONE]
                        from dbo.PAGEMODELITEM
                        inner join dbo.SiteContent
                            on PAGEMODELITEM.PRIMARYKEY = SiteContent.ID
                        inner join dbo.SHOPPINGCARTSETTINGS
                            on SiteContent.[Guid] = SHOPPINGCARTSETTINGS.ID
                        where ARTIFACTID = 'f4f84e8c-12da-43d8-8957-0feff9cedd53' --Webforms payment part page model artifact ID

                        --Defaults if there is no record for this part
                        set @ALLOWREGISTRATION = coalesce(@ALLOWREGISTRATION, @PAYMENTPARTALLOWREGISTRATION, 0)
                        set @REQUIREFIRSTNAME = coalesce(@REQUIREFIRSTNAME, @PAYMENTPARTREQUIREFIRSTNAME, 0)
                        set @REQUIRETITLE = coalesce(@REQUIRETITLE, @PAYMENTPARTREQUIRETITLE, 0)
                        set @REQUIREPHONE = coalesce(@REQUIREPHONE, @PAYMENTPARTREQUIREPHONE, 0)
                        set @SENDEMAIL = isnull(@SENDEMAIL, 1)

                    return 0;