completes type column fix