TR_STUDENT_MARKASCONSTITUENT

                    create trigger TR_STUDENT_MARKASCONSTITUENT
                        on dbo.STUDENT
                        after insert, update
                        not for replication
                    as begin
                        if update(ID)
                        begin
                            if ((select ISCONSTITUENTWHENCODE from dbo.STUDENTCONSTITUENCYSETTINGS) = 0)
                            begin
                                update dbo.CONSTITUENT
                                    set ISCONSTITUENT = 1,
                                        CHANGEDBYID = inserted.CHANGEDBYID,
                                        DATECHANGED = GetDate()
                                from inserted
                                where (inserted.ID = CONSTITUENT.ID) and
                                        (CONSTITUENT.ISCONSTITUENT = 0);
                            end
                        end
                    end