USP_DATAFORMTEMPLATE_EDITLOAD_SIMPLEACKNOWLEDGEMENT

        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SIMPLEACKNOWLEDGEMENT
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
as
    begin
        set nocount on;

        declare @MKTSEGMENTATIONACTIVATEPROCESSID nvarchar(36);    

        select 
            @MKTSEGMENTATIONACTIVATEPROCESSID = cast(ID as nvarchar(36)) 
        from dbo.MKTSEGMENTATIONACTIVATEPROCESS 
        where MKTSEGMENTATIONACTIVATEPROCESS.SEGMENTATIONID = @ID;

        select 
            MKTSEGMENTATION.NAMEFORMATPARAMETERID,
            MKTSEGMENTATION.ADDRESSPROCESSINGOPTIONID,
            dbo.UFN_SIMPLEACKNOWLEDGEMENT_GETSOLICITCODES_TOITEMLISTXML(@ID) as SOLICITCODES,
            dbo.UFN_COMMUNICATIONLETTER_GETSCHEDULEINFO_TOITEMLISTXML(MKTSEGMENTATION.ID) as LETTERS,
            (
                select top 1 
                    sysschedules.freq_type --weekly = 8 daily = 1

                        from 
                    msdb.dbo.sysschedules
                            inner join msdb.dbo.sysjobschedules on sysschedules.schedule_id = sysjobschedules.schedule_id
                            inner join msdb.dbo.sysjobsteps on sysjobschedules.job_id = sysjobsteps.job_id
                            inner join msdb.dbo.sysjobs on sysjobschedules.job_id = sysjobs.job_id
                            inner join msdb.dbo.sysproxies on sysjobsteps.proxy_id = sysproxies.proxy_id
                        where 
                    sysproxies.name like 'Blackbaud % Proxy - ' + db_name() and 
                    sysjobsteps.step_name = 'Business process invoke' and 
                    (null is null or sysjobsteps.command like '%DatabaseName=' + null + '&%') and 
                    sysjobsteps.command like '%' + @MKTSEGMENTATIONACTIVATEPROCESSID + '%'
            ) as FREQUENCY,
            MKTSEGMENTATIONACTIVATEPROCESS.ID as ACTIVATIONPROCESSID,
                MKTSEGMENTATION.TSLONG,
            cast(isnull(SIMPLEACKNOWLEDGEMENT.INCLUDERECIPIENTS, 0) as bit) as INCLUDERECIPIENTS
        from dbo.MKTSEGMENTATION
        left join dbo.MKTSEGMENTATIONACTIVATEPROCESS on MKTSEGMENTATIONACTIVATEPROCESS.SEGMENTATIONID = MKTSEGMENTATION.ID
        left join dbo.SIMPLEACKNOWLEDGEMENT on SIMPLEACKNOWLEDGEMENT.ID = MKTSEGMENTATION.ID
        where MKTSEGMENTATION.ID = @ID;

            return 0;
    end