TR_CONSTITUENTACCOUNT_INSERT_BBNCCONSTITACCOUNTIDMAP

                CREATE trigger TR_CONSTITUENTACCOUNT_INSERT_BBNCCONSTITACCOUNTIDMAP on dbo.CONSTITUENTACCOUNT after insert not for replication
                as begin
                    insert into dbo.BBNCCONSTITACCOUNTIDMAP (CONSTITUENTACCOUNTID)
                        select ID from inserted
                end