USP_CORRESPONDENCEPROCESS_GETPARAMETERS

            CREATE procedure dbo.USP_CORRESPONDENCEPROCESS_GETPARAMETERS
            (
                @ID uniqueidentifier = null
            )
            as
                set nocount on;

                select    
                    CORRESPONDENCEPROCESS.NAME, 
                    CORRESPONDENCEPROCESS.DESCRIPTION,
                    BPVIEW.ID as OUTPUTVIEWID,                    
                    CORRESPONDENCEPROCESS.IDSETREGISTERID, 
                    CORRESPONDENCEPROCESS.UPDATECONSTITUENTRECORD,
                    CORRESPONDENCEPROCESS.CORRESPONDENCECODEID,
                    CORRESPONDENCEPROCESS.COMMENTS,                    
                    CORRESPONDENCEPROCESS.CREATEOUTPUTIDSET, 
                    CORRESPONDENCEPROCESS.OUTPUTIDSETNAME,
                    CORRESPONDENCEPROCESS.OVERWRITEOUTPUTIDSET,
                    CORRESPONDENCEPROCESS.EXCLUDEMAIL,
                    CORRESPONDENCEPROCESS.EXCLUDEPHONE,
                    CORRESPONDENCEPROCESS.EXCLUDEEMAIL,

                    convert(bit, case when exists(select * from dbo.BUSINESSPROCESSCOMMPREFINCLUSIONS where BUSINESSPROCESSPARAMETERSETID=@id) then 1 else 0 end) 'INCLUSION',
                    convert(bit, case when exists(select * from dbo.BUSINESSPROCESSCOMMPREFEXCLUSIONS where BUSINESSPROCESSPARAMETERSETID=@id) then 1 else 0 end) 'EXCLUSION',
                    BUSINESSPROCESSCOMMPREF.DATETYPECODE as EXCLUSIONDATETYPECODE,
                    BUSINESSPROCESSCOMMPREF.ASOFDATE,
                    BUSINESSPROCESSCOMMPREF.EXCLUDEDECEASED,
                    BUSINESSPROCESSCOMMPREF.EXCLUDEINACTIVE,
                    CORRESPONDENCEPROCESS.CUSTOMPARAMETERDATAFORMITEM,
                    CORRESPONDENCEPROCESS.HOUSEHOLDSINGLEMAIL,
                    CORRESPONDENCEPROCESS.EXPORTDEFINITIONID,
                    CORRESPONDENCEPROCESS.USEPRIMARYOVERHOUSEHOLD
                from dbo.CORRESPONDENCEPROCESS
                left join dbo.BUSINESSPROCESSVIEW BPVIEW on CORRESPONDENCEPROCESS.QUERYVIEWID = BPVIEW.QUERYVIEWCATALOGID
                left outer join dbo.BUSINESSPROCESSCOMMPREF on CORRESPONDENCEPROCESS.ID=BUSINESSPROCESSCOMMPREF.BUSINESSPROCESSPARAMETERSETID
                where 
                    CORRESPONDENCEPROCESS.ID = @ID;