explicit column for has lookup