USP_REPORT_AMPROIMPORTBATCHEXCEPTION_CONSTITUENT

            CREATE procedure dbo.USP_REPORT_AMPROIMPORTBATCHEXCEPTION_CONSTITUENT
            (
                @BATCHID uniqueidentifier
            )
            with execute as owner
            as
            begin
                set nocount on;

                declare @TABLENAME nvarchar(128);
                select @TABLENAME = dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 1);

                declare @SQL nvarchar(max);
                set @SQL = N'set nocount on;

                            select
                                REPORTTABLE.ID,
                                REPORTTABLE.REASON,
                                BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_UPDATEDFIRSTNAME,
                                BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_UPDATEDKEYNAME,
                                BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_ISINDIVIDUAL,
                                case
                                    when BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_LINKID is null then 1
                                    else 0
                                end ISNEWCONSTITUENT,
                                BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_AUTOMATCHSTATUSCODE AUTOMATCHSTATUSCODE
                            from 
                                dbo.' + @TABLENAME + ' REPORTTABLE ' + '
                                left join dbo.BATCHAMPROIMPORTCONSTITUENT on BATCHAMPROIMPORTCONSTITUENT.ID = REPORTTABLE.ID
                            where
                                REPORTTABLE.RECORDTYPECODE = 2
                            order by REPORTTABLE.SEQUENCE;'

                exec sp_executesql @SQL;
            end