added new column typ for type + supporting temp code until implementation