The current project I am working on has the need to not hard delete anything. instead, I mark a column named "retired" as true when we do not want something to be shown in the application any longer.

My question is this, is there a way to override the default action of the orphanremoval process so that instead of the record getting deleted, I could simply mark the "retired" field as true and update the record. All tables have the same Bit field of retired, so this would apply to the entire application.

Thanks!