USP_AUTOSETTLEBBMSTRANSACTIONS_PROMPT

                        create procedure dbo.USP_AUTOSETTLEBBMSTRANSACTIONS_PROMPT
                        (
                            @STATUS nvarchar(512) output
                        )
                        as 
                            set nocount on;
                            declare @AUTOSETTLEPROCESSID uniqueidentifier = '0A350644-832E-45BE-99FC-90BCCA0AD216'

                            if exists (select [ID] from dbo.[SCHEDULE] where [ID] = @AUTOSETTLEPROCESSID)
                            begin
                                select
                                    @STATUS = case ENABLED
                                        when 1 then 'Disable BBMS auto settle to stop the automatic reconciliation of transactions processed through Blackbaud Merchant Services. Do you want to continue?'
                                        when 0 then 'Enable BBMS auto reconcile to automatically receive information from Blackbaud Merchant Services about the transactions included in your disbursement and mark those transactions as reconciled. Do you want to continue?'
                                    end
                                from dbo.[SCHEDULE]
                                where [ID] = @AUTOSETTLEPROCESSID
                            end